Question

In: Finance

Henry and Bob are both 35 years old but have been investing different amounts of money...

Henry and Bob are both 35 years old but have been investing different amounts of money for different lengths of time.

  • Henry saved $15 each month for 12 years at an average interest rate of 3.6% compounded monthly until he was 25. Then he reinvested the entire amount at 3.8% compounded monthly for 10 years.
  • Bob has been depositing $18 each month for the past 10 years into a savings account that earns an average annual interest rate of 3.8% compounded monthly.

a) Determine the total value of each of the above investments. Complete the tables or show your formula calculations as part of your solution.

Solutions

Expert 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:


Related Solutions

Bob and Donna have been married for 35 years and have filed joint returns since their...
Bob and Donna have been married for 35 years and have filed joint returns since their marriage. The couple has 3 children: Jack age 11, Bonnie age 16, and Margie age 22. All three children live with Bob and Donna. None of the children provide more than half their own support. Margie is a full time student at a local university. Margie is married. her and her husband report no tax liability on their joint return. If the couple had...
Bob and Donna have been married for 35 years and have filed joint returns since their...
Bob and Donna have been married for 35 years and have filed joint returns since their marriage. The couple has three children: Jack (age 11), Bonnie (age 16), and Margie (age 22). All three children live with Bob and Donna. In addition, none of the children provide more than half of their own support. Margie is a full-time student at a local university and does not have any gross income. Based on the situation above, answer the following questions: a....
Bob and Donna have been married for 35 years and have filed joint returns since their...
Bob and Donna have been married for 35 years and have filed joint returns since their marriage. The couple has three children: Jack (age 11), Bonnie (age 16), and Margie (age 22). All three children live with Bob and Donna. In addition, none of the children provide more than half of their own support. Margie is a full-time student at a local university and does not have any gross income. Assume the original facts, except that Margie is married. She...
Pertaining to 2017 tax laws. Bob and Donna have been married for 35 years and have...
Pertaining to 2017 tax laws. Bob and Donna have been married for 35 years and have filed joint returns since their marriage. The couple has three children: Jack (age 11), Bonnie (age 16), and Margie (age 22). All three children live with Bob and Donna. In addition, none of the children provide more than half of their own support. Margie is a full-time student at a local university and does not have any gross income. Based on the situation above,...
Mary and Bob have been married for 25 years. They are both college professors. Mary (50...
Mary and Bob have been married for 25 years. They are both college professors. Mary (50 years of age) makes $65,000 annually and Bob (60 years of age) makes $75,000 annually. Their oldest daughter is getting married. Bob and Mary would like to either 1) take out a second mortgage on their home (they can get an interest rate of 7 percent) or 2) withdraw funds from their IRAs or 3) sell their rental property. The cost of the wedding...
Warner and Augustine Robins, both 33 years old, have been married for 9 years and have...
Warner and Augustine Robins, both 33 years old, have been married for 9 years and have no dependents. Warner is the president of Dragon Lady Corporation located in Macon. The Dragon Lady stock is owned 40 percent by Warner, 40 percent by Augustine, and 20 percent by Warner’s father. Warner and Augustine received the following tax documents: 1) W-2 Form 2) Form 1099-INT 3) Form 1098 4) Letter from Macon Museum of Arts regarding their charitable contribution. These items are...
Jamie Lee and Rose Lee are both 36 years old. They have been married for six...
Jamie Lee and Rose Lee are both 36 years old. They have been married for six years, and they have a son who is 3 years old and a daughter who is almost 2 years old. Rose Lee is expecting, and the family just found out from their doctor that, instead of them being a family of three with the new baby, they are now going to be a family of five because Rose is expecting triplets. Jamie and Rose...
Over the past 35 years, there has been a marked increase in both the flow and...
Over the past 35 years, there has been a marked increase in both the flow and stock of FDI in the world economy. Discuss why FDI has grown more rapidly than world trade and world output. Site examples when possible.
Henry and Jacob have been friends for many years and decide to go into business together....
Henry and Jacob have been friends for many years and decide to go into business together. Henry is 25 years old and Jacob has just turned 17 years old two weeks ago. The have now saved up enough money to purchase a Macbook from Simon, their mutual friend, to start a graphic design business. Henry and Jacob approach you to advice on the following: 1.3 Assume the parties go to see Simon and agree that: a) They will purchase the...
Suppose that we 2 individuals, Jim-Bob and Billy-Bob, have been suffering from illnesses for 10 years....
Suppose that we 2 individuals, Jim-Bob and Billy-Bob, have been suffering from illnesses for 10 years. Jim-Bob suffers from continuous eczema (itchy and irritated skin). Billy-Bob suffers from gout (a painful swelling of the joints). Both Jim-Bob and Billy-Bob agree that Billy-Bob’s disease (gout) is MUCH WORSE than Jim-Bob’s disease. Because of an expansion of low income health insurance offerings, both Jim-Bob and Billy-Bob now have the opportunity to purchase health insurance. Who is likely to increase their consumption of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT