CORPORATE FINANCE - CONNECT ACCESS
12th Edition
ISBN: 9781264054893
Author: Ross
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 32QAP
Summary Introduction
Adequate information:
| Year | Unit Sales |
| 1 | 73,000 |
| 2 | 79,000 |
| 3 | 84,000 |
| 4 | 82,000 |
| 5 | 68,000 |
Initial net working capital (NWC) = $1,500,000
Additional net working capital for Year 1 to Year 4 will be 15% of the projected sales increase in the following year.
Total fixed costs = $3,400,000
Variable cost per unit = $145
Price per unit = $325
Cost of equipment (C) = $18,500,000
Market value = 20% of acquisition cost
Tax rate = 23% or 0.23
Required
To compute: The
Introduction:
Internal rate of return (IRR) is defined as the discount rate at which the aggregate present value of net
Net present value (NPV) is defined as the summation of the present value of cash inflows in each period minus the summation of the present value of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Aguilera Acoustics, Inc. (AAI), projects unit sales for a newseven-octave voice emulation implant as follows:
Year
Unit Sales
1
8300
2
9200
3
10400
4
9800
5
8400
Production of the implants will require GH¢ 150,000 in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales for that year. In the final year of the project, net working capital will decline to zero as the project is wound down. In other words, the investment in working capital is to be completely recovered by the end of the project’s life. Total fixed costs are GH¢ 240,000 per year, variable production costs are GH¢ 190 per unit, and the units are priced at GH¢ 345 each. The equipment needed to begin production has an installed cost of GH¢ 2,300,000. Because the implants are intended for professional singers, this equipment depreciated using the straight-line basis. In five years,…
Can someone please help me solve this question using Excel?
Consider a project to supply Detroit with 20,000 tons of machine screws annually for automobile production. You will need an initial $3.1 million investment in threading equipment to get the project started; the project will last for five years. The accounting department estimates that annual fixed costs will be $925,000 and that variable costs should be $185 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the five-year project life. It also estimates a salvage value of $400,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $295 per ton. The engineering department estimates you will need an initial net working capital investment of $380,000. You require a return of 13 percent and face a tax rate of 22 percent on this project.
a.
Suppose you’re confident about your own projections, but you’re a little unsure about Detroit’s actual machine screw…
Chapter 6 Solutions
CORPORATE FINANCE - CONNECT ACCESS
Ch. 6 - Opportunity Cost In the context of capital...Ch. 6 - Prob. 2CQCh. 6 - Incremental Cash Flows Your company currently...Ch. 6 - Depreciation Given the choice, would a firm prefer...Ch. 6 - Prob. 5CQCh. 6 - Prob. 6CQCh. 6 - Equivalent Annual Cost When is EAC analysis...Ch. 6 - Prob. 8CQCh. 6 - Capital Budgeting Considerations A major college...Ch. 6 - To answer the next three questions, refer to the...
Ch. 6 - Prob. 11CQCh. 6 - To answer the next three questions, refer to the...Ch. 6 - Prob. 1QAPCh. 6 - Prob. 2QAPCh. 6 - Calculating Project NPV Down Under Boomerang,...Ch. 6 - Calculating Project Cash Flow from Assets In the...Ch. 6 - Prob. 5QAPCh. 6 - NPV and Bonus Depreciation In the previous...Ch. 6 - Prob. 7QAPCh. 6 - Prob. 8QAPCh. 6 - NPV and Bonus Depreciation In the previous...Ch. 6 - Calculating Salvage Value An asset used in a...Ch. 6 - Calculating NPV Thurston Petroleum is considering...Ch. 6 - Prob. 12QAPCh. 6 - Cost-Cutting Proposals Starset Machine Shop is...Ch. 6 - NPV and Bonus Depreciation In the previous...Ch. 6 - Prob. 15QAPCh. 6 - Prob. 16QAPCh. 6 - NPV and Bonus Depreciation Eggz, Inc., is...Ch. 6 - Prob. 18QAPCh. 6 - Prob. 19QAPCh. 6 - Prob. 20QAPCh. 6 - Prob. 21QAPCh. 6 - Prob. 22QAPCh. 6 - Prob. 23QAPCh. 6 - Prob. 24QAPCh. 6 - Prob. 25QAPCh. 6 - Prob. 26QAPCh. 6 - Prob. 27QAPCh. 6 - Prob. 28QAPCh. 6 - Prob. 29QAPCh. 6 - Prob. 30QAPCh. 6 - Prob. 31QAPCh. 6 - Prob. 32QAPCh. 6 - Prob. 33QAPCh. 6 - Prob. 34QAPCh. 6 - Prob. 35QAPCh. 6 - Prob. 36QAPCh. 6 - Prob. 37QAPCh. 6 - Prob. 38QAPCh. 6 - Prob. 39QAPCh. 6 - Prob. 40QAPCh. 6 - Prob. 41QAPCh. 6 - Prob. 42QAPCh. 6 - Prob. 1MCCh. 6 - GOODWEEK TIRES, INC. After extensive research and...
Knowledge Booster
Similar questions
- Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.arrow_forwardGardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.arrow_forwardThe Rodriguez Company is considering an average-risk investment in a mineral water spring project that has an initial after-tax cost of 170,000. The project will produce 1,000 cases of mineral water per year indefinitely, starting at Year 1. The Year-1 sales price will be 138 per case, and the Year-1 cost per case will be 105. The firm is taxed at a rate of 25%. Both prices and costs are expected to rise after Year 1 at a rate of 6% per year due to inflation. The firm uses only equity, and it has a cost of capital of 15%. Assume that cash flows consist only of after-tax profits because the spring has an indefinite life and will not be depreciated. a. What is the present value of future cash flows? (Hint: The project is a growing perpetuity, so you must use the constant growth formula to find its NPV.) What is the NPV? b. Suppose that the company had forgotten to include future inflation. What would they have incorrectly calculated as the projects NPV?arrow_forward
- Project Evaluation: Kolby's Korndogs is looking at a new sausage system with an installed cost of $655,000. The cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage stystem can be scrapped for $85,000. The sausage system will save the firm $183,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $35,000. If the tax rate is 22 percent and the discount rate is 8 percent, what is the NPV of this project? Can the calculator and excel solution be provided?arrow_forwardConsider a project to supply Detroit with 40,000 tons of machine screws annually forautomobile production. You will need an initial $5,600,000 investment in threadingequipment to get the project started; the project will last for 6 years. The accountingdepartment estimates that annual fixed costs will be $600,000 and that variable costsshould be $250 per ton. Further, the accounting department will depreciate the initialfixed asset investment straight-line to zero over the 6-year project life and estimate asalvage value of $450,000 after dismantling costs. The marketing department estimatesthat the automakers will let the contract at a selling price of $340 per ton. The engineeringdepartment estimates you will need an initial net working capital investment of $560,000.You require a return of 13 percent and face a marginal tax rate of 24 percent on thisproject.Suppose you’re confident about your own projections, but you’re a little unsure aboutDetroit’s actual machine screw…arrow_forwardVandelay Industries is considering the purchase of a new machine for the production of latex. Machine A costs $3,210,000 and will last for six years. Variable costs are 37 percent of sales, and fixed costs are $350,000 per year. Machine B costs $5,455,000 and will last for nine years. Variable costs for this machine are 32 percent of sales and fixed costs are $240,000 per year. The sales for each machine will be $12.4 million per year. The required return is 9 percent, and the tax rate is 24 percent. Both machines will be depreciated on a straight-line basis. The company plans to replace the machine when it wears out on a perpetual basis. Calculate the EAC for each machine. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Answer is complete but not entirely correct. System A $ -4,473,627.60 X System B $ -4,090,361.10arrow_forward
- Vandelay Industries is considering the purchase of a new machine for the production of latex. Machine A costs $ 3,210,000 and will last for six years. Variable costs are 37 percent of sales, and fixed costs are $350,000 per year. Machine B costs $5,455,000 and will last for nine years. Variable costs for this machine are 32 percent of sales and fixed costs are $240,000 per year. The sales for each machine will be $12.4 million per year. The required return is 9 percent, and the tax rate is 24 percent. Both machines will be depreciated on a straight-line basis. The company plans to replace the machine when it wears out on a perpetual basis. Calculate the EAC for each machine.arrow_forwardDrones-R-Fun is considering a new drone product line. The initial investment is $17,883,958, annual revenues are $7,566,755 and annual maintenance is $317,415. Assume a 10% MARR and a project life of 5 years. Using Annual Worth (AW), determine the B/C Ratio of this program. Initial Cost $17,883,958 Annual Cost $317,415 Annual Benefit $7,566,755 MARR 10% Life Time 5 yearsarrow_forwardVandalay Industries is considering the purchase of a new machine for the production of latex. Machine A costs $1,810,000 and will last for 4 years. Variable costs are 37 percent of sales, and fixed costs are $179,000 per year. Machine B costs $4,730,000 and will last for 8 years. Variable costs for this machine are 32 percent of sales and fixed costs are $117,000 per year. The sales for each machine will be $9.46 million per year. The required return is 10 percent and the tax rate is 21 percent. Both machines will be depreciated on a straight-line basis. If the company plans to replace the machine when it wears out on a perpetual basis, what is the EAC for machine A? EAC If the company plans to replace the machine when it wears out on a perpetual basis, what is the EAC for machine B? EACarrow_forward
- Consider a project to supply Detroit with 27,000 tons of machine screws annually for automobile production. You will need an initial $5,600,000 investment in threading equipment to get the project started; the project will last for 6 years. The accounting department estimates that annual fixed costs will be $1,350,000 and that variable costs should be $255 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the 6-year project life. It also estimates a salvage value of $725,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $368 per ton. The engineering department estimates you will need an initial net working capital investment of $540,000. You require a return of 12 percent and face a tax rate of 23 percent on this project. Calculate the accounting, cash, and financial break-even quantities. (Do not round intermediate calculations and round your answers to the…arrow_forwardConsider a project to supply Detroit with 27,000 tons of machine screws annually for automobile production. You will need an initial $5,600,000 investment in threading equipment to get the project started; the project will last for 6 years. The accounting department estimates that annual fixed costs will be $1,350,000 and that variable costs should be $255 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the 6-year project life. It also estimates a salvage value of $725,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $368 per ton. The engineering department estimates you will need an initial net working capital investment of $540,000. You require a return of 12 percent and face a tax rate of 23 percent on this project. Calculate the accounting, cash, and financial break-even quantities. (Do not round intermediate calculations and round your answers to the…arrow_forwardSpacevoyage Inc, is considering the installation of a new experimental laboratory which requires a key equipment costing $5,000,000. It is expected that the equipment will generate important experimental material worth $2,000,000 for each of the next 5 years. In the 6th year, the equipment will need an upgrade costing $2,500,000. Required return for this project is 15%. a) Which capital budgeting method between NPV and IRR will be most suitable for arriving at a decision on whether or not to get the equipment installed? Briefly explain your reasons. b) Should the new equipment be installed? Support your answer with relevant computation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College