How to Consolidate Data from Multiple Excel Columns All into One Column?

From:  http://stackoverflow.com/questions/4480227/how-to-consolidate-data-from-multiple-excel-columns-all-into-one-column

Select the data you want to list in one column. Must be contiguous columns. May contain blank cells.

Press Alt+F11 to open the VBE

Press Control+R to view the Project Explorer

Navigate to the project for your workbook and choose Insert - Module

Paste this code in the code pane:

Sub MakeOneColumn()

    Dim vaCells As Variant
    Dim vOutput() As Variant
    Dim i As Long, j As Long
    Dim lRow As Long

    If TypeName(Selection) = "Range" Then
        If Selection.Count > 1 Then
            If Selection.Count <= Selection.Parent.Rows.Count Then
                vaCells = Selection.Value

                ReDim vOutput(1 To UBound(vaCells, 1) * UBound(vaCells, 2), 1 To 1)

                For j = LBound(vaCells, 2) To UBound(vaCells, 2)
                    For i = LBound(vaCells, 1) To UBound(vaCells, 1)
                        If Len(vaCells(i, j)) > 0 Then
                            lRow = lRow + 1
                            vOutput(lRow, 1) = vaCells(i, j)
                        End If
                    Next i
                Next j

                Selection.ClearContents
                Selection.Cells(1).Resize(lRow).Value = vOutput
            End If
        End If
    End If

End Sub

How to combine multiple workbooks to one workbook in Excel?

1. Put all the workbooks that you want to combine into the same directory.

2. Launch an Excel file that you want to combine other workbooks into.

3. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, clickInsert > Module, and input the following code into the Module:

Sub GetSheets()
Path = "C:\Users\dt\Desktop\dt kte\"
Filename = Dir(Path & "*.xls")
Do While Filename <> ""
Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
For Each Sheet In ActiveWorkbook.Sheets
Sheet.Copy After:=ThisWorkbook.Sheets(1)
Next Sheet
Workbooks(Filename).Close
Filename = Dir()
Loop
End Sub

Tip: In the above code, you can change the path to the one that you are using.

4. Then click  button to run the code, and all of the worksheets (including the blank worksheets) within the workbooks have been merged into the master workbook.

From: http://www.extendoffice.com/documents/excel/456-combine-multiple-workbooks.html

Sale-Leaseback & Inverted Lease

The two lease structures that are most commonly used to finance solar collection installations are the Sale-Leaseback Structure and the Inverted Lease Structure.

The Sale-Leaseback Structure

Under this structure, the system is sold by the Developer to the Investor and then leased back to the Developer, and the Developer delivers the power to the Off-taker via a Power Purchase Agreement (PPA). The Investor would be the owner, and would claim the tax depreciation and the Investment Tax Credit (ITC) Grant. In addition, the Developer would have a purchase option at the end of the lease term.

The advantages of a Sale-Leaseback Structure include:

• Common project finance structure
• Provides 100% financing for the system
• Transfers 100% of the tax benefits to the Investor
• Sale-Leaseback Structure can commence up to three months after the system has been placed into service
• ITC Grant based upon FMV rather than Developer’s cost

The disadvantages of a Sale-Leaseback Structure include:

• Generally not available for Production Tax Credit (PTC) because of ownership requirements
• Developer’s purchase option is more expensive
• Tax-exempt or government entities can’t be the Developer or Investor
• Lease must qualify as a true lease for U.S. federal tax purposes

The Inverted Lease Structure

Under this structure, the Developer leases the system to the Investor. The Off-taker receives the energy from the system via a PPA, and in turn pays the Investor for the energy produced. The Developer may operate the system on behalf of the Investor pursuant to an Operation & Maintenance (O&M) Agreement. The Developer (as owner) claims any tax depreciation, and can elect whether the Investor can claim the ITC Grant. The Investor (as lessee) claims any tax deductions for the lease payments. At the conclusion of the lease term, the system automatically reverts to the Developer.

The advantages of the Inverted Lease Structure include:

• Popularity and understanding of lease structures
• Developer retains the residual interest
• Easy exit for the Investor
• Developer may capture some upside during lease term under an O&M Agreement
• ITC Grant based upon FMV of the system rather than the Developer’s cost
• Achieves separation of ITC Grant and depreciation

The disadvantages of the Inverted Lease Structure include:

• Generally not available for PTC because of ownership requirements
• Investor recognizes income equal to 50% of ITC Grant over initial five years of lease term
• Tax-exempt or government entities can’t be Developer or Investor
• Lease must qualify for credit pass-through election
• Lease must qualify as a true lease for U.S. federal tax purposes

5 Basic Rules That Teach You 90% of Successful Investing

Written by Morgan Housel from The Motley Fool 

Everyone in my family except me works in health care, so dinnertime discussions around the holidays inevitably drift toward talk of antibiotics, appendectomies, and insulin.

I've listened to hours of family medical conversations for years, and I still know little about it. Medicine is really complicated. Even a basic level of competence requires years of specific training. If you're like me and don't have that training, you have no idea what everyone else at the dinner table is talking about, and you definitely shouldn't try to be a doctor.

My field -- finance -- is different. It's the opposite, actually.

