Question: NOTE: PLEASE USE EXCEL FOR EXCEL FORMULA 8. If you deposit $5,000 per year for the next 20 years into an account paying 10%, how

NOTE: PLEASE USE EXCEL FOR EXCEL FORMULA

8. If you deposit $5,000 per year for the next 20 years into an account paying 10%, how much money will you have in the account in after the 20 years? Suppose you decide to invest this $5,000 per year in the same account earning 10% for 40 years rather than 20, how much will you have in the account after 40 years?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

NOTE: PLEASE USE EXCEL FOR EXCEL FORMULA 8. If you deposit $5,000 per year for the next 20 years into an account paying 10%, how much money will you have in the account in after the 20 years? Suppose...

NOTE: PLEASE USE EXCEL FOR EXCEL FORMULA 1. PNC Bank pays 5% simple interest on its savings account balances, whereas First Niagara Bank pays 5% interest compounded annually. If you made a deposit of...

NOTE; Please use Excel for Excel formula 4. You have just received notification that you have won $5 million lottery. However, your price will be awarded on your 60th birthday, 40 years from now....

NOTE: Please use Excel for Excel Formulas 7. You receive $5,000 per year for the next 20 years from your Grandmothers trust. If a 7% interest rate is applied, what is the present value of the future...

Please answer all. If not I will also post separately. (Show all your work or calculator keys. Please do not take pictures of your hand written answers and you must type. Do not show calculator keys...

Please help on my assignment, Please use excel as the following template. Majestic Mulch and Compost Company (MMCC) YEAR 0 $ $ 3 5,000 6,000 120.00 ### 14.29% 114,320 685,680 24.49% 195,920 489,760...

You are starting to plan for your retirement and want to determine the optimal type of retirement account to establish in light of different tax treatments on the accounts. Suppose that you are 30...

(a)Investment planning (30 marks) (i) If Nurfarhana requires similar lifestyle post-retirement age and considering yearly inflation rate remains at 4%, by the age 55 she needs around RM7,148,000 to...

Allied Pigments and Dyes, Inc. (APD) has received notification from the New Jersey Environment Protection Agency (NJEPA) that their Bound Brook manufacturing facility is in violation of waste water...

Assume you are the lead hedge strategist at ANZ Bank. ANZ has borrowed US$1 Bn and the first repayment in due in 3 months. would you recommend ANZ to hedge its exposure to exchange rate risk?...

10. What evidence is necessary to demonstrate the ability to defer settlement of short-term debt?

The cost of capital is typically the largest component of holding costs Question 1 options: True False

3.100 It is known that 20% of all farms in a state exceed 160 acres and that 60% of all farms in that state are owned by persons over 50 years old. Of all farms in the state exceeding 160 acres, 55%...

3.99 In a campus restaurant it was found that 35% of all customers order vegetarian meals and that 50% of all customers are students. Further, 25% of all customers who are students order vegetarian...

3.98 Staff, Inc., a management consulting company, is surveying the personnel of Acme Ltd. It determined that 35% of the analysts have an MBA and that 40% of all analysts are over age 35. Further, of...