only need 2-4 and 6 if possible
D L M 1 2 3 4 2012 5 6 7 5 Assets: Cash Accounts Receivable Inventory Total Current Balance Sheet Llobe Acc Payable Accruals Total Current 2012 2015 S 160 $ 154 $ 5255 455 5 497 $450 s 1,182 $ 1.059 2018 2665 100 2005 150 466 $ 250 Income Statement 2019 Seles $ 1,509 Cost of Goods Sold 5 900 Depreciation 5 90 Operating Income $ 519 $ 8 Long-Term Debt Total Liab $ $ 224 $ 690$ 350 600 10 Net Fixed Assets Total Agents 1.650 1.400 $152.882 2859 Interest Expense Pre-tax Income 5 $ 70 449 12 13 14 $ $ 494 Taxes Net Income Common Per Capital Surplus Retained Earnings Treasury Stock Total Eq Total Liab & Eq $ 5 212 237 15 $ $ $ 55 $ 45 585 $ 1,552 5 1,370 (50) $ 150) 2,1425 3.859 2,832 $2,459 16 17 Dividends Addition to RE'S 5 $ 55 182 $ 11 19 20 21 22 23 25 26 27 28 29 31 32 34 + 36 37 38 39 40 42 You need the excel spreadsheet provided that has financials for a firm. 1. Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and Cash Flow to Shareholders for the firm, 2. Assume you are sitting in a board meeting discussing the firm's plans for sales growth. You are telling the board that you expect to grow sales by 7.5 %. After explaining your plan, a board member asks you for an estimate of how much funding you will need in 2020. What is your answer if you use the formula for External Funds Needed? 3. Now assume the board member asks whether or not you can achieve the growth holding your capital structure constant. What is your answer? 4. What is your answer if the board member asks if you can achieve the growth without issuing ANY new external financing? 5. Calculate the following ratios for the firm for 2019. Current Quick Cash Debt Equity Mult Cash Coverage Inventory Turn Days Sales in Inv Rec Turn Days Sales Out Total Asset Turn Profit Margin ROA ROE 6. Also calculate ROE using the expanded DuPont formula. Income Statement 2019 Sales 1,509 Cost of Goods Sold 900 Depreciation 90 Operating Income 519 Interest Expense Pre-tax Income 70 449 Taxes Net Income 212 237 Dividends Addition to RE's 55 182 2019 266 Assets: Cash Accounts Receivable Inventory Total Current 2019 160 525 497 1,182 Balance Sheet Liab+Eq: Acc Payable Accruals Total Current 2018 154 455 450 1,059 2018 100 150 200 466 250 Long-Term Debt Total Liab 224 690 350 600 Net Fixed Assets Total Assets 1,650 2.832 1,400 2.459 Common @ Par Capital Surplus Retained Earnings Treasury Stock Total Eq Total Liab & Eq 55 585 1,552 -50 2.142 2.832 45 494 1,370 -50 1.859 2,459 D L M 1 2 3 4 2012 5 6 7 5 Assets: Cash Accounts Receivable Inventory Total Current Balance Sheet Llobe Acc Payable Accruals Total Current 2012 2015 S 160 $ 154 $ 5255 455 5 497 $450 s 1,182 $ 1.059 2018 2665 100 2005 150 466 $ 250 Income Statement 2019 Seles $ 1,509 Cost of Goods Sold 5 900 Depreciation 5 90 Operating Income $ 519 $ 8 Long-Term Debt Total Liab $ $ 224 $ 690$ 350 600 10 Net Fixed Assets Total Agents 1.650 1.400 $152.882 2859 Interest Expense Pre-tax Income 5 $ 70 449 12 13 14 $ $ 494 Taxes Net Income Common Per Capital Surplus Retained Earnings Treasury Stock Total Eq Total Liab & Eq $ 5 212 237 15 $ $ $ 55 $ 45 585 $ 1,552 5 1,370 (50) $ 150) 2,1425 3.859 2,832 $2,459 16 17 Dividends Addition to RE'S 5 $ 55 182 $ 11 19 20 21 22 23 25 26 27 28 29 31 32 34 + 36 37 38 39 40 42 You need the excel spreadsheet provided that has financials for a firm. 1. Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and Cash Flow to Shareholders for the firm, 2. Assume you are sitting in a board meeting discussing the firm's plans for sales growth. You are telling the board that you expect to grow sales by 7.5 %. After explaining your plan, a board member asks you for an estimate of how much funding you will need in 2020. What is your answer if you use the formula for External Funds Needed? 3. Now assume the board member asks whether or not you can achieve the growth holding your capital structure constant. What is your answer? 4. What is your answer if the board member asks if you can achieve the growth without issuing ANY new external financing? 5. Calculate the following ratios for the firm for 2019. Current Quick Cash Debt Equity Mult Cash Coverage Inventory Turn Days Sales in Inv Rec Turn Days Sales Out Total Asset Turn Profit Margin ROA ROE 6. Also calculate ROE using the expanded DuPont formula. Income Statement 2019 Sales 1,509 Cost of Goods Sold 900 Depreciation 90 Operating Income 519 Interest Expense Pre-tax Income 70 449 Taxes Net Income 212 237 Dividends Addition to RE's 55 182 2019 266 Assets: Cash Accounts Receivable Inventory Total Current 2019 160 525 497 1,182 Balance Sheet Liab+Eq: Acc Payable Accruals Total Current 2018 154 455 450 1,059 2018 100 150 200 466 250 Long-Term Debt Total Liab 224 690 350 600 Net Fixed Assets Total Assets 1,650 2.832 1,400 2.459 Common @ Par Capital Surplus Retained Earnings Treasury Stock Total Eq Total Liab & Eq 55 585 1,552 -50 2.142 2.832 45 494 1,370 -50 1.859 2,459
