Question

In: Finance

The YayForSemesterBreak Company wants to calculate the NPV and IRR on the following project: Cost is...

The YayForSemesterBreak Company wants to calculate the NPV and IRR on the following project: Cost is $17,800 today, with end-of-year cash flows of $8,000, $8,000, and $7,000, Years 1 through 3 respectively for three years. Assume the cost of capital is 8%. SHOW ALL WORK on the TI BAII Plus Calculator FOR FULL CREDIT. a) NPV? b) IRR? c) Do you accept or reject the project, and why?

Solutions

Expert Solution

NPV = PV of cash Inflows - PV of Cash Outflows

Year CF PVF @8% Disc CF
0 $ -17,800.00     1.0000 $ -17,800.00
1 $    8,000.00     0.9259 $      7,407.41
2 $    8,000.00     0.8573 $      6,858.71
3 $    7,000.00     0.7938 $      5,556.83
NPV $      2,022.94

IRR is the Rate at which PV of Cash Inflows are equal to PV of Cash Outflows

Year CF PVF @14% Disc CF PVF @15% Disc CF
0 $ -17,800.00     1.0000 $ -17,800.00     1.0000 $ -17,800.00
1 $    8,000.00     0.8772 $      7,017.54     0.8696 $    6,956.52
2 $    8,000.00     0.7695 $      6,155.74     0.7561 $    6,049.15
3 $    7,000.00     0.6750 $      4,724.80     0.6575 $    4,602.61
NPV $            98.08 $      -191.72

IRR = Rate at which least +ve NPV + [ NPV at that Year / Change in NPV due to 1% inc in Disc Rate ] * 1%

= 14% + [ 98.08 / 289.80 ] * 1%

= 14% + 0.34%

= 14.34%

Part C:

As it has +ve NPV & IRR > COst of Capital, Project can be accepted.


Related Solutions

Calculate the NPV for the following project. The company wants to determine whether it should expand...
Calculate the NPV for the following project. The company wants to determine whether it should expand and purchase a new piece of equipment (20% CCA Rate). The equipment will cost $100,000, have a useful life of 20 years, and have a projected salvage value of $5,000. By purchasing the equipment, the company can increase its net revenues by $7,500 per year. Using a discount rate of 10% and a tax rate of 30%, should the company purchase the equipment?
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%
If your firm were to consider investing in the following project, calculate the NPV, IRR, and...
If your firm were to consider investing in the following project, calculate the NPV, IRR, and Payback values. Would this be a good investment for your company? PROJECT CASH FLOWS AND VALUES FOR A PROPOSED NEW PRODUCTION FACILITY: In year 0, invest $1,000,000 for a new production facility. The project will also require an investment of $50,000 into Net Working Capital. (Assume regular conditions of liquidation at project end.) The project is forecasted to last 4 years. Facility investment is...
NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially) & IRR of...
NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially) & IRR of these projects. When would you choose one over the other (i.e. what is the crossover rate)? Draw the NPV profile using 11 intervals of interest rates ranging from (and including) 0% to 100%. Place all data, ratios, calculations, findings, etc. in the first Excel sheet with references to the information in other sheets. Time A CF B CF 0 -10000 -10000 1 12000 9000...
1. a. Calculate the IRR for the following project if its cost was $5,000 and the...
1. a. Calculate the IRR for the following project if its cost was $5,000 and the annual expenditures and costs were: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 2,000 2,000 2,000 2,000 -1,000 -1,000 b. Assume a firm's WACC is 10 percent. Calculate the NPV for the following project if its cost was $5,000 and the annual expenditures and costs were: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 2,000 2,000...
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For...
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years.          Project A= Required rate of Return= 16.30% Project B= R= 12.50% Project C= R= 15.35% Project D= R= 17.25%      Expected cash flows for the four...
Calculate the NPV at 9% and the IRR for the following projects: An initial outlay of...
Calculate the NPV at 9% and the IRR for the following projects: An initial outlay of $69,724 and an inflow of 15,000 followed by four consecutive inflows of $17,000
1. Compute the NPV of a project with the following information. The IRR is 9%. The...
1. Compute the NPV of a project with the following information. The IRR is 9%. The project life is 3 years. The initial cost is $19,000. In years 1 and 2 the cash inflows are $4,500 and $5,500, respectively. Cash flow in year 3 is missing. WACC is 12%.
For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each...
For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years. Risk free rate = 1.10%, MRP = 9.5%, Required return = 14.40% Yes excel is fine Expected cash flows for the four potential projects that Avalon is...
If the IRR for a project is 20%, then the project's NPV would be:
If the IRR for a project is 20%, then the project's NPV would be:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT