Please show me all the work including every single formula in excel. Please it would save my life.

1. Calculate the 1-year internal growth rate (copy and paste the value in a separate cell). 2. The firm intends to issue/buy-back LTD and CS in the case of deficit/surplus, what is the value of LTD and CS if it intends to maintain the same D/E ratio as before (copy and paste the values in a separate cell). 3. Calculate the 5-year proforma statement in a separate worksheet. Income Statement Current Proforma Thousands Thousands COGS 1250 GP Op Exp 250 EBIT Int Exp 50 EBT Tax NI CS Div RE Balance Sheet (Year End) (Thousands) Current Proforma Current Proforma Current Assets AP/Accruals 500 Fixed Assets 2000 LTD 1000 CS Par+Paid-in- 900 Cap RE 600 TL+OE PLUG