In: Finance
Henry and Bob are both 35 years old but have been investing different amounts of money for different lengths of time.
a) Determine the total value of each of the above investments. Complete the tables or show your formula calculations as part of your solution.
Answer:
The question does not say whether the monthly savings were deposited at the end of month or beginning of month:
Hence please find two sets of answers:
Answer (i)
Assuming monthly savings were made at the END of MONTH each month:
Above excel with 'show formula' is as follows:
Answer (ii)
Assuming monthly savings were made at the BEGINNING of MONTH each month:
The above excel with 'show formula' is as below: