Question: 5 . An investment requires 1 7 , 0 0 0 today, and produces the first cash flow of 1 2 0 0 in three

5. An investment requires 17,000 today, and produces the first cash flow of 1200 in three years (year 3). Cash flow is expected to grow at 5% a year after year 3 until eternity.
a)What is the NPV of this investment if the discount rate is 8%?
NPV =
b) What is the rate of return of this investment?
Rate of return =
How to calculate this in excel would be great!

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:

In 20X4, L Concept entered into an agreement with J Trax whereby J Trax agreed to purchase common shares from L Concept. Details of the transaction are as follows: $420,000 will be paid in in order...

Q:

1 - You own a gas pipeline that requires no maintenance and will produce $ 2 million of revenue next year. Unfortunately, after the first year the volume of gas ( and thus the revenue ) is expected...

Q:

Project an initial investment o! greater than and the projects are OA T will always be preferable to H. Os will always be preferable to T. OCHand Tare equally attractive. OD The project rankings will...

Q:

Assume all cash inflows occur at the end of the period. The free advice department advocates that you draw a timeline for each of these problems to assist you in the proper set up of the cash flows....

Q:

You are considering investing $775,000 today in return for receiving the following 15 cash flows in the next 15 years (the first cash flow occurs one year from today): [Total 20 Points] - Years 1...

Q:

Dear Tutor, Could you explain how to solve the Table 4,5,7 in the second part of the document? Thank you so much! Homework 1 FINA 4522 Options and Derivatives (I) Professor Hengjie Ai Undergrad, Fall...

Q:

4 . Consider the following data - A machine costs $ 1 2 0 0 today ( year 0 ) . Assume this investment is fully tax - deductible, as stipulated by the US corporate tax code of 2 0 1 8 . - This company...

Q:

A machine costs $300 today (year 0). Assume this investment is fully tax-deductible, as stipulated by the new US corporate tax code of 2018. This company has current pre-tax profits from other...

Q:

Answers needed for #3-4, 9, 11, 13-17, 19-22, 29-32, 35-37, 40 FI 3300 - CORPORATION FINANCE Take-Home Problem Set Three (THPS-3) Fall 2015 Directions: This problem set covers chapters 6 and 7 in the...

Q:

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

Q:

1. (Points: 1) With respect to a corporation, select the statement that is correct. a. Its organization requires an approved charter which is governed by state law. b. Ownership rights to the...

Q:

Sun company, an oil-refining concern, purchased all of its outstanding 8.5 percent (stated rate) debentures as part of a restructuring plan. The balance sheet value of each outstanding debenture at...

Q:

A grand jury indicted Automated Medical Laboratories, Inc. (AML), Richmond Plasma Corporation (RPC) (a wholly owned AML subsidiary), and three former RPC managers for engaging in a conspiracy that...

Q:

A large regular dividend always denotes a company with a high level of cash that also has many new project alternatives. Question 28 options: True False

Q:

1. How has the behavior of the staff been influenced by the ethical behavior of the company? 2. What are the ethical issues in Susans behavior? Is her behavior acceptable or excusable in any way? 3....

Q:

1. Describe how the First Amendment to the United States Constitution was interpreted in the following Supreme Court cases: (a) Engel v. Vitale (1962) (b) Schenck v. United States (1919). 2. The...

Q:

Write a paper on Immigration Problems to the United States of America.

Q:

Suppose that instead of a frame, a point P = (3,5,7) T in space was translated a distance of d = (2,3,4) T . Find the new location of the point relative to the reference frame

Q:

Suppose that instead of both ends being fixed, the end of the string at x = L is free to move up and down. Then, the point at x = L is an antinode and not a node. Start with the equation for a...

Q:

Consider how you might introduce either informal or formal feedback concerning recognizing merit or improving the performance of your team. How would you plan or set up this type of assessment in...

Q:

Outline how companies can foster self-organized and peer learning. How does this approach differ from traditional learning approaches? What are the advantages and the disadvantages?

Q:

Characterize the basic features of HRM in Germany in relation to the German business system.

Q:

Discuss the impact of structural change in the business environment on the employability and skills of the workforce.