Question

In: Accounting

What is the nominal rate of interest compounded monthly at which payments of $200 made at...

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).

Solutions

Expert Solution

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

Related Solutions

For an interest rate of 8% per year compounded monthly, what is the nominal interest rate...
For an interest rate of 8% per year compounded monthly, what is the nominal interest rate for one year?
Compute the nominal annual rate of interest (compounded monthly) at which $250.00 deposited at the end...
Compute the nominal annual rate of interest (compounded monthly) at which $250.00 deposited at the end of each month for ten years will amount to $30 000.00.
What is the periodic rate if the nominal rate of 12% is compounded monthly? What is...
What is the periodic rate if the nominal rate of 12% is compounded monthly? What is the periodic rate if the nominal rate of 6% is compounded quarterly? When is the nominal or annual stated rate the same as the effective rate?
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded...
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded monthly. The loan is to be repaid by 36 monthly payments of 367.21 over 37 months, starting one month after the loan is made, there being a payment at the end of every month but one. At the end of which month is the missing payment? For your reference, the answer is at the 17th month.
A loan will be repaid in 5 years with monthly payments at a nominal interest rate...
A loan will be repaid in 5 years with monthly payments at a nominal interest rate of 9% monthly convertible. The first payment is $1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 2% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
Monthly payments on a $165,000 mortgage are based on an interest rate of 6.6% compounded semiannually...
Monthly payments on a $165,000 mortgage are based on an interest rate of 6.6% compounded semiannually and a 30-year amortization. If a $5000 prepayment is made along with the thirty-second payment: (Do not round the intermediate calculations.) a. How much will the amortization period be shortened? (Round UP to the next whole number.)    The amortization period will be shortened by years and month(s).    b.What will be the principal balance after four years? (Round your answer to two decimal...
A loan is amortized over five years with monthly payments at an annual nominal interest rate...
A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
(a) What interest rate compounded monthly is equivalent to (has the same APY as) 15% compounded...
(a) What interest rate compounded monthly is equivalent to (has the same APY as) 15% compounded semi-annually? (b) What interest rate compounded continuously is equivalent to (has the same APY as) 15% compounded semi-annually?
Which of the following offers the highest return?         A. 12% nominal rate compounded monthly         B. 12.4%...
Which of the following offers the highest return?         A. 12% nominal rate compounded monthly         B. 12.4% nominal rate compounded quarterly         C. 12.8% nominal rate compounded semi-annually         D. 13.0% nominal rate compounded annually         E. More information is needed to determine the best investment.
4. A $600,000 CPM fully amortizing loan is made, at a 4% interest rate compounded monthly,...
4. A $600,000 CPM fully amortizing loan is made, at a 4% interest rate compounded monthly, for a 30 year term. Loan comes with a charge of 5 points. What is the effective annual rate on the loan? *do work in EXCEL please*
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT