Question: Using the NPV function of Excel, calculate the present value of the following cash flows: Year Cash flow 1 10,000 2 12,000 3 15,000 4

Using the NPV function of Excel, calculate the present value of the following cash flows:

Year Cash flow
1 10,000
2 12,000
3 15,000
4 20,000

Discount rate is 8% p.a.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Question 6 Your grandparents would like to establish a trust fund that would pay annual payments to you and your heirs of $100,000 a year forever. How much do your parents need to deposit into this...

Q:

HI, I need help with this 4 Accounting questions. Thank you 1. You are looking at a 1-year loan of $1,002. If the quoted interest is 9% plus 1 points, what rate would you actually paying for this...

Q:

(a) Using annuity tables and calculate the present value of the following cash flows: i. P2,000 per year will be received for 3 years at a rate of discount of 7%. (2 marks) ii. P6,000 received for...

Q:

5) Which of the following statements is FALSE? Select one: A. Once a capital project is approved, the role of a financial manager is still essential B. Capital projects are a long term investment C....

Q:

Question 2 This is a formatting practice question to ensure the computer will recognize your answers as correct: What is the answer for a number formatted as #,##0.0000 ? Select one: a. $1,234.50 b....

Q:

Question 7 This is a formatting practice questions to ensure the computer will recognize your answers as correct: What is the answer for a number formatted as 0/0 ? Select one: a. 1 / 2 b. 0.5000 c....

Q:

2. The next dividend payment by Halestorm, Inc., will be $2.00 per share. The dividends are anticipated to maintain a growth rate of 6 percent forever. If the stock currently sells for $40 per share,...

Q:

Problem 10-6 Calculating Depreciation [LO1] 10 A piece of newly purchased industrial equipment costs $970,000 and is classified as points seven-year property under MACRS. The MACRS depreciation...

Q:

P11-4 You are evaluating a project for The Farpour golf dlub, guaranteed to correct For Projec D: rBE(-r that nasty slice. You estimate the sales price of The Tiff-any to be $400 per unit and sales...

Q:

Using the tables in Exhibits 26-3 and 26-4, determine the present value of the following cash flows, discounted at an annual rate of 15 percent. (Round "PV factors" to 3 decimal places. Do not round...

Q:

What drives expense recognition? When should expenses be recognized?

Q:

Four mutually exclusive projects are being considered for a new 2-mile jogging track. The life of the track is expected to be 75 years, and the sponsoring agency's MARR is 9% per year. Annual...

Q:

Kelley argues that creative confidence can be developed through small steps and practice. Based on his examples, what specific step could you realistically apply in your own academic or personal work...

Q:

1. Glucose will react with oxygen in a laboratory setting using a combustion chamber. The reaction is exergonic, with the release of a large amount of energy in the form of heat and the production of...

Q:

Your client is a startup medical device manufacturer. It intends to raise $20M - $30M in order to design, test, obtain FDA approval and bring to market 2-3 medical devices in different areas/uses,...

Q:

Your client is a startup medical device manufacturer. It intends to raise $20M - $30M in order to design, test, obtain FDA approval and bring to market 2-3 medical devices in different areas/uses,...

Q:

Your client is a startup medical device manufacturer. It intends to raise $20M - $30M in order to design, test, obtain FDA approval and bring to market 2-3 medical devices in different areas/uses,...

Q:

Tracey and Whitney are skilled doctors and engineers. They each own a patent with a value of $1M and a tax basis of $0. Joe is a wealthy investor and he would like to invest $2M cash in startup...

Q:

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Q:

What is meant by the term capital expenditures?

Q:

The Oakville Medical Center operates a general hospital but rents space and beds to separate entities for specialized areas such as pediatrics, maternity, and psychiatry. The medical center charges...

Q:

Computing the rate of return on initial investment. The Harley Corporation uses the straight-line method for computing depreciation. What is the anticipated rate of return on the initial investment...