Axia College of University of Phoenix (UoP)
Foundations of Financial Management
Block Hirt Danielsen
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 Problems 16 and 25
- Post the assignment as an attachment.
16. J. Lo’s Clothiers has forecast credit sales for the fourth quarter of the year as:
September (actual) . . . . . . . . . . . . . $70,000
Fourth Quarter
October . . . . . . . . . . . . . . . . . . . . . . $60,000
November . . . . . . . . . . . . . . . . . . . . 55,000
December . . . . . . . . . . . . . . . . . . . . 80,000
Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent are never collected.
Prepare a schedule of cash receipts for J. Lo’s Clothiers covering the fourth quarter (October through December).
25. Carter Paint Company has plants in nine midwestern states. Sales for last year were $100 million, and the balance sheet at year-end is similar in percentage of sales to that of previous years (and this will continue in the future). All assets (including fixed assets) and current liabilities will vary directly with sales.
BALANCE SHEET
(in $ millions)
Assets Liabilities and Stockholders’ Equity
Cash . . . . . . . . . . . . . . . . . . . . . . . . $ 5 Accounts payable . . . . . . . . . . . . . . $15
Accounts receivable. . . . . . . . . . . . . 15 Accrued wages . . . . . . . . . . . . . . . . 6
Inventory . . . . . . . . . . . . . . . . . . . . . 30 Accrued taxes . . . . . . . . . . . . . . . . . 4
Current assets . . . . . . . . . . . . . . . 50 Current liabilities . . . . . . . . . . . . . 25
Fixed assets . . . . . . . . . . . . . . . . . . 40 Notes payable . . . . . . . . . . . . . . . . . 30
Common stock . . . . . . . . . . . . . . . . . 15
Retained earnings . . . . . . . . . . . . . . 20
Total assets . . . . . . . . . . . . . . . . . . . $90 Total liabilities and
stockholders’ equity . . . . . . . . . . . $90
Carter Paint has an aftertax profit margin of 5 percent and a dividend payout ratio of 30 percent. If sales grow by 10 percent next year, determine how many dollars of new funds are needed to finance the expansion. (Assume Carter Paint is already using assets at full capacity and that plant must be added.)
