need the cell references. its on excel

2) Calculate the financial ratios listed below.

Use the Name Manager to point the named cell NetIncome (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).

Calculate the financial ratios listed in Column D. Use the DuPont Identity to calculate ROA and ROE.

Name the corresponding financial ratios in Column D with the following names: TAT, PM, DE, ROA, ROE, SGR, and IGR. Use these names to reference these cells in any equations, but do not name other cells.

3) Construct a pro forma income statement using the company's sustainable growth rate as the projected growth in sales. Use the MAX function in the equation to prevent negative taxes. (Pro forma net income will be around $10,800)

4) Construct a pro forma balance sheet based on the company's sustainable growth rate. Only assume that costs, accounts payable, and assets grow proportional to sales.

5) Use the pro forma balance sheet to calculate the external financing needs.

Based on the assumptions of the SGR, what is the total growth in assets and the external financing needed? (EFN will be around $1,700)

What is the internal equity financing and spontaneous (A/P) financing? NOTE: EFN plus the internal/spontaneous financing in this step should sum to the growth in assets.

Based on the assumptions of the SGR, what is the external debt financing?

Output areas: HEIR JORDAN CORPORATION Financial Ratios Payout ratio Plowback ratio TAT Profit margin Debt-equity ratio ROA ROE Sustainable growth rate Internal growth rate HEIR JORDAN CORPORATION Pro forma income statement Sales Costs Taxable income Taxes Net income \begin{tabular}{rr} $ & 69,000.00 \\ 56,000.00 \\ \hline$ & 13,000.00 \\ 2,730.00 \\ \hline & 23,270.00 \\ \hline \end{tabular} Dividends Add. To Ret. Earnings \begin{tabular}{|l|} \hline$4,200.00 \\ \hline$19,070.00 \\ \hline \end{tabular} HEIR JORDAN CORPORATION Pro Forma Balance Sheet Liabilities and Owners' equity Current liabilities Accounts payable Notes payable Total Long-term debt \$ 29,386.98 Owners' equity Common stock \& Paid-in Capital Retained earnings Total Equity Total assets Total liabilities and Owners' equity 166,708.11 Growth in assets External financing needed Internal equity financing Spontaneous debt (AVP) External debt (excludes A/P) \begin{tabular}{|r|} \hline \\ \hline \\ \hline \\ \hline \\ \hline 1,79 \\ \hline \end{tabular}