Amortization Chart Printable - Excel

Document Sample
Amortization Chart Printable - Excel Powered By Docstoc
					The information on this page is intended to make the template easier to use. It describes requirements, specific design features, and hints for
overcoming challenges the designers encountered during development that resulted from the variety of ways financial statements are presented in
annual reports and/or 10K filings at www.sec.gov.

There are three requirements for making this template function properly:
1) Enable all imbedded macros by single-clicking on the                                                          button displayed when opening the template file.
2) All financial statement data must be entered. If a line item does not have an explicit template line item match, include the amount as part
   of a formula on an 'Other…' line item such as 'Other current assets' or 'Other operating expenses'.
3) Ensure Analysis ToolPak add-in is active.
   Verify by selecting the menu path Tools > Add-Ins…, and ensure the 'Analysis ToolPak' add-in is checked.




            NOTE: If the Add-Ins option is unavailable, it will have to be installed from your original Microsoft Office/Excel CD.

Three buttons are common to each of the enterable financial statement worksheets –                                                                                        . It is
important to understand their function because all sheets are protected to preserve the integrity of total totals and ratio formulas.
                - Allows entry of data into appropriate cells and displays entry hints
                - Displays printable versions of financial statements and hides entry hints
                - Clears values from all enterable cells and prepares the worksheet for data entry

The            worksheet should be completed first. It is enterable and also contains a                                              button.
The remaining worksheets –                                                                                                                     are automatically generated by the
template. No entry is required or permitted.
The template is flagged as ‘read-only’ to permit reuse. If you save your work, you will be prompted to rename the file.

Recommendations:
   Set monitor resolution to 1024 x 768 to minimize scrolling during data entry.
   Use a formula statement [= n + n + n ] rather than a hand-calculated summary amount when combining multiple financial statement lines
     into a single template cell. This will aid when troubleshooting entry errors that could result in mismatched check figures.
   Use the TAB key to navigate between cells. The active cell is automatically moved to the next cell which accepts data.


          worksheet supplemental information
Colored fields have special significance. Only cells with borders permit data entry.
           – financial statement header information

           – special data needed for ratios that cannot be found as line items on financial statements

           – check figures for financial statement summary comparisons
An unbordered, colored cell on any sheet indicates Cover worksheet data has not been entered or a summary total on a financial statement
  does not compare favorably to its associated Cover worksheet check figure.
Rent Expense - Amounts can usually be found in the 'Notes to consolidated financial statements' section of a company's annual report or 10K.
Rent expense amounts are generally discussed under a note heading titled 'Commitments' or 'Commitments and Contingencies' and sometimes
included under a note heading titled 'Leases'.

Dividends per Share - Amounts can usually be found on one of following statements: Statement of Stockholders' Equity, Statement of Cash Flows,
or Statement of Operations. Dividends per share amounts are also often included in the 'Notes to consolidated financial statements' section of a
company's annual report or 10K under note headings titled 'Selected Financial Data', 'Five Year Summary Data', or 'Quarterly Financial Data'.
The information on this page is intended to make the template easier to use. It describes requirements, specific design features, and hints for
overcoming challenges the designers encountered during development that resulted from the variety of ways financial statements are presented in
annual reports and/or 10K filings at www.sec.gov.

End of Year Stock Price– the template supports researching a company’s year-end stock price when following these steps:
a) Enter the company’s Stock Ticker Symbol
b) Enter the year end dates for the three years covered on the annual report
c) Copy        the contents from one year’s URL cell to the clipboard




d) Paste       the clipboard contents into an open browser’s Address field (Internet Explorer is shown)


e) Click the           button (or your browser’s equivalent) to access the Marketwatch web site for the company’s stock price
f)   Make sure the Split Adjusted Price (see red arrow below) is used, if available; otherwise, use the Closing Price




g)   If the market was closed on the day supplied by the URL, change the historical quote date (see red arrow below) to the next earlier
     weekday until data is available.




h)   Repeat steps c) through g) for the remaining years
Gross Profit - If Gross Profit is not listed on the Income Statement/Statement of Operations, review financial data for COGS information and enter
a formula to net Sales and COGS. If there is no COGS data, enter the Net Sales amount as the Gross Profit amount. Service companies may not
display a Cost of Goods/Cost of Sales amount.
Cost of Goods / COGS / Cost of Sales / Cost of Revenue are alternative titles for the same data
Operating Profit- Do not include Interest Expense or Other Income (Loss) items in this check figure; otherwise, the check figure will not compare
favorably with the Income Statement Operating Profit subtotal. These are non-operating items and should be entered below the operating profit
line.
Operating Profit / Operating Income / Earnings from Operations   are alternative titles for the same data
The information on this page is intended to make the template easier to use. It describes requirements, specific design features, and hints for
overcoming challenges the designers encountered during development that resulted from the variety of ways financial statements are presented in
annual reports and/or 10K filings at www.sec.gov.



                         worksheet supplemental information
Interest Expense - This line item must be segregated to ensure correct ratio calculations. Interest Expense is sometimes included in the 'Other
Income (Expense/Loss)' line item. In that situation, look in the 'Notes to consolidated financial statements' section to find the actual amount of
Interest Expense that should be entered and use a formula to exclude it from the 'Other Income (Expense/Loss)' line. If a company has no short- or
long-term debt, there will generally be no Interest Expense.


               worksheet supplemental information
Interest Paid and Income Taxes Paid (Refunded) are generally found       at the end of the Cash Flow Statement. If not, look in the 'Notes to consolidated
financial statements'.


            worksheet supplemental information
To display the underlying formulas related to ratios, single-click the                          button
To redisplay the ratios, single-click the                       button
              Please enter data on this sheet before entering financial statement information.
                       The 'Analysis ToolPak' add-in must be installed and active.

                               Company Name:
                          Stock Ticker Symbol:
                         U.S. Stock Exchange:           12/31/2000                                      Fixed
    Year End Dates for Financial Statements:
               Financial Reports Rounded to :


   Supplemental Ratio Requirements:                    0                       0                         0
                             Rent expense (in ):
                            Dividends per share:
     End of year stock price (adjusted for splits ):
       Marketwatch.com URL for stock prices:                      0                        0                    0




            Check Figures:
 Balance Sheet             Current Assets:
                                    Total Assets:
                               Current Liabilities:
                     Total Stockholders' Equity:


Income Statement                     Gross Profit:
                                Operating Profit:
                                       Net Profit:


Cash Flow           Net Flows from Operations:
             Net Flows from Investing Activity:
             Net Flows from Financing Activity:
                                                           No enterable fields exist below this point
                                                             0
                                          Annual Consolidated Balance Sheet
                                                    Amounts Rounded to :

                                                                                       Results as of
                                                                                  Jan 0, 1900        Jan 0, 1900
ASSETS
  Current Assets:
   Cash and cash equivalents
   Short-term investments
    Total cash and short-term investments                                                   -                 -
   Accounts receivable, net
   Inventories, net
   Current deferred taxes
   Other current assets
      Total current assets                                                                  -                 -
   Property, plant, and equipment
   Less: accumulated depreciation
    Net property, plant, and equipment                                                      -                 -
   Long-term investments
   Goodwill, net
   Other intangibles, net
   Other deferred taxes
   Other assets
       Total assets                                                           $             -   $             -

LIABILITIES
  Current Liabilities:
   Accounts payable
   Short-term debt
   Current portion of long-term debt
   Accrued liabilities
   Income taxes payable
   Other current liabilities
    Total current liabilities                                                               -                 -
   Long-term debt
   Deferred income taxes payable
   Other deferred liabilities
   Other liabilities
      Total liabilities                                                                     -                 -
   Minority interest

STOCKHOLDERS' EQUITY
   Preferred stock
   Common stock, par value plus additional paid-in capital
   Retained earnings (accumulated deficit)
   Treasury stock
   Accumulated other comprehensive income (loss)
   Other stockholders' equity
      Total stockholders' equity                                                            -                 -

       Total liabilities and stockholders' equity                             $             -   $             -
                                                           0
                                  Annual Consolidated Income Statement
                                    Amounts Rounded to :   (except per share amounts)


                                                                                 Results for the Years Ending
                                                                          Jan 0, 1900         Jan 0, 1900     Jan 0, 1900

Net sales
Less: Cost of goods sold
  Gross profit                                                                          -            -                 -
Sales, general and administrative
Research and development (R&D)
Restructuring, impairment, and amortization
Purchased in-process R&D
Other operating expenses
 Total operating expenses                                                               -            -                 -
  Operating profit (loss)                                                               -            -                 -
Other income (expenses), net excluding interest expense
 Earnings (loss) before interest and taxes                                              -            -                 -
Interest expense
 Earnings (loss) before taxes                                                           -            -                 -
Provision for (benefit from) income taxes
 Earnings (loss) after taxes                                                            -            -                 -
Extraordinary items, net
Discontinued operations, net
Cumulative effect of changes in accounting principles, net
Other after-tax income (loss), net

  Net profit (loss)                                                  $                  -   $        -   $             -


Basic earnings per common share
                                                               0
                                    Annual Consolidated Statement of Cash Flows
                                                      Amounts Rounded to :


                                                                                        Results for the Years Ending
                                                                                 Jan 0, 1900         Jan 0, 1900     Jan 0, 1900
Cash flows from operating activities:
  Income (loss) from continuing operations
  Adjustments to reconcile to net cash provided by operating activities:
    Restructuring charges
    Impairment charges
    Depreciation and amortization
    (Gain) loss on sales of investments, acquisitions, and securities
    (Gain) loss on sales of property, plant, and equipment
    Increase (decrease) in provision for deferred income taxes
    Other non-cash items, net
    Changes in assets and liabilities:
      (Increase) decrease in receivables
      (Increase) decrease in inventories
      (Increase) decrease in other current assets
      Increase (decrease) in accounts payable,
        accrued liabilities, and income taxes payable
      Increase (decrease) in deferred liabilities
      Other assets and liabilities, net
     Net cash provided by (used in ) operating activities                                  -                -                 -

Cash flows from investing activities:
  Purchases of property, plant, and equipment
  Sales of property, plant, and equipment
  Purchases of marketable securities and short-term investments
  Sales of marketable securities and short-term investments
  Acquisitions, net of cash acquired
  Other investing activities, net
     Net cash provided by (used in) investing activities                                   -                -                 -

Cash flows from financing activities:
  Short-term borrowings, net
  Proceeds from long-term borrowings
  Payment of long-term borrowings
  Proceeds from sales of common stock
  Repurchase of common stock / treasury stock
  Dividends to shareholders
  Other financing activities, net
     Net cash provided by (used in) financing activities                                   -                -                 -
  Net cash provided by (used for) discontinued operations
  Effect of exchange rate changes on cash, net
  Net increase (decrease) in cash and equivalents for period                               -                -                 -
  Cash and equivalents, beginning of period                                                -
    Cash and equivalents, end of period                                      $             -   $            -   $             -

Supplemental disclosures of cash flow information:
  Cash paid during the year for:
   Interest
   Income taxes (refunded)
                                                      0
                                    Summary of Financial Statement Ratios

                                                               Results for the Years Ending
                                               Jan 0, 1900              Jan 0, 1900               Jan 0, 1900
Liquidity Ratios:
  Current ratio                                    0.00 0                  0.00 0
  Quick ratio                                      0.00 0                  0.00 0
  Cash flow liquidity                              0.00 0                  0.00 0
 Average collection period                            0   0                   0   0
 Days inventory held                                  0   0                   0   0
 Days payable outstanding                             0   0                   0   0
  Cash conversion cycle                               0   0                   0   0


Activity Ratios:
 Accounts receivable turnover                      0.00   0                0.00   0
 Inventory turnover                                0.00   0                0.00   0
 Payables turnover                                 0.00   0                0.00   0
 Fixed asset turnover                              0.00   0                0.00   0
 Total asset turnover                              0.00   0                0.00   0


Leverage Ratios:
 Debt ratio                                        0.00   0                0.00   0
 Long-term debt to total capitalization            0.00   0                0.00   0
 Debt to equity                                    0.00   0                0.00   0
 Financial leverage (FL)                           0.00   0                0.00   0
 Times interest earned                             0.00   0                0.00   0                  0.00   0
 Cash interest coverage                            0.00   0                0.00   0                  0.00   0
 Fixed charge coverage                             0.00   0                0.00   0                  0.00   0
 Cash flow adequacy                                0.00   0                0.00   0                  0.00   0


Profitability Ratios:
  Gross profit margin                              0.00   0                0.00   0                  0.00   0
  Operating profit margin                          0.00   0                0.00   0                  0.00   0
  Net profit margin                                0.00   0                0.00   0                  0.00   0
  Cash flow margin                                 0.00   0                0.00   0                  0.00   0
  Return on assets (ROA)
                                                   0.00 0                  0.00 0
   or Return on investment (ROI)
  Return on equity (ROE)                           0.00 0                  0.00 0
  Cash return on assets                            0.00 0                  0.00 0


Market Ratios:
 Earnings per share                        $       -              $        -                  $      -
 Price-to-earnings                                 0.00 0                  0.00 0                    0.00 0
 Dividend payout                                   0.00 0                  0.00 0                    0.00 0
 Dividend yield                                    0.00 0                  0.00 0                    0.00 0

NOTES: If a ratio's numerator and/or denominator equals zero, no ratio is displayed.
      "N/M" indicates a calculated ratio is not meaningful for analysis
                                                                  0
                                          Annual Common Size Balance Sheet
                                       Summary percentages in italics will not foot due to rounding

                                                                                                           Results as of
                                                                                                      Jan 0, 1900        Jan 0, 1900
ASSETS
  Current Assets:
   Cash and cash equivalents
   Short-term investments
     Total cash and short-term investments
    Accounts receivable, net
    Inventories, net
    Current deferred taxes
    Other current assets
      Total current assets
    Property, plant, and equipment
    Less: accumulated depreciation
     Net property, plant, and equipment
    Long-term investments
    Goodwill, net
    Other intangibles, net
    Other deferred taxes
    Other assets
        Total assets

LIABILITIES
  Current Liabilities:
   Accounts payable
   Short-term debt
   Current portion of long-term debt
   Accrued liabilities
   Income taxes payable
   Other current liabilities
     Total current liabilities
    Long-term debt
    Deferred income taxes payable
    Other deferred liabilities
    Other liabilities
      Total liabilities

    Minority interest

STOCKHOLDERS' EQUITY
   Preferred stock
   Common stock, par value plus additional paid-in capital
   Retained earnings (accumulated deficit)
   Treasury stock
   Accumulated other comprehensive income (loss)
   Other stockholders' equity
      Total stockholders' equity

        Total liabilities and stockholders' equity
                                                            0
                                  Annual Common Size Income Statement
                                 Summary percentages in italics will not foot due to rounding


                                                                                     Results for the Years Ending
                                                                              Jan 0, 1900         Jan 0, 1900     Jan 0, 1900

Net sales
Less: Cost of goods sold
  Gross profit
Sales, general and administrative
Research and development (R&D)
Restructuring, impairment, and amortization
Purchased in-process R&D
Other operating expenses
 Total operating expenses
  Operating profit (loss)
Other income (expenses), net excluding interest expense
 Earnings (loss) before interest and taxes
Interest expense
 Earnings (loss) before taxes
Provision for (benefit from) income taxes
 Earnings (loss) after taxes
Extraordinary items, net
Discontinued operations, net
Cumulative effect of changes in accounting principles, net
Other after-tax income (loss), net

  Net profit (loss)

Effective tax rate
                                                          0
                       Annual Common Size Multiple Source Revenue & COGS
                               Summary percentages in italics will not foot due to rounding


                                                                                   Results for the Years Ending
                                                                            Jan 0, 1900         Jan 0, 1900     Jan 0, 1900
