Purchase Solution

Additional Funds Needed

Not what you're looking for?

Ask Custom Question

Please work this in excel so I can understand the concept.

Additional Funds Needed with Excess Capacity

Baxter Box Company's balance sheet showed the following amounts as of December 31st:

Cash 10.00 Accounts Payable 15.00
Accounts Receivable 40.00 Accruals 5.00
Inventory 50.00 Notes Payable 20.00
Net Fixed Assets 100.00 Long-term debt 20.00
Common Stock 20.00
Retained Earning 120.00
Total Assets 200.00 Total Liabilities and Equity 200.00

Last year the firm's sale were $2,000, and its had a profit margin of 10 percent and a dividend payout ratio of 50 percent. Baxter Box operated its fixed assets at 80 percent of capacity during the year. The company expected to increase next year's sales by 37.5 percent to $2,750, but the profit margin is expected to fall to 3 percent, and the dividend payout ratio is expected to rise to 60 percent. What is Baxter Box additional funds needed (AFN) for next year?

Purchase this Solution

Solution Summary

The solution explains how to determine the amount of Additional Funds Needed (AFN).

Solution Preview

Please see the attachment.

Baxter Box Company's balance sheet showed the following amounts as of December 31st:

Cash 10.00 Accounts payable 15.00
Accounts receivable 40.00 Accruals 5.00
Inventory 50.00 Notes payable 20.00
Net fixed assets 100.00 Long-term debt 20.00
Common stock 20.00
...

Purchase this Solution


Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.