Answer:
Ramos Savings after taxes $9344.96
Vanessa Savings $9344.96
Explanation:
Ramos Savings:
Rate Interest rate 5%
Nper Number of years 30 (67-37)
Pmt Amount of deposit per year $5,500
FV Future value of savings at age 67 $365,413.66 (using FV function of excel with Rate=3%,Nper=30, Pmt=-5500)
Excel Command: FV(3%,30,-5500)
Taxes on savings=30%*365413.66= $109,624.10
Ramos Savings after taxes $9344.96
Vanessa Savings:
Rate Interest rate 3%
Nper Number of years 30 (67-37)
Pmt Amount of deposit per year $3,850
FV Future value of savings at age 67 $255,789.56 (using FV function of excel with Rate=3%,Nper=30, Pmt=-3850)
Excel Command: FV(3%,30,-3850)
Vanessa Savings $9344.96