Lesson 6 of 6

The analyst's spreadsheet

Step 5 of 6

Check yourself

Answer in your head first, then tap to reveal.

1. You have revenue for 2020, 2021, 2022, 2023 and 2024. How many periods do you use in the CAGR formula?

Show answer

Four. There are four gaps between five years.

2. Revenue goes from 50 to 60. What's the growth, and what's the formula if 50 is in B2 and 60 in C2?

Show answer

60 ÷ 50 − 1 = 20%. The formula is =C2/B2-1.

3. You pay $500 today. Why is =NPV(8%, B2:E2) wrong if B2 holds the −500?

Show answer

NPV treats the first value as one year away, so it would discount today's −500 as if paid next year. Use =NPV(8%, C2:E2) + B2.

4. An investment's IRR is 12% and you need 8%. Is its NPV at 8% positive or negative?

Show answer

Positive. The investment earns more than the rate you discount at, so the cash coming back is worth more than the cost.