Exercise 3 if you invest $4000 each year for 40% years, how much will you have at the end of 40 years assuming a 9% annual return?
Exercise 4 if you want to withdraw $35000 each year for 30 years, how much would you need to have saved today to fund these withdrawals? (Assume 7% annual return)
Exercise 5 if you purchase a machine and borrow $30000, what will your approximate monthly payment be if you pay back the loan over 5 years. Assume a 10% interest rate.
Exercise 6 You are considering purchasing a new machine for $32000 that will save $6000 per year for 8 years. If cost of capital is 12%, what is the net present value (NPV) of buying the new machine?
Part 3
Future value = annual payment * future value annuity
= 4000*(((1.09^40)-1)/9%) = $1351530
Future value annuity =( (1+r)^n -1)/r
R = 9%
N= 40
Part 4
Present value = annual withdrawal * present value of annuity
= 35000*((1-(1.07^-35))/7%)
= $453168.53
= $453169
Present value of annuity = ((1-((1+r)^-n))/r)
R = 7%
N= 35
Part 5
Monthly payment = PV/present value of annuity
=30000/(((1-((1+(10%/12))^-60))/(10%/12))) = $637.41 = $637
Present value of annuity = ((1-((1+r)^-n))/r)
R= 10%/12
N = 5*12 = 60
Part 6
NPV = present value of cash inflows – present value of cash outflows
= -32000+(8000/(1.12))+ (8000/(1.12^2))+ (8000/(1.12^3))+ (8000/(1.12^4))+ (8000/(1.12^5))+ (8000/(1.12^6))+ (8000/(1.12^7))+ (8000/(1.12^8)) = $7741.12 = $7741
PV = C/(1+r^n)
R = 12%
Exercise 3 if you invest $4000 each year for 40% years, how much will you have...
I’ll give thumbs up right away! DONT HAVE TO SHOW WORK 1) if you invest 2000 each year for 40 years, how much will you have at the end of 40 years assuming 9% annual return? 2) if you want to withdraw 35000 each year for 30 years, how much would you need to have saved today to fund these withdrawals? 3) if you purchase a machine and borrow 10000, what will your approximate monthly payment be if you pay...
1. Your grandmother has invested $4000 in a mutual fund each year on your birthday (she made her first payment when you turned 1 year old). The mutual fund has grown at an annual interest rate of 6.8%. How much is your account worth on the day of your 21st birthday immediately after your grandmother’s deposit? answer: 2. You set up a college fund in which you pay $4000 each year at the beginning of the year. How much money...
Case 2: By the end of each year, you contribute an equal amount of $3,300 per year to your retirement fund portfolio, which earns an annual nominal return of 11.25% averagely in the long term. The annual contribution continues for 36 years until you retire. (Note: All tax concerns are ignored.) (a) Ignoring the annual inflation. By the time of your retirement, how much nominal money value would you have in your portfolio? (b) Again, ignoring the annual inflation. For...
Imagine you are 25 years old right now. You would like to retire in 40 years (at age 65). You would like to fund your retirement. You would like to have enough saving to withdraw $50,000 each year in retirement and you want to plan for 20 hears (the last withdrawal is at age 85). You will earn 7% annually on your saving before you retire. Then once you retire, you will move your nest egg into a safer investment,...
You plan to invest your money either in a Bank CD paying 3% per year or a Mutual fund with an expected return of 6%. You have $300,000 to invest for 7 years. How much more money will you have at the end of 7 years if you invest in the Mutual fund? $367,491 $227,682 $198,671 $128,540 $ 82,127 On August 1, you borrow $180,000 to buy a house. The mortgage rate is 7.0 percent. The loan is to be...
You are planning for a very early retirement. You would like to retire at age 40 and have enough money saved to be able to draw $240,000 per year for the next 30 years (based on family history you think you'll live to age 70 You plan to save for retirement by making 10 equal annual installments from age 30 to age 40 into a fairly risky investment fund that you expect will earn 14% per ar. You will leave...
You have turned 40 years old and have recently switched to a new job. You have $200,000 in the retirement plan from your former employer. You will roll that money into the retirement plan of the new employer. In addition, you will contribute $10,000 each year into your new employer’s plan. The rolled-over money and the new contributions both earn an 8 percent return. How much money will you able to withdraw each year for the 20 years after your...
*** Please show me how to do this in Excel*** 2. You have turned 40 years old and have recently switched to a new job. You have $200,000 in the retirement plan from your former employer. You will roll that money into the retirement plan of the new employer. In addition, you will contribute $10,000 each year into your new employer’s plan. The rolled-over money and the new contributions both earn an 8 percent return. A) How much money would...
If you invest $4,000 at the end of each year at 8% for 40 years, how much will you have in 40 years?
If you invest $3,000 at the end of each year at 8% for 40 years, how much will you have in 40 years?