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 3 Solution
Assignment: Pro Forma Statements
Chapter 4
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.)
Click here for the SOLUTION
Showing posts with label Week 3. Show all posts
Showing posts with label Week 3. Show all posts
Saturday, July 3, 2010
16. J. Lo’s Clothiers has forecast credit sales for the fourth quarter of the year as
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 3 Solution
Assignment: Pro Forma Statements
Chapter 4
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).
Click here for the SOLUTION
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
Chapter 4
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).
Click here for the SOLUTION
Saturday, April 24, 2010
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
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
Friday, April 23, 2010
ACC 281 Week 3: P10-5A At December 31, 2008, Jimenez Company
ACC 281
Axia College of University of Phoenix (UoP)
Financial Accounting Transaction Analysis
Weygandt, J. J., Kimmel, P. D., & Kieso, D. E. (2008). Financial Accounting (6th ed.). Hoboken, NJ: Wiley.
ACC 281 Week Three Solution
Learning Team Assignment
P10-5A At December 31, 2008, Jimenez Company reported the following as plant assets. Land $ 4,000,000 Buildings $28,500,000 Less: Accumulated depreciation—buildings 12,100,000 16,400,000 Equipment 48,000,000 Less: Accumulated depreciation—equipment 5,000,000 43,000,000 Total plant assets $63,400,000 During 2009, the following selected cash transactions occurred. April 1 Purchased land for $2,130,000. May 1 Sold equipment that cost $780,000 when purchased on January 1, 2005.The equipment was sold for $450,000. June 1 Sold land purchased on June 1, 1999, for $1,500,000.The land cost $400,000. July 1 Purchased equipment for $2,000,000. Dec. 31 Retired equipment that cost $500,000 when purchased on December 31, 1999. No salvage value was received.
Instructions
(a) Journalize the above transactions. The company uses straight-line depreciation for buildings and equipment. The buildings are estimated to have a 50-year life and no salvage value. The equipment is estimated to have a 10-year useful life and no salvage value. Update depreciation on assets disposed of at the time of sale or retirement.
(b) Record adjusting entries for depreciation for 2009.
(c) Prepare the plant assets section of Jimenez’s balance sheet at December 31, 2009.
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Financial Accounting Transaction Analysis
Weygandt, J. J., Kimmel, P. D., & Kieso, D. E. (2008). Financial Accounting (6th ed.). Hoboken, NJ: Wiley.
ACC 281 Week Three Solution
Learning Team Assignment
P10-5A At December 31, 2008, Jimenez Company reported the following as plant assets. Land $ 4,000,000 Buildings $28,500,000 Less: Accumulated depreciation—buildings 12,100,000 16,400,000 Equipment 48,000,000 Less: Accumulated depreciation—equipment 5,000,000 43,000,000 Total plant assets $63,400,000 During 2009, the following selected cash transactions occurred. April 1 Purchased land for $2,130,000. May 1 Sold equipment that cost $780,000 when purchased on January 1, 2005.The equipment was sold for $450,000. June 1 Sold land purchased on June 1, 1999, for $1,500,000.The land cost $400,000. July 1 Purchased equipment for $2,000,000. Dec. 31 Retired equipment that cost $500,000 when purchased on December 31, 1999. No salvage value was received.
Instructions
(a) Journalize the above transactions. The company uses straight-line depreciation for buildings and equipment. The buildings are estimated to have a 50-year life and no salvage value. The equipment is estimated to have a 10-year useful life and no salvage value. Update depreciation on assets disposed of at the time of sale or retirement.
(b) Record adjusting entries for depreciation for 2009.
(c) Prepare the plant assets section of Jimenez’s balance sheet at December 31, 2009.
Click here for the SOLUTION
ACC 281 Week 3: P10-3A On January 1, 2008, Pele Company
ACC 281
Axia College of University of Phoenix (UoP)
Financial Accounting Transaction Analysis
Weygandt, J. J., Kimmel, P. D., & Kieso, D. E. (2008). Financial Accounting (6th ed.). Hoboken, NJ: Wiley.
ACC 281 Week Three Solution
Learning Team Assignment
P10-3A Compute depreciation under different methods.
On January 1, 2008, Pele Company purchased the following two machines for use in its production process.
Machine A: The cash price of this machine was $38,000. Related expenditures included: sales tax $1,700, shipping costs $150, insurance during shipping $80, installation and testing costs $70, and $100 of oil and lubricants to be used with the machinery during its first year of operations. Pele estimates that the useful life of the machine is 5 years with a $5,000 salvage value remaining at the end of that time period. Assume that the straight-line method of depreciation is used.
Machine B: The recorded cost of this machine was $160,000. Pele estimates that the useful life of the machine is 4 years with a $10,000 salvage value remaining at the end of that time period.
Instructions
(a) Prepare the following for Machine A.
(1) The journal entry to record its purchase on January 1, 2008.
(2) The journal entry to record annual depreciation at December 31, 2008.
(b) Calculate the amount of depreciation expense that Pele should record for machine B each year of its useful life under the following assumptions.
(1) Pele uses the straight-line method of depreciation.
(2) Pele uses the declining-balance method.The rate used is twice the straight-line rate.
(3) Pele uses the units-of-activity method and estimates that the useful life of the machine is 125,000 units. Actual usage is as follows: 2008, 45,000 units; 2009, 35,000 units; 2010, 25,000 units; 2011, 20,000 units.
(c) Which method used to calculate depreciation on machine B reports the highest amount of depreciation expense in year 1 (2008)? The highest amount in year 4 (2011)? The highest total amount over the 4-year period?
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Financial Accounting Transaction Analysis
Weygandt, J. J., Kimmel, P. D., & Kieso, D. E. (2008). Financial Accounting (6th ed.). Hoboken, NJ: Wiley.
ACC 281 Week Three Solution
Learning Team Assignment
P10-3A Compute depreciation under different methods.
On January 1, 2008, Pele Company purchased the following two machines for use in its production process.
Machine A: The cash price of this machine was $38,000. Related expenditures included: sales tax $1,700, shipping costs $150, insurance during shipping $80, installation and testing costs $70, and $100 of oil and lubricants to be used with the machinery during its first year of operations. Pele estimates that the useful life of the machine is 5 years with a $5,000 salvage value remaining at the end of that time period. Assume that the straight-line method of depreciation is used.
Machine B: The recorded cost of this machine was $160,000. Pele estimates that the useful life of the machine is 4 years with a $10,000 salvage value remaining at the end of that time period.
Instructions
(a) Prepare the following for Machine A.
(1) The journal entry to record its purchase on January 1, 2008.
(2) The journal entry to record annual depreciation at December 31, 2008.
(b) Calculate the amount of depreciation expense that Pele should record for machine B each year of its useful life under the following assumptions.
(1) Pele uses the straight-line method of depreciation.
(2) Pele uses the declining-balance method.The rate used is twice the straight-line rate.
(3) Pele uses the units-of-activity method and estimates that the useful life of the machine is 125,000 units. Actual usage is as follows: 2008, 45,000 units; 2009, 35,000 units; 2010, 25,000 units; 2011, 20,000 units.
(c) Which method used to calculate depreciation on machine B reports the highest amount of depreciation expense in year 1 (2008)? The highest amount in year 4 (2011)? The highest total amount over the 4-year period?
Click here for the SOLUTION
Saturday, October 17, 2009
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
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
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.
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
Subscribe to:
Posts (Atom)