Flexible Financial Statement - Excel

Document Sample
Flexible Financial Statement - Excel Powered By Docstoc
					1

2

ABC, Inc. Income Statement
1
Annual Interim

3 4 5

Period End Date Period Length Statement Source Statement Source Date Statement Update Type Revenue Other Revenue, Total Total Revenue Cost of Revenue Gross Profit Fuel Expense Operations & Maintenance Selling/General/Administrative Expenses, Total Research & Development Depreciation/Amortization Interest Expense (Income), Net Operating Unusual Expense (Income) Other Operating Expenses, Total Operating Income Interest Income (Expense), Net Non-Operating Gain (Loss) on Sale of Assets Allowance for Funds Used during Const. Other, Net Income Before Tax Income Tax - Total Income After Tax Minority Interest Equity In Affiliates U.S. GAAP Adjustment Net Income Before Extra. Items

2009 12/31/2008 12

2008 12/31/2008 12

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Total Extraordinary Items Net Income Total Adjustments to Net Income Preferred Dividends General Partners' Distributions Basic Weighted Average Shares Basic EPS Excluding Extraordinary Items Basic EPS Including Extraordinary Items Diluted Weighted Average Shares Diluted EPS Excluding Extrordinary Items Diluted EPS Including Extraordinary Items Dividends per Share - Common Stock Primary Issue Gross Dividends - Common Stock Interest Expense, Supplemental Depreciation, Supplemental Normalized EBITDA Normalized EBIT Normalized Income Before Tax Normalized Income After Taxes Normalized Income Available to Common Basic Normalized EPS Diluted Normalized EPS Amortization of Intangibles

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

3

4

5

2007 12/31/2007 12

2006 12/31/2006 12

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1

2

ABC, Inc. Balance Sheet
1
Annual Interim

Period End Date Period Length Statement Source Statement Source Date Statement Update Type Assets Cash and Short Term Investments Cash & Equivalents Short Term Investments Total Receivables, Net Accounts Receivable - Trade, Net Accounts Receivable - Trade, Gross Provision for Doubtful Accounts Notes Receivable - Short Term Receivables - Other Total Inventory Prepaid Expenses Other Current Assets, Total Total Current Assets Property/Plant/Equipment, Total - Net Goodwill, Net Intangibles, Net Total Utility Plant, Net Long Term Investments Note Receivable - Long Term Other Long Term Assets, Total Other Assets, Total Total Assets Liabilities and Shareholders' Equity Accounts Payable Payable/Accrued Accrued Expenses Notes Payable/Short Term Debt Current Port. of LT Debt/Capital Leases

2009 12/31/2008 12

2008 12/31/2008 12

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

Other Current Liabilities, Total Total Current Liabilities Total Long Term Debt Long Term Debt Capital Lease Obligations Deferred Income Tax Minority Interest Other Liabilities, Total Total Liabilities Redeemable Preferred Stock Preferred Stock - Non Redeemable, Net Common Stock Additional Paid-In Capital Retained Earnings (Accumulated Deficit) Treasury Stock - Common Unrealized Gain (Loss) Other Equity, Total Total Equity Total Liabilities & Shareholders’ Equity Total Common Shares Outstanding Total Preferred Shares Outstanding

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

3

4

5

2007 12/31/2007 12

2006 12/31/2006 12

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1

2

ABC, Inc. Cash Flow
1
Annual Interim

Period End Date Period Length Statement Source Statement Source Date Statement Update Type Net Income/Starting Line Depreciation/Depletion Amortization Deferred Taxes Non-Cash Items Discontinued Operations Unusual Items Equity in Net Earnings (Loss) Other Non-Cash Items Changes in Working Capital Accounts Receivable Inventories Prepaid Expenses Other Assets Accounts Payable Accrued Expenses Other Liabilities Other Operating Cash Flow Cash from Operating Activities Capital Expenditures Purchase of Fixed Assets Purchase/Acquisition of Intangibles Other Investing Cash Flow Items, Total Acquisition of Business Sale of Fixed Assets Sale/Maturity of Investment Investment, Net Purchase of Investments Sale of Intangible Assets Other Investing Cash Flow

2009 12/31/2008 12

2008 12/31/2008 12

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Cash from Investing Activities Financing Cash Flow Items Other Financing Cash Flow Total Cash Dividends Paid Issuance (Retirement) of Stock, Net Issuance (Retirement) of Debt, Net Cash from Financing Activities Foreign Exchange Effects Net Change in Cash Net Cash - Beginning Balance Net Cash - Ending Balance

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

3

4

5

2007 12/31/2007 12

2006 12/31/2006 12

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Financial Statement
1) 2) Annual and Interim displays types are available. Check the ones that you prefer:
Annual Interim

