5. XYZ\'s balance sheet and income statement are given below: Balance Sheet: Cas

Question

5. XYZ's balance sheet and income statement are given below: Balance Sheet: Cash A/R Inventories Fixed assets Total assets $ 100 Accounts payabe Notes payable Long-term debt! (10%) Comon equity 20 shares) $ 50 150 0 700 91,000 Income Statement: Sales Cost of goods solod EBIT Interest EBT Taxes (33.3338) Net income $1,000 855 145 70 $ 75 25 50 xYz is forecasting a 108 sales increase next year. They lan to pay 30 of their net income out as dividend. All of their assets are fully utilized. They expect their profit margin to remain constant. a. Using the AFN equation, what is their AFN (addition l funds needed)2 b. What if the fixed assets are only 80% utilized (1.e we have 20% unused capacity going into next year). What is the EN now?

Explanation / Answer

a) AFN = (A*/S0)S – (L*/S0) S – M(S1)(RR)

where, A* - Total Assets = 1,000, S0 - Current Sales = 1,000, S - Increase in sales = 10% x 1000 = 100, L* - Account Payable = 100, M - Profit Margin = 50 / 1000 = 5%, S1 - Next year's sales = 1,100, RR - Retention Ratio = 70%

=> AFN = (1000 / 1000) x 100 - (100 / 1000) x 100 - 5% x 1,100 x 70% = $51.50

b) If only 80% of assets are utilized, then, A* = 80% x 1000 = 800 in the above equation

=> AFN = $31.50

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.