Explore BrainMass

Calculate NPV, IRR, maximum cost of capital

See attached file.

Problem 1

For each of the projects shown in the following table, calculate the internal rate of return (IRR). Then indicate, for each project, the maximum cost of capital that the firm could have and still find the IRR acceptable.

Project A Project B Project C Project D
Initial investment (CF0): $90,000 $490,000 $20,000 $240,000

Year (t) Cash inflows (CFt)
1 $20,000 $150,000 $7,500 $120,000
2 25,000 150,000 7,500 100,000
3 30,000 150,000 7,500 80,000
4 35,000 150,000 7,500 60,000
5 40,000 - 7,500 -

There is no data for year 5 for Projects B and D. Need NPV and IRR for all if possible, please.

Problem 2:

Long-term investment decision, IRR method Billy and Mandy Jones have $25,000 to invest. On average, they do not make any investment that will not return at least 7.5% per year. They have been approached with an investment opportunity that requires $25,000 upfront and has a payout of $6,000 at the end of each of the next 5 years. Using the internal rate of return (IRR) method and their requirements, determine whether Billy and Mandy should undertake the investment.

Use Attached NPV IRR spreadsheet. Both problems should be on one page of one excel spreadsheet.