FIN 200 CP 4-1 The Landis Corporation had 2008 sales of $100 million
Introduction to Finance: Harvesting the Money Tree. Axia College of University of Phoenix (UoP)
Complete the Comprehensive Problem Assignment: Pro Forma Statements
Resource: Ch. 4 of Foundations of Financial Management Landis Corporation on p. 118.
CP 4-1 The Landis Corporation had 2008 sales of $100 million. The balance sheet items that vary directly with sales and the profit margin are as follows:
Chapter 4 Financial Forecasting
Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5%
Accounts receivable. . . . . . . . . . . . . . . . . . . . . . 15
Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Net fixed assets . . . . . . . . . . . . . . . . . . . . . . . . . 40
Accounts payable . . . . . . . . . . . . . . . . . . . . . . . 15
Accruals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Profit margin after taxes . . . . . . . . . . . . . . . . . . 6%
The dividend payout rate is 50 percent of earnings, and the balance in retained earnings at the end of 2008 was $33 million. Common stock and the company’s long-term bonds are constant at $10 million and $5 million, respectively. Notes payable are currently $12 million.
a. How much additional external capital will be required for next year if sales increase 15 percent? (Assume that the company is already operating at full capacity.)
b. What will happen to external fund requirements if Landis 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 2009 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).
| TUTORIAL PREVIEW | ||||
| Change in Sales = 15% x $100 million = $15 million | ||||
| Spontaneous Assets = 5% + 15% + 25% +40% = 85% | ||||
File name: Landis-Corporation.xls File type: application/vnd.ms-excel Price:
$7
