Intro Annual Rate Quotes

crown

This intro problem practices NOMINAL. NOMINAL converts an effective annual interest rate into a nominal annual rate for a specified compounding frequency. Update the output cells to calculate the nominal annual rate in each row. Eff Rate is the effective 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 NOMINAL details and syntax? Review the NOMINAL function guide first.

NOMINAL
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