| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | टाइमस्टैम्प | Sample Question 1 | ||||
2 | Enter amounts in white cells (e.g.are in blue font) Results are in grey cells | |||||
3 | ||||||
4 | To find CAGR: | |||||
5 | Initial amount: | 10000 | ||||
6 | Ending amount: | 15000 | ||||
7 | Years of investment: | 2 | ||||
8 | CAGR (%): | 22.47% | ||||
9 | ||||||
10 | To find ending amount: | |||||
11 | Initial amount: | 100000 | ||||
12 | CAGR (%): | 10.00% | ||||
13 | Years of investment: | 15 | ||||
14 | Ending amount: | 417,725 | ||||
15 | ||||||
16 | To find # of years of required investment: | |||||
17 | Initial amount: | 100000 | ||||
18 | Ending amount: | 400000 | ||||
19 | CAGR (enter as decimal): | 10.00% | ||||
20 | Years of investment: | 14.55 | ||||
21 | ||||||