How to achieve the result of part (b). ( e.g Show the figures of change in NFA, old CL, old LT debt...)

cash Accounts Receivable Inventory $16,789 $24,054 $30,947 Accounts Payable Notes Payable Accrued Wages $71,790 Accrued Taxes Total current liabilities $25,684 $22,422 $7,263 $3,631 Fixed Assets Less Acc Dep" $115,263 $31,580 $59,000 $26,316 $26,316 83,683 Long-term Debt Contributed Capital Retained Earnings Total equity 155,473 Total liabilities and equity $41,841 $28,316 $70,157 Total Assets $155,473 (Part (a)) Therefore Year Sales = S. % Capacity growth profit margin div payout 2019 19,500,000 0.9 1.4 0.08 0.5 NPAT = Chng RE = 1,560,000 780,000 Year 2020 Sales = S 27,300,000 Therefore NPAT = 2,184,000 profit margin 0.08 Chng RE = 1,092,000 div payout 0.5 Fixed assets calculation Capacity sales Scap (S. /% capacity) = 21,666,667 Net Fixed Assets / Capacity sales = 3.862292308 Therefore increase in net fixed assets = 21,757,580 Proportional assets calculation =(A"/So)(S.-S.) 28,716,000 Less Proportional liabilities calculation = 14,631,200 Less MS,(1-d) calculation = 1,092,000 AFN = 34,750,380 Part (b) 205,946,580 119,449,016 Restriction on additional debt TA1 = TA, + change in CA + change in NFA from AFN equation = Max debt permitted = 0.58 times TA: Less old CL + change in L* 73,631,200 Less old LT debt 26,316,000 Therefore max additional debt = Check against AFN total to be apportioned therefore new Equity must be 99,947,200 19,501,816 34,750,380 15,248,564 77,312,308 73,631,200 3,681,108 Restriction on additional current liabilities Max CL = CA/1.3: Less projected debt (Old CL + [(L*)/S.J(S.-S.) Therefore max additional CL (notes payable) New long term debt raisable calculation Max additional debt from above Maximum additional CL (notes payable) Additional long-term debt required Equity requirements: Total AFN Less total additional debt Therefore new equity funds required 19,501,816 3,681,108 15,820,709 34,750,380 19,501,816 15,248,564