Question
In: Accounting
The user plans to invest money in a variable rate CD for the next 5 years....
- 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
ekkarill92 answered 1 year agoRelated 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
Latest Questions
- For Questions 1-3: consider the following code: public class A { private int number; protected String...
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
ADVERTISEMENT