Intro Future Savings

crown

This intro problem practices FV. FV calculates the future value of an initial lump sum, equal periodic payments, or both, using a constant interest rate. Update the output cells to calculate the future value of the savings cash flows in each row. Rate is the rate per period and Periods is the total period count. Deposit is the amount paid out each period, and Start Amt is an initial amount paid out at the start of the first period. Both are shown as negative cash flows so End Value should be positive. Timing is 0 when the periodic deposits occur at the end of each period and 1 when they occur at the start of each period. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

Need help with FV details and syntax? Review the FV function guide first.

FV
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50