I've attached the question bellow , and the final answers I need the steps

Problem (12-9) suppose that in 2011 sales increase by 10% over 2010 sales and that 2011 div. will increase to 112000. forcast the financial statmment using the forcasted financial statement method. Assume the firm is operated at full capacity in 2010. use an interest rate of 13%. and assume that any new debt will be added at the end of the year ( so forcast the interest expense based on the debt balance at the beginning of the year). cash does not earn any interest income . Assume that the AFN will be in the form of notes payable. HINT : AFN= $128,783 and NOTES PAYABLE = $284,783 Forecast 2010 basis % Addition w/o AFN Finacning with AFN 2011 sales Cash $ 180,000 1.00% $198,000 $198,000 A/R $360,000 7.43% $396,000 $396,000 Inv $720,000 16.60% $792,000 $792,000 Total CA $1,260,000 $1,386,000 $1,386,000 FA $1,440,000 10.00% $1,584,000 $1,584,000 TA $2,700,000 $2,970,000 $2,970,000 Income statement 2010 2011 A/P $360,000 2.57% $396,000 $396,000 SALES 3,600,000 NP $156,000 $156,000 $156,000 COST 3,279,720 Accruals $180,000.0 2.43% $198,000 $198,000 EBIT 320,280 Total CL $696,000.0 $750,000 $750,000 Common $1,800,000 $1,800,000 $1,800,000 INTEREST 41,636 stock Retained $204,000 $204,000 $204,000 EBT 278,644 earnings TAXES 111457 TL+TE $2,700,000 $2,754,000 $2,754,000 NET INCOME 167,186 AFN = DIV. 108000 112000 Profit Margin = Dividend Payout = Net Income 2011 = Div payout 2011 = *Addition to RE 2011 Additional Funding is done by using NP