# Calculations for AFN

See attached file for detailed problem and requirements.

XYW Company has the following December 31st balance sheet:

($000)

Cash $ 41 A/P $ 335

A/R 160 Accruals 150

Inventory 450 Long-term Debt 246

Net Fixed Assets 650 Common Equity 570

Total liabilities

Total assets $ 1301 and equity $ 1301

XYW Company last year sales were $1,500; it operated at 80% of capacity. Sales are expected to increase by 28% this year and Business Choice net profit margin is projected at 9.53%, with 42% of Net Income paid as dividends to its common shareholders.

1) Use the formula method to calculate A-O's AFN.

2) Use AFN formula =(A/S)(S1-S0) - (L/S)(S1-S0) -MS1(1-d)

3) Prepare a pro-forma balance sheet after the sales expansion and new AFN

© BrainMass Inc. brainmass.com June 3, 2020, 10:24 pm ad1c9bdddfhttps://brainmass.com/business/accounting/calculations-afn-229793

#### Solution Preview

XYW Company has the following December 31st balance sheet:

($000)

Cash $ 41 A/P $ 335

A/R 160 Accruals 150

Inventory 450 Long-term Debt 246

Net Fixed Assets 650 Common Equity 570

Total liabilities

Total assets $ 1301 and equity $ 1301

XYW Company last year sales were $1,500; it operated at 80% of capacity. Sales are expected to increase by 28% this year and Business Choice net profit margin is projected at 9.53%, with 42% of Net Income paid as dividends to its common shareholders.

1) Use the formula method to calculate A-O's AFN.

There ...

#### Solution Summary

This solution provides calculations for AFN.