Doing well in finance isn't about memorizing textbooks. It's more about patience and an even temperament. That's why people with no formal financial training can master investing. Doctors might require a decade of school to become competent, but I'd say 90% of successful investing can be summed up with just a handful of simple rules.

I spent a lot of time in 2013 writing about simple finance rules. Here are five of my favorites.

1. Wealth takes time.

Charlie Munger, Warren Buffett's investing partner, put it best: "You don't have to be brilliant, only a little bit wiser than the other guys, on average, for a long, long time."

Warren Buffett is a great investor, but what makes him rich is that he's been a great investor for seven decades. Of his current $60 billion net worth, $59.7 billion was added after his 50th birthday, and $57 billion came after his 60th. If Buffett started saving in his 30s and retired in his 60s, you would have never heard of him. His skill is investing, but his secret is time.

Understanding the value of time is the most important lesson in all of finance. The single best thing we can do to improve the financial state of Americans is encourage people to save from as early an age as possible.

2. Most financial problems are caused by debt.

I have a family friend who earned several hundred thousand dollars a year as a specialist in an advanced field. He went bankrupt a few years ago and will probably need to work for the rest of his life. I know another who never earned more than $50,000 a year but retired comfortably on his own terms.

The only real difference between these two friends is that one used debt to live beyond his means while the other avoided it and accepted a realistic standard of living.

Just as saving gives you options in the future, debt takes options away. Not having the option of flexibility is the root of most financial problems. You can be a brilliant worker (or investor) and find yourself in financial ruin if you don't respect the power of debt. Income, wealth, and standard of living aren't as correlated as people think.

3. Forecasting market returns is close to impossible. Worse, it's dangerous. 

A stock's future returns will equal its dividend yield, plus its earnings growth, plus or minus changes in valuations (earnings multiples). That's really all there is to it.

Dividends and earnings growth for many companies can be reasonably projected.

But what about the change in valuations? There's no way we could possibly know that.

Stock market valuations reflect people's feelings about the future, swinging between optimism and fear. And there's just no way to know what people are going to think about the future in the future. How could you?

If someone said, "I think most people will be in a 9.26% better mood in the year 2024," we'd call them delusional. When someone does the same thing by projecting 10-year market returns, we call them Wall Street analysts.

We know a group of high-quality companies will build wealth for their shareholders over time. But we can never be specific when trying to guess what the stock market might do going forward. Assuming we can predict exactly what stocks will do in the future makes us blind to risk and uncertainty. Coming to terms with an unpredictable future forces us to be nimble and prepared. You can guess which group does better.

4. Simple can be better than smart.

Someone who bought a low-cost S&P 500 index fund in 2003 and left it alone earned a 97% return by the end of 2012. That's great! And they could have spent the last 10 years at the beach, or hanging out with their kids.

Meanwhile, the average fancy professional market-neutral hedge fund -- many of which are staffed with PhDs and some of the world's fastest computers -- lost 4.7% over the same period, according to data from Dow Jones Credit Suisse Hedge Fund Indices. The average stock-trading equity hedge fund produced a 96% total return -- still short of a simple index fund.

There are no points awarded for difficulty in investing. Smart people who devote their entire lives to investing can (and often do) fail, while some of the simplest investing techniques you can think of are wildly successful. Good businesses run by good people purchased at good prices held for as long as possible. That's it.

5. The odds of experiencing stock market volatility are exactly 100%.

Most investors understand that stocks produce superior long-term returns, but at the cost of higher volatility. Yet every time there's even a whiff of volatility in the stock market, the same cry is heard from investors around the world: "What the heck is going on?!"

The majority of the time, the honest and correct answer is the same: Nothing is going on. This is normal and just what stocks do.

Since 1900 the S&P 500 has returned about 6% per year, but the average difference between any year's highest close and lowest close is 23%. Volatility, even really severe swings, is perfectly normal and shouldn't be feared.

Accepting market volatility as normal and focusing on the businesses I own is a lesson I've learned from Motley Fool co-founder David Gardner. David is one of the brightest investors I know, and has one of the best track records in the industry. His ability to remain steadfast in the face of market volatility is astounding. David's service, Supernova, is about to open to new investors for the first time in months.Click here if you're interested in how he does it.

As we head into 2014, one of the best things you can do to improve your experience as an investor is remind yourself that investing may not be easy, but it's not difficult or complicated. Professional investors and pundits make it seem complicated because they think of it like medicine, complex and dependent on detailed knowledge. It's not. This isn't brain surgery. All we're doing is spending less than we earn, saving the difference, investing it, and waiting. 

Differences between bills, notes and bonds?

Treasury bills (T-Bills), notes and bonds are marketable securities the U.S. government sells in order to pay off maturing debt and to raise the cash needed to run the federal government. When you buy one of these securities, you are lending your money to the government of the United States. 

Frequency of interst paid

• T-bills: Because they are sold at a discount from face value, they do not pay interest before maturity. The interest is the difference between the purchase price and the price paid either at maturity (face value) or the price of the bill if sold prior to maturity.
• Notes and bonds: They have a stated interest rate that is paid semi-annually until maturity. 

Terms to maturity

• T-bills are short-term obligations issued with a term of one year or less
• Notes are issued in two-, three-, five- and 10-year terms. 
• Bonds are issued in more-than-10-year terms.

Edited from investopedia