Forecasting a firm's financial statements can help both financial managers and general managers. Pro forma statements help the financial manager plan the firm's financial needs. With an estimate of future income statement and balance sheet accounts, a manager can tell how much financing might be needed, and when it might be needed. Therefore, a company like the Body Shop can use forecasted financial statements to estimate how much future external debt financing the company needs.
Given the Body Shop’s growth level of 36.8% and 27.5% in the period between 1990-1992, it is assumed that the Body Shop will be able to sustain a relatively high growth rate …show more content…
This can then be duplicated for the next two years. Once completed, you can see that interest is exactly 10% of long term liabilities and the balance sheet balances.
PROJECTING FARTHER | | | | INPUT DATA | (in millions) | | | | | | | | 1993 | 1994 | 1995 | SALES | 191,673 | 249,175 | 323,927 | COGS/SALES | 0.44 | 0.44 | 0.44 | OPERATING EXPENSE/SALES | 0.36 | 0.36 | 0.36 | INTEREST RATE | 0.10 | 0.10 | 0.10 | TAX RATE | 0.35 | 0.35 | 0.35 | DIVIDENDS | 0.19 | 0.19 | 0.19 | CURRENT ASSETS/SALES | 0.42 | 0.42 | 0.42 | CURRENT LIABILITIES/SALES | 0.35 | 0.35 | 0.35 | FIXED ASSETS | 58,657 | 58,657 | 58,657 | STARTING EQUITY | 74,360 | 74,360 | 74,360 | | | | | INCOME STATEMENT | 1993 | 1994 | 1995 | | | | | SALES | 191,673 | 249,175 | 323,927 | COGS | 84,336 | 109,637 | 142,528 | OPERATING EXPENSE | 69,002 | 89,703 | 116,614 | INTEREST EXPENSE | (2,372) | (4,848) | (8,166) | PROFIT BEFORE TAX | 40,706 | 54,683 | 72,951 | TAX | 14,247 | 19,139 | 25,533 | PROFIT AFTER TAX | 26,459 | 35,544 | 47,418 | DIVIDENDS | 5,027 | 6,753 | 9,010 | EARNINGS RETAINED | 21,432 | 28,791 | 38,409 | | | | | BALANCE SHEET | 1993 | 1994 | 1995 | | | | | CURRENT ASSETS | 80,503 | 104,653 | 136,049 | FIXED ASSETS | 58,657 | 58,657 |