Question 1-3 for the questions below

Please use excel formulas for the cells provided in screenshot

need excel formulas for answers

1) Construct the company's current balance sheet 2) Calculate the financial ratios listed below. a) Use the Name Manager to point the named cell Nettincome (currently pointing to sales revenue) to the net income amount for the current year provided in Column D. Use the name to reference this cell in any equations (NOTE: do not name cells unless instructed). b) Name the corresponding financial ratios in Column D with the following names: TAT, PM, DE, ROA, ROE and SGR. Use the names to reference these cells in any equations c) Use the DuPont Identity to calcul late ROA and ROE. 3) Construct a pro forma income statement using the company'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 equily financing and spontaneous (AP) financing? NNOTE: 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? HEIR JORDAN CORPORATION Pro forma income statement Problem 3 Costs Taxable income Taxes Net income Dividends Add. To Ret. Earnings 1) Construct the company's current balance sheet 2) Calculate the financial ratios listed below. a) Use the Name Manager to point the named cell Nettincome (currently pointing to sales revenue) to the net income amount for the current year provided in Column D. Use the name to reference this cell in any equations (NOTE: do not name cells unless instructed). b) Name the corresponding financial ratios in Column D with the following names: TAT, PM, DE, ROA, ROE and SGR. Use the names to reference these cells in any equations c) Use the DuPont Identity to calcul late ROA and ROE. 3) Construct a pro forma income statement using the company'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 equily financing and spontaneous (AP) financing? NNOTE: 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? HEIR JORDAN CORPORATION Pro forma income statement Problem 3 Costs Taxable income Taxes Net income Dividends Add. To Ret. Earnings