Financial Accounting Review 50 Points formation about The Heir Jordan Company is provided below. The company needs you to help estimate its finam 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 Netincome (currently pointing to sales revenue) to the net income amou b) Name the corresponding financial ratios in Column D with the following names: TAT, PM, DE, ROA, ROE and SGR. Us c) Use the DuPont Identity to calculate ROA and ROE. 3) Construct a pro forma income statement using the company's sustainable growth rate as the project 4) Construct a pro forma balance sheet based on the company's sustainable growth rate (sheet will not 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 (A/P) financing? NOTE: EFN plus the internal/spontanoues financ c) Based on the assumptions of the SGR, what is the external debt financing? 24 25 26 27 28 29 30 31 Current Year Sales 70,000 Total Costs (COGS & Admin.) 55,000 Cash 3,140 Accounts receivable 4,200 Inventory 6,500 Net plant and equipment 145,000 Accounts payable 2,600 Notes payable 5,700 Long-term debt 28,000 Common stock & Paid-in Capita 5,000 Retained earnings 117,540 Dividends Paid 4,200 Net income Tax rate 11,850 21%