M2 _Instructor Response

profiletxhrdr

SEE ATTACHMENT!!!!! 


NEED FOLLOW-UP RESPONSE TO THE INSTRUCTOR:


ORIGINAL POSTING:


Recently, I had to choose between opening a savings account and a certificate of deposit (CD). The savings account offered 1.05% of interest and the CD, 2.75%. I had to compare both investments in a 5-year horizon in order to reach the achieved calculation. 

In this case, I relied on the Future Value (VF); which is the value that will have in the future a certain amount of money that we maintain today or that we decide to invest in a certain project. Future Value (VF) allows us to calculate how the value of the money we have today (today) will be modified considering the different investment alternatives available to us. In order to calculate the VF, we need to know the value of our money is the current moment and the interest rate that will be applied in the coming periods. Future Value is used to evaluate the best alternative as to what to do with our money today. Also to see how the value of money changes in the future.

The first alternative has an FV of $5,268.07, while the second alternative offered an FV of $5,726.37. The FV of the CD is greater than the savings account; as a result, it means a more attractive investment than the alternative. 

Explanation:

Task 2

◦Determine the present value of $75,000 discounted at 6% over 6 years.

FV= $75,000

Rate= 6%

Period= 6 years

PV = $52,872.04

 Determine the future value of $100,000 invested today at 4% for 5 years.

FV = $121,665.29

Rate= 4%

Period= 5 years

PV = $100,000

 Determine what monthly payment will need to be invested if you have $10,000 today and want it to grow to $100,000 over 20 years at 4.5%.

Monthly payment = $193.66

PV= $10,000

FV= $100,000

Period= 20 years

Rate= 4.5%

References

Patnaik, P. (2009). The value of money

Staff, I. (2018, March 6). Time Value of Money - TVM. Retrieved from https://www.investopedia.com/terms/t/timevalueofmoney.asp


INSTRUCTOR:


Task 2:


=PV(0.06,6,0,75000)


What would be the formula if the interest rate were compounded monthly?


THE ORIGINAL ASSIGNMENT AS FOR


 

  1. Download the MS6014_M2A1_workbook.xlsx template, and using the appropriate Excel financial functions, do the following:
    • Determine the present value of $75,000 discounted at 6% over 6 years.
    • Determine the future value of $100,000 invested today at 4% for 5 years.
    • Determine what annual payment will need to be invested if you have $10,000 today and want it to grow to $100,000 over 20 years at 4.5%.

Copy and paste the results of task #2 into your post underneath your response to task #1.


NEED FOLLOW-UP

  • Posted: 8 months ago
  • Due: 
  • Budget: $10
Answers 1

Purchase the answer to view it

blurred-text
  • Provided 1 ratings

    M2 Instructor Response

    NEED FOLLOW-UP RESPONSE TO THE INSTRUCTOR:


    ORIGINAL POSTING:


    Recently, I had to choose between opening a savings account and a certificate of deposit (CD). The savings account offered 1.05% of …