Money at the end of time period is calculated using the FV function:-
=FV(rate,nper,pmt,pv,0 or 1)
=FV(3.04%/12,11*12,-416,,1)
=65276.26
Where,
rate is periodic rate
nper is number of periods
pmt is periodic payment
1 is used when the payments are at the beginning of a period
You have decided to place $416 in equal deposits every month at the beginning of the...
You have decided to place $416 in equal deposits every month at the beginning of the month into a savings account earning 3.04 percent per year, compounded monthly for the next 11 years. The first deposit is made today. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
You have decided to place $147 in equal deposits every month at the beginning of the month into a savings account earning 13.34 percent per year, compounded monthly for the next 14 years. The first deposit is made today. How much money will be in the account at the end of that time period? Round the answer to two decimal places
You have decided to place $175 in equal deposits every month at the beginning of the month into a savings account earning 7.66 percent per year, compounded monthly for the next 14 years. The first deposit is made today. How much money will be in the account at the end of that time period? Round the answer to two decimal places. Thank you.
You have decided to place $166 in equal deposits every month at the beginning of the month into a savings account earning 5.58 percent per year, compounded monthly for the next 15 years. The first deposit is made today. How much money will be in the account at the end of that time period? Please provide steps and show work using excel.
Show how to enter into EXCEL 1. You have decided to place $153 in equal deposits every month at the beginning of the month into a savings account earning 4.69 percent per year, compounded monthly for the next 15 years. The first deposit is made today. How much money will be in the account at the end of that time period? Round the answer to two decimal places 2. What is the present value of the following annuity? $4,765 every...
For the next 7 years, you decide to place $1,536 in equal year-end deposits into a savings account earning 6.60 percent per year. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
For the next 8 years, you decide to place $3,747 in equal year-end deposits into a savings account earning 5.74 percent per year. How much money will be in the account at the end of that time period? Round answer to two decimal places.
For the next 15 years, you decide to place $1,299 in equal year-end deposits into a savings account earning 11.37 percent per year. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
For the next 3 years, you decide to place $3,695 in equal year-end deposits into a savings account earning 8.25 percent per year. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
For the next 13 years, you decide to place $749 in equal year-end deposits into a savings account earning 8.67 percent per year. How much money will be in the account at the end of that time period? Round answer to two decimal places. Thank you.