The AGI of the Newtons, a married couple, is $199,000 this year. They would like to contribute to a Roth IRA. 1. What is the maximum amount this couple can contribute to a Roth IRA? Show your calculations using Microsoft Excel. 2. Now suppose that the Newtons will report AGI of less than $196,000 and put $12,000 each year into their Roth IRA for 20 years, earning an annual return of 5%. What future value will accumulate in their Roth at the end of this period?

Q: The AGI of the Newtons, a married couple, is $199,000 this year. They would like to contribute to a…

A: 2. The maximum  to contribute can be calculated as follows : Results obtained :

Q: When you retire, you plan to draw $50,000 per year from your retirement accounts, which will be…

A: Annuity is the no. of payments which are equal in size and made in equal interval of time. Person…

Q: The Kellys are planning for a retirement home. They ­estimate they will need $200,000 4 years from…

A: Here Future value of annuity required is $200,000 Interest rate = 10% Future value of annuity:…

Q: Jia has just won a $20 million lottery, which will pay her $1 million at the end of each year for 20…

A: The value which shows the equivalent worth of payment that is expected to be realized in future by…

Q: To help out with her retirement savings, Kaitlin invests in an ordinary annuity that earns 2.4%…

A: Formula  Annual payment = FV/((1+i)n-1)/i Where FV - Future value i.e. $98000 i - Interest rate i.e.…

Q: If they make annual payments into a savings plan, how much will they need to save each year ?

A: Information Provided: Retirement time = 50 years Amount to be spend = $38,000 Interest rate = 9%

Q: Meredith, who is single, would like to contribute $6,000 annually to her Roth IRA. Her AGI is…

A: Roth IRA is a scheme for contribution into retirement account by the citizens of the United States…

Q: The Kellys are planning for a retirement home. Theyestimate they will need $200,000 4 years from now…

A:

Q: Fatzamata and Maggie have $30,000 for a down payment on a future house. Their budget can accomodate…

A: Given: Amount available for downpayment : $30,000 Monthly mortgage payment: $1200 The amount owed to…

Q: Dean Gooch is planning for his retirement, so he is setting up a payout annuity with his bank. He…

A: Payout annuity is the amount that an investor receives at a regular interval after a certain period…

Q: Jake plans to contribute $3600 at the end of each year to his IRA. If he earns a return of 8.5%…

A: Future Value Future value  is the worth of any asset or any sum of money at a future date when such…

Q: You would like to have enough money saved to receive a growing annuity for 25 years, growing at a…

A: Solution-PV of growing annuityi=0.04r=0.12

Q: June Watson is contributing $2,500 each year to a Roth IRA. The IRA earns 3.4% per year. How much…

A: A concept that implies the future worth of the money is lower than its current value due to several…

Q: Your parents will retire in 19 years. They currently have $330,000 saved, and they think they will…

A: Interest rate is the rate of return to be earned from an investment for a particular period. Given:…

Q: Your uncle is about to retire, and he wants to buy an annuity that will provide him with $7,000 of…

A: Annual income (C) = $ 7000 Number of annual payments (n) = 21 Annual interest rate (r) = 5.25%

Q: Suppose a newlywed couple is planning lo buy a home two years from now. To save the down payment…

A: Computation:

Q: Mr. Handsome would like to accumulate $1 million in his pension fund. If the annual interest rate is…

A: A study that proves that the future worth of the money is lower than its current value due to…

Q: How much money will they have accumulated 30 years from now

A: Let us first determine how much we will save in the first 10 years of the saving plan. T =…

Q: Suppose you are 30 years old and would like to retire at age 60. ​Furthermore, you would like to…

A: Annuity means a series of finite number of payments which are equal in size and made in equal…

Q: You annually invest $1,000 in an individual retirement account (IRA) starting at the age of 30 and…

A: a)  Computation of my account balance:

Q: Please provide working to the solution for the question below: Suppose you are 40 years old and…

A: Solution:- When an equal amount is deposited each period, it is called annuity.  We know, Present…

Q: June Watson is contributing $2,000 each year to a Roth IRA. The IRA earns 4.4% per year. How much…

A: Ordinary annuity: In an ordinary annuity, we have to make equal payments at the end of consecutive…