Your Financial Statement will be displayed annually and quarterly. > For annual display, how many years do you want to display?
1 2 3 4 5

Type the final year in your financial statement: 2009 > For quarterly display, how many periods do you want to display?
1 2 3 4 5

Type the periods that you want to display. Year 2008 2008 2008 2008 2007 3) Q Q4 Q3 Q2 Q1 Q4 Length (months) 3 3 3 3 3

On the "Data" sheet you will see the lines of Financial Statement in standard format. Provide the necessary information. Fill only the white cells. You can uncheck the items which you do not want to display on your Financial Statement.

4) >>

Type the name of your company: ABC, Inc. Your Income Statement, Balance Sheet and Cash Flow are ready to use. a password, if necessary.

These 3 sheets are prepared for displaying the statements, hence, they are all protected. However, the sheets can be unprotected w

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

e sheets can be unprotected without

TRUE

TRUE

FALSE

4

4

4

4

1 1 1
0. GENERAL 2009 Period End Date Period Length Statement Source Statement Source Date Statement Update Type 1. INCOME STATEMENT 2009 Revenue Other Revenue, Total Total Revenue Cost of Revenue Gross Profit Fuel Expense Operations & Maintenance Selling/General/Administrative Expenses, Total Research & Development Depreciation/Amortization Interest Expense (Income), Net Operating Unusual Expense (Income) Other Operating Expenses, Total Operating Income Interest Income (Expense), Net Non-Operating Gain (Loss) on Sale of Assets Allowance for Funds Used during Const. Other, Net Income Before Tax Income Tax - Total Income After Tax 0.00 0.00 0.00 0.00 0.00 12/31/2008 12

2 1 2
2008 12/31/2008 12

3 1 3
2007 12/31/2007 12

4 1 4
2006 12/31/2006 12

5 2 1
2008-Q4 12/31/2008 3

6 2 2
2008-Q3 9/30/2008 3

2008

2007

2006

2008-Q4

2008-Q3

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00

0.00

0.00

0.00

0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

Minority Interest Equity In Affiliates U.S. GAAP Adjustment Net Income Before Extra. Items Total Extraordinary Items Net Income Total Adjustments to Net Income Preferred Dividends Preferred Dividends General Partners'Partners' Distributions General Distributions Basic Weighted Average Shares Basic EPS Excluding Extraordinary Items Basic EPS Including Extraordinary Items Diluted Weighted Average Shares Diluted EPS Excluding Extrordinary Items Diluted EPS Including Extraordinary Items Dividends per Share - Common Stock Primary Issue Gross Dividends - Common Stock Interest Expense, Supplemental Depreciation, Supplemental Normalized EBITDA Normalized EBIT Normalized Income Before Tax Normalized Income After Taxes Normalized Income Available to Common Basic Normalized EPS Diluted Normalized EPS Amortization of Intangibles 2. BALANCE SHEET Assets Cash and Short Term Investments Cash & Equivalents Cash & Equivalents Short Term Investments Short Term Investments Total Receivables, Net 0.00 0.00 0.00 0.00 0.00 0.00 2009 0.00 2008 0.00 2007 0.00 2006 0.00 2008-Q4 0.00 2008-Q3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Accounts Receivable - Trade, Net Accounts Receivable - Trade, Net Accounts Receivable - Trade, Gross - Trade, Gross Accounts Receivable Provision for Doubtful Accounts Provision for Doubtful Accounts Notes Receivable - Short Term Term Notes Receivable - Short Receivables - Other - Other Receivables Total Inventory Prepaid Expenses Other Current Assets, Total Total Current Assets Property/Plant/Equipment, Total - Net Goodwill, Net Intangibles, Net Total Utility Plant, Net Long Term Investments Note Receivable - Long Term Other Long Term Assets, Total Other Assets, Total Total Assets Liabilities and Shareholders' Equity Accounts Payable Payable/Accrued Accrued Expenses Notes Payable/Short Term
				
DOCUMENT INFO
Description: This file is created for preparing Income Statement, Balance Sheet and Cash Flow, each on another sheet. Flexibility of the template allows users to easily edit the statements with controls on another sheet. The annual or interim (or both) statements may be created. Up to 5 periods may displayed on the statements. The statements are created in standard format. However, flexible design of the template allows to create the rows that will be displayed by using the checkboxes only.
BUY THIS DOCUMENT NOW PRICE: $12.99 100% MONEY BACK GUARANTEED
PARTNER SpreadsheetZone
SpreadsheetZONE features one of the biggest Microsoft Excel template repositories on the web. Supported by an active community and Excel Pros SpreadsheetZONE grows rapidly, delivering new templates everyday. Find the template you need now!