Answer 3 and 4 please, with excel table screenshot.

1. Your Case Study should begin with an Executive Summary on page 1 (paragraph). The Executive Summary should highlight your recommendations for this project. It should not be a summary of what you were asked to do. You will need to complete this project to be able to write this summary 2. Page 2 should show a summary of the investments you are recommending. Make sure that the total investment you are recommending is within the firm's budget 3. Your first task is to calculate the CFFA, CFS and CFC, the Internal Growth Rate, the Sustainable Growth Rate and the dividend payout ratio for CVF based on the latest financial statements available. Considering Claravale's growth strategy, address whether an internal growth or sustainable growth strategy is a viable option for CVF at this time. Crave Income Salomert nos of 2018 Sales $11.2015 OES Depreciation Gross income 2015 7619 211 3.371 219 3.413 SCA Other perses MT More Income Tax Not room 3.000 102 18 23 3154 23 144 18 ca Caravale Blace Set in Doosos 2018 2016 $ 2535 ST Investments 71 remurta Pele 291 Hvory Baldrpandud 1.75 Machinery and Bosport 10 Net Foods 2.678 traite Assets 619 679 Totalets 's $120's 49 ) INP home To Pay Se Other infortabilities 15 ST DICH 370 203 LTD 156 . aan 5 Egy Common Added in Capital Predam 375 531 1056 1730 Uabies and 4. Review and analyze each proposed investment, using both NPV and IRR capital budgeting methods. Show your work: use Excel to set up your cash flow tables and run your NPVs/IRRs. Use the "Copy/paste special", "insert Excel object" commands to insert your Excel work into your Word document. 5. Based on your analysis, prepare a capital expenditure plan of action for the CVF management team (conclusion of your work) 6. Discuss the External Financing Needed and/or increase in equity needed. Recommend an optimal capital structure for Claravale (debt versus equity financing) and explain your reasoning. 7. Choose 1 project and perform a scenario analysis. Then focus on just one variable for the same project and perform a sensitivity analysis. Analyze your findings and address potential concerns for CVF to take into consideration. 8. There is no page limit to your paper, but remember that you are writing a business paper: it should be succinct and avoid waffle at all costs. Your paper should be properly organized, professionally written (proper grammar, correct spelling), with a logical flow of analysis. Be sure to cite your sources if needed. 1. Your Case Study should begin with an Executive Summary on page 1 (paragraph). The Executive Summary should highlight your recommendations for this project. It should not be a summary of what you were asked to do. You will need to complete this project to be able to write this summary 2. Page 2 should show a summary of the investments you are recommending. Make sure that the total investment you are recommending is within the firm's budget 3. Your first task is to calculate the CFFA, CFS and CFC, the Internal Growth Rate, the Sustainable Growth Rate and the dividend payout ratio for CVF based on the latest financial statements available. Considering Claravale's growth strategy, address whether an internal growth or sustainable growth strategy is a viable option for CVF at this time. Crave Income Salomert nos of 2018 Sales $11.2015 OES Depreciation Gross income 2015 7619 211 3.371 219 3.413 SCA Other perses MT More Income Tax Not room 3.000 102 18 23 3154 23 144 18 ca Caravale Blace Set in Doosos 2018 2016 $ 2535 ST Investments 71 remurta Pele 291 Hvory Baldrpandud 1.75 Machinery and Bosport 10 Net Foods 2.678 traite Assets 619 679 Totalets 's $120's 49 ) INP home To Pay Se Other infortabilities 15 ST DICH 370 203 LTD 156 . aan 5 Egy Common Added in Capital Predam 375 531 1056 1730 Uabies and 4. Review and analyze each proposed investment, using both NPV and IRR capital budgeting methods. Show your work: use Excel to set up your cash flow tables and run your NPVs/IRRs. Use the "Copy/paste special", "insert Excel object" commands to insert your Excel work into your Word document. 5. Based on your analysis, prepare a capital expenditure plan of action for the CVF management team (conclusion of your work) 6. Discuss the External Financing Needed and/or increase in equity needed. Recommend an optimal capital structure for Claravale (debt versus equity financing) and explain your reasoning. 7. Choose 1 project and perform a scenario analysis. Then focus on just one variable for the same project and perform a sensitivity analysis. Analyze your findings and address potential concerns for CVF to take into consideration. 8. There is no page limit to your paper, but remember that you are writing a business paper: it should be succinct and avoid waffle at all costs. Your paper should be properly organized, professionally written (proper grammar, correct spelling), with a logical flow of analysis. Be sure to cite your sources if needed