Question

1. You are an investor evaluating a project which is going to take 8 years. The...

1. You are an investor evaluating a project which is going to take 8 years. The project will pay $500,000 at the beginning of each year starting a year from now. These payments will grow at 2% for the first two years, then 3.5% for the following two years and then stay consistent at 4% until the end of the project. In the last year of the project you will receive a lump sum of $1 million while also paying a lump sum of $200,000. If your expected retrun on this project is 12.5%, what is the PV of the project?

PLEASE ANSWER IN EXCEL FORM

Homework Answers

Answer #1

The Present Value of the project is $2,964,362

The same with Excel Formulas shown:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1.   You have just received some great news from your parents… they are going to give...
1.   You have just received some great news from your parents… they are going to give your inheritance early, starting now! But, they’re going to force to you make a decision on how you want it. At the end of the day, they are going to give you a total of $500,000. But you have to pick one of the two options for disbursement: Option A: You get it in three lump sum payments as follows: •   You receive $100,000...
You are going to sublet one of the rooms in your apartment for the next year...
You are going to sublet one of the rooms in your apartment for the next year for $250 a month. Payments are due at the first of every month, starting tomorrow. If the tenant wanted to pay a lump sum today for the entire year and your discount rate is 3% per year, how much would you receive? a. How much does that amount differ if the payment is at the end of each month?
You are evaluating an investment that will pay you $5,000 in two years and $6,000 in...
You are evaluating an investment that will pay you $5,000 in two years and $6,000 in four years. If your required return is 8%p.a. compounded annually, how much is this investment worth? $9,430.73 $8,696.87 $8,085.33 $10,185.19 Which of the following is NOT a characteristic of equity? There is no maturity date. Shareholders are paid last and receive whatever is left after paying operating expenses and debt holders. Dividend payments are fixed and do not change year to year. Dividend payments...
Suppose you are going to receive $21,000 per year for 6 years. The appropriate interest rate...
Suppose you are going to receive $21,000 per year for 6 years. The appropriate interest rate is 11 percent. a. What is the present value of the payments if they are in the form of an ordinary annuity? b. What is the present value if the payments are an annuity due?
Suppose you are going to receive $13,800 per year for six years. The appropriate interest rate...
Suppose you are going to receive $13,800 per year for six years. The appropriate interest rate is 8.7 percent. What is the present value of the payments if they are in the form of an ordinary annuity? What is the present value if the payments are an annuity due? Suppose you plan to invest the payments for six years. What is the future value if the payments are an ordinary annuity? Suppose you plan to invest the payments for six...
Suppose you are going to receive $14,400 per year for six years. The appropriate interest rate...
Suppose you are going to receive $14,400 per year for six years. The appropriate interest rate is 9.5 percent. a. What is the present value of the payments if they are in the form of an ordinary annuity? b. What is the present value if the payments are an annuity due? Suppose you plan to invest the payments for six years. c. What is the future value if the payments are an ordinary annuity? d. What is the future value...
Suppose you are going to receive $23,000 per year for 9 years. The appropriate interest rate...
Suppose you are going to receive $23,000 per year for 9 years. The appropriate interest rate is 12 percent.    a. What is the present value of the payments if they are in the form of an ordinary annuity?       b. What is the present value if the payments are an annuity due?      c. Suppose you plan to invest the payments for 9 years, what is the future value if the payments are an ordinary annuity?      d. Suppose...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan to deposit each year an equal sum in the bank, which will earn 7% interest annually. Your first payment will be made at the end of the year. o How much must you deposit annually to accumulate this amount? o If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? o At...
You and your friend, Polly Horn are thinking of going on a year trip around the...
You and your friend, Polly Horn are thinking of going on a year trip around the world in exactly 3 years’ from today. Unfortunately, you will need a lot of money to ensure you can afford all the fun activities you have planned! You have determined that you will each need $30,000 to fund this trip. Polly Horn has been lucky enough to win the lottery recently and can afford to put a single lump sum into the bank account...
You take out a $25,000 30 years mortgage with monthly payments and a rate of 3.5%,...
You take out a $25,000 30 years mortgage with monthly payments and a rate of 3.5%, monthly compounded. What is your monthly mortgage payment? You take out a $25,000 30 years mortgage with monthly payments and a rate of 3.5%, monthly compounded. What is the loan balance by the end of year 15? Calculate the future value at the end of year 4 of an investment fund earning 7% annual interest and funded with the following end-of-year deposits: $1,500 in...