Stock forum

Jae; More suggestions.

1. For the line that says "Accounts Receivable" you could think of this as "Net Accounts Receivables" and then you could break this down futher into two more catagories: "Gross Accounts Receivable" + "Allowance for Uncollectable Accounts". So therefore you would have in the following order:

Gross Accounts Receivable then Allowance for Uncollectable Accounts = Net Accounts Receivable. Then under that you have Other Receivable and then = Total Receivables.

2. Where you have "Intangibles" you could say "Net Intangibles" = Gross Intangibles – Accumulated Amortization. So therefore you would have the following order:

Gross Intangibles and then Accumulated Amortization and then Net Intangibles.

3. Finally under "Gross Fixed Assets" – "Accumulated Depreciation and Amortization" = "Net Fixed Assets". So list in the following order:

Gross Fixed Assets and then Accumulated Depreciation and Amortization and then Net Fixed Assets.

Post edited 2:50 am – August 20, 2010 by MrBook

Jae; I am referring to (ABT) 8/19/2010 and the Financial Statements spreadsheet. I am a premium user.

1. First of all I see that the "Financial Statements" spreadsheet is a much more detailed spreadsheet than the "Statements" spreadsheet. Therefore perhaps it would save you some work not having to program/correct the same information over and over again. I suggest getting rid of the "Statements" spreadsheet and continuing with the "Financial Statements" spreadsheet only.

2. For the "Statements" spreadsheet I see that at the top you labeled 2000 at the very left with 2009 at the very right followed by TTM. For the "Financial Statements" spreadsheet you did the opposite. You labeled the top 2009 at the left and then put 1993 all the way over to the very last right side of the page.

I suggest labeling the data/years the same way that you did for the "Statements" spreadsheet. The earliest year at the very left and the latest year to the very right.

I also suggest that for "Financial Statements" that you put TTM to the very right.

3. For "Financial Statements" I see that here you have a company with more than 10 years of data so you listed all fifteen years on one sheet. I suggest listing the earliest year and then the next 9 years on one sheet (so 10 years on one sheet) and then the next five or so years with TTM on the next sheet. In this way the print would not be so small if the user choose to print out the entire "Financial Statements" spreadsheet. As it stands now its hard to read the printout with all 15+ years of data on one sheet due to the very small print.

4. I see that for both spreadsheets for some categories such as Revenue and COGS you showed the % change in from the last period. I suggest doing this for every accounting category. This includes all items on the Income Statement, Balance Sheet, and Cash Flow Statement. This is a very helpful feature.

5. I was planning on gradually suggesting more accounting ratios in due time. According to the theory of Vertical Analysis you take EVERY ITEM on the Income Statement and divide by Revenue. You then show that % in the line underneath it. I see that you did this for COGS, SG&A for examples. This is a very helpful feature also.

You then take EVERY ITEM on the Balance sheet and divide by Revenue. You show the % underneath it.

Finally you take EVERY ITEM on the Cash Flow statement and divide by Revenue. You show the % ratio underneath it.

6. According to the theory of Common Size analysis you take every item on the Balance Sheet and divide by Total Assets. Do the same for the Income Statement and Cash Flow Statement. Show the % ratio underneath it.

7. Regarding the "Financial Statements" spreadsheet. Just a reminder that in the Income Statement the following always goes in the following order: EBITDA then EBIT then EBT then EAT then NI.

For EBITDA line 29 I think its a good idea to Bold this entire line all the way across the page. This is one key number that many people look for in a Income Statement.

For EBIT on line 40 Bold all the way across.

For EBT on line 44 after "Income before Income Taxes" then put (EBT) after it. Then make sure this entire line is Bold-ed.

For EAT on line 45 after "net income(continuing operations)" then put (EAT) after it. Bold the entire line.

For NI on line 48 Bold this entire line.

8. For total non-current assets on line 95 Bold all the way across. Its good form to Bold when ever you see a line with a total in it. This would also include total current liabilities on line 106, total non-current liabilities on line 112, total capitalization on line 116, total equity on line 117, total liabilities & stock equity on line 118.

9. There was no need to Bold Working capital, Invested Capital and cash flow on lines 118-120.

10. After reviewing the following spreadsheets: "Charts", "Statements", the top ratios in the "DCF" spreadsheet, "AR&Inventory", "Debt Analysis", "EPS-TaxChange", "EPS-NonOperating", "EPS-D&A" I think that they add no value or are redundant information. I suggest removing them unless its explained to me why they add value and where you discovered these ideas. This might be important since if you decide to follow my advice and makes changes to upgrade the spreadsheet or add more ideas it might be a good idea to remove what's redundant so that it saves you time and the hassle of having to answer questions about why data from one spreadsheet is different from another spreadsheet.

Besides makes the above changes to "Financial Statements" I think that you you break this spreadsheet up into separate spreadsheets. One spreadsheet for "Income Statement", one for "Balance Sheet", one for "Cash Flow Statement" and finally a separate spreadsheet for "Other Ratios".

The only ratios that would go on the "Income Statement", "Balance Sheet" and "Cash Flow Statement" would be what I suggested in #4, #5, #6 above. All other ratios would go into the "Other Ratios" spreadsheet. This would include others that I will suggest later.

OK. That's all for the suggestions. Next will be the errors and Questions.