Points 4 Initial Forecast Factor Basis Final Forecast $ $ 1 Directions: 1). Complete the Financial Statement. 32). Complete the initial Forecast. 3). Complete the Final Forecast. 1. File > Save As, include your name (5 millions) Actual Results Factor Basis Net sales 1,600.00 1.2 growth Cost of Goods sold $ (1,312.00 0.8% sales Gross profit $ 288.00 Fixed operating costs $ (90.00 ($5.00) additional Depreciation 5 (50.00 11 growth 2 EBIT 3: Less: Interest $ (40.00) * Earnings before taxes (EBT) $ Taxes (40%) 40% tax rate Net income 7. Common dividends $ 1.16 div paid/shr Shares Outstanding Addition to retained earnings $ $ $ 13% interest rate W NNWWWNWNNW NN $ 1.00 div cut Assets Actual Balances Factor Basis Initial Forecast Factor Basis Final Forecast 2 millions 3: Cash Accounts receivable 5 Inventories $ Total current assets Net plant and equipment Total assets $ $ $ 15.00 180.00 270.00 1.21 growth 11% % Sales 1.2 growth $ $ $ $ $ $ W NWNNN son S 390.00 1. growth Liabilities 2018 Actual Balances Factor Basis 2019 Initial Forecast Factor Basis 2019 Initial Forecast $ $ $ 30.00 60.00 50.00 1.21 growth 1.2 growth 0$ millions) 1 Accounts payable Accruals Notes payable Total current liabilities 5 Long-term bonds 6 Total liabilities Common stock Retained earnings Total owners' equity Total liabilities and equity Additional funds needed (AFN) $ $ $ 3.00 more debt $ $25.00 more debt $ $ from above 300.00 $ $ 130.00 285.00 from above 3 2 80 80 100% Points 4 Initial Forecast Factor Basis Final Forecast $ $ 1 Directions: 1). Complete the Financial Statement. 32). Complete the initial Forecast. 3). Complete the Final Forecast. 1. File > Save As, include your name (5 millions) Actual Results Factor Basis Net sales 1,600.00 1.2 growth Cost of Goods sold $ (1,312.00 0.8% sales Gross profit $ 288.00 Fixed operating costs $ (90.00 ($5.00) additional Depreciation 5 (50.00 11 growth 2 EBIT 3: Less: Interest $ (40.00) * Earnings before taxes (EBT) $ Taxes (40%) 40% tax rate Net income 7. Common dividends $ 1.16 div paid/shr Shares Outstanding Addition to retained earnings $ $ $ 13% interest rate W NNWWWNWNNW NN $ 1.00 div cut Assets Actual Balances Factor Basis Initial Forecast Factor Basis Final Forecast 2 millions 3: Cash Accounts receivable 5 Inventories $ Total current assets Net plant and equipment Total assets $ $ $ 15.00 180.00 270.00 1.21 growth 11% % Sales 1.2 growth $ $ $ $ $ $ W NWNNN son S 390.00 1. growth Liabilities 2018 Actual Balances Factor Basis 2019 Initial Forecast Factor Basis 2019 Initial Forecast $ $ $ 30.00 60.00 50.00 1.21 growth 1.2 growth 0$ millions) 1 Accounts payable Accruals Notes payable Total current liabilities 5 Long-term bonds 6 Total liabilities Common stock Retained earnings Total owners' equity Total liabilities and equity Additional funds needed (AFN) $ $ $ 3.00 more debt $ $25.00 more debt $ $ from above 300.00 $ $ 130.00 285.00 from above 3 2 80 80 100%
