Intro Implied Interest

crown

This intro problem practices RATE. RATE finds the constant interest rate per period from a payment schedule and starting and ending amounts. Update the output cells to calculate the rate per period in each row. Periods is the total period count. Payment is the fixed amount paid or received each period; zero means no periodic payments. Start Amt is the amount received or paid out now. End Amt is the amount available or owed at the end of the last period. Money received or available is positive; money paid out or owed is negative. Timing is 0 for payments at the end of each period and 1 for payments at the beginning. See Examples

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

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

RATE
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