Intro Fixed Payments

crown

This intro problem practices PMT. PMT calculates the fixed periodic payment needed to connect starting and ending amounts, using a constant interest rate. Update the output cells to calculate the signed periodic payment in each row. Rate is the rate per period and Periods is the total period count. Start Amt is the amount received at the start of the first period, and End Amt is an additional positive amount to accumulate at the end of the last period. Rows with Start Amt 0 represent saving toward End Amt. The positive starting and ending amounts require negative payments, so Payment should be negative. Timing is 0 when 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 PMT details and syntax? Review the PMT function guide first.

PMT
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