Question

In: Finance

A real estate investment has the following expected cash flows: Year 0 Year 1 Year 2...

A real estate investment has the following expected cash flows:

Year 0

Year 1

Year 2

Year 3

Year 4

Cashflow

10,000

25,000

50,000

35,000


The discount rate is 9%. What is the investment’s value 4 years from now?

Select one:

a. $ 132,152

b. $103,700

c. $ 113,345

d. $120,000

e. $130,757

Solutions

Expert Solution

Given information in question is Cash flows from real estate investment from year 1 to year 4.
Assuming Investment is made in Year 0.
Our objective is to calculate the value of the investment at the end of the 4th Year.

Cash flows are as follows

Year Year 0 Year 1 Year 2 Year 3 Year 4
Cash Flow 10000 25000 50000 35000

Given Discount Rate ( r ) 9%.

First, we are going to calculate discounted cash flows for each year.

This will give us the value of the investment in Year 0. Then we will use the compound interest formula to calculate the value of the investment in 4 years.

The formula used for calculation of discounted cash flows is the Present Value (PV) formula
PV = Cash Flow / (1+r)^n
Where r is the discount rate and "n" is the period ( in this question that is in years )

Compound interest formula
A= P*(1+r )^n where A is the Final amount, P is the initial principal amount, r is the rate of interest, and n is the number of periods.
Note:- Always keep in mind if the period is in years then "r" should also be annual rate.

So Using PV formula

PV of Year 1= 10000 / (1+9%)^1 = 9174

PV of Year 2= 25000 / (1+9%)^1 = 21042

PV of Year 3= 50000 / (1+9%)^1 = 38609

PV of Year 4= 35000 / (1+9%)^1 = 24795

So total PV = 93620 ( Sum of above 4 values )

Present value means value of investment in year 0.

Now we have to calculate the value of investment after 4 years using compund interest formula. ( rate of compounding remains same as discount rate
P= 93620, r = 9%, n = 4

Investment Value after 4 yeas r= 93620*(1+9%)^4 = 132152.

So the answer is $132152.

Value of investment will be $132152 after 4 years with given cash flows.

So the Option "a" is correct.


Related Solutions

A real estate investment has the following expected cash flows: Year Cash Flows 1 $7,000 2...
A real estate investment has the following expected cash flows: Year Cash Flows 1 $7,000 2 17,000 3 22,000 4 22,000 The discount rate is 11 percent. What is the investment’s present value? Round it to two decimal places, i.e., 1234.45.
A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2...
A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2 7,630 3 5,040 4 −1,580 Assuming the appropriate interest rate is 10 percent, what is the MIRR for this project using the discounting approach? 19.21% 15.23% 13.96% 11.63% 17.77%
A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2...
A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2 7,360 3 4,800 4 −1,640 Assuming the appropriate interest rate is 7 percent, what is the MIRR for this project using the discounting approach?
A project has the following cash flows: Year Cash Flows 0 −$127,800 1 47,000 2 63,800...
A project has the following cash flows: Year Cash Flows 0 −$127,800 1 47,000 2 63,800 3 51,600 4 28,100 The required return is 8.3 percent. What is the profitability index for this project?
A hospital’s project has the following expected cash flows Year Cash flow 0 ($5,000) 1 $1,000...
A hospital’s project has the following expected cash flows Year Cash flow 0 ($5,000) 1 $1,000 2 $2,000 3 $3,000 If the cost of capital is 12%, should the project be undertaken? Show your calculations
1) A project has the following cash flows: Year 0 -$22,500, Year 1 $12,650, Year 2...
1) A project has the following cash flows: Year 0 -$22,500, Year 1 $12,650, Year 2 $10,900, and Year 3 $6,500. What is the IRR of the project? Please round your answer to two decimal places. 2) Following question 1, suppose the cost of capital is 15%. Would you accept or reject the project according to the IRR criterion? Accept or Reject 3) Following questions 1 and 2, which of the following statements about the IRR rule is false? -...
The cash flows below contain the cash flows from a completed real estate investment analysis. Based...
The cash flows below contain the cash flows from a completed real estate investment analysis. Based on the information in the cash flows what is the internal rate of return of the before-tax unlevered cash flows? Purchase Price $4,569,231 Loan Amount $3,198,462 Year 1 2 3 4 5 Leasable Space 30,000 30,000 30,000 30,000 30,000 Average Rent $20 $21.00 $22.05 $23.15 $24.31 Potential Gross Income $600,000 $630,000 $661,500 $694,575 $729,304 Vacancy and Collection Losses 10% 10% 10% 10% 10% ($60,000)...
Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3...
Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3 5,000 4 6,000 5 7,000 a. What is the return expected on this investment measured in dollar terms if the opportunity cost is 6%. b. What is the return on this investment measured in percentage terms? c. Is the investment profitable? Explain your answer.
A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2...
A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2 8,100 3 6,600 What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) NPV $ What is the NPV at a discount rate of 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ What is the NPV...
A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2...
A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2 –27,600 What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Internal rate of return             % What is the NPV of this project if the required return is 5 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT