Calculate NPV, IRR, maximum cost of capital
Not what you're looking for?
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.
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.