Question

A couple want to save $100,000 to pay for their daughter's education. They put $2,000 into a fund at the beginning of every month. Interest is compounded monthly at a nominal rate of 7%. How long does it take for the fund to reach $100,000?

Answer #1

Answer : Calculation of Number of years that will take the fund to reach $100000

Reason :

Using NPER function of Excel we can calculate number of years

=NPER(rate,pmt,pv,fv,type)

where rate is rate of interest per interest i.e 7%/12

pmt is the periodic payment i.e 2000

pv is the present value i.e 0

fv is the future value i.e 100000

type is 1 as the payments are made beginning of every month.

=NPER(7%/12,2000,0,-100000,1)

On putting this values

**NPER will return 43.77684 months or 3.65 years (43.77684
/ 12)**

A couple wants to save for their daughter's college expense.
The daughter will enter college eight years from now, and she will
need$37,000 ,$37,900, $38,800,and $39,700
in actual dollars for four school years. Assume that these
college payments will be made at the beginning of each school year.
The future general inflation rate is estimated to be
7% per year, and the annual inflation-free interest rate is
6%
What is the market interest rate to use in the analysis? The...

29.You would like to save up for a down payment on a house. You
need to save up $30,000 and can afford to put $500 in the bank at
the end of every month. How long will it take you to reach your
goal if quoted interest rates are 7% compounded monthly?
Select one:
a. About 68 months
b. About 52 months
c. About 77 months
d. About 71 months
e. None of the above.

After retiring, you want to be able to take $2,000 every month
for a total of 20 years from your retirement account. The account
has an annual rate of 4.1% compounded monthly. How much of the
money paid out over the 20 years is the interest earned? Round your
answer to two decimal places.

You have a couple who are 31 years old, and want to retire at
the age of 67. Knowing that, the couple has a combined annual
income of $95,000 today.
1. If the couple want to procrastinate their retirement savings
until they reach 35, and if retirement savings will grow at a rate
of 8%, how much would they need to save per year, at the end of
every year, in order to achieve the $2 million target by the...

1. You want to start saving for your daughter's college
education now. She will enter college at age 18 and will pay fees
of $5,000 at the end of each of the four years. You will start your
savings by making a deposit in one year and at the end of every
year until she begins college. If annual deposits of $3,960.46 will
allow you to reach your goal, how old is your daughter now? Assume
you can earn 6%...

Holly would like to plan for her daughter's college education.
She would like for her daughter, who was born today, to attend
college for 4 years, beginning at age 18. Tuition is currently
$10,000 per year and tuition inflation is 7%. Holly can earn an
after-tax rate of return of 9.5%. How much must Holly save at the
end of each year, if she wants to make the last payment at the
beginning of her daughter's first year of college?

at age 20, to save for retirement, jane decides to put aside
$100 every month at 2.75% interest compounded monthly. a) how much
will jane have accumulated at age 62, which is the age she plans to
retire? b) find the interest earned on this investment

After retiring, you want to be able to take $2,000 every month
for a total of 20 years from your retirement account. The account
has an annual rate of 4.1% compounded monthly. How much of the
money paid out over the 20 years is the interest earned? Round your
answer to two decimal places. (152,808.38)
After retiring, you want to be able to take $3,500 every month
for a total of 35 years from your retirement account. The account
has...

A young couple take out a 30-year home mortgage of $145,000.00
at 6.9% compounded monthly. They make their regular monthly payment
for 7 years, then decide to up their monthly payment to
$1,200.00.
a) What is the regular monthly payment? $
b) What is the unpaid balance when they begin paying the
accelerated monthly payment of $1,200.00? $
c) How many monthly payment of $1,200.00 will it take to pay off
the loan? payments d) How much interest will this...

You plan to buy a house in 7 years. You want to save money for a
down payment on the new house. You are able to place $353 every
month at the end of the month into a savings account at an annual
rate of 10.73 percent, compounded monthly. How much will be in the
account after you made the last payment? Round the answer to the
two decimal places.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 21 minutes ago

asked 47 minutes ago

asked 52 minutes ago

asked 52 minutes ago

asked 53 minutes ago

asked 58 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago