ACC 561
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
Question 3-38, Mixed Cost, Choosing Cost Drivers, and High-Low and Visual-Fit Methods, on p. 121-122
Click here for the SOLUTION
Question 3-38, Mixed Cost, Choosing Cost Drivers, and High-Low and Visual-Fit Methods
Cedar Rapids Implements Company produces farm implements. Cedar Rapids is in the process of measuring its manufacturing costs and is particularly interested in the costs of the manufacturing maintenance activity, since maintenance is a significant mixed cost. Activity analysis indicates that maintenance activity consists primarily of maintenance labor setting up machines using certain supplies. A setup consists of preparing the necessary machines for a particular production run of a product. During setup, machines must still be running, which consumes energy. Thus, the costs associated with maintenance include labor, supplies, and energy. Unfortunately, Cedar Rapid’s cost accounting system does not trace these costs to maintenance activity separately. Cedar Rapids employs two fulltime maintenance mechanics to perform maintenance. The annual salary of a maintenance mechanic is $25,000 and is considered a fixed cost. Two plausible cost drivers have been suggested: “units produced” and “number of setups.” Data had been collected for the past 12 months and a plot made for the cost driver—units of production. The maintenance cost figures collected include estimates for labor, supplies, and energy. Cory Fielder, controller at Cedar Rapids, noted that some types of activities are performed each time a batch of goods is processed rather than each time a unit is produced. Based on this concept, he has gathered data on the number of setups performed over the past 12 months. The plots of monthly maintenance costs versus the two potential cost drivers follow on page 122.
1. Find monthly fixed maintenance cost and the variable maintenance cost per driver unit using the visual-fit method based on each potential cost driver. Explain how you treated the April data.
2. Find monthly fixed maintenance cost and the variable maintenance cost per driver unit using the high-low method based on each potential cost driver.
3. Which cost driver best meets the criteria for choosing cost functions? Explain.
Click here for the SOLUTION
Tuesday, June 22, 2010
2-65 Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units
ACC 561
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
EXCEL Application Exercise, CVP and Break-Even, on p. 89
Click here for the SOLUTION
EXCEL Application Exercise
2-65 CVP and Break-Even
Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units and dollars. Use the results to answer questions about your findings.
Scenario: Phonetronix is a small manufacturer of telephone and communications devices. Recently, company management decided to investigate the profitability of cellular phone production. They have three different proposals to evaluate. Under all the proposals, the fixed costs for the new phone would be $110,000. Under proposal A, the selling price of the new phone would be $99 and the variable cost per unit would be $55. Under proposal B, the selling price of the phone would be $129 and the variable cost would remain the same.
Under proposal C, the selling price would be $99 and the variable cost would be $49.
When you have completed your spreadsheet, answer the following questions:
1. What are the break-even points in units and dollars under proposal A?
2. How did the increased selling price under proposal B impact the break-even points in
units and dollars compared to the break-even points calculated under proposal A?
3. Why did the change in variable cost under proposal C not impact the break-even points
in units and dollars as significantly as proposal B did?
Step-by-Step:
1. Open a new Excel spreadsheet.
2. In column A, create a bold-faced heading that contains the following:
Row 1: Chapter 2 Decision Guideline
Row 2: Phonetronix
Row 3: Cost-Volume-Profit (CVP) Analysis
Row 4: Today’s Date
3. Merge and center the four heading rows across columns A through D.
4. In Row 7, create the following bold-faced, right-justified column headings:
Column B: Proposal A
Column C: Proposal B
Column D: Proposal C
Note: Adjust cell widths when necessary as you work.
5. In Column A, create the following row headings:
Row 8: Selling price
Row 9: Variable cost
Row 10: Contribution margin
Row 11: Contribution margin ratio
Skip a row
Row 13: Fixed cost
Skip a row
Row 15: Break-even in units
Skip a row
Row 17: Break-even in dollars
6. Use the scenario data to fill in the selling price, variable cost, and fixed cost amounts
for the three proposals.
7. Use the appropriate formulas from this chapter to calculate contribution margin,
contribution margin ratio, break-even in units, and break-even in dollars.
8. Format all amounts as:
Number tab: Category: Currency
Decimal places: 0
Symbol: None
Negative numbers: Red with parenthesis
9. Change the format of the selling price, contribution margin, fixed cost, and break-even
in dollars amounts to display a dollar symbol.
10. Change the format of both contribution margin headings to display as indented:
Alignment tab: Horizontal: Left (Indent)
Indent: 1
11. Change the format of the contribution margin amount cells to display a top border,
using the default line style.
Border tab: Icon: Top Border
12. Change the format of the contribution margin ratio amounts to display as a percentage
with two decimal places.
Number tab: Category: Percentage
Decimal places: 2
13. Change the format of all break-even headings and amounts to display as bold-faced.
14. Activate the ability to use heading names in formulas under Tools ? Options:
Calculation tab: Check the box: Accept labels in formulas
15. Replace the cell-based formulas with “word-based” equivalents for each formula used
in Proposal A.
Example: Contribution margin for proposal B would be:
= (‘Selling price’ ‘Proposal B’) - (‘Variable cost’ ‘Proposal B’)
Note: The tic marks used in the example help avoid naming errors caused by data having similar titles (i.e., “contribution
margin” and “contribution margin ratio”). The parentheses help clarify groupings.
Help: Ask the Answer Wizard about “Name cells in a workbook.”
Select “Learn about labels and names in formulas” from the right-hand panel.
16. Save your work to a disk, and print a copy for your files.
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
EXCEL Application Exercise, CVP and Break-Even, on p. 89
Click here for the SOLUTION
EXCEL Application Exercise
2-65 CVP and Break-Even
Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units and dollars. Use the results to answer questions about your findings.
Scenario: Phonetronix is a small manufacturer of telephone and communications devices. Recently, company management decided to investigate the profitability of cellular phone production. They have three different proposals to evaluate. Under all the proposals, the fixed costs for the new phone would be $110,000. Under proposal A, the selling price of the new phone would be $99 and the variable cost per unit would be $55. Under proposal B, the selling price of the phone would be $129 and the variable cost would remain the same.
Under proposal C, the selling price would be $99 and the variable cost would be $49.
When you have completed your spreadsheet, answer the following questions:
1. What are the break-even points in units and dollars under proposal A?
2. How did the increased selling price under proposal B impact the break-even points in
units and dollars compared to the break-even points calculated under proposal A?
3. Why did the change in variable cost under proposal C not impact the break-even points
in units and dollars as significantly as proposal B did?
Step-by-Step:
1. Open a new Excel spreadsheet.
2. In column A, create a bold-faced heading that contains the following:
Row 1: Chapter 2 Decision Guideline
Row 2: Phonetronix
Row 3: Cost-Volume-Profit (CVP) Analysis
Row 4: Today’s Date
3. Merge and center the four heading rows across columns A through D.
4. In Row 7, create the following bold-faced, right-justified column headings:
Column B: Proposal A
Column C: Proposal B
Column D: Proposal C
Note: Adjust cell widths when necessary as you work.
5. In Column A, create the following row headings:
Row 8: Selling price
Row 9: Variable cost
Row 10: Contribution margin
Row 11: Contribution margin ratio
Skip a row
Row 13: Fixed cost
Skip a row
Row 15: Break-even in units
Skip a row
Row 17: Break-even in dollars
6. Use the scenario data to fill in the selling price, variable cost, and fixed cost amounts
for the three proposals.
7. Use the appropriate formulas from this chapter to calculate contribution margin,
contribution margin ratio, break-even in units, and break-even in dollars.
8. Format all amounts as:
Number tab: Category: Currency
Decimal places: 0
Symbol: None
Negative numbers: Red with parenthesis
9. Change the format of the selling price, contribution margin, fixed cost, and break-even
in dollars amounts to display a dollar symbol.
10. Change the format of both contribution margin headings to display as indented:
Alignment tab: Horizontal: Left (Indent)
Indent: 1
11. Change the format of the contribution margin amount cells to display a top border,
using the default line style.
Border tab: Icon: Top Border
12. Change the format of the contribution margin ratio amounts to display as a percentage
with two decimal places.
Number tab: Category: Percentage
Decimal places: 2
13. Change the format of all break-even headings and amounts to display as bold-faced.
14. Activate the ability to use heading names in formulas under Tools ? Options:
Calculation tab: Check the box: Accept labels in formulas
15. Replace the cell-based formulas with “word-based” equivalents for each formula used
in Proposal A.
Example: Contribution margin for proposal B would be:
= (‘Selling price’ ‘Proposal B’) - (‘Variable cost’ ‘Proposal B’)
Note: The tic marks used in the example help avoid naming errors caused by data having similar titles (i.e., “contribution
margin” and “contribution margin ratio”). The parentheses help clarify groupings.
Help: Ask the Answer Wizard about “Name cells in a workbook.”
Select “Learn about labels and names in formulas” from the right-hand panel.
16. Save your work to a disk, and print a copy for your files.
Click here for the SOLUTION
2-65 Scenario: Phonetronix is a small manufacturer of telephone and communications devices
ACC 561
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
EXCEL Application Exercise, CVP and Break-Even, on p. 89
Click here for the SOLUTION
EXCEL Application Exercise
2-65 CVP and Break-Even
Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units and dollars. Use the results to answer questions about your findings.
Scenario: Phonetronix is a small manufacturer of telephone and communications devices. Recently, company management decided to investigate the profitability of cellular phone production. They have three different proposals to evaluate. Under all the proposals, the fixed costs for the new phone would be $110,000. Under proposal A, the selling price of the new phone would be $99 and the variable cost per unit would be $55. Under proposal B, the selling price of the phone would be $129 and the variable cost would remain the same.
Under proposal C, the selling price would be $99 and the variable cost would be $49.
When you have completed your spreadsheet, answer the following questions:
1. What are the break-even points in units and dollars under proposal A?
2. How did the increased selling price under proposal B impact the break-even points in
units and dollars compared to the break-even points calculated under proposal A?
3. Why did the change in variable cost under proposal C not impact the break-even points
in units and dollars as significantly as proposal B did?
Step-by-Step:
1. Open a new Excel spreadsheet.
2. In column A, create a bold-faced heading that contains the following:
Row 1: Chapter 2 Decision Guideline
Row 2: Phonetronix
Row 3: Cost-Volume-Profit (CVP) Analysis
Row 4: Today’s Date
3. Merge and center the four heading rows across columns A through D.
4. In Row 7, create the following bold-faced, right-justified column headings:
Column B: Proposal A
Column C: Proposal B
Column D: Proposal C
Note: Adjust cell widths when necessary as you work.
5. In Column A, create the following row headings:
Row 8: Selling price
Row 9: Variable cost
Row 10: Contribution margin
Row 11: Contribution margin ratio
Skip a row
Row 13: Fixed cost
Skip a row
Row 15: Break-even in units
Skip a row
Row 17: Break-even in dollars
6. Use the scenario data to fill in the selling price, variable cost, and fixed cost amounts
for the three proposals.
7. Use the appropriate formulas from this chapter to calculate contribution margin,
contribution margin ratio, break-even in units, and break-even in dollars.
8. Format all amounts as:
Number tab: Category: Currency
Decimal places: 0
Symbol: None
Negative numbers: Red with parenthesis
9. Change the format of the selling price, contribution margin, fixed cost, and break-even
in dollars amounts to display a dollar symbol.
10. Change the format of both contribution margin headings to display as indented:
Alignment tab: Horizontal: Left (Indent)
Indent: 1
11. Change the format of the contribution margin amount cells to display a top border,
using the default line style.
Border tab: Icon: Top Border
12. Change the format of the contribution margin ratio amounts to display as a percentage
with two decimal places.
Number tab: Category: Percentage
Decimal places: 2
13. Change the format of all break-even headings and amounts to display as bold-faced.
14. Activate the ability to use heading names in formulas under Tools ? Options:
Calculation tab: Check the box: Accept labels in formulas
15. Replace the cell-based formulas with “word-based” equivalents for each formula used
in Proposal A.
Example: Contribution margin for proposal B would be:
= (‘Selling price’ ‘Proposal B’) - (‘Variable cost’ ‘Proposal B’)
Note: The tic marks used in the example help avoid naming errors caused by data having similar titles (i.e., “contribution
margin” and “contribution margin ratio”). The parentheses help clarify groupings.
Help: Ask the Answer Wizard about “Name cells in a workbook.”
Select “Learn about labels and names in formulas” from the right-hand panel.
16. Save your work to a disk, and print a copy for your files.
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
EXCEL Application Exercise, CVP and Break-Even, on p. 89
Click here for the SOLUTION
EXCEL Application Exercise
2-65 CVP and Break-Even
Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units and dollars. Use the results to answer questions about your findings.
Scenario: Phonetronix is a small manufacturer of telephone and communications devices. Recently, company management decided to investigate the profitability of cellular phone production. They have three different proposals to evaluate. Under all the proposals, the fixed costs for the new phone would be $110,000. Under proposal A, the selling price of the new phone would be $99 and the variable cost per unit would be $55. Under proposal B, the selling price of the phone would be $129 and the variable cost would remain the same.
Under proposal C, the selling price would be $99 and the variable cost would be $49.
When you have completed your spreadsheet, answer the following questions:
1. What are the break-even points in units and dollars under proposal A?
2. How did the increased selling price under proposal B impact the break-even points in
units and dollars compared to the break-even points calculated under proposal A?
3. Why did the change in variable cost under proposal C not impact the break-even points
in units and dollars as significantly as proposal B did?
Step-by-Step:
1. Open a new Excel spreadsheet.
2. In column A, create a bold-faced heading that contains the following:
Row 1: Chapter 2 Decision Guideline
Row 2: Phonetronix
Row 3: Cost-Volume-Profit (CVP) Analysis
Row 4: Today’s Date
3. Merge and center the four heading rows across columns A through D.
4. In Row 7, create the following bold-faced, right-justified column headings:
Column B: Proposal A
Column C: Proposal B
Column D: Proposal C
Note: Adjust cell widths when necessary as you work.
5. In Column A, create the following row headings:
Row 8: Selling price
Row 9: Variable cost
Row 10: Contribution margin
Row 11: Contribution margin ratio
Skip a row
Row 13: Fixed cost
Skip a row
Row 15: Break-even in units
Skip a row
Row 17: Break-even in dollars
6. Use the scenario data to fill in the selling price, variable cost, and fixed cost amounts
for the three proposals.
7. Use the appropriate formulas from this chapter to calculate contribution margin,
contribution margin ratio, break-even in units, and break-even in dollars.
8. Format all amounts as:
Number tab: Category: Currency
Decimal places: 0
Symbol: None
Negative numbers: Red with parenthesis
9. Change the format of the selling price, contribution margin, fixed cost, and break-even
in dollars amounts to display a dollar symbol.
10. Change the format of both contribution margin headings to display as indented:
Alignment tab: Horizontal: Left (Indent)
Indent: 1
11. Change the format of the contribution margin amount cells to display a top border,
using the default line style.
Border tab: Icon: Top Border
12. Change the format of the contribution margin ratio amounts to display as a percentage
with two decimal places.
Number tab: Category: Percentage
Decimal places: 2
13. Change the format of all break-even headings and amounts to display as bold-faced.
14. Activate the ability to use heading names in formulas under Tools ? Options:
Calculation tab: Check the box: Accept labels in formulas
15. Replace the cell-based formulas with “word-based” equivalents for each formula used
in Proposal A.
Example: Contribution margin for proposal B would be:
= (‘Selling price’ ‘Proposal B’) - (‘Variable cost’ ‘Proposal B’)
Note: The tic marks used in the example help avoid naming errors caused by data having similar titles (i.e., “contribution
margin” and “contribution margin ratio”). The parentheses help clarify groupings.
Help: Ask the Answer Wizard about “Name cells in a workbook.”
Select “Learn about labels and names in formulas” from the right-hand panel.
16. Save your work to a disk, and print a copy for your files.
Click here for the SOLUTION
2-61 A division of Hewlett-Packard Company changed its production operations from one where a large labor force assembled electronic components to an
ACC 561
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
Question 2-61, CVP in a Modern Manufacturing Company, on p. 87
Click here for the SOLUTION
Question 2-61, CVP in a Modern Manufacturing Company
A division of Hewlett-Packard Company changed its production operations from one where a large labor force assembled electronic components to an automated production facility dominated by computer-controlled robots. The change was necessary because of fierce competitive pressures. Improvements in quality, reliability, and flexibility of production schedules were necessary just to match competition. As a result of the change, variable costs fell and fixed costs increased, as shown in the following assumed budgets:
Old Production Operation Old Production Operation
Unit variable cost
Material $0.88 $0.88
Labor $1.22 0.22
Total per unit $2.10 $1.10
Monthly fixed costs
Rent and depreciation 450,000.00 $875,000.00
Supervisory labor 80,000.00 175,000.00
Other 50,000.00 90,000.00
Total per month $580,000.00 $1,140,000.00
Expected volume is 600,000 units per month, with each unit selling for $3.10 Capacity is 800,000 units.
1. Compute the budgeted profit as the expected volume of 600,000 units under both the old and the new production environments.
2. Compute the budgeted break-even point under both the old and the new production environments.
3 .Discuss the effect on profits if volume falls to 500,000 units under both the old and the new production environments.
4 .Discuss the effect on profits if volume increases to 700,000 units under both the old and the new production environments.
5 .Comment on the riskiness of the new operation versus the old operation.
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
Question 2-61, CVP in a Modern Manufacturing Company, on p. 87
Click here for the SOLUTION
Question 2-61, CVP in a Modern Manufacturing Company
A division of Hewlett-Packard Company changed its production operations from one where a large labor force assembled electronic components to an automated production facility dominated by computer-controlled robots. The change was necessary because of fierce competitive pressures. Improvements in quality, reliability, and flexibility of production schedules were necessary just to match competition. As a result of the change, variable costs fell and fixed costs increased, as shown in the following assumed budgets:
Old Production Operation Old Production Operation
Unit variable cost
Material $0.88 $0.88
Labor $1.22 0.22
Total per unit $2.10 $1.10
Monthly fixed costs
Rent and depreciation 450,000.00 $875,000.00
Supervisory labor 80,000.00 175,000.00
Other 50,000.00 90,000.00
Total per month $580,000.00 $1,140,000.00
Expected volume is 600,000 units per month, with each unit selling for $3.10 Capacity is 800,000 units.
1. Compute the budgeted profit as the expected volume of 600,000 units under both the old and the new production environments.
2. Compute the budgeted break-even point under both the old and the new production environments.
3 .Discuss the effect on profits if volume falls to 500,000 units under both the old and the new production environments.
4 .Discuss the effect on profits if volume increases to 700,000 units under both the old and the new production environments.
5 .Comment on the riskiness of the new operation versus the old operation.
Click here for the SOLUTION
2-48 Procter & Gamble Company is a Cincinnati-based company that produces household products under brand names such as Gillette, Bounty, Crest,
ACC 561
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
Question 2-48, CVP and Financial Statements for a Mega-Brand Company, on p. 82
Click here for the SOLUTION
Question 2-48 CVP and Financial Statements for a Mega-Brand Company, on p. 82
Procter & Gamble Company is a Cincinnati-based company that produces household products under brand names such as Gillette, Bounty, Crest, Folgers, and Tide. The company’s 2006 income statement showed the following (in millions):
Net sales $68,222
Costs of products sold 33,125
Selling, general, and administrative expense 21,848
Operating income $13,249
Suppose that the cost of products sold is the only variable cost; selling, general, and administrative expenses are fixed with respect to sales.
Assume that Procter & Gamble had a 10% increase in sales in 2007 and that there was no change in costs except for increases associated with the higher volume of sales. Compute the predicted 2007 operating income for Procter & Gamble and its percentage increase. Explain why the percentage increase in income differs from the percentage increase in sales.
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Management Accounting
Horngren, C. T., Sundem, G. L., Stratton, W. O., Burgstahler, D., & Schatzberg, J. (2008). Introduction to Management Accounting (14th ed.). Upper Saddle River, New Jersey: Pearson-Prentice Hall.
4. Individual Assignment: Practice Text Exercises
• Complete the following problem sets from the Introduction to Management Accounting text:
Question 2-48, CVP and Financial Statements for a Mega-Brand Company, on p. 82
Click here for the SOLUTION
Question 2-48 CVP and Financial Statements for a Mega-Brand Company, on p. 82
Procter & Gamble Company is a Cincinnati-based company that produces household products under brand names such as Gillette, Bounty, Crest, Folgers, and Tide. The company’s 2006 income statement showed the following (in millions):
Net sales $68,222
Costs of products sold 33,125
Selling, general, and administrative expense 21,848
Operating income $13,249
Suppose that the cost of products sold is the only variable cost; selling, general, and administrative expenses are fixed with respect to sales.
Assume that Procter & Gamble had a 10% increase in sales in 2007 and that there was no change in costs except for increases associated with the higher volume of sales. Compute the predicted 2007 operating income for Procter & Gamble and its percentage increase. Explain why the percentage increase in income differs from the percentage increase in sales.
Click here for the SOLUTION
Bob Night’s fishing camp, “The General’s Favorite Fishing Hole,” is in the second month of operation. The camp is open from April through September
The General's Favorite Fishing Hole - Period 2
Click here for the SOLUTION
Comprehensive Problem. Heintz and Parry. College Accounting 19th Edition and 20th Edition
The General’s Favorite Fishing Hole
PERIOD 2
The General’s Favorite Fishing Hole
Bob Night’s fishing camp, “The General’s Favorite Fishing Hole,” is in the second month of operation. The camp is open from April through September, which allows for many college basketball coaches to attend during their off-season. The camp’s attendees arrive on Sunday afternoon and return home the following Saturday afternoon. Each attendee pays a registration fee that includes room and board, the use of fishing boats, and professional instruction in fishing techniques. Based on suggestions from clients, Night plans to expand the facilities and provide additional services. The post-closing trial balance as of April 30, and chart of accounts are provided below.
The General’s Favorite Fishing Hole
The following transactions took place during May 20--
The General’s Favorite Fishing Hole
May
1 In order to provide snacks for guests on a 24 hour basis, Night signed a contract with Snack Attack. Snack Attack will install vending machines with food and drinks and pay a 10% commission on all sales. Estimated payments are made at the beginning of each month. Night received a check for $200, the estimated commission on sales for May.
2 Night purchased a surround sound system and big screen TV with a Digital Satellite System for the guest lounge. The surround sound system cost $3,600 and has an estimated useful life of 5 years, and no salvage value. The TV cost $8,000 and has an estimated useful life of 8 years, and a salvage value of $800. Night paid cash for both items.
2 Paid for May’s programming on the new Digital Satellite System, $125.
3 Night's office manager returned $100 worth of office supplies to Gordon Office Supply. Night received a $100 reduction in our account with Gordon.
3 Deposited registration fees, $52,700
3 Paid rent for lodge and campgrounds for the month of May, $40,000.
3 In preparation for the purchase of a nearby campground, Night invested an additional $600,000.
4 Paid Gordon Office Supply on account, $400.
4 Purchased the assets of a competing business and paid cash for the following: land $100,000, lodge $530,000 and fishing boats $9,000. The lodge has a remaining useful life of 50 years and a $50,000 salvage value. The boats have remaining lives of 5 years and zero salvage value.
5 Paid May's insurance premium for the new camp, $1,000
5 Purchased food supplies from Acme Super Market on account, $22,950.
5 Purchased office supplies from Gordon Office Supplies on account, $1,200.
7 Night paid $40 each for one-year subscriptions to Fishing Illustrated, Fishing Unlimited, and Fish Master.
10 Deposited registration fees, $62,750
13 Paid wages to fishing guides, $30,000.
14 A guest because ill and was unable to stay for the entire week. A refund was issued in the amount of $1,000.
17 Deposited registration fees, $63,000.
19 Purchased food supplies from Acme Super Market on account, $18,400.
21 Deposited registration fees, $63,400
23 Paid $2,500 for advertising spots on National Sports Talk Radio
25 Paid repair fee for damaged boat, $ 850.
27 Paid wages to fishing guides, $30,000.
28 Paid $1,800 for advertising spots on billboards in the mid-west.
29 Purchased food supplies from Acme Super Market on account, $14,325.
30 Paid utilities bill, $3,300
30 Paid telephone bill, $1,800.
30 Paid Acme Super Market on account, $47,350.
31 Bob Night withdrew cash for personal use, $7,500.
Adjustment information at the end of May is provided below.
a. Total vending machine sales were $2,300 for the month of May.
b. Straight-line depreciation is used for the 10 boats purchased on April 2nd for $60,000. The useful life for these assets is 5 years and there is no salvage value. A full month's depreciation was taken in April on these boats.
c. Straight line depreciation is used for the 2 boats purchased in May.
d. Straight line depreciation is used to depreciate the surround sound system.
e. Straight line depreciation is used to depreciate the big screen TV.
f. Straight line depreciation is used for the building purchased in May.
g. On April 2nd Night paid $9,000 for insurance during the six-month camping season. May's portion of this premium was used up during this month.
h. Night received his May issues of Fishing Illustrated, Fishing Unlimited, and Fish Master.
i. Office supplies remaining on hand, $150.
j. Food supplies remaining on hand, $5,925.
k. Wages earned, but not yet paid, at the end of May, $6,000.
The General’s Favorite Fishing Hole
REQUIRED
1. Enter the above transactions in a general journal. Enter transactions from May 1-4 on page 5, May 5-28 on page 6, and the remaining entries on page 7.
2. Post the entries to the general ledger. (If you are not using the working papers that accompany this text, you will need to enter the account titles and account numbers in the general ledger accounts.)
3. Prepare a trial balance on a work sheet.
4. Complete the work sheet.
5. Prepare the income statement.
6. Prepare the statement of owner’s equity
7. Prepare the balance sheet.
8. Journalize the adjusting entries on page 8 of the general journal.
9. Post the adjusting entries to the general ledger.
10. Journalize the closing entries on page 9 of the general journal.
11. Post the closing entries to the general ledger.
12. Prepare a post-closing trial balance.
Click here for the SOLUTION
Click here for the SOLUTION
Comprehensive Problem. Heintz and Parry. College Accounting 19th Edition and 20th Edition
The General’s Favorite Fishing Hole
PERIOD 2
The General’s Favorite Fishing Hole
Bob Night’s fishing camp, “The General’s Favorite Fishing Hole,” is in the second month of operation. The camp is open from April through September, which allows for many college basketball coaches to attend during their off-season. The camp’s attendees arrive on Sunday afternoon and return home the following Saturday afternoon. Each attendee pays a registration fee that includes room and board, the use of fishing boats, and professional instruction in fishing techniques. Based on suggestions from clients, Night plans to expand the facilities and provide additional services. The post-closing trial balance as of April 30, and chart of accounts are provided below.
The General’s Favorite Fishing Hole
The following transactions took place during May 20--
The General’s Favorite Fishing Hole
May
1 In order to provide snacks for guests on a 24 hour basis, Night signed a contract with Snack Attack. Snack Attack will install vending machines with food and drinks and pay a 10% commission on all sales. Estimated payments are made at the beginning of each month. Night received a check for $200, the estimated commission on sales for May.
2 Night purchased a surround sound system and big screen TV with a Digital Satellite System for the guest lounge. The surround sound system cost $3,600 and has an estimated useful life of 5 years, and no salvage value. The TV cost $8,000 and has an estimated useful life of 8 years, and a salvage value of $800. Night paid cash for both items.
2 Paid for May’s programming on the new Digital Satellite System, $125.
3 Night's office manager returned $100 worth of office supplies to Gordon Office Supply. Night received a $100 reduction in our account with Gordon.
3 Deposited registration fees, $52,700
3 Paid rent for lodge and campgrounds for the month of May, $40,000.
3 In preparation for the purchase of a nearby campground, Night invested an additional $600,000.
4 Paid Gordon Office Supply on account, $400.
4 Purchased the assets of a competing business and paid cash for the following: land $100,000, lodge $530,000 and fishing boats $9,000. The lodge has a remaining useful life of 50 years and a $50,000 salvage value. The boats have remaining lives of 5 years and zero salvage value.
5 Paid May's insurance premium for the new camp, $1,000
5 Purchased food supplies from Acme Super Market on account, $22,950.
5 Purchased office supplies from Gordon Office Supplies on account, $1,200.
7 Night paid $40 each for one-year subscriptions to Fishing Illustrated, Fishing Unlimited, and Fish Master.
10 Deposited registration fees, $62,750
13 Paid wages to fishing guides, $30,000.
14 A guest because ill and was unable to stay for the entire week. A refund was issued in the amount of $1,000.
17 Deposited registration fees, $63,000.
19 Purchased food supplies from Acme Super Market on account, $18,400.
21 Deposited registration fees, $63,400
23 Paid $2,500 for advertising spots on National Sports Talk Radio
25 Paid repair fee for damaged boat, $ 850.
27 Paid wages to fishing guides, $30,000.
28 Paid $1,800 for advertising spots on billboards in the mid-west.
29 Purchased food supplies from Acme Super Market on account, $14,325.
30 Paid utilities bill, $3,300
30 Paid telephone bill, $1,800.
30 Paid Acme Super Market on account, $47,350.
31 Bob Night withdrew cash for personal use, $7,500.
Adjustment information at the end of May is provided below.
a. Total vending machine sales were $2,300 for the month of May.
b. Straight-line depreciation is used for the 10 boats purchased on April 2nd for $60,000. The useful life for these assets is 5 years and there is no salvage value. A full month's depreciation was taken in April on these boats.
c. Straight line depreciation is used for the 2 boats purchased in May.
d. Straight line depreciation is used to depreciate the surround sound system.
e. Straight line depreciation is used to depreciate the big screen TV.
f. Straight line depreciation is used for the building purchased in May.
g. On April 2nd Night paid $9,000 for insurance during the six-month camping season. May's portion of this premium was used up during this month.
h. Night received his May issues of Fishing Illustrated, Fishing Unlimited, and Fish Master.
i. Office supplies remaining on hand, $150.
j. Food supplies remaining on hand, $5,925.
k. Wages earned, but not yet paid, at the end of May, $6,000.
The General’s Favorite Fishing Hole
REQUIRED
1. Enter the above transactions in a general journal. Enter transactions from May 1-4 on page 5, May 5-28 on page 6, and the remaining entries on page 7.
2. Post the entries to the general ledger. (If you are not using the working papers that accompany this text, you will need to enter the account titles and account numbers in the general ledger accounts.)
3. Prepare a trial balance on a work sheet.
4. Complete the work sheet.
5. Prepare the income statement.
6. Prepare the statement of owner’s equity
7. Prepare the balance sheet.
8. Journalize the adjusting entries on page 8 of the general journal.
9. Post the adjusting entries to the general ledger.
10. Journalize the closing entries on page 9 of the general journal.
11. Post the closing entries to the general ledger.
12. Prepare a post-closing trial balance.
Click here for the SOLUTION
Bob night opened "The general's favorite Fishing Hole" The fishing camp is open from April through September and attracts many famous college
The General's Favorite Fishing Hole - Period 1 (Month of April)
Click here for the SOLUTION
Comprehensive Problem. Heintz and Parry. College Accounting 19th Edition and 20th Edition
PERIOD 1
The Account Cycle
Bob night opened "The general's favorite Fishing Hole" The fishing camp is open from April through September and attracts many famous college basketball coaches during the off-season. Guests typically register for one week, arriving on Sunday afternoon and returning home the following Saturday afternoon. The registration fee includes room and board, the use of fishing boats, and professional instruction in fishing techniques. The chart of accounts for the camping operations is provided below.
Required:
1 Enter the above transactions in a general journal. Enter transactions from April 1-5 on pages 1, April 7-8 on page 2, April 21-29 and the first two entries for April 30 on page 3, and the remain entries for April 30 on page 4.
2 Post the entries to the general ledger.(if you are not using the working papers that accompany this text, you will need to enter the account titles and account numbers in the general leger accounts).
3 Prepare a trial balance on a work sheet.
4 Complete the work sheet.
5 Prepare the income statement.
6 Prepare the statement of owner's equity
7 Prepare the balance sheet.
8 Journalise the adjusting entries (page 5)
9 Post the adjusting entries to the general ledger.
10 Journalise the closing entries (page 5 and 6)
11 Post the closing entries to the general ledger.
12 Prepare a post-closing trial balance.
Click here for the SOLUTION
Click here for the SOLUTION
Comprehensive Problem. Heintz and Parry. College Accounting 19th Edition and 20th Edition
PERIOD 1
The Account Cycle
Bob night opened "The general's favorite Fishing Hole" The fishing camp is open from April through September and attracts many famous college basketball coaches during the off-season. Guests typically register for one week, arriving on Sunday afternoon and returning home the following Saturday afternoon. The registration fee includes room and board, the use of fishing boats, and professional instruction in fishing techniques. The chart of accounts for the camping operations is provided below.
Required:
1 Enter the above transactions in a general journal. Enter transactions from April 1-5 on pages 1, April 7-8 on page 2, April 21-29 and the first two entries for April 30 on page 3, and the remain entries for April 30 on page 4.
2 Post the entries to the general ledger.(if you are not using the working papers that accompany this text, you will need to enter the account titles and account numbers in the general leger accounts).
3 Prepare a trial balance on a work sheet.
4 Complete the work sheet.
5 Prepare the income statement.
6 Prepare the statement of owner's equity
7 Prepare the balance sheet.
8 Journalise the adjusting entries (page 5)
9 Post the adjusting entries to the general ledger.
10 Journalise the closing entries (page 5 and 6)
11 Post the closing entries to the general ledger.
12 Prepare a post-closing trial balance.
Click here for the SOLUTION
3. You will receive $5,000 three years from now. The discount rate is 8 percent.
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 9 Solution
Assignment: Present Value, Future Value, and Annuity Due
3. You will receive $5,000 three years from now. The discount rate is 8 percent.
a. What is the value of your investment two years from now? Multiply $5,000 .926 (one year’s discount rate at 8 percent).
b. What is the value of your investment one year from now? Multiply your answer to part a by .926 (one year’s discount rate at 8 percent).
c. What is the value of your investment today? Multiply your answer to part b by .926 (one year’s discount rate at 8 percent).
d. Confirm that your answer to part c is correct by going to Appendix B (present value of $1) for n 3 and i 8 percent. Multiply this tabular value by $5,000 and compare your answer to part c. There may be a slight difference due to rounding.
4. If you invest $9,000 today, how much will you have:
a. In 2 years at 9 percent?
b. In 7 years at 12 percent?
c. In 25 years at 14 percent?
d. In 25 years at 14 percent (compounded semiannually)?
5. Your uncle offers you a choice of $30,000 in 50 years or $95 today. If money is
discounted at 12 percent, which should you choose?
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 9 Solution
Assignment: Present Value, Future Value, and Annuity Due
- Resource: Ch. 9 of Foundations of Financial Management
- Due Date: Day 5 [Individual forum]
- Complete Problems 3, 4, and 5 on pp. 278-279.
- Post as an attachment.
3. You will receive $5,000 three years from now. The discount rate is 8 percent.
a. What is the value of your investment two years from now? Multiply $5,000 .926 (one year’s discount rate at 8 percent).
b. What is the value of your investment one year from now? Multiply your answer to part a by .926 (one year’s discount rate at 8 percent).
c. What is the value of your investment today? Multiply your answer to part b by .926 (one year’s discount rate at 8 percent).
d. Confirm that your answer to part c is correct by going to Appendix B (present value of $1) for n 3 and i 8 percent. Multiply this tabular value by $5,000 and compare your answer to part c. There may be a slight difference due to rounding.
4. If you invest $9,000 today, how much will you have:
a. In 2 years at 9 percent?
b. In 7 years at 12 percent?
c. In 25 years at 14 percent?
d. In 25 years at 14 percent (compounded semiannually)?
5. Your uncle offers you a choice of $30,000 in 50 years or $95 today. If money is
discounted at 12 percent, which should you choose?
Click here for the SOLUTION
Write a 200- to 300-word description of the four time value of money concepts: present value, present value of an annuity, future value, and future
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 8 Solution
CheckPoint: Time Value of Money
Axia College of University of Phoenix (UoP)
Foundations of Financial Management
Block Hirt Danielsen
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 8 Solution
CheckPoint: Time Value of Money
- Resource: Ch. 7 of Foundations of Financial Management
- Due Date: Day 5 [Individual forum]
- Write a 200- to 300-word description of the four time value of money concepts: present value, present value of an annuity, future value, and future value of annuity. Describe the characteristics of each concept and give an example of when each would be used.
Midland Chemical Co. is negotiating a loan from Manhattan Bank and Trust. The small chemical company needs to borrow $500,000. The bank offers a rate
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 7 Solution
CheckPoint: Loan Scenario
Midland Chemical Co. is negotiating a loan from Manhattan Bank and Trust. The small chemical company needs to borrow $500,000.
The bank offers a rate of 8¼ percent with a 20 percent compensating balance requirement, or as an alternative, 9¾ percent with additional fees of $5,500 to cover services the bank is providing. In either case the rate on the loan is floating (changes as the prime interest rate changes), and the loan would be for one year.
a. Which loan carries the lower effective rate? Consider fees to be the equivalent of
other interest.
b. If the loan with a 20 percent compensating balance requirement were to be paid
off in 12 monthly payments, what would the effective rate be? (Principal equals
amount borrowed minus the compensating balance.)
c. Assume the proceeds from the loan with the compensating balance requirement
will be used to take cash discounts. Disregard part b about installment payments
and use the loan cost from part a.
If the terms of the cash discount are 1.5/10, net 50, should the firm borrow the funds
to take the discount?
d. Assume the firm actually takes 80 days to pay its bills and would continue to
do so in the future if it did not take the cash discount. Should it take the cash
discount?
e. Because the interest rate on the loans is floating, it can go up as interest rates go
up. Assume that the prime rate goes up by 2 percent and the quoted rate on the
loan goes up the same amount. What would then be the effective rate on the loan
with compensating balances? Convert the interest to dollars as the first step in
your calculation.
f. In order to hedge against the possible rate increase described in part e, Midland
decides to hedge its position in the futures market. Assume it sells $500,000
worth of 12-month futures contracts on Treasury bonds. One year later, interest
rates go up 2 percent across the board and the Treasury bond futures have gone
down to $488,000. Has the firm effectively hedged the 2 percent increase in
interest rates on the bank loan as described in part e? Determine the answer in
dollar amounts.
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 7 Solution
CheckPoint: Loan Scenario
- Resource: Ch. 8 of Foundations of Financial Management
- Due Date: Day 7 [post to the Individual forum]
- Complete the Comprehensive Problem: Midland Chemical Co. on pp. 250-251.
- Post the assignment as an attachment.
Midland Chemical Co. is negotiating a loan from Manhattan Bank and Trust. The small chemical company needs to borrow $500,000.
The bank offers a rate of 8¼ percent with a 20 percent compensating balance requirement, or as an alternative, 9¾ percent with additional fees of $5,500 to cover services the bank is providing. In either case the rate on the loan is floating (changes as the prime interest rate changes), and the loan would be for one year.
a. Which loan carries the lower effective rate? Consider fees to be the equivalent of
other interest.
b. If the loan with a 20 percent compensating balance requirement were to be paid
off in 12 monthly payments, what would the effective rate be? (Principal equals
amount borrowed minus the compensating balance.)
c. Assume the proceeds from the loan with the compensating balance requirement
will be used to take cash discounts. Disregard part b about installment payments
and use the loan cost from part a.
If the terms of the cash discount are 1.5/10, net 50, should the firm borrow the funds
to take the discount?
d. Assume the firm actually takes 80 days to pay its bills and would continue to
do so in the future if it did not take the cash discount. Should it take the cash
discount?
e. Because the interest rate on the loans is floating, it can go up as interest rates go
up. Assume that the prime rate goes up by 2 percent and the quoted rate on the
loan goes up the same amount. What would then be the effective rate on the loan
with compensating balances? Convert the interest to dollars as the first step in
your calculation.
f. In order to hedge against the possible rate increase described in part e, Midland
decides to hedge its position in the futures market. Assume it sells $500,000
worth of 12-month futures contracts on Treasury bonds. One year later, interest
rates go up 2 percent across the board and the Treasury bond futures have gone
down to $488,000. Has the firm effectively hedged the 2 percent increase in
interest rates on the bank loan as described in part e? Determine the answer in
dollar amounts.
Click here for the SOLUTION
Collins Office Supplies is considering a more liberal credit policy to increase sales, but expects that 9 percent of the new accounts will be
FIN 200
Axia College of University of Phoenix (UoP)
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 6 Solution
CheckPoint: Credit Policy Decisions
Collins Office Supplies is considering a more liberal credit policy to increase sales, but expects that 9 percent of the new accounts will be uncollectible. Collection costs are 5 percent of new sales, production and selling costs are 78 percent, and accounts receivable turnover is five times. Assume income taxes of 30 percent and an increase in sales of $80,000. No other asset buildup will be required to service the new accounts.
a. What is the level of accounts receivable needed to support this sales expansion?
b. What would be Collins’s incremental aftertax return on investment?
c. Should Collins liberalize credit if a 15 percent aftertax return on investment is required?
Assume Collins also needs to increase its level of inventory to support new sales and that inventory turnover is four times.
d. What would be the total incremental investment in accounts receivable and inventory to support an $80,000 increase in sales?
e. Given the income determined in part b and the investment determined in part d, should Collins extend more liberal credit terms?
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 6 Solution
CheckPoint: Credit Policy Decisions
- Resource: Ch. 7 of Foundations of Financial Management
- Due Date: Day 5 [Individual forum]
- Complete Problem 17 on p. 220.
Collins Office Supplies is considering a more liberal credit policy to increase sales, but expects that 9 percent of the new accounts will be uncollectible. Collection costs are 5 percent of new sales, production and selling costs are 78 percent, and accounts receivable turnover is five times. Assume income taxes of 30 percent and an increase in sales of $80,000. No other asset buildup will be required to service the new accounts.
a. What is the level of accounts receivable needed to support this sales expansion?
b. What would be Collins’s incremental aftertax return on investment?
c. Should Collins liberalize credit if a 15 percent aftertax return on investment is required?
Assume Collins also needs to increase its level of inventory to support new sales and that inventory turnover is four times.
d. What would be the total incremental investment in accounts receivable and inventory to support an $80,000 increase in sales?
e. Given the income determined in part b and the investment determined in part d, should Collins extend more liberal credit terms?
Click here for the SOLUTION
Lear, Inc. has $800,000 in current assets, $350,000 of which are considered permanent current assets. In addition, the firm has $600,000 invested in
FIN 200
Axia College of University of Phoenix (UoP)
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 5 Solution
Assignment: Alternative Financing Plans
Resource: Ch. 6 of Foundations of Financial Management
Due Date: Day 7 [post to the Individual forum]
Complete Problem 14 on p. 184.
Post the assignment as an attachment.
Click here for the SOLUTION
Lear, Inc. has $800,000 in current assets, $350,000 of which are considered permanent current assets. In addition, the firm has $600,000 invested in fixed assets.
a. Lear wishes to finance all fixed assets and half of its permanent current assets with long-term financing costing 10 percent. Short-term financing currently costs 5 percent. Lear’s earnings before interest and taxes are $200,000. Determine Lear’s earnings after taxes under this financing plan. The tax rate is 30 percent.
b. As an alternative, Lear might wish to finance all fixed assets and permanent current assets plus half of its temporary current assets with long-term financing. The same interest rates apply as in part a. Earnings before interest and taxes will be $200,000. What will be Lear’s earnings after taxes? The tax rate is 30 percent.
c. What are some of the risks and cost considerations associated with each of these alternative financing strategies?
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 5 Solution
Assignment: Alternative Financing Plans
Resource: Ch. 6 of Foundations of Financial Management
Due Date: Day 7 [post to the Individual forum]
Complete Problem 14 on p. 184.
Post the assignment as an attachment.
Click here for the SOLUTION
Lear, Inc. has $800,000 in current assets, $350,000 of which are considered permanent current assets. In addition, the firm has $600,000 invested in fixed assets.
a. Lear wishes to finance all fixed assets and half of its permanent current assets with long-term financing costing 10 percent. Short-term financing currently costs 5 percent. Lear’s earnings before interest and taxes are $200,000. Determine Lear’s earnings after taxes under this financing plan. The tax rate is 30 percent.
b. As an alternative, Lear might wish to finance all fixed assets and permanent current assets plus half of its temporary current assets with long-term financing. The same interest rates apply as in part a. Earnings before interest and taxes will be $200,000. What will be Lear’s earnings after taxes? The tax rate is 30 percent.
c. What are some of the risks and cost considerations associated with each of these alternative financing strategies?
Click here for the SOLUTION
Healthy Foods, Inc., sells 50-pound bags of grapes to the military for $10 a bag. The fixed costs of this operation are $80,000, while the variable
FIN 200
Axia College of University of Phoenix (UoP)
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 4 Solution
CheckPoint: Break-Even Analysis
Healthy Foods, Inc., sells 50-pound bags of grapes to the military for $10 a bag. The fixed costs of this operation are $80,000, while the variable costs of the grapes are $.10 per pound.
a. What is the break-even point in bags?
b. Calculate the profit or loss on 12,000 bags and on 25,000 bags.
c. What is the degree of operating leverage at 20,000 bags and at 25,000 bags? Why does the degree of operating leverage change as the quantity sold increases?
d. If Healthy Foods has an annual interest expense of $10,000, calculate the degree of financial leverage at both 20,000 and 25,000 bags.
e. What is the degree of combined leverage at both sales levels?
Click here for the SOLUTION
Axia College of University of Phoenix (UoP)
Introduction to Finance: Harvesting the Money Tree
Fin 200 Week 4 Solution
CheckPoint: Break-Even Analysis
- Resource: Ch. 5 of Foundations of Financial Management
- Due Date: Day 5 [Individual forum]
- Complete Problem 13 on p. 144.
Healthy Foods, Inc., sells 50-pound bags of grapes to the military for $10 a bag. The fixed costs of this operation are $80,000, while the variable costs of the grapes are $.10 per pound.
a. What is the break-even point in bags?
b. Calculate the profit or loss on 12,000 bags and on 25,000 bags.
c. What is the degree of operating leverage at 20,000 bags and at 25,000 bags? Why does the degree of operating leverage change as the quantity sold increases?
d. If Healthy Foods has an annual interest expense of $10,000, calculate the degree of financial leverage at both 20,000 and 25,000 bags.
e. What is the degree of combined leverage at both sales levels?
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
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)