FORECASTING FINANCIAL STATEMENTS -

Company A reported an income statement and balance sheet as shown below:

Company A
Income Statement
For the Years Ended
	2017
Sales	550.00
Cost of sales	275.00
Gross profit	275.00
SG&A	55.00
Depreciation	60.00
Interest	14.47
Pretax income	145.53
Tax	43.66
Net income	101.87

Company A
Balance Sheet
As of
	2017
Cash	60.00
Accounts receivable	5.00
Inventory	8.00
Total current assets	73.00
PP&E - gross	600.00
Accumulated depreciation	200.00
PP&E - net	400.00
Total assets	473.00
Accounts payable	20.00
Other current liabilities	10.00
Total current liabilities	30.00
Notes payable	241.13
Total liabilities	271.13
Common stock	100.00
Retained earnings	101.87
Total equity	201.87
Total liabilities and equity	473.00

Use the following assumptions to forecast pro-forma income statement and balance sheets for a 5-year period and a terminal year: (PLEASE SHOW FORMULAS USED TO SOLVE PROBLEM)

(a) Sales increase to $825 in the first year and then increase 20 percent the second year, 15 percent the third year, 10 percent in the fourth year, and 7 percent in the fifth year. Terminal year increases at the assumed growth rate of 4 percent.

(b) Cost of sales is 35 percent of sales.

(c) Sales, general, and administrative expenses are 15 percent of sales.

(d) Depreciation is 8 percent of gross end-of-year property, plant, and equipment.

(e) Interest expense is 5 percent of end-of-year notes payable.

(f) Tax expense is 35 percent of pretax income.

(g) Cash is equal to three month's cost of sales (use current year costs of sales divided by 4).

(h) Accounts receivable has a turnover ratio of 9.0.

(i) Inventory has a turnover ratio of 4.0

(j) Gross property, plant, and equipment gross at the same rate as sales.

(k) Accumulated depreciation increases in Years 1 through 5 by the amount of the current year depreciation. Accumulated depreciation in the terminal year is equal to $711.36

(l) Accounts payable has a turnover ratio of 6.0

(m) Other current liabilities are $35 in Year 1, increasing by $10 in each of Year 2 thorugh 5, and equal to $78.00 in the terminal year.

(n) Notes payable are $498.94 in Year 1, $521.48 in Year 2, $493,56 in Year 3, $401.47 in Year 4, $264.22 in Year 5, and $274.79 in the terminal year

(o) Common stock is remains at $100 in Years 1 through 5, increasing to $104 in the terminal year.

(p) Retained earnings increases by the current year net income less dividends of $125 in Year 1, $150.01 in Year 2, $174.99 in Year 3, $200.01 in Year 4, $224.99 in Year 5, and $339.19 in the terminal year.

q) The depreciation add back in the operating cash flow section of the statement of cash flows is equal to the change in accumulated depreciation for the year.

BELOW IS THE SPREADSHEETS REQUESTED:

Company A
Income Statement
For the Years Ended
	2017	2018	2019	2020	2021	2022	Terminal year 2023
Sales
Cost of Sales
Gross Profit
SG&A
Depreciation
Interest
Pretax Income
Tax (35% of Pretax Income)
Net Income

Company A
Balance sheet
As of
	2017	2018	2019	2020	2021	2022	Terminal year 2023
Cash
Accounts Receivable
Inventory
Total Current Assets
PP&E - gross
Accumulated Depreciation
PP&E - net
Total Assets
Accounts Payable
Other Current Liabilities
Total Current Liabilities
Notes Payable
Total Liabilities
Common Stock
Retained Earnings
Total Equity
Total Liabilities and Equity