Question
M.V.P. Games, Inc., has hired you to perform a feasibility study of a new video game that requires an initial investment of $7.2 million. M.V.P.
M.V.P. Games, Inc., has hired you to perform a feasibility study of a new video game that requires an initial investment of $7.2 million. M.V.P. expects a total annual operating cash flow of $1.32 million for the next 9 years. The relevant discount rate is 9 percent. Cash flows occur at year-end.
a.What is the NPV of the new video game?(Enter your answer in dollars, not millions of dollars (e,g., 1,234,567). Do not round intermediate calculations. Round your final answer to 2 decimal places (e.g., 32.16).)
NPV$
b.After one year,the estimate of remaining annual cash flows will either be revised upward to $2.22 million or revised downward to $287,000. Each revision has an equal probability of occurring. At that time, the video game project can be sold for $2.62 million, after taxes. What is the revised NPV given that the firm can abandon the project after one year?(Enter your answer in dollars, not millions of dollars (e.g., 1,234,567). Do not round intermediate calculations. Round your final answer to 2 decimal places (e.g., 32.16).)
NPV$
I have solved part A correctly but, am stuck on part B. Please use Excel and Excel formulas to solve so that I can find where I'm making my mistake(s).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started