Intro Money Today

crown

This intro problem practices PV. PV calculates the present value of equal periodic payments, a future lump sum, or both, using a constant interest rate. Update the output cells to calculate the present value of the future cash flows in each row. Rate is the rate per period and Periods is the total period count. Payment is the amount paid out each period, and Final Amt is an additional amount paid out at the end of the last period. Both are shown as negative cash flows so Value Now should be positive. Timing is 0 when the periodic payments 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 PV details and syntax? Review the PV function guide first.

PV
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