Financial Planning & Forecasting: Spreadsheet Modeling Assignment Course: Corporate Financial Problems (FIN 34000) Instructor: Pat Obi, College of Business (Anderson 333) Please watch the Video on this subject (http:/youtube/dnsvTkeaBg) and apply the SAME SPREADSHEET MODEL using the following financial data: Notes and input data Sales growth: g 21.00% Interest rate on all debt (s.t. + I.t.): ro 10.00% Source for additional funds, i.e. AFN Short-term debt Fixed assets capacity utilization 75% Fixed asset growth rate 0.00% Tax rate 40% Dividend payout ratio: DPO 60% Note!!! Interest charges in the forecast year to be calculated as ro x (s.t. + I.t. debt). Use short-term and long-term debt balances in the current year. Income Statement Current Year Sales $850,000 Operating costs 637,500 EBIT $212,500 Interest 80,000 EBT $132,500 Less: Taxes 53,000 Net income $79,500 Dividends $47,700 Addition to retained earnings $31,800