Chapter 4: Financial Planning using Percentage of Sales Baseline: Operating capacity 80% 2019 Income Statement Sales Rp 905.000 COGS 710.000 Gross Profit 195.000 Other expenses 12.000 EBIT Rp 183.000 Interest expense 19.700 EBT Rp 163.300 Taxes 57.155 Net income Rp 106.145 Assets Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment 2019 Balance Sheet as of 31 Dec Liabilities and Owners' Equity Current liabilities 25.000 Accounts payable 65.000 43.000 Notes payable 9.000 76.000 Total 74.000 144.000 Long-term debt 156.000 Owners' equity 364.000 Common stock and 21.000 Paid-in surplus Retained earnings 257000 Total 278.000 Total liabilities and 508.000 owners' equity 508.000 Rp Dividends Add. To R/E 42.458 63.687 Total assets Scenario 1 Operating capacity 10% Sales increase 30% interest expense Constant Tax rate Constant Dividers Payout Constant Cost Var to Sales other expense Varto Sales Current assets Varto Sales Accounts payable Var to Sales 2020 Proforma Income Statement Sales Rp COGS Gross Profit Other expenses EBIT Rp Interest expense EBT Rp Taxes Net income Rp 2020 Proforma Balance Sheet as of 31 Dec Assets Liabilities and Owners' Equity Current assets Current liabilities Cash Accounts payable Accounts receivable Notes payable Inventory Total Total Long-term debt Fixed assets Net plant and Owners' equity equipment Common stock and Paid-in surplus Retained earnings Total Total liabilities and Total assets owners' equity EFN >> Rp Dividends Add. To RIE