A firm has the following income statement and balance sheet for the current year. Use the following assumptions: Sales will increase by 12% 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. (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 + (NI for projected year – Dividends Paid for projected year). The firm pays interest on debt (notes payable and LT Debt) at 6%. 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.

 

Initial Projection Final Projection -- Current Year No Adj With Adj -- -- Sales $4 60,000.00 Operating Costs 45,000.00 EBIT $4 15,000.00 Interest (5%) $ 810.00 EBT 14,190.00 Taxes @ 21% 2,979.90 NI 11,210.10 Regular Dividends Paid Addition to Retained Earnings 24 6,726.06 2$ 4,484.04 Special Dividends Paid Balance Sheet Initial Projection Final Projection Assets Current Year No Adj -- With Adj -- Cash $4 2,000.00 Other CA 5,000.00 Total CA 24 7,000.00 NFA 24 68,000.00 Total Assets 75,000.00 Liabilities & Equity $ A/P Notes Payable Line of Credit (LOC) 4,500.00 $4 3,500.00 $4 Total Current Liabilities $ 8,000.00 LT Debt Total Liabilities $4 24 10,000.00 18,000.00 2$ C Stock Retained Earnings Total Equity Total Liabilities & Equity 25,000.00 32,000.00 24 57,000.00 75,000.00 AFN