FIN 6406 Excel HW 1 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 20% Afler 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 extemal financing? 5. Calculate the following ratios for the firm for 2019. Current Quick Cash Debt Equity Mult Cash Coverage Inventory Tum Days Sales in Iny Rec Turn Days Sales Out Total Asset Turn Profit Margin ROA ROE 6. Also calculate ROE using the expanded DuPont formula Excel Grading Template - Values for each category range from 1-3 with 3 highest Total: Neatness and Organization of Presentation Use of Formulas Titles, Labels, and Headings Followed Directions Answers Auto excel augmente Home Insert A ROSELE CASTOR Drow Page Layout Formula Data Review View Help Share B. D LE N 5 Cash Accounts Weceivable inventory Total Current $ Balance Sheet Libre Acc Payable Accra Total Current 2019 2018 5 300 $ 154 5 7255 455 5 6653 450 $ 1,690'S 1,059 2019 2018 299 $ 100 2365 150 535S 250 Income Statement 2019 Sales $1,850 Cast of Goods Sold s 950 Depreciation S 30 Operating income $ 810 5 9 10 Net Fred Assets TE Toral Assets Long-Term Debt Total Liob $ 5 S 5 1,650 $ 1.400 1240 2459 420 $ 9555 350 GOO Interest Expense Pretor income $ S 70 740 Tunes $ 5 212 528 14 15 16 17 18 Net Income Common e Par Capital Surplus Retained Earning: Treasury Stock Total Toto tiob & ER $ $ 5 $ S S 555 585 S 1,7955 (50) $ 2,3555 3,340$ 45 494 1,370 150) 1,859 2.459 5 100 Dividends Addition to RES $ 125 ALISOWOOD DS ROSELE CASTOR RC excel assignment 1) Decel Formulas Date Rew File Home Insert Draw Page Layout View Hele C26 N 4 Ash Cash 6 Accounts Receivable Inventory Total Current Balance Sheet Liebe Ace Payable Accruals Toro went 2019 2018 3005 154 725 $ 455 665 $ 450 1.690'S 1,059 2019 3 2995 5 236 $ 535s 2018 100 150 250 5 $ S income Statemem 2019 sales 5 1150 Cost of Goods Sold $ 950 Depreciation 5 90 Operating Income 810 350 Long-Term Debt Total Lab $ S 4205 955 5 600 0 Net Fixed Assets Totol Ave 2 $ 5 1.650 1.400 240S159 Interest Expense Pre-fax Income $ $ 70 740 5 5 55 5 585 5 45 494 Taxes Net Income 5 5 4 521 Common e por Capital Surplus Retoined Earnings Treasury Stock Totol Eg Total Lab & E 5 s 5 (50) $ 2.3855 3,3405 370 15.0) 1,859 5 Dividends Addition to RES 103 125 2.459 FIN 6406 Excel HW 1 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 20% Afler 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 extemal financing? 5. Calculate the following ratios for the firm for 2019. Current Quick Cash Debt Equity Mult Cash Coverage Inventory Tum Days Sales in Iny Rec Turn Days Sales Out Total Asset Turn Profit Margin ROA ROE 6. Also calculate ROE using the expanded DuPont formula Excel Grading Template - Values for each category range from 1-3 with 3 highest Total: Neatness and Organization of Presentation Use of Formulas Titles, Labels, and Headings Followed Directions Answers Auto excel augmente Home Insert A ROSELE CASTOR Drow Page Layout Formula Data Review View Help Share B. D LE N 5 Cash Accounts Weceivable inventory Total Current $ Balance Sheet Libre Acc Payable Accra Total Current 2019 2018 5 300 $ 154 5 7255 455 5 6653 450 $ 1,690'S 1,059 2019 2018 299 $ 100 2365 150 535S 250 Income Statement 2019 Sales $1,850 Cast of Goods Sold s 950 Depreciation S 30 Operating income $ 810 5 9 10 Net Fred Assets TE Toral Assets Long-Term Debt Total Liob $ 5 S 5 1,650 $ 1.400 1240 2459 420 $ 9555 350 GOO Interest Expense Pretor income $ S 70 740 Tunes $ 5 212 528 14 15 16 17 18 Net Income Common e Par Capital Surplus Retained Earning: Treasury Stock Total Toto tiob & ER $ $ 5 $ S S 555 585 S 1,7955 (50) $ 2,3555 3,340$ 45 494 1,370 150) 1,859 2.459 5 100 Dividends Addition to RES $ 125 ALISOWOOD DS ROSELE CASTOR RC excel assignment 1) Decel Formulas Date Rew File Home Insert Draw Page Layout View Hele C26 N 4 Ash Cash 6 Accounts Receivable Inventory Total Current Balance Sheet Liebe Ace Payable Accruals Toro went 2019 2018 3005 154 725 $ 455 665 $ 450 1.690'S 1,059 2019 3 2995 5 236 $ 535s 2018 100 150 250 5 $ S income Statemem 2019 sales 5 1150 Cost of Goods Sold $ 950 Depreciation 5 90 Operating Income 810 350 Long-Term Debt Total Lab $ S 4205 955 5 600 0 Net Fixed Assets Totol Ave 2 $ 5 1.650 1.400 240S159 Interest Expense Pre-fax Income $ $ 70 740 5 5 55 5 585 5 45 494 Taxes Net Income 5 5 4 521 Common e por Capital Surplus Retoined Earnings Treasury Stock Totol Eg Total Lab & E 5 s 5 (50) $ 2.3855 3,3405 370 15.0) 1,859 5 Dividends Addition to RES 103 125 2.459