Question

In: Accounting

Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment...

Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Assignment Steps Resources: Corporate Finance Calculate the following time value of money problems in Microsoft Excel or Word document. You must show all of your calculations. If you want to accumulate $500,000 in 20 years, how much do you need to deposit today that pays an interest rate of 15%? What is the future value if you plan to invest $200,000 for 5 years and the interest rate is 5%? What is the interest rate for an initial investment of $100,000 to grow to $300,000 in 10 years? If your company purchases an annuity that will pay $50,000/year for 10 years at a 11% discount rate, what is the value of the annuity on the purchase date if the first annuity payment is made on the date of purchase? What is the rate of return required to accumulate $400,000 if you invest $10,000 per year for 20 years. Assume all payments are made at the end of the period. Calculate the project cash flow generated for Project A and Project B using the NPV method. Which project would you select, and why? Which project would you select under the payback method? The discount rate is 10% for both projects. Use Microsoft® Excel® to prepare your answer. Note that a similar problem is in the textbook in Section 5.1. Sample Template for Project A and Project B: Show all work. Submit the all calcluations. Click the Assignment Files tab to submit your assignment.

Solutions

Expert Solution

1. FV = $500,000, n = 20, r = 15%

Let PV = x. Thus FV = PV*(1+r)^n

Or 500,000 = x*(1.15)^20

Or x = 500,000/1.15^20

= $30,550.14

2. This is the case of an annuity in which $200,000 is invested each year. n = 5 years and r = 5%. We can use the FVIFA (future value interest factor of annuity here). FVIFA (5 years, 5%) = 5.5256

Thus future value = 200,000*5.5256 = $1,105,120

(It has been assumed that amounts are deposited at the end of each year)

3. Let the interest rate be “r”

Thus 300,000 = 100,000*(1+r)^10

Or 3 = (1+r)^10

Or r = 11.61%

4. Here annuity starts at the beginning of the year.

Year Amount 1+r PVIFA Present value
1 50,000.00 1.11 2.8394 50,000.00
2 50,000.00 2.5580 45,045.05
3 50,000.00 2.3045 40,581.12
4 50,000.00 2.0762 36,559.57
5 50,000.00 1.8704 32,936.55
6 50,000.00 1.6851 29,672.57
7 50,000.00 1.5181 26,732.04
8 50,000.00 1.3676 24,082.92
9 50,000.00 1.2321 21,696.32
10 50,000.00 1.1100 19,546.24
Total 326,852.38

5. Here annuity = 10,000, n = 20 and FV = 400,000. As payments are made at the end of each year it is an ordinary annuity

Thus 400,000 = 10,000* FVIFA of an ordinary annuity for 20 years and r%

or 40 = FVIFA of an ordinary annuity for 20 years and r%

or 40 = 1/[(1+r)^20 - 1/r]

Thus r = 6.774%

6. This cannot be answered as the financial data and cash flow data for projects A and B is not provided.


Related Solutions

. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial...
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s payback period? f. What is...
SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback...
SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s...
Calculations of the NPV, IRR and the payback for the project and an analysis of the...
Calculations of the NPV, IRR and the payback for the project and an analysis of the results. I need the excel formula calculation and analysis of the questions You have identified a potential opportunity for WBC, which involves undertaking a project that will have a ten-year life. The project requires an initial purchase of equipment and furniture totalling $4,500,000, plus ancillary programming capability and machinery costing $1,500,000. The equipment and furniture will depreciate and have a salvage value of $500,000...
Using the Payback Method, IRR, and NPVTop of FormBottom of FormAssignment ContentTop...
Using the Payback Method, IRR, and NPVTop of FormBottom of FormAssignment ContentTop of FormResourceCorporate FinancePurpose of AssignmentThe purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods.Assignment StepsCreate a 350-word memo to management including the following:Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows.Describe the break-even point and...
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%
What is the payback period, NPV, IRR of A. Using this information, should we accept Project...
What is the payback period, NPV, IRR of A. Using this information, should we accept Project A. Why or why not. Given the following information answer the question above. The discount rate is 10 percent.      PROJECT A       t           Cash Flow       0          (150,000)        1          40,000           2          40,000              3          40,000          4           40,000           5            40,000               ROUND TO NEAREST DOLLAR OR TEN %
Using the Payback Method and NPV The Scenario:You work in the product development department of an...
Using the Payback Method and NPV The Scenario:You work in the product development department of an athletic apparel company.  Your company has decided to add a new product and is choosing between a polo tee, yoga pants, or running shoes. You have been asked to evaluate the financial profitability of each option.  You have estimated that the company has $2,000,000 to invest in the project, and each product has the potential to bring in an estimated $3,000,000 of future cash flows, although...
You evaluate ALL of its projects by applying the Payback, Discounted Payback, NPV, and IRR rules....
You evaluate ALL of its projects by applying the Payback, Discounted Payback, NPV, and IRR rules. Assume the cost of capital is 10%. Assume cash flows of: TIME               CASH FLOWS -------------------------------------------------------------- 0               -$100 1               +$75 2               +$50 3               +$25 What is the payback?                                What is the Discounted Payback?                                What...
While NPV and IRR are measures of return of a project/investment. Payback is a measure of...
While NPV and IRR are measures of return of a project/investment. Payback is a measure of risk. Explain what payback tells about a project/investment and how is it calculated.
How does the NPV, IRR and the payback period of an Investment usually react to the...
How does the NPV, IRR and the payback period of an Investment usually react to the following developments (please indicate, UP/DOWN or N/A)? 1. Increasing Investment amount 2. Increasing tax rate 3. Increased annual depreciation due to change of depreciation method 4. Increasing cost of capital 5. Increasing residual value So I actually Need 15 indications (5*3) - TIA
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT