a)
To find: The
Introduction:
The price that a buyer is ready to pay for a security is the bid price.
a)
Answer to Problem 34QP
The net present value is $861,836.07.
Explanation of Solution
Given information:
The R enterprise requires someone to supply the 140,000 cartons of screw machines for the year for the purpose of supporting it with the operations that are needed for the next five years. Person X has decided to make a bid on the contract. It will cost Person X $940,000 to install the necessary equipment for beginning the production. Person X depreciates on a straight-line to zero over the life of the project.
The cost of fixed production of Person X is $435,000 for a year, and the variable production cost must be $15.10 for a carton. The essential investment that is required by Person X in the net working capital is $90,000. The tax rate is assumed to be 35% and the
Note: To calculate the bid price it is essential to set the net present value equal to zero and the essential price is found using the operating cash flow. Thus, the bid price is representing the project’s financial break-even level.
Computation of the net present value:
Year | 1 | 2 | 3 | 4 | 5 |
Sales | 3,220,000 | 3,220,000 | 3,220,000 | 3,220,000 | 3,220,000 |
Less: Variable costs | -2,114,000 | -2,114,000 | -2,114,000 | -2,114,000 | -2,114,000 |
Fixed costs | -435,000 | -435,000 | -435,000 | -435,000 | -435,000 |
-188,000 | -188,000 | -188,000 | -188,000 | -188,000 | |
EBIT | 483,000 | 483,000 | 483,000 | 483,000 | 483,000 |
Less: Taxes (35%) | -169,050 | -169,050 | -169,050 | -169,050 | -169,050 |
Net Income | 313,950 | 313,950 | 313,950 | 313,950 | 313,950 |
Add: Depreciation | 188,000 | 188,000 | 188,000 | 188,000 | 188,000 |
Operating cash flow | $501,950 | $501,950 | $501,950 | $501,950 | $501,950 |
Year | 1 | 2 | 3 | 4 | 5 |
Operating cash flow | $501,950 | $501,950 | $501,950 | $501,950 | $501,950 |
Change in NWC | 0 | 0 | 0 | 0 | 90,000 |
Capital spending | 0 | 0 | 0 | 0 | 55,250 |
Total CF | $501,950 | $501,950 | $501,950 | $501,950 | $647,200 |
Computations for the above table:
Formula to calculate the sales:
Computation of the sales:
Formula to calculate the
Computation of the cash outflow:
Formula to calculate the net present value:
Computation of the net present value:
Hence, the net present value is $861,836.07.
Explanation:
The net present value of the project is positive. If the real price is above the bid price then it shows the results in zero net present value, as for the cartons sold, if the numbers of cartons sold increase, then the net present value will increase, and if the costs increase, the net present value will decline.
b)
To find: The cartons quantity that can be still supplied and still break even.
Introduction:
The price that a buyer is ready to pay for a security is the bid price.
b)
Answer to Problem 34QP
The quantity of the cartons is 93,440.69.
Explanation of Solution
Given information:
The price per quantity is $23.
Computation of the operating cash flow using the formula of the net present value:
Hence, the operating cash flow is $262,867.98.
Formula to calculate the tax shield approach:
Computation of the quantity using the formula of the operating cash flow:
Hence, the quantity of the carton is 93,440.69.
c)
To find: The highest level of the fixed cost that can be afforded and still breaks even.
Introduction:
The price that a buyer is ready to pay for a security is the bid price.
c)
Answer to Problem 34QP
The highest fixed cost is $802,818.49.
Explanation of Solution
Given information:
The price per quantity is $23, and the number of cartons is 140,000. The fixed price must be more than $435,000.
Computation of the operating cash flow using the formula of the net present value:
Hence, the operating cash flow is $262,867.98.
Formula to calculate the tax shield approach:
Computation of the fixed cost using the tax shield approach:
Hence, the highest level of fixed cost is $802,818.49.
Want to see more full solutions like this?
Chapter 10 Solutions
FUND. OF CORPORATE FIN 2 YEARS CONNECT
- use excel/show all excel formulas answering the following LO3 20. Sensitivity Analysis We are evaluating a project that costs $1.68 million, has a six-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 90,000 units per year. Price per unit is $37.95, variable cost per unit is $23.20, and fixed costs are $815,000 per year. The tax rate is 21 percent, and we require a return of 11 percent on this project. a. Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the sales figure? Explain what your answer tells you about a 500-unit decrease in projected sales. b. What is the sensitivity of OCF to changes in the variable cost figure? Explain what your answer tells you about a $1 decrease in estimated variable costs. LO3 21. Scenario Analysis In the previous problem, suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to…arrow_forward36 The relationship between the payback method and the internal rate of return is that: Group of answer choices The discounted payback period is exactly the same as the IRR. The payback period is the present value factor for the IRR. A payback period of less than one-half of the life of a project will yield an IRR lower than the target rate. A project whose payback period does not meet the company’s cut-off rate for payback will not meet the company’s criterion for IRR.arrow_forwardQ15. Which of the following is NOT potentially problematic for Internal Rate of Return (IRR)? Group of answer choices 1. IRR cannot cope with multiple future cash flows 2. It is assumed that intermediate cash flow can be reinvested at the same rate as the project IRR 3. IRR may produce nonsense answers when there is unconventional cash flow with more than one change of sign'. 4. When comparing 2 projects with very different sensitivity to the assumed discount rate, IRR may conflict with Net Present Valuearrow_forward
- 1. Basic NPV methods tell us that the value of a project today is NPV0. Time value of money issues also lead us to believe that if we choose not to do the project that it will be worth NPV1 one period from now, such that NPV0 > NPV1. Why then do we see some firms choosing to defer taking on a project. Be complete and thorough in your answer. 2. Briefly describe the agency relationship that exists between the shareholders and the managers of the firm and how it can result in what is referred to as the agency conflict?arrow_forwardBasic NPV methods tell us that the value of a project today is NPV0. Time value of money issues also lead us to believe that if we choose not to do the project that it will be worth NPV1 one period from now, such that NPV0 > NPV1. Why then do we see some firms choosing to defer taking on a project?arrow_forwardQ.3 (x1=70000 x2=10%) The IPS company has installed a system to help reduce the number of defective products. The capital investment in the system is $X1, and the projected annual savings are tabled below. The system's market value at the EOY five is negligible, and the MARR is x2% per year A. What is the FW of this investment? Based on econonical deciston rule, is this a good investment. b. What is the IRR of the system? Based on economical decision rule, is this a good investmentr. C. What is the discounted pavback period for this investment.arrow_forward
- Mf2. Your firm is considering choosing either Project X or Project Y with the following cash flows: Year: 0. 1 2 3 4 Project X -$150,000 $75,000. $65,000 55,000 $45,000 Project Y -$180,000 $90,000. $70,000 $70,000 $50,000 Between a discount rate of ______ and ______ you can be sure your firm should prefer Project Y to Project X. a. 0%; 14.16% b. 0%; 10.25% c.14.16%; 24.26% d10.25; 22.63% e. 0%; 25%arrow_forwardH5. Discuss the following statement: If a firm has only independent projects, a constant WACC, and projects with normal cash flows, the NPV and IRR methods will always lead to identical capital budgeting decisions. What does this imply about the choice between IRR and NPV? If each of the assumptions were changed (one by one), how would your answer change? Explain with detailsarrow_forwardP12–28 CAPITAL RATIONING: NPV APPROACH A firm with a 13% cost of capital must select the optimal group of projects from those shown in the following table, given its capital budget of $1 million. Calculate the present value of cash inflows associated with each project. Select the optimal group of projects, keeping in mind that unused funds are costly.arrow_forward
- 9. Interest rates and decisions Suppose that a firm is facing an upward-sloping yield curve and needs to borrow money to invest in production. Does this mean that the firm should consider borrowing only at short-term rates? No, the firm needs to take the volatility of short-term rates into account. Yes, using short-term financing will give the firm the lowest possible interest rate over the life of the project. No, an upward-sloping yield curve means that the firm will get a lower interest rate if it uses long-term financing. Credit ratings affect the yields on bonds. Based on the scenario described in the following table, determine whether yields will increase or decrease and whether it will be more expensive or less expensive, as compared to other players in the market, for a company to borrow money from the bond market. Scenario Impact on Yield Cost of Borrowing Money from Bond Markets ABC Real Estate is a commercial real estate firm…arrow_forwardshow all excel formulas/ work answering the following: LO2 27. Project Analysis You are considering a new product launch. The project will cost $780,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 170 units per year, price per unit will be $16,300, variable cost per unit will be $11,100, and fixed costs will be $535,000 per year. The required return on the project is 11 percent, and the relevant tax rate is 21 percent. a. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate within +10 percent. What are the best and worst cases for these projections? What is the base-case NPV? What are the best- case and worst-case scenarios? b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs.arrow_forwardBasic NPV methods tell us that the value of a project today is NPV0. Time value of money issues also lead us to believe that if we choose not to do the project that it will be worth NPV1 one period from now, such that NPV0 > NPV1. Why then do we see some firms choosing to defer taking on a project. Be complete and thorough in your answer.arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education