Please use excel functions to solve Questions 4 and 5

Please use the cells provided for calculations

2) Construct the company's current bala idced bheet. b) Name the corresponding financial ratios in Column 3) Construct a pro forma income statement using the compary's sustainable growth rate as the projected growth in sales. Use the MAX function to prevent negative taxes. 4) Construct a pro forma balance sheet based on the company's sustainable growth rate (sheet will not balance since only costs, current liabilities, and assets are assumed to grow proportional to sales). 5) Use the pro forma balance sheet to calculate the external financing needs. a) Based on the assumptions of the SGR, what is the total growth in assets and the external financing needed? b) What is the internal equity financing and spontaneous (APP) financing? NOTE: EFN plus the internallspontanoues financing in this step should sum to the growth in assets. c) Based on the assumptions of the SGR, what is the external debt financing? 2) Construct the company's current bala idced bheet. b) Name the corresponding financial ratios in Column 3) Construct a pro forma income statement using the compary's sustainable growth rate as the projected growth in sales. Use the MAX function to prevent negative taxes. 4) Construct a pro forma balance sheet based on the company's sustainable growth rate (sheet will not balance since only costs, current liabilities, and assets are assumed to grow proportional to sales). 5) Use the pro forma balance sheet to calculate the external financing needs. a) Based on the assumptions of the SGR, what is the total growth in assets and the external financing needed? b) What is the internal equity financing and spontaneous (APP) financing? NOTE: EFN plus the internallspontanoues financing in this step should sum to the growth in assets. c) Based on the assumptions of the SGR, what is the external debt financing