please show all work

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. Sales Growth 22.00% Tax Rate 21.00% Interest 5.00% Rate Div 35.00% Payout Income Statement Balance Sheet (Year End) (Thousands) Current Proforma Current Proforma Current Proforma Current Thousands Thousands 1000 AP/Accruals 500 Assets Sales 2000 Fixed COGS -1250 2000 LTD 1000 Assets GP Op Exp250 CS Par+Paid-in- 900 Cap EBIT RE 600 Int Exp -50 TL+OE EBT PLUG NI CS Div RE 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. Sales Growth 22.00% Tax Rate 21.00% Interest 5.00% Rate Div 35.00% Payout Income Statement Balance Sheet (Year End) (Thousands) Current Proforma Current Proforma Current Proforma Current Thousands Thousands 1000 AP/Accruals 500 Assets Sales 2000 Fixed COGS -1250 2000 LTD 1000 Assets GP Op Exp250 CS Par+Paid-in- 900 Cap EBIT RE 600 Int Exp -50 TL+OE EBT PLUG NI CS Div RE