Q: uppose you are 40 years old and plan to retire in exactly 20 years. 21 years from now you will need…

A: The concept of time value of money will have to be used here. As per the concept of time value of…

Q: Your uncle has $375,000 and wants to retire. He expects to live for another 25 years and to earn…

A: Present value of annuity due=(1+rate)*Annuity[1-(1+interest rate)^-time period]/rate

Q: Your parents will retire in 23 years. They currently have $300,000 saved, and they think they will…

A: Time value of money means that the worth of currency in present terms is different from the worth in…

Q: You estimate you need to supplement your social security payments with monthly withdrawals of…

A: The question is based on the concept present value of annuity payment Formula as, Pv=pmt*1-(1+r)-nr

Q: Cheryl Wilcox is planning for her retirement, so she is setting up a payout annuity with her bank.…

A: Amount to be saved monthly = Total future amount needed / Present value annuity factor for the…

Q: You have just inherited $100,000 as a lump-sum amount from your distant aunt. After depositing the…

A: In order to find the number of years taken to withdraw the amount one can use excel and in excel…

Q: Without using Excel and using the formula, Cheryl is setting up a payout annuity and wishes to…

A: Present Value of annuity refers to the present value of all the future payments of and series of…

Q: Dean Gooch is planning for his retirement, so he is setting up a payout annuity with his bank. He…

A: The annuity is a series of cash flow wherein an equal amount is paid every period.

Q: How much money does she need to pay into the annuity each quarter for the annuity to have a total…

A: Ordinary Annuity: These are payments made at the period end regularly for a period of time. The size…

Q: Becky would like to be a millionaire in 40 years. How much would she need to invest quarterly in a…

A: Given:

Q: What is the maximum amount this couple can contribute to a Roth IRA?

A: Roth IRA is a specific retirement account in which the individual has to pay taxes on the amount…

Q: Your parents will retire in 16 years. They currently have $400,000 saved, and they think they will…

A:

Q: Your parents will retire in 17 years. They currently have $310,000 saved, and they think they will…

A: Future value = present value * (1+r)^n Where r= rate of interest n= compounding year

Q: Your parents will retire in 29 years. They currently have $240,000 saved, and they think they will…

A: Number of years to retirement is 29.  The amount saved is $240,000 The amount required in 29 years…

Q: Suppose you are 40 years old and plan to retire in exactly 20 years. 21 years from now you will need…

A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one…

Q: Suppose you make an annual contribution of P9,993 each year to a college fund for a niece. He is 6…

A: Annual contribution (P) = P 9,993 Period from 6th year to 19th year (n) = 13 Annual interest rate…

Q: Gabrielle just won ​$2.7 million in the state lottery. She is given the option of receiving a of…

A: Here, Annual Payment received is $90,000 Time Period is 30 years Interest Rate is 5% One time amount…

Q: Your parents will retire in 17 years. They currently have $290,000 saved, and they think they will…

A: Future value = Present value *(1+rate)^years $2,000,000 = $290,000*(1+rate)^17 Rate = ($2,000,000 /…

Q: You annually invest $1,500 in an individual retirement account (IRA) starting at the age of 30 and…

A: Question is based on the concept of Annuity

Q: Your favorite uncle wants to give each of his favorite nieces and nephews $30,000 now while he is…

A: Future Value: The future value is the amount that will be received at the end of a certain period.…

Q: Your parents will retire in 28 years. They currently have $300,000 saved, and they think they will…

A: Investment amount (PV) = $300,000 Future value required (FV) = $2,500,000 Period (n) = 28 Years

Q: The Nelson family wants to save money to travel the world. They plan to invest in an ordinary…

A: Annuity means a series of finite number of payments which are the same in size and occurred at equal…

Q: Your parents will retire in 23 years. They currently have $290,000 saved, and they think they will…

A: The present value is $290,000.The future value is $900,000.Number of years is 23.

Q: Suppose you want to use this fund to buy a $279,000 houseboat when you retire in 40 years. How much…

A: Future Value = $279,000 Interest Rate = 4.75% Time Period = 40 Years

Q: Your parents will retire in 30 years. They currently have $350,000 saved, and they think they will…

A: Given information: Present value amount (PV) is $350,000 Future value (FV) is $1,950,000 Number of…