Need help, I tried to solve it but having trouble and not sure if what I have is correct. (grey area top left need help as well).

Mini Case: Ratios and Financial Planning at East Coast Yachts

Lisa wants to find out how East Coast Yachts is performing relative to its peers. Additionally, she wants to find out the future financing necessary to fund the company's growth. In the past, East Coast Yachts experienced difficulty in financing its growth plan, in large part because of poor planning. Lisa would like to estimate the amount of capital the company would have to raise next year so that East Coast Yachts would be better prepared to fund its expansion plans.

1.(Excel) Calculate the sustainable growth rate for East Coast Yachts.

a.Calculate external funds needed

b.Prepare pro forma income statement and balance sheet using this sustainable growth rate

c.Do you obtain the same numbers of EFN from part a and part b? What source of financing should East Coast Yachts use?

d.Recalculate the ratios in the previous question. What do you observe?