In: Accounting
What is the nominal rate of interest compounded monthly at which payments of $200 made at the end of every three months accumulate to $9200 in eight years?
Show the financial calculator (BA II Plus) steps with
values so I can see how to do the question as they need just the
financial calculations for the midterm (and timeline if
needed).
A | B | C | D | E | F | G | H | I |
2 | ||||||||
3 | Future Value | $9,200 | ||||||
4 | Quarterly Payment | $200 | ||||||
5 | Period | 8 | Years | |||||
6 | Number of quarters | 32 | ||||||
7 | Since payment is quarterly, therefore, the quarterly interest rate will be calculated first, | |||||||
8 | then the monthly interest rate is calculated using the quarterly interest rate. | |||||||
9 | ||||||||
10 | To calculate the rate of return, enter the following data in the financial calculator: | |||||||
11 | FV | $9,200 | =D3 | |||||
12 | N | 32 | =D6 | |||||
13 | PMT | ($200.00) | =-D4 | |||||
14 | PV | $0 | 0 | |||||
15 | After entering the above values, press I/Y to calculate the quarterly rate of return. | |||||||
16 | ||||||||
17 | Quartely Rate of return | 2.23% | =RATE(D12,D13,D14,D11) | |||||
18 | ||||||||
19 | Let monthly rate of return be r then | |||||||
20 | (1+r)3 = (1+2.3%) | |||||||
21 | solving the above equation, | |||||||
22 | Monthly interest rate, r= | 0.74% | =((1+D17)^(1/3))-1 | |||||
23 | ||||||||
24 | Nominal rate of interest compounded monthly | =12*Monthly interest rate | ||||||
25 | 8.86% | =12*D22 | ||||||
26 | ||||||||
27 | Hence Nominal rate of interest compounded monthly | 8.86% | ||||||
28 |