Purchase Solution

Payback period, IRR and NPV

Not what you're looking for?

Ask Custom Question

Your company uses a 12% annual rate to discount cash flows for NPV. The following table presents the costs of each investment (negative values in time zero) and the expected cash flows for each investment each year.

Period A B C
0 -500 -2000 -500
1 200 400 300
2 300 500 200
3 400 800 100
4 500 900 0
5 0 1000 0

1. Calculate the payback period for each investment.
2. Calculate the IRR for each investment.
3. Calculate the NPV for each investment.

Purchase this Solution

Solution Summary

Excel file contains calculations of payback period, IRR and NPV for 3 investment options.

Purchase this Solution


Free BrainMass Quizzes
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.