Question #38. [15 points] A firm has the following income statement and balance sheet for the current year. Use the following assumptions: Sales will increase by 15% in the projected year, Operating costs, Cash, Other CA, NFA, and A/P & Accruals all change as a percentage of sales -- the same ratio/percentage as the current year. The firm pays out 60% of their earnings as dividends. (a) (3 points) Use the AFN Equation to forecast the amount of additional funds needed. Assume that the dividend payout ratio and net profit margin remain constant. I (b) (12 points) Use the percentage of sales approach to complete the pro forma statements for the projected year such that the balance sheet balances. In addition to the assumptions noted above, use the following assumptions to complete your forecast: LT Debt and C Stock will remain the same as the previous year. Retained earnings: RE last year + (Nl for projected year - Dividends Paid for projected year). The firm pays interest on debt (notes payable and LT Debt) at 5%. The tax rate is 21%. Surplus funds will be paid out as a special dividend. AFN will be sourced from a line of credit (LOC). The balance sheet must balance when you are finished. You can list any adjustments to the balance sheet to the right, if you like. Be sure to update any accounts or totals impacted by adjustments made. There should be a value (even if it's $0) in each grey box. You may write as much as you wish on/around the financial statements for calculations/supporting information. The shaded boxes are what will be graded, but you may show your work to support your answers. i Final Projection -- With Adj - Sales Operating Costs EBIT Interest (5%) EBT Taxes @ 21% NI Income Statement Initial Projection Current Year - No Adj -- $ 60,000.00 $ 45,000.00 $ 15,000.00 $ 675.00 $ 14,325.00 $ 3,008.25 $ 11,316.75 Regular Dividends Paid Addition to Retoined Earnings Special Dividends Paid $ $ $ 6,790.05 4,526.70 Final Projection -- With Adj Assets Cash Other CA Total CA Balance Sheet Initial Projection Current Year - No Adj -- $ 2,000.00 $ 5,000.00 $ 7,000.00 NFA Total Assets $ 68,000.00 $ 75,000.00 Liabilities & Equity A/P Notes Payable Line of Credit (LOC) Total Current Liabilities LT Debt Total liabilities I $ 4,500.00 $ 3,500.00 $ $ 8,000.00 $ 10,000.00 $ 18,000.00 C Stock Retained Earnings Total Equity Total Liabilities & Equity AFN $ 25,000.00 $ 32,000.00 $ 57,000.00 S 75,000.00