Intro Annual Growth Rates

crown

This intro problem practices EFFECT. EFFECT converts a nominal annual interest rate into an effective annual rate for a specified compounding frequency. Update the output cells to calculate the effective annual rate in each row. Nom Rate is the nominal annual interest rate. Periods is the number of compounding periods per year. See Examples

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

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

EFFECT
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