FIN 200: Week Three Solution

FIN 200

Axia College of University of Phoenix (UoP)

Introduction to Finance: Harvesting the Money Tree

Fin 200 Week 3 Solution

Assignment: Pro Forma Statements

• Resource: Ch. 4 of Foundations of Financial Management
• Due Date: Day 7 [post to the Individual forum]
• Complete the Comprehensive Problem: Landis Corporation on p. 118.
• Post the assignment as an attachment.

Click here for the SOLUTION

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%
.com/bhd13e
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).

Click here for the SOLUTION

FIN 200: Week Two Solution

FIN 200

Axia College of University of Phoenix (UoP)

Introduction to Finance: Harvesting the Money Tree

Fin 200 Week 2 Solution

CheckPoint: Financial Ratios

• Resource: Ch. 3 of Foundations of Financial Management
• Due Date: Day 5 [Individual forum]
• Complete Problem 34 on p. 84.

Click here for the SOLUTION

Using the financial statements for the Goodyear Calendar Company, calculate
The 13 basic ratios found in the chapter.

GOODYEAR CALENDAR COMPANY
Balance Sheet
December 31, 2008
Assets
Current assets:
Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 40,000
Marketable securities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30,000
Accounts receivable (net) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120,000
Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180,000
Total current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 370,000
Investments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40,000
Plant and equipment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 450,000
Less: Accumulated depreciation . . . . . . . . . . . . . . . . . . . . . . . (100,000)
Net plant and equipment . . . . . . . . . . . . . . . . . . . . . . . . . . . 350,000
Total assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 760,000
GOODYEAR CALENDAR COMPANY
Liabilities and Stockholders’ Equity
Current liabilities:
Accounts payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 90,000
Notes payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10,000
Accrued taxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10,000
Total current liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110,000
Long-term liabilities:
Bonds payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170,000
Total liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 280,000
Stockholders’ equity
Preferred stock, $100 par value . . . . . . . . . . . . . . . . . . . . . . . . 90,000
Common stock, $1 par value . . . . . . . . . . . . . . . . . . . . . . . . . . 60,000
Capital paid in excess of par . . . . . . . . . . . . . . . . . . . . . . . . . . 230,000
Retained earnings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100,000
Total stockholders’ equity . . . . . . . . . . . . . . . . . . . . . . . . . 480,000
Total liabilities and stockholders’ equity . . . . . . . . . . . . . . . . . . . . $ 760,000
GOODYEAR CALENDAR COMPANY
Income Statement
For the Year Ending December 31, 2008
Sales (on credit) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $2,000,000
Less: Cost of goods sold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,300,000
Gross profit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 700,000
Less: Selling and administrative expenses . . . . . . . . . . . . . . . 400,000*
Operating profit (EBIT) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 300,000
Less: Interest expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20,000
Earnings before taxes (EBT) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 280,000
Less: Taxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112,000
Earnings after taxes (EAT) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 168,000
*Includes $10,000 in lease payments.

Click here for the SOLUTION

FIN 200: Week One Solution

FIN 200

Axia College of University of Phoenix (UoP)

Foundations of Financial Management
Block Hirt Danielsen

Introduction to Finance: Harvesting the Money Tree

Fin 200 Week 1 Solution

Assignment: Cash Flow Preparation

• Resource: Ch. 2 of Foundations of Financial Management
• Due Date: Day 7 [post to the Individual forum]
• Complete Problems 27, 28, and 29 on pp. 51-53.
• Post the assignment as an attachment.

Click here for the SOLUTION

Prepare a statement of cash flows for the Crosby Corporation
CROSBY CORPORATION
Income Statement
For the Year Ended December 31, 2008
Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $2,200,000
Cost of goods sold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,300,000
Gross profits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 900,000
Selling and administrative expense . . . . . . . . . . . . . . . . . . . . 420,000
Depreciation expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150,000
Operating income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 330,000
Interest expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90,000
Earnings before taxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240,000
Taxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80,000
CROSBY CORPORATION
Income Statement
For the Year Ended December 31, 2008
Earnings after taxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160,000
Preferred stock dividends . . . . . . . . . . . . . . . . . . . . . . . . . . . 10,000
Earnings available to common stockholders . . . . . . . . . . . . . $ 150,000
Common shares outstanding . . . . . . . . . . . . . . . . . . . . . . . . 120,000
Earnings per share . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 1.25
Statement of Retained Earnings
For the Year Ended December 31, 2008
Retained earnings, balance, January 1, 2008 . . . . . . . . . . . . . . . . . . . . $500,000
Add: Earnings available to common stockholders, 2008 . . . . . . . . . . 150,000
Deduct: Cash dividends declared and paid in 2008 . . . . . . . . . . . . . 50,000
Retained earnings, balance, December 31, 2008 . . . . . . . . . . . . . . . . . $600,000
CROSBY CORPORATION
Income Statement
For the Year Ended December 31, 2008
Earnings after taxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160,000
Preferred stock dividends . . . . . . . . . . . . . . . . . . . . . . . . . . . 10,000
Earnings available to common stockholders . . . . . . . . . . . . . $ 150,000
Common shares outstanding . . . . . . . . . . . . . . . . . . . . . . . . 120,000
Earnings per share . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 1.25
Liabilities and Stockholders’ Equity
Current liabilities:
Accounts payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 250,000 $ 440,000
Notes payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400,000 400,000
Accrued expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70,000 50,000
Total current liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . 720,000 890,000
Long-term liabilities:
Bonds payable, 2012 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70,000 120,000
Total liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 790,000 1,010,000
Comparative Balance Sheets
For 2007 and 2008
Year-End
2007
Year-End
2008
Assets
Current assets:
Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 70,000 $ 100,000
Accounts receivable (net) . . . . . . . . . . . . . . . . . . . . . . . . . . 300,000 350,000
Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410,000 430,000
Prepaid expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50,000 30,000
Total current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 830,000 910,000
Investments (long-term securities) . . . . . . . . . . . . . . . . . . . 80,000 70,000
Plant and equipment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,000,000 2,400,000
Less: Accumulated depreciation . . . . . . . . . . . . . . . . . . . 1,000,000 1,150,000
Net plant and equipment . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,000,000 1,250,000
Total assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $1,910,000 $2,230,000
Stockholders’ equity:
Preferred stock, $100 per value . . . . . . . . . . . . . . . . . . . . . . 90,000 90,000
Common stock, $1 par value . . . . . . . . . . . . . . . . . . . . . . . . 120,000 120,000
Capital paid in excess of par . . . . . . . . . . . . . . . . . . . . . . . . 410,000 410,000
Retained earnings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 500,000 600,000
Total stockholders’ equity . . . . . . . . . . . . . . . . . . . . . . . . . 1,120,000 1,220,000
Total liabilities and stockholders’ equity . . . . . . . . . . . . . . . . . . $1,910,000 $2,230,000
28. Describe the general relationship between net income and net cash flows from
operating activities for the firm.
29. Has the buildup in plant and equipment been financed in a satisfactory manner?
Briefly discuss.

Click here for the SOLUTION