please solve it with full steps and show the formulas in table also... I'll give you up thumb definitely

Instructions: Solve each exercise with full calculations, create tables or schedules with all answers. Do not show only answers. Exercise 3 Bengals, Inc. expects its sales to grow by 15 percent next year. Last year, when the firm was operating at full capacity, Bengals generated sales equal to $400,000 with assets of $1,000,000. Bengals' current balance sheet shows that accounts payable and accruals are $250,000, notes payable are $45,000, long-term debt is $150,000, common stock is $420,000, and retained earnings are $135,000. Next year, Bengals' net profit margin is expected to be the same as this past year, 8 percent, and the company plans to continue to pay 40 percent of earnings as dividends. Estimate Bengals' additional funds needed (AFN) for next year