Question

In: Finance

Deposits of $425 are made quarterly in an investment. The first deposit is made on February...

Deposits of $425 are made quarterly in an investment. The first deposit is made on February 15, 2014 and the last deposit is made on August 15, 2024. Find the nominal rate converted quarterly that is earned if the account balance just after the last deposit on August 15, 2024 is $28966.54.

Solutions

Expert Solution

Answer : Calculation of Nominal Rate converted Quarterly :

Using RATE function of Excel :

=RATE(nper,pmt,pv,fv)

where

nper is the number of deposits i.e 42

pmt is 425

pv is 0

fv is future value i.e 28966.54

=RATE(42,425,0,28966.54)

Therefore Rate of interest is 2.22% quarterly or 8.86% per annum compounded quarterly.


Related Solutions

A person deposits $12,000 per year for 5 years, with the first deposit made one year...
A person deposits $12,000 per year for 5 years, with the first deposit made one year from the present. One year after the last deposit, the person makes continuous withdrawals of $2,000 for the next 15 years. Find the effective annual ERR being earned on this investment. Thank you very much to whomever can give me the solution and answer! ?
2. An investment of $425 is made at a nominal rate of 4% per year, with...
2. An investment of $425 is made at a nominal rate of 4% per year, with interest compounded monthly. How long will it take that investment to double? a) Write the equation that you need to solve in order to answer this problem. b) Show how to solve your equation TWO ways: graphically and symbolically. To solve graphically, clearly sketch the window you saw, give the dimensions of the window, label your curves, and give the coordinates of any point(s)...
Quarterly deposits are made into a fund at the beginning of each quarter starting today for...
Quarterly deposits are made into a fund at the beginning of each quarter starting today for 5 years. The first 8 deposits are $1000 each and deposits increase by 1% per quarter thereafter. If the fund earns 8% effective annually, find the accumulated value at the end of 5 years. Please explain which equations you used and do not use excel.
Equal – quarterly deposits of P 2,000 for 2 years which starts immediately is made at...
Equal – quarterly deposits of P 2,000 for 2 years which starts immediately is made at a savings account that earns 4% compounded quarterly. What is the amount in the account when the last deposit is made? What is the amount in the account at the end of the last quarter?
Ten months from today, you plan to make the first of several quarterly deposits into an...
Ten months from today, you plan to make the first of several quarterly deposits into an account paying an APR of 4% with monthly compounding. After your first deposit, subsequent deposits will grow by 1% each. After your final deposit three years and seven months from today, you will simply let interest accrue on the account. Set up the calculations needed to determine your first and your final deposit if you want the balance in your account to equal $100,000...
Deposits of $800 are made the first year into a 7% account. This amount increases by...
Deposits of $800 are made the first year into a 7% account. This amount increases by $30 for the second year and continues to increase over a total of 10 years. What is the equivalent annual cost of these future deposits? What is the present value of these deposits?
what quarterly deposits at the end of each quarter should be made into a savings account paying the nominal interest of
1. what quarterly deposits at the end of each quarter should be made into a savings account paying the nominal interest of 4% compounded quarterly to accumulate $10,000 at the end of 10 years?2. Faith buys a used car by paying a $500 down payment plus $180 a month for 3 years. what was the price of the car if the interest rate on the loan is the nominal interest rate of 9% compounded monthly?
You have set up an investment that pays 5% compounded quarterly but requires deposits of $1,000...
You have set up an investment that pays 5% compounded quarterly but requires deposits of $1,000 at the beginning of each quarter period for 4 years. How much will you have in the account in 4 years? The account will be worth $ in 4 years?  (Round to 2 decimal places.)
You deposit $1000 per month every month into an investment account for 40 years. The deposits...
You deposit $1000 per month every month into an investment account for 40 years. The deposits are made at the end of each month . The first deposit is made at the end of the first month. If the return 6 percent compounded monthly for the first 10 years, and 9 percent compounded monthly thereafter, how much will you have in the account in year 40?
$1,000 deposits are made into an investment account at the end of year 1, 2, and 3
$1,000 deposits are made into an investment account at the end of year 1, 2, and 3. No deposit was made in year 4. Interest accrues at 5.0% monthly. What is the balance in the account at the end of Year 5?$3,666$3,487$3,476$3,649
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT