Pro-Forma Balance Sheet[4]

Pro-Forma Balance Sheet This template is a financial planning tool for businesses. It is especially useful for estimating long-term financing needs. The first year date is entered manually, but subsequent year headings are calculated. The Retained Earnings figure for each year is calculated, to insure that Assets equal Liabilities plus Equity. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next. Copyright © KMT Software, Inc. All Rights Reserved.Pro-Forma Balance Sheet <--Enter company name in cell to the left 2000 (all numbers in $000) ASSETS 2000 2001 2002 2003 Current Assets Cash Net accounts receivable Inventory Temporary investment Prepaid expenses Total Current Assets Fixed Assets Long-term investments Land Buildings (net of depreciation) Plant & equipment (net) Furniture & fixtures (net) Total Net Fixed Assets TOTAL ASSETS LIABILITIES Current Liabilities Accounts payable Short-term notes Current portion of long-term notes Accruals & other payables Total Current Liabilities Long-term Liabilities Mortgage Other long-term liabilities Total Long-term Liabilities SHAREHOLDERS' EQUITY Capital stock Retained earnings Total Shareholders' Equity TOTAL LIABILITIES & EQUITY