need correct excel formulas

3) Construct a pro forma income statement using the companys sustainable growth rate as the projected growth in sales. Use the Max function in the equation to prevent negative taxes. 4) Construct a pro forms bulance sheet bused on the companys sustainable growth rate. Only assume that costs and assets grow proportional to sales. 5) Use the pro forma balance sheet to calculate the external financing needs. Based on the this growth rate, what is the total growth in assets? How much is financed by internal equity? What is the external finanoing needed? Based on the assumptions of the 5c, what is the amount of external debt financine? 6) Assume the company wants to grow at this rate (the SGR you calculated), but whout using any external finanoing: What dividend (\$ amount) would allow the company to grow at this rate this year, but without using any external financing? What would the new payout ratio be based on that dindend? Asume the not does not change but the parout policy does. Given the new payout ratio, whut would the new SGR be? Hint; SCR will be higher than before. New dividend (Answer about $7,50 New payout ratio New SGR \begin{tabular}{|lr|} \hline Current Year & \\ \hline Sales & 207,000 \\ Total Costs (COGS \& Admin.) & 168,000 \\ Common stock \& Paid-in Capital & 15,000 \\ Retained earnings & 352,620 \\ Dividends Paid & 12,600 \\ Accounts payable & 7,800 \\ Notes payable & 17,100 \\ Long-term debt & 84,000 \\ Net income & 30,810 \\ Cash & 9,420 \\ Accounts receivable & 12,600 \\ Inventory & 19,500 \\ Net plant and equipment & 435,000 \\ Tax rate & 21% \\ \hline \end{tabular}