Question

Calculate the equal annual end of year amount needed to accumulate a given sum of $100,...

Calculate the equal annual end of year amount needed to accumulate a given sum of $100, 000 in 20 years if interest rate is 7%.

Homework Answers

Answer #1

Ans:- In this question, we need to find the annual annuity or payment which needs to deposit to accumulate $100,000 in 20 years at an interest rate of 7%.we will use excel PMT function to find the answer easily.

Therefore the annual Payment needed is $2439.29.

Note:- By Formula Method PMT is given by FV / [ ((1+r)^n - 1) / r], where FV is the future value,r is the rate, and n is the number of periods.

PMT = $100000 / [((1+0.07)^20-1) / 0.07] = $100000 / 41 = $2439.29.

Note:- If this answer helps you pls give thumbs up.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Nana Akoto wants to have Ȼ50,000 at the end of 10 years. To accumulate this sum,...
Nana Akoto wants to have Ȼ50,000 at the end of 10 years. To accumulate this sum, he has decided to save a certain amount at the end of each year for the next 10 years and deposit it in a bank that pays an annual interest rate of 8% compounded annually. How much will he have to save at the end of each year
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan to deposit each year an equal sum in the bank, which will earn 7% interest annually. Your first payment will be made at the end of the year. o How much must you deposit annually to accumulate this amount? o If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? o At...
Ray wants to accumulate 8,000 at the end of 20 years. At the end of each...
Ray wants to accumulate 8,000 at the end of 20 years. At the end of each year for the first 10 years he deposits 150. At the end of each year for the next 10 years he deposits X. The annual effective interest rate is 5%. Calculate X.
You would like to have $41,000 in 15 years. To accumulate this​ amount, you plan to...
You would like to have $41,000 in 15 years. To accumulate this​ amount, you plan to deposit each year an equal sum in the​ bank, which will earn 7 percent interest compounded annually. Your first payment will be made at the end of the year. At the end of 4 years you will receive $9,000 and deposit this in the bank toward your goal of $41,000 at the end of 15 years. In addition to this​ deposit, how much must...
1)Nicole wants to accumulate $ 8,000 at the end of 5 years making equal money deposits...
1)Nicole wants to accumulate $ 8,000 at the end of 5 years making equal money deposits at the end of each year for the next 5 years. If Nicole can earn 7% of her investments, how much should she deposit at the end of each year to meet her goal (accumulate $ 8,000)? 2)Mr. Roman wants to determine how long it will take for an initial deposit of $ 10,000 to double. a)If Mr. Román earns 10% annual interest on...
You would like to have ​$73,000 in 14 years. To accumulate this​ amount, you plan to...
You would like to have ​$73,000 in 14 years. To accumulate this​ amount, you plan to deposit an equal sum in the bank each year that will earn 9 percent interest compounded annually. Your first payment will be made at the end of the year. a.  How much must you deposit annually to accumulate this​ amount? b.  If you decide to make a large​ lump-sum deposit today instead of the annual​ deposits, how large should the​ lump-sum deposit​ be? ​...
A businesswoman wants to invest a certain sum of money at the end of each year...
A businesswoman wants to invest a certain sum of money at the end of each year for 6 years. The investment will earn 9 % compounded annually. At the end of 6 years, she will need a total of dollar-sign 20 ,000 accumulated. How should she compute the required annual investment? (a) dollar-sign 20 ,000 times the amount of an annuity of dollar-sign Baseline 1 at 9 % at the end of each year for 6 years (b) dollar-sign 20...
You would like to have $47,000in 9 years. To accumulate this amount you plan to deposit...
You would like to have $47,000in 9 years. To accumulate this amount you plan to deposit each year an equal sum in the bank, which will earn 8 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate $47,000 in 9 years? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be?...
Ali wants to accumulate 150,000 dollars at the end of year 12 .To do this he...
Ali wants to accumulate 150,000 dollars at the end of year 12 .To do this he will deposit 10 equal annual amounts starting from end of year 1 . the bank have an interest   rate of 10% per year . what is the magnitude of the annual payments ? .
What equal amount Q must be deposited at the beginning of each year for the next...
What equal amount Q must be deposited at the beginning of each year for the next 5 years in a savings account 10% interest in order to accumulate 1000 at the end of year 6. The value of Q is? First cost for special equipment = $1000 per every 50 years of its life cycle. If n= infinity and I = 9% then it’s EUAC is most nearly: You obtain 1000 loan from the bank. The amount to repay the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT