Intro Loan Interest

crown

This intro problem practices IPMT. IPMT calculates the interest portion of a specific loan payment, assuming a fixed interest rate and equal periodic payments. Update the output cells to calculate the signed interest portion of the selected payment in each row. Return negative amounts for interest paid out, or 0 if no interest is paid. Rate is the interest rate per period. Period selects the payment, starting at 1, and Periods is the total number of payments. Start Amt is the amount borrowed. End Amt is 0 for full repayment or a negative amount for a balance still owed. Timing is 0 for end-of-period payments or 1 for beginning-of-period payments. See Examples

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

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

IPMT
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