Problem 2: Submit your excel file to show how you work out the problem with excel function and cell references. The Optical Scam Company has forecast a sales growth of 20 percent for next year. T rirront finanrial ctatomontc aro chnisin hara. b-2. Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed c. Calculate the sustainable growth rate for the company based on the current financial statements. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b- Construct the firm's pro forma balance sheet for next year. (Do not round 1. intermediate calculations and round your answers to the nearest whole number, e.g., 32.) b-2. Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Please show how you work on the following questions in the excel file. (15 points) (1) Please construct your pro forma income statement and balance sheet. (2) Show how you calculate EFN with Pro Forma statements. (3) Show how you verify EFN with the formula. a. Using the equation from the chapter, calculate the external financing needed for next year. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed b- Construct the firm's pro forma balance sheet for next year. (Do not round 1. intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Problem 2: Submit your excel file to show how you work out the problem with excel function and cell references. The Optical Scam Company has forecast a sales growth of 20 percent for next year. T rirront finanrial ctatomontc aro chnisin hara. b-2. Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed c. Calculate the sustainable growth rate for the company based on the current financial statements. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b- Construct the firm's pro forma balance sheet for next year. (Do not round 1. intermediate calculations and round your answers to the nearest whole number, e.g., 32.) b-2. Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Please show how you work on the following questions in the excel file. (15 points) (1) Please construct your pro forma income statement and balance sheet. (2) Show how you calculate EFN with Pro Forma statements. (3) Show how you verify EFN with the formula. a. Using the equation from the chapter, calculate the external financing needed for next year. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed b- Construct the firm's pro forma balance sheet for next year. (Do not round 1. intermediate calculations and round your answers to the nearest whole number, e.g., 32.)