FIN 200: Assignment Workbook Week 3 Solution

FIN 200

Axia College of University of Phoenix (UoP)

Introduction to Finance: Harvesting the Money Tree

Finance 200 Assignment Workbook Week 3 Solution

Week 3 Assignment: Pro Forma Financial Statements

Click here for the SOLUTION

The Niara Corporation
The balance sheet items of The Niara Corporation that vary directly with sales and the profit margin are as follows:

Percent
Cash 9%
Accounts receivable 11%
Inventory 22%
Net fixed assets 32%
Accounts payable 12%
Accruals 9%
Profit margin after taxes 5%

2009 Sales $2,200 thousand
2010 Sales Increase 14%
Dividend Payout Ratio 40%
2009 Retained Earnings Balance 620.00 thousand
Common Stock 120.00 thousand
Long Term Bonds 80.00 thousand
Notes Payable 346.00 thousand

You must show your work in order to receive credit
a . How much additional external capital will be required for next year given the sales increase as noted above? (Assume that the company is already operating at full capacity.)
b . What will happen to external fund requirements if The Niara Corporation reduces the payout ratio, grows at a slower rate, or suffers a decline in its profit margin? Discuss each of these separately.
c. Prepare a pro forma balance sheet for 2010 assuming that any external funds being acquired will be in the form of notes payable. Disregard the information in part b in answering this question (that is, use the original information and part a in constructing your pro forma balance sheet).

Click here for the SOLUTION