Determine the payback period of each project

Reference no: EM132470251

You will compare three projects. The following table lists each projects initial outlay (price of the project) in year 0 (zero). The following years are the cash inflows. All projects receive the same total cash inflows. They differ on when the cash flows occur and the amount of the annual cash flow You must submit your backup in Excel showing how answers were reached. Use the formula and the financial calculator or Excel to determine:

Given three projects with the following cash flows:

Project A Project B Project C

Year Cash Flow Cash Flow Cash Flow

0 -1000 -1000 -1000

1 200 500 350

2 300 400 350

3 400 300 350

4 500 200 350

Question 1: Find the NPV, IRR and MIRR of each the projects with a cost of capital of 5%, 10%, and 12%.

Question 2: Determine the payback period of each project.

Question 3: Determine the acceptance of the projects if you have a capital budget of $3000, $2000. and $1000.

Question 4: Compare the timing of the cash flows of each project relative to its NPV.

Question 5: Compare how the timing and size of the cash flows change the net present value.

Reference no: EM132470251

Questions Cloud

Information systems in business and beyond : Review the timeline of computers at the Old Computers website. Pick one computer from the listing and write a brief summary.

Cyber security planning and management : Creating Company E-mail/WIFI/Internet Use Policies. create two separate policies on use of EMAIL and a WIFI/INTERNET USE within the company.

Data modeling integration process : Let's assume your organization has both an fully functioning IT department and now starting an ad hoc Information Governance department.

Explicit strategies for technology development : Do you feel that countries and companies need explicit strategies for technology development,

Determine the payback period of each project : Find the NPV, IRR and MIRR of each the projects with a cost of capital of 5%, 10%, and 12%. Determine the payback period of each project

Compare and contrast npv and irr : What impact does timing of the cash flows have on your overall return? How might this impact project acceptance? Compare and contrast NPV and IRR

How could johnathan have constructed a general chart : How could Johnathan have constructed a general chart that would have shown him his break-even point before starting his business?

Discuss strengths of percent of sales method : Discuss the effects on the breakeven of what happens during a business cycle: falling and rising sales and costs. Discuss strengths of percent of sales method.

Determine and estimate wacc for coca-cola amatil ltd : Determine and Estimate WACC for Coca-Cola Amatil Ltd. Label all input figures, state any assumptions necessary for their use, and reference their source.

User Account

All Pages