MBA Assignment Help: NPV, IRR, Break-Even and Ratio Analysis Explained
How to calculate NPV, IRR, payback, break-even and key ratios, with worked examples.
What MBA finance assignments are really testing
Most MBA finance and accounting assignments ask you to do two things: calculate a few standard measures correctly, then argue what they mean for a decision. The calculations are usually net present value (NPV), internal rate of return (IRR), payback period, break-even and a handful of financial ratios. The marks mostly come from the second part, so show your working and then say what you would recommend. If your brief is about case studies rather than numbers, see our MBA case study guide.
1. Net present value (NPV)
NPV adds up the value of future cash flows in today's money and subtracts the amount you invest. A positive NPV means the project earns more than the required return.
NPV = (cash flow in year 1 ÷ (1 + r)) + (year 2 ÷ (1 + r)²) + ... − initial investment
Worked example (made-up numbers). A project costs $100,000 and is expected to return $40,000, $50,000 and $60,000 over three years. The required return is 10%.
- Year 1: 40,000 ÷ 1.10 = 36,364
- Year 2: 50,000 ÷ 1.21 = 41,322
- Year 3: 60,000 ÷ 1.331 = 45,079
- Present value of the cash flows = 122,765
- NPV = 122,765 − 100,000 = about $22,765
The NPV is positive, so on this measure the project is worth doing. A good answer also names the assumptions: the cash flows are forecasts, and the 10% rate is a judgement.
2. Internal rate of return (IRR)
IRR is the discount rate at which the NPV equals zero. It is usually found by trial and error or with the IRR function in Excel.
For the same project, an NPV of about +2,778 at 20% and about −578 at 22% puts the IRR at roughly 21.7%. Because that is above the 10% required return, the project passes.
IRR is easy to compare across projects, but it can mislead when cash flows change sign more than once or when projects differ greatly in size. Mention this if the brief asks you to compare methods.
3. Payback period
Payback is the time it takes to earn back the initial investment.
In the example, the cumulative cash flow is 40,000 after year 1 and 90,000 after year 2. The remaining 10,000 comes from year 3's 60,000, so payback = 2 + (10,000 ÷ 60,000) = about 2.17 years.
Payback is simple and shows risk, but it ignores the time value of money and any cash flow after the payback date. Say so.
4. Break-even analysis
Break-even is the sales level at which total revenue equals total cost.
Break-even units = fixed costs ÷ (price per unit − variable cost per unit)
Worked example (made-up numbers). Fixed costs are $30,000 a month, the price is $50 and the variable cost is $20 per unit.
- Contribution per unit = 50 − 20 = $30
- Break-even = 30,000 ÷ 30 = 1,000 units, or $50,000 of sales
- If sales are 1,400 units, the margin of safety is (1,400 − 1,000) ÷ 1,400 = about 28.6%
5. Ratio analysis in one table
| Ratio | Formula | Example (made-up) | What it tells you |
|---|---|---|---|
| Current ratio | current assets ÷ current liabilities | 150,000 ÷ 100,000 = 1.5 | Short-term ability to pay bills |
| Net profit margin | net profit ÷ revenue | 24,000 ÷ 400,000 = 6% | How much of each sale is kept as profit |
| Return on equity | net income ÷ shareholders' equity | 24,000 ÷ 200,000 = 12% | Return earned for owners |
| Debt-to-equity | total debt ÷ shareholders' equity | 150,000 ÷ 200,000 = 0.75 | How much the firm relies on borrowing |
One ratio on its own says little. Compare it with the same company in earlier years and with similar firms, then explain the reason for any gap.
Writing the analysis, not just the numbers
- State the formula and the assumptions before the calculation.
- Show every step with units, so a marker can give method marks even if one number is wrong.
- Say in one sentence what the result means for the decision.
- Name one limitation, such as uncertain forecasts or a discount rate that is an estimate.
- Finish with a clear recommendation.
Mistakes that cost marks
- Using the wrong discount rate, or applying it to year 0 as well as the later years.
- Forgetting the initial investment when calculating NPV.
- Mixing monthly and annual figures in break-even or ratio work.
- Stopping at the number with no recommendation.
- Treating payback as the whole answer and ignoring cash flows after it.
Common questions
What does a positive NPV mean? It means the project's future cash flows, in today's money, are worth more than the cost. On that measure alone, it adds value.
What is the difference between NPV and IRR? NPV gives the value created in money terms at a chosen discount rate. IRR gives the rate of return at which the NPV is zero. They usually agree, but NPV is safer when comparing projects of different sizes.
How do I calculate break-even? Divide fixed costs by the contribution per unit, which is the price minus the variable cost. The result is the number of units you must sell to cover all costs.
Can you help with an MBA assignment? Yes. Our MBA experts can explain the methods, check your calculations and give feedback on your analysis. You can message us on WhatsApp for a quote, with free rework or a refund if the work does not meet your brief.