801094-11152013-122255-PM-226221004

You have just made your first $5,500 contribution to your retirement account. Assuming you earn a return of 10 percent per year and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing? (Does this suggest an investment strategy?) Input area: Present value Interest rate Number of years Number of years (Use cells A6 to 89 from the given information to complete this question. Your answer should be a positive value.) Output area: $5,500 10% 45 35 Future value Future value $

You are looking to invest your savings and want to earn a 10% annualized return. You can choose from the following three options:Project A: You will receive $100 at the end of two years.Project B: You will receive $50 at the end of one year and another $50 at the end of two years.Project C: You will receive $80 at the end of one year and another $20 at the end of two years.Calculate the present value of each option, which option should you pick?

(Use Calulator or Formula Approach) You are offered the opportunity to put some money away for retirement. You will receive five annual payments of $25,000 each beginning in 40 years. How much would you be willing to invest today if you desire an interest rate of 12%?

Pick a target retirement age. It can be any age you want. Using your real life current age, and your target retirement age, how much would you need to invest each month in order to reach $1,000,000 by the time you want to retire. Assume you can earn 12% APY on your investing and you have $0 now. You can use annual values for APY and PMT to solve this. If you had $1,000,000 and you wanted to live until age 100, how much could you spend each year, starting from your target retirement age, and spending the same amount each year until age 100? Assume your savings will earn 4% APY after you retire, and you will have nothing left at the end.

You plan to invest $12,000 per year into a retirement account. If you earn a compound annual rate of return of 11%, how many years will it take you to reach a balance of $1,500,000?   Question 2 options:   22.83   25.79   24.24   21.09   26.76

You are trying to decide how much to save for retirement. Assume you plan to save $4,500 per year with the first investment made one year from now. You think you can earn 6.0% per year on your investments and you plan to retire in 45 years, immediately after making your last $4,500 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $4,500 per year, you wanted to make one lump-sum investment today for your retirement that will result in the same retirement saving, how much would that lump sum need to be? c. If you hope to live for 16 years in retirement, how much can you withdraw every year in retirement (starting one year after retirement) so that you will just exhaust your savings with the 16th withdrawal (assume your savings will continue to earn 6.0% in retirement)? d. If, instead, you decide to withdraw $191,000 per year in retirement (again with the first withdrawal one year after retiring), how many years will it…

When you retire, you plan to draw $50,000 per year from your retirement accounts, which will be earning 6% per year.   Find PV Annuity: If you wish to do that for 10 years starting one year after you retire, what does the balance in your retirement account have to be when you retire? Find PV Annuity: If the account will be earning 3% per year, and you wish to do that for 20 years starting on the day you retire, what does the balance in your retirement account have to be when you retire?

Please help me with this question :) A detailed answer will be much appreciated.

a) Suppose you have $10,000 to invest in a savings account, and you have two investment options available to you. Option A is a savings account that pays an annual interest rate of 5% with compounding annually, while option B is a savings account that pays an annual interest rate of 4.5% with compounding quarterly. Both options have a 5-year term. Which option should you choose to maximize your return on investment? Why? b) Which factor do you think played a critical role in your investment decision making?

In planning for your retirement, you have decided that you would like to be able to withdraw $60,000 per year for a 10 year period. The first withdrawal will occur 20 years from today. a. What amount must you invest today if your return is 10% per year? b. What amount must you invest today if your return is 15% per year?

Your financial planner offers you two different investment plans. Plan X is a $22, 000 annual perpetuity. Plan Y is an annuity lasting 20 years and an annual payment, $30,000. Both plans will make their first payment one year from today. At what discount rate would you be indifferent between these two plans

An investment pays you $100 at the end of each of the next 3 years. The investment will then pay you $200 at the end of year 4, $300 at the end of year 5, and $500 at the end of year 6. If the rate of interest earned on the investment is 8%, what is the present value of this investment? What is its future value?   How do you solve this with excel?

An example of how to calculate net present value is done using the following. Imagine you have been given an investment opportunity wherein if you invest $1,200 today, you will receive $650 dollars at the end of each year for the next 5 years. You could separately choose to invest your money at 10% interest each year. Should you take the investment opportunity? To find the answer, use the NPV formula:

Please  put the solution in an excel spreadsheet to get the correct answer and please explain the steps for each formula in excel  You are offered the opportunity to put some money away for retirement. You will receive 10 annual payments of $5,000 each beginning in 26 years. If you desire an annual interest rate of 12% compounded monthly, answer the following two questions:   How much would you be willing to invest today? How much would the money (that you will be willing to invest today) be worth at the end of your last payment (i.e., in year 35)?   Amount that you would be willing to invest today = PV = $5,000/(1.01)26*12 + $5,000/(1.101)27*12 + $5,000/(1.01)28*12 + $5,000/(1.01)29*12 + $5,000/(1.01)30*12 + $5,000/(1.01)31*12 + $5,000/(1.01)32*12 + $5,000/(1.01)33*12 + $5,000/(1.01)34*12 + $5,000/(1.01)35*12 = $1,388.638 Amount that would the money worth at the end of your last payment = FV = $1388.64 * (1+ 0.01)35*12 = $90691.52

