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...
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 Celestial Crane Cosmetics 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: Year Cash Flow Year 1 $300,000 Year 2 $400,000 Year...
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...
What is the net present value (NPV) of a project that has an initial cash outflow...
What is the net present value (NPV) of a project that has an initial cash outflow of $19,851, at time 0, and the following cash inflows? The required return is 13.0%.  DO NOT USE DOLLAR SIGNS OR COMMAS IN YOUR ANSWER. ROUND ANSWER TO THE NEAREST DOLLAR. Year Cash Flow 1 $5,423 2 $7,483 3 $7,107 4 $6,010
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...
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT