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.