Revenues by Source as a % of Net Sales
 Replace with source1 title
 Replace with source2 title
 Replace with source3 title
 Replace with source4 title
 Other revenues
Summary of revenue sources as a % of net sales
COGS as a % of Associated Revenue Source
 Replace with source1 title
 Replace with source2 title
 Replace with source3 title
 Replace with source4 title
 Other cost of goods sold
Gross Profit Margin for Associated Revenue Source
 Replace with source1 title
 Replace with source2 title
 Replace with source3 title
 Replace with source4 title
 Other revenues
                                                                                              0
                                                         Annual Summary Analysis Statement of Cash Flows
                                                              Summary percentages in italics do not foot due to rounding differences


                                                                                                                               Results for the Years Ending
                                                                                            Jan 0, 1900                   0       Jan 0, 1900               0      Jan 0, 1900     0
Inflows                                                                               $                                       $                               $
  Proceeds from operating activities                                                                     -                                    -                             -
  Sales of property, plant, and equipment                                                                -                                    -                             -
  Sales of marketable securities and short-term investments                                              -                                    -                             -
  Divestiture of acquisitions, net of cash acquired                                                      -                                    -                             -
  Proceeds from other investing activities, net                                                          -                                    -                             -
  Proceeds from short-term borrowings, net                                                               -                                    -                             -
  Proceeds from long-term borrowings                                                                     -                                    -                             -
  Proceeds from sales of common stock                                                                    -                                    -                             -
  Proceeds from other financing activities, net                                                          -                                    -                             -
  Proceeds from discontinued operations                                                                  -                                    -                             -
  Gains from effect of exchange rate changes on cash, net                                                -                                    -                             -

    Total Inflows                                                                      $                 -             0.0    $              -           0.0   $            -    0.0

Outflows                                                                              $                                       $                                $
 Losses from operating activities                                                                        -                                   -                              -
 Purchases of property, plant, and equipment                                                             -                                   -                              -
 Purchases of marketable securities and short-term investments                                           -                                   -                              -
 Acquisitions, net of cash acquired                                                                      -                                   -                              -
 Losses from other investing activities, net                                                             -                                   -                              -
 Payment of short-term borrowings, net                                                                   -                                   -                              -
 Payment of long-term borrowings                                                                         -                                   -                              -
 Repurchase of common stock / treasury stock                                                             -                                   -                              -
 Payment of dividends to shareholders                                                                    -                                   -                              -
 Payment of other financing activities, net                                                              -                                   -                              -
 Losses from discontinued operations                                                                     -                                   -                              -
 Losses from effect of exchange rate changes on cash, net                                                -                                   -                              -

    Total Outflows                                                                     $                 -             0.0    $              -           0.0   $            -    0.0

Net increase (decrease) in cash and cash equivalents                                                     -                                   -                              -
                                                      0
                                        Additional Ratio Analysis

                                                                Growth Rate Comparisons Between
                                                                0 vs. 0                   0 vs. 0
Selected Income Statement Growth Rates:
 Sales growth rate                                                 0.00    0                   0.00   0
 Gross profit growth rate                                          0.00    0                   0.00   0
 Operating expenses growth rate                                    0.00    0                   0.00   0
 Operating profit growth rate                                      0.00    0                   0.00   0
 Net profit growth rate                                            0.00    0                   0.00   0


Accounts Receivable Analysis
  Sales growth rate                                                0.00 0                      0.00 0
  Gross accounts receivable growth rate                            0.00 0
  Accounts receivable allowance growth rate                        0.00 0

                                                                   Results for the Years Ending
                                                              Jan 0, 1900                 Jan 0, 1900
  Allowance as a % of gross accounts receivable                    0.00 0                       0.00 0




NOTES: If a ratio's denominator equals zero, no ratio is displayed.
       "N/M" indicates a calculated ratio is not meaningful for analysis

				
DOCUMENT INFO
Description: Amortization Chart Printable document sample