Question

In: Accounting

The user plans to invest money in a variable rate CD for the next 5 years....

  1. The user plans to invest money in a variable rate CD for the next 5 years. Have the user input the amount of money that they will invest today. The annual interest rate for the CD can vary from 0% to 10% (whole percentages only). Use the RANDBETWEEN function to predict the annual interest rate for the CD. Calculate how much money the user will have at the end of the five years.

Note: This question is from Excel for accounting, so it should be calculated in excel format.

Solutions

Expert Solution


Related Solutions

You plan to invest an amount of money in five (5) year certificate of deposit (CD)...
You plan to invest an amount of money in five (5) year certificate of deposit (CD) at your bank. The stated interest rate applied to the CD is 12 percent, compounded monthly and paid out at the end of the five years. How much must you invest today if you want the balance in the CD account to be $30,000 in seven (7) years? (Hint:Need to adjust time and interest rate for monthly compounding - e.g., time is 84 periods,...
A company plans to invest in a new manufacturing project over the next 12 years. The...
A company plans to invest in a new manufacturing project over the next 12 years. The project will require an initial investment of $65,000, and an additional investment of $26,000 in Year 5. Starting in Year 2, the company will reduce their labour costs by $14,500 a year for the next 5 years, and $9000 a year for the next 4 years. At the end of the project, there will be a residual value of $24,000. If the company’s cost...
Druscilla Lopez just received $10,755 and plans to invest it for 8 years. The interest rate...
Druscilla Lopez just received $10,755 and plans to invest it for 8 years. The interest rate paid on an 8 year risk-free investment is 0.1. The amount Druscilla expects to have in 8 years is:
Bart is a junior in college. He plans to invest equal, annualamounts starting 5 years...
Bart is a junior in college. He plans to invest equal, annual amounts starting 5 years from now for 7 consecutive years in order to accumulate a total of $49,000 at the end of 15 years. If the funds earn 8% per year, what is the required amount of each deposit?
Explain how to ladder a CD? Give an example Why invest your money in a roth...
Explain how to ladder a CD? Give an example Why invest your money in a roth IRA? Two reasons What is more liquid, a CD or a piece of property you own? Why?
CASE #5 APR vs EAR Mary Jo plans to invest some money so that she has...
CASE #5 APR vs EAR Mary Jo plans to invest some money so that she has $8,000 at the end of three years. Option A Option B Option C Option D APR 5.19% 5.11% 5.20% 5.40% m/per year 365 12 4 1 How much should she invest today given the choices above? What is her best choice? What is the EAR for each account? Support your decision in question 2. Physical therapy equipment purchase Your firm needs to buy additional...
John plans to invest $200 at the end of every quarter for next 2 years. Assume that today is January 1st, 2020.
John plans to invest $200 at the end of every quarter for next 2 years. Assume that today is January 1st, 2020. He expects to earn 10% annual rate of return with monthly compounding.2.a Calculate the interest rate to be applied2.b Calculate the future value at the end of 2 years (December 31st, 2021)2.c Calculate the present value as on today (January 1st, 2020)
Joyce Bromfield has $30,000 to invest for 5 years. She will allocate her money to government...
Joyce Bromfield has $30,000 to invest for 5 years. She will allocate her money to government Treasury Bills (T-Bills), mutual fund A, and mutual fund B as follows: $4,500 in T-bills; $13,500 in A and $12,000 in B. Fund A has a front-end fee of 5%, MER of 2% and no rear-end fee. Fund B has no front-end fee, MER of 2.5%, and rear-end fee of 5%. Assume that the appropriate discount rate to compare fund fees is 5%. The...
Joyce Bromfield has $30,000 to invest for 5 years. She will allocate her money to government...
Joyce Bromfield has $30,000 to invest for 5 years. She will allocate her money to government Treasury Bills (T-Bills), mutual fund A, and mutual fund B as follows: $4,500 in T-bills; $13,500 in A and $12,000 in B. Fund A has a front-end fee of 5%, MER of 2% and no rear-end fee. Fund B has no front-end fee, MER of 2.5%, and rear-end fee of 5%. Assume that the appropriate discount rate to compare fund fees is 5%. The...
MM company expects to grow at a rate of 25per cent for the next 5 years...
MM company expects to grow at a rate of 25per cent for the next 5 years and then settle to a constant-growth rate of 6 per cent. The company's recent dividend was $2.35. The required rate of return is 15 per cent a.Find the present value of the dividends during the rapid growth b.What is the price of the share at the end of year c.What is the price of the share today
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT