Purchase Solution

Basic NPV

Not what you're looking for?

Ask Custom Question

HW4 Finance type your name here

This sheet is to train you with financial calculations in Excel. Save your document as "Lastname-HW4".

You became an assistant manager at Strategic Finance Dept. of a Theme park.
A new water-ride is proposed by the Sales & Marketing department, which presented the following data.
Initial investment: $40 million.
First year Net Income: 5 million. But 3% of Net Income has to be set aside as Capital Maintenance Fund
Annual increase of the Revenue: 10% for the first 5 years, then 5% for the rest
For the sake of calculation, a new project is considered to be "sold" at the end of 10th year at 80% of the initial investment value.
Corporate wide Hurdle rate (=required rate of return) for a new capital investment project is 15%.

Q1: Analyze whether the new "Harraah" Water Ride Attraction should be invested by calculating the NPV and IRR

Investment Analysis of the Proposed Harraah Water Ride Attraction

Year Net CF = NI - Reserve Key parameters
0 0 Initial investment
1 First year NI (before reserve)
2 Reserve % of NI
3 Growth rate 2-5
4 Growth rate 6-10
5 Residual value of project at yr 10.
6
7
8
9
10
Key parameters
NPV Corporate Hurdle rate
IRR

Based on the above calculation, we should invest or not invest?
type short answer here

Q2: Director of Sales & Marketing proposes an additional strategic idea for the "Harraah" Water Ride project.
She says that if her department can have $3 million budget for national marketing campaign for this project,
she has enough reason to believe that the first year's NI (before reserve) would start from $6 million,
resulting $1 million increase of Net Income in year 1, and maintain the same growth rate as simulated above.

As an assistant manager of Strategic Finance Department, would you endorse her idea or not?
Show your calculations.
(Hint: Add marketing costs as additional initial investment. So it becomes $43 million.
Then start the First Year NI as $6M instead of $5M. All the other parameters and assumptions stay the same)

Investment Analysis of the Proposed Harraah Water Ride Attraction with Marketing Blitz

Year Net CF = NI - Reserve Key parameters
0 Initial investment
1 First year NI (before reserve)
2 Reserve % of NI
3 Growth rate 2-5
4 Growth rate 6-10
5 Residual value of project at yr 10.
6
7
8
9
10
Key parameters
NPV Corporate Hurdle rate
IRR

Based on the above calculation, will you endorse the Sales & Marketing Director's revised idea?
type short answer here

Attachments
Purchase this Solution

Solution Summary

Basic NPV issues are solved.

Purchase this Solution


Free BrainMass Quizzes
Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.