Question

In: Finance

Using the Payback Method, IRR, and NPVTop of FormBottom of FormAssignment ContentTop...

Using the Payback Method, IRR, and NPV

Top of Form

Bottom of Form

Assignment Content

Top of Form

Resource

Corporate Finance

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

Create 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 its importance.
Describe the advantages and disadvantages of each method.

Calculate the following time value of money problems:

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.

“Table showing investments and returns for Project A and Project B. Project A has $10,000 initial investment with $5,000 returns in each of the first 3 years. Project B has $55,000 initial investment with $20,000 in each of the first 3 years.”

Show all work.

Submit the memo and all calculations.

Expert Solution

jeff jeffy answered 2 years ago

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...

What is the correction that is made to the IRR method when using the Modified IRR...

What is the correction that is made to the IRR method when using the Modified IRR method?

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 %

Evaluate the following projects using the payback method assuming a rule of 4 years for payback....

Evaluate the following projects using the payback method assuming a rule of 4 years for payback. Year Project A Project B 0. -10,000 -10,000 1. 4000 4000 2. 4000 3000 3. 4000 2000 4. 0. 1,000,000 A. Project A can be accepted because the payback period is 2.5 years but Project B cannot be accepted because its payback period is longer than 3 years. B. Project B should be accepted, since there is a $1,000,000 payoff in the 4th year...

Evaluate the following projects using the payback method assuming a rule of 3 years for payback....

Evaluate the following projects using the payback method assuming a rule of 3 years for payback. Year Project A Project B 0 -10,000 -10,000 1 4,000 4,000 2 4,000 3,000 3 4,000 2,000 4 0 1,000,000

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...

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...

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...

Why does IRR and Payback periods gives different results? and would you prefer to use IRR...

Why does IRR and Payback periods gives different results? and would you prefer to use IRR or Payback period when deciding which project to go with? (You can come up with your own projects and figures to answer this)