Your investment advisor wants you to purchase an annuity that will pay you $81,491 after 10 years. If you require a 7.8% return, what is the most you should pay for this investment? (Keep 2 decimal places)

Suppose you wish to retire forty years from today. You determine that you need $50,000 per year once you retire, with the first retirement funds withdrawn one year from the day you retire. You estimate that you will earn 6% per year on your retirement funds and that you will need funds up to 25 years after retirement. Use the PV of an ordinary annuity due formula.  a) Calculate the amount you must deposit in an account today so that you have enough funds for retirement b) Calculate the amount you must deposit each year, starting one year from today, so that you have enough funds for retirement.

Answer the questions ASAP.

You purchase an annuity that will pay you $100 every three months for five years. The first $100 payment will be made as soon as you purchases the investment. If your required rate of return is 9% , how much should you be willing to pay for this investment? Group of answer choices   $1,596.82 $1,632.29 $1,759.34 $1,510.46

You are trying to decide how much to save for retirement. Assume you plan to save $4,000 per year with the first investment made one year from now. You think you can earn 7.0​% per year on your investments and you plan to retire in   29 ​years, immediately after making your last $4,000 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $4,000 per​ year, you wanted to make one​ lump-sum investment today for your retirement that will result in the same retirement​ saving, how much would that lump sum need to​ be? c. If you hope to live for 28 years in​ retirement, how much can you withdraw every year in retirement​ (starting one year after​ retirement) so that you will just exhaust your savings with the 28th withdrawal​ (assume your savings will continue to earn 7.0​% in​ retirement)? d.​ If, instead, you decide to withdraw $70,000 per year in retirement​ (again with the first withdrawal one year after​ retiring), how…

You are considering two savings options. Both options offer a rate of return of 8.2 percent. The first option is to save $1,500, $1,500, and $2,000 at the end of each year for the next three years, respectively. The other option is to save one lump sum amount today. You want to have the same balance in your savings account at the end of the three years, regardless of the savings method you select. If you select the lump sum method, how much do you need to save today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

You are trying to decide how much to save for retirement. Assume you plan to save $5,000 per year with the first investment made one year from now. You think you can earn 10.0% per year on your investments and you plan to retire in 43 years, immediately after making your last $5,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $5,000 per year, you wanted to make one lump-sum investment today for your retirement that will result in the same retirement saving, how much would that lump sum need to be? c. If you hope to live for 20 years in retirement, how much can you withdraw every year in retirement (starting one year after retirement) so that you will just exhaust your savings with the 20th withdrawal (assume your savings will continue to earn 10.0% in retirement)? d. If, instead, you decide to withdraw $300,000 per year in retirement (again with the first withdrawal one year after retiring), how many years will it…

Assume that you contribute $340 per month to a retirement plan for 25 years. Then you are able to increase the contribution to $680 per month for another 25 years. Given a 9.0 percent interest rate, what is the value of your retirement plan after the 50 years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Future value of multiple annuities

in planning for your retirement, you would like to withdraw $80,000 per year for 17 years, the first withdrawal will occur 20 years from today. A- what amount must you invest today if your return is 10% per year? B-What amount must you invest today if your return is 15% per year?

Suppose you are planning for retirement. At thebeginning of this year and each of the next 39 years,you plan to contribute some money to your retirementfund. Each year, you plan to increase your retirement contribution by $500. When you retire in 40years, you plan to withdraw $100,000 at the beginning of each year for the next 20 years. You assumethe following about the yields of your retirementinvestment portfolio:■ During the first 20 years, your investments willearn 10% per year.■ During all other years, your investments will earn5% per year.All contributions and withdrawals occur at thebeginnings of the respective years.a. Given these assumptions, what is the least amountof money you can contribute this year and stillhave enough to make your retirement withdrawals?b. How does your answer change if inflation is 2%per year and your goal is to withdraw $100,000 peryear (in today’s dollars) for 20 years?

You intend to make the annual maximum contribution of $6,000 to your Roth IRA (individual retirement account) at the end of each year for the next 30 years.  If you can earn 10 percent on your contributions, how much will you have at the end of the thirtieth year? Include the follwing variables to help you solve the problem: m Nper (or N) =n*m Rate (or I/Y)=i/m PV PMT FV

Assume that you contribute $150 per month to a retirement plan for 20 years. Then you can increase the contribution to $274 per month for another 20 years, and finally, $424 per month for the last 10 years. Given a 7 percent interest rate, what is the value of your retirement plan after the 50 years? Note: Do not round intermediate calculations and round your final answer to 2 decimal places. Value of retirement assets

You have RM 5,000.00 you want to invest for the next 45 years until retirement. You are offered an investment plan that will pay you 6 percent per year for the next 15 years and 10 percent per year for the last 30 years. 1) Draw a graph that illustrates the relationship between interest rates and the present value of RM1,000.00 to be received in one year.2) Compute the amount you will have at the end of the 45 years.3) Calculate the amount you would have if the investment plan pays 10 percent for the first 15 years and 6 percent per year for the next 30 years.