Question

In: Finance

1. What is the net present value (NPV) of the project? 2. Based on this NPV,...

1. What is the net present value (NPV) of the project?

2. Based on this NPV, should Hasbro undertake this project?

3. What is the internal rate of return (IRR) of this project? You can find IRR by varying the discount rate in your table until NPV is zero. That new discount rate will be the IRR.

Your grade will be based on the completeness of your cash flow table and calculations as well as your answers above.

Monopoly expansion project Hasbro is considering a new high-profile marketing project to aggressively market a card game version of Monopoly called Monopoly Deal. The Marketing department would spend an extra $1.0 million per year for the next five years to increase TV commercials and print ads featuring Monopoly Deal. The primary Monopoly factory would be expanded at a cost of $5.5 million to manufacture more of the games. Assume that the factory expansion would be completed in the first year of the project. The Marketing department estimates that the marketing campaign will increase Hasbro sales enough to bring in additional cash inflows of $2.5 million per year for the five-year period. Hasbro uses a discount rate of 15% to evaluate projects such as this one. Use a 5-year time horizon, and assume no salvage value of the factory expansion at the end of this period.

Solutions

Expert Solution

PART 1- COMPUTATION OF NPV

NOTE- We have assumed that expenditure on expansion of factory is done in year 0 and expansion is completed in year 1.

Year Cash inflow Cash outflow Net Cash Flow PVF @
15%
Present Value
a b c d=b-c e f=d*e
0 $0.00 $5,500,000.00 -$5,500,000.00 1.000 -$5,500,000.000
1 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.870 $1,304,347.826
2 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.756 $1,134,215.501
3 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.658 $986,274.349
4 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.572 $857,629.868
5 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.497 $745,765.103
NPV -$471,767.353

Thus, NPV of the Project = - $471,767.353

PART 2- DECISION

Hasbro should not undertake this project since the Present value of net benefit attained from the project will be negative. For a project to be accepted, net benefit should be positive.

PART 3- CALCULATION OF IRR

IRR is that rate of return at which Net Present value becomes zero. It is the minimum desired return by an organisation.

By substituting various rates in place of 15% while computing Present value factor, we got the IRR as 11.316416765%.

Year Cash inflow Cash outflow Net Cash Flow PVF @
11.316416765%
Present Value
a b c d=b-c e f=d*e
0 $0.00 $5,500,000.00 -$5,500,000.00 1.000 -$5,500,000.000
1 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.898 $1,347,510.137
2 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.807 $1,210,522.379
3 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.725 $1,087,460.785
4 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.651 $976,909.621
5 $2,500,000.00 $1,000,000.00 $1,500,000.00 0.585 $877,597.078
NPV $0.000

Please upvote the answer if it was of help to you.
In case of any doubt just comment below, I would love to help.


Related Solutions

1. What is the net present value (NPV) of the project? 2. Based on this NPV,...
1. What is the net present value (NPV) of the project? 2. Based on this NPV, should Hasbro undertake this project? 3. What is the internal rate of return (IRR) of this project? You can find IRR by varying the discount rate in your table until NPV is zero. That new discount rate will be the IRR. Your grade will be based on the completeness of your cash flow table and calculations as well as your answers above. Monopoly expansion...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions. Consider this case: Suppose Cold Goose Metal Works Inc. is evaluating a proposed capital budgeting project (project Alpha) that will require an initial investment of $450,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $325,000 Year 2...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions. Consider this case: Suppose Happy Dog Soap Company is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $3,000,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $300,000 Year 2 $475,000...
The NPV (net present value) of Plan Alpha is $ (130,539) The NPV (net present value)...
The NPV (net present value) of Plan Alpha is $ (130,539) The NPV (net present value) of Plan Beta is $ 233,001 The IRR (internal rate of return) of Plan Alpha is $ 19.36 %. The IRR (internal rate of return) of Plan Beta is $ 21.25 %. Which​ plan, if​ any, should the company​ pursue? Based on the results​ above, the company should pursue Plan Beta because the NPV is positive and the IRR is greater than the​ company's...
2. Net present value (NPV) The capital budgeting process is comprehensive and is based on certain...
2. Net present value (NPV) The capital budgeting process is comprehensive and is based on certain assumptions, models, and benchmarks. This process often begins with a project analysis. Generally, the first step in a capital budgeting project analysis—which occurs before any evaluation method is applied—involves estimating the project’s expected cash flows   . Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good...
Net present value (NPV)The net present value (NPV) rule is considered one of the most...
Net present value (NPV)The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions.Consider this case:Suppose Pheasant Pharmaceuticals is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $2,225,000. The project is expected to generate the following net cash flows:YearCash FlowYear 1$275,000Year 2$475,000Year 3$450,000Year 4$450,000Pheasant Pharmaceuticals’s weighted average cost of capital is 8%, and project Beta has the same risk as the...
What is the difference between discounted present value and net present value?   What is the NPV...
What is the difference between discounted present value and net present value?   What is the NPV of the following cash flows, assuming a 6% discount rate? Initial investment – year 0: $(1,000,000) Year 1 cash flows: $100,000 Year 2 cash flows: $100,000 Year 3 cash flows: $100,000 Year 4 -sale: $1,200,000
1 A. What is the net present value (NPV) of an investment of $1000 that returns...
1 A. What is the net present value (NPV) of an investment of $1000 that returns $1500 in three years, using a discount rate of 10%? B. What is the NPV of a $5000 investment that is worth $10,000 at the end of five years, if we wanted to earn 15% on the investment?Did we earn our required 15%?  How can you tell? C. What is the present value of a stock that pays a $1 dividend in perpetuity, if you...
1. Calculate the net present value (NPV) for both projects, anddetermine which project should be...
Use the following information to answer the next three questions. Consider the cash flows from two mutually exclusive projects: YearProject AProject B0-$420,000-$420,0001$140,000$400,0002$230,000$110,0003$331,000$140,000The appropriate discount rate is 8.5%.1. Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar.2. Calculate the internal rate of return (IRR) for both projects, and determine which project should be accepted based on IRR.3. Calculate the net present value (NPV) for both projects...
. Net present value (NPV) The capital budgeting process is comprehensive and is based on certain...
. Net present value (NPV) The capital budgeting process is comprehensive and is based on certain assumptions, models, and benchmarks. This process often begins with a project analysis. Generally, the first step in a capital budgeting project analysis—which occurs before any evaluation method is applied—involves estimating the .............. A.project's expected cash flow, B. company's net income , C. revenues from all new projects . Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT