firm has the following income statement and balance sheet for the current year. Use the following ssumptions: Sales will increase by 8% 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) (1.5 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) (7.5 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, Notes Payable, 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 7%. 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-add balancing adjustments to the right of the Initial projection. Round values to two (2) decimal places. You may write as much as you wish on/around the financial statements for calculations and supporting information. The shaded boxes and their adjustments are what will be graded, but you may show your work to support your answers. Income Statement Sales Operating Costs EBIT Interest (6% EBT Taxes@ 21% NI Regular Dividends Paid Addition to Retained Earnings Special Dividends Paid Assets Cash Other CA Total CA NFA Total Assets Liabilities & Equity A/P Notes Payable Line of Credit (LOC) Total Current liabilities LT Debt Total liabilities C Stock Retained Farmings Total Equity Total liabilities & Equity AFN Current Year $ 60,000.00 $ 45,000,00 $ 15,000.00 S 810,00 $ 14,190.00 S 2,979.90 11,210.10 $ S 6,726.06 $ 4,484.04 $ Balance Sheet Current Year $ 2,100.00 S 5,400.00 S 7,500.00 $ 68,400.00 $ 75,900.00 $ 4,500.00 $ 3,500.00 $ $ 8,000,00 $ 10,000.00 $ 18,000.00 $ 25,500.00 $ 32,400.00 $ 57,900.00 $ 75,900.00 Initial Projection -No Adj Initial Projection No Adj