Question

In: Finance

A construction project has the following data: initial disbursement $ 400,000. The required rate of return...

A construction project has the following data: initial disbursement $ 400,000. The required rate of return is 9% per year.          Net cash income for the following years:

   1st. year $ 87,000 =

2nd. years $ 106,500 =

3rd. years $ 192,000 =

4th. years $ 184,800 =

5th. years $ 184,800 =

Net Present Value _____________

Determine the payback present value _______

Solutions

Expert Solution

Year Cash Flow Present Value Factor at 9% Present Value of Cash flow Cumulative Present Value of cash flow
0         (400,000)                                                1.00                                 (400,000.00)        (400,000.00)
1              87,000                                  0.91743119                                      79,816.51        (320,183.49)
2           106,500                                  0.84167999                                      89,638.92        (230,544.57)
3           192,000                                  0.77218348                                   148,259.23           (82,285.34)
4           184,800                                  0.70842521                                   130,916.98             48,631.64
5           184,800                                  0.64993139                                   120,107.32           168,738.96
Total Or NPV                                   168,738.96

PBPV is Payback present value .

Therefore,

Excel formula:

Present value factor formula, if not using excel:

Where,
i = rate of return
n = number of years


Related Solutions

WITH PROCESS: A construction project has the following data: initial disbursement $ 40,000. The required rate...
WITH PROCESS: A construction project has the following data: initial disbursement $ 40,000. The required rate of return is 9% per year. Net cash income for the following years: 1st. Year $ 8,000 = 2nd. Year $ 10,500 = 3rd. Year $ 19,000 = 4th. Year $ 18,800 = 5th. Year $ 18,800 = Net Present Value _____________ Determine the payback present value _______ PREPA is offering a $ 45 Bonus, payable semi-annually, for the next 20 years. The prevailing...
If a company has a required rate of return of 15%, should the following project be...
If a company has a required rate of return of 15%, should the following project be accepted based on these expected cash flows below? Year 0 1 2 3 4 5 6 Cash Flow (274,000) 68,000 73,000 76,500 78,000 82,500 77,000 Please explain why or why not the company should move forward with this endeavor. Answer:
Assume you have the following information on Project X: Initial Investment -$1,000 Required rate of return...
Assume you have the following information on Project X: Initial Investment -$1,000 Required rate of return = 10% Year Cash Flow Present Value of CF Accum. Discount CF 0 -1000 -1000 -1000 1 200 182 182 2 400 331 513 3 700 526 1039 4 300 205 1244 What is the discount payback period?
An investment requires an initial disbursement of € 2,500,000 and the duration of the project is...
An investment requires an initial disbursement of € 2,500,000 and the duration of the project is 3 years, in the first of which it generates a cash flow of € 1,500,000, in the second € 3,700,000 and the third € 4,100,000. Calculate the Net Present Value of the investment, knowing that inflation is 3% cumulative annually and that the required profitability in the absence of inflation is 8%. Calculate the actual internal rate of return of the previous investment.
Following table shows the initial investment required in and cash flow (return) from a project
Following table shows the initial investment required in and cash flow (return) from a project: The expected payback period from the project is 2 years and the discount rate is 14%. Based on the Discounted Payback Period, will you accept the project?
BETA AND REQUIRED RATE OF RETURN a. A stock has a required return of 9%; the...
BETA AND REQUIRED RATE OF RETURN a. A stock has a required return of 9%; the risk-free rate is 5%; and the market risk premium is 3%. What is the stock's beta? Round your answer to two decimal places. b. If the market risk premium increased to 10%, what would happen to the stock's required rate of return? Assume that the risk-free rate and the beta remain unchanged. If the stock's beta is equal to 1.0, then the change in...
Determine the internal rate of return on the following​ project: An initial outlay of 9000 resulting...
Determine the internal rate of return on the following​ project: An initial outlay of 9000 resulting in a cash inflow of 1800 at the end of year​ 1, 4800 at the end of year 2, and 7800 at the end of year 3
Calculate the rate of return for an investment with the following characteristics. Initial cost $20,000 Project...
Calculate the rate of return for an investment with the following characteristics. Initial cost $20,000 Project life 10 years Annual receipts $6000 Annual disbursements $3000
The point where a project produces a rate of return equal to the required rate of...
The point where a project produces a rate of return equal to the required rate of return is known as the 117 In financial breakeven, the EAC is used to (choose all that apply) A. external breakeven point. B. accounting profit breakeven point. C. internal breakeven point. D. financial breakeven point. E. contribution margin breakeven point. F. allocate depreciation over the life of a project. G. determine the tax benefit of depreciation. H. allocate the initial investment over the life...
Beta and required rate of return A stock has a required return of 12%; the risk-free...
Beta and required rate of return A stock has a required return of 12%; the risk-free rate is 2.5%; and the market risk premium is 3%. What is the stock's beta? Round your answer to two decimal places. B. If the market risk premium increased to 9%, what would happen to the stock's required rate of return? Assume that the risk-free rate and the beta remain unchanged. 1. If the stock's beta is equal to 1.0, then the change in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT