Question

In: Accounting

Scenario 1 In 2017, Joe and Michelle finally finished school and each accepted a job making...

Scenario 1

In 2017, Joe and Michelle finally finished school and each accepted a job making $75,000 each. They heard it was a great idea to start contributing right away to their 401K and have each put away $12,000 a year. During the next five years, they are enjoying life. They spend a bunch of money on travel both in the U.S. and around the world. They each bought a brand new car, one got a BMW and one got a Acura RDX. They incurred over $30,000 in credit debt and still have student loans of $50,000 each.

In 2022, at the age of 30, they found out they were having a baby girl. They are super excited but realized things were going to change. They decided they want to buy a house. Each of their salaries have increased by 5% per year so that’s been great. They’ve been stacking some money aside and have $80,000 for a down payment. They are feeling good about their 401K, as they have each continued to contribute $12,000 each since they started working 5 years ago. Unfortunately, they still have credit card debt of $30,000, resulting in minimum payments of $850 a month, they have student loan debt with monthly payments of $1,200 a month, and car payments totaling $1,250 a month. They also spend a bunch of money on travel, insurance, and dinners out.

They go talk to a mortgage broker and find out what they need to do to qualify for a new house. They could qualify for a mortgage equal to no more than 28% of their gross monthly income but their total outstanding debt (including mortgage, credit card debt, student loan debt and car payments) cannot exceed 40% of gross monthly income. They could get an interest rate of 5.5% for a 30 year mortgage but they must have a credit score equal to or above 720. If they have a score less than that, the interest rate goes up - up to 6.5% if their credit score is below 720 and to 7.5% if it is below 700. If the credit score is less than 680, they can’t qualify for a house at all.

They were a bit worried because they had paid late on their credit card twice in the past year. They found out their score was a 690. In any case, they were happy they could buy a house but concerned about what they could afford.

The mortgage broker also told them they would need 4% in closing costs, 20% down payment for a 30 year mortgage. They are really hoping to buy that $500,000 house inside the beltline.

How big a house could they afford (i.e. how much of a mortgage will they qualify for)?

Moving on, they did buy a house but struggled with cash flow. As soon as they bought a house, in 2022, they stopped contributing to their 401K and did not contribute again until their kids were grown up – they were 48. They really wanted to retire when they were 60 and were nervous that they would not have enough money to do it. They panicked and started maximizing their 401K contributions again and contributed $12,000 each for the next 12 years. The 401K earned on average, 8% per year on the money invested.

How much will they have for retirement from their 401K if they both retire at 60?

How much would they have had if they contributed just 6,000 a year (combined) while the kids were growing up (instead of nothing)?

How much would they have had if they continued to contribute $24,000 (combined) from the time they were 25 until they reached age 60?

Solutions

Expert Solution

If both retire at 60, the total that they will have for retirement from their 401k would be $ 10,158,384

Calculation:

Initial Contribution per year $ 12000
Time till contribution made 5 Years
Rate of interest 8%
Value of 301 K as on year ending 2021 $ 70,399
Value of 301 K as on year ending 2077 $ 4,851,467
Second contribution per year from age 48 12000
Time to retirement 12
Rate of interest 8%
Value of 301 K as on year ending 2077 227,726
Total value of 301K on retirement for one 5,079,192
For both of them 10,158,384

If they continued contributing 6000 a year, then they would have $ 19,890,011.

Initial Contribution per year $ 12000
Time till contribution made 5 Years
Rate of interest 8%
Value of 301 K as on year ending 2021 $ 70399
Value of 301 K as on year ending 2077 $ 4,851,467
Second contribution per year from age 48 6000
Time to retirement 55
Rate of interest 8%
Value of 301 K as on year ending 2077 5,093,539
Total value of 301K on retirement for one 9,945,006
For both of them 1,9890,011

If they continued to contribute $ 24,000 they would have $ 30,077,119 in their retirement account 401K

Initial Contribution per year $ 24000
Time till contribution made 60
Rate of interest 8%
Value of 301 K as on year ending 2077 $ 30,077,119

Related Solutions

Paul Jordan has just graduated from high school and has accepted the job of help desk...
Paul Jordan has just graduated from high school and has accepted the job of help desk specialist in the home office of the DurandOil Co. As a customer service representative at the help desk, Paul answers customer questions by phone, fax, e-mail, and web-based technologies. Software is provided to assist help desk specialists in quickly finding answers to commonly asked questions about aboutparticular products and services. It is your plan, as administrative manager, to have each worker, such as Paul,...
On January 3, 2017, Carl Castro, a construction worker from Phoenix, Arizona, accepted a job in...
On January 3, 2017, Carl Castro, a construction worker from Phoenix, Arizona, accepted a job in San Diego, California, at a large residential development. He's not sure how long the construction will go on, but it is projected to be at least three years. He gave up his apartment in Arizona and leased a small house in California. He obtained a California driver's license. He plans to drive back to Arizona to visit friends and family for long weekends whenever...
1. Rick, Mary, and Joe formed a partnership on January 1, 2017,with investments of $100,000,...
1. Rick, Mary, and Joe formed a partnership on January 1, 2017, with investments of $100,000, $150,000, and $200,000, respectively. For division of income, they agreed to (1) interest of 10% of the beginning capital balance each year, (2) annual compensation of $10,000 to Mary, and (3) sharing the remainder of the income or loss in a ratio of 20% for Rick, and 40% each for Mary and Joe. Net income was $150,000 in 2017 and $180,000 in 2018.Each partner...
Scenario 1 - You are working on a mental health inpatient unit and just finished admitting...
Scenario 1 - You are working on a mental health inpatient unit and just finished admitting a patient with schizophrenia who stopped taking his medications three weeks ago. The patient is hallucinating but is not aggressive. The patient appears disheveled with poor hygiene. The hospitalist asks you to participate in treatment planning and has a few questions for you. Using the information from your textbook, develop appropriate answers regarding the assessment and treatment options for this patient. List three positive...
1) Mighty Joe company purchases merchcandise for $12,000 on Dec 1, 2017, by issuing a $12,000,...
1) Mighty Joe company purchases merchcandise for $12,000 on Dec 1, 2017, by issuing a $12,000, 10%, 30 day note to the supplier. Record the journal entry for the issuance of the note. Do not forget journal entry descriptions. 2.) Jaxon Company records gross salaries of $50,000 for September 30, 2017. FICA taxes are 8% of gross salaries, the federal unemployment tax rate is 0.6% because the state unemployment tax rate is 5.4%. Federal income tax withholdings amounted to $5,500...
For each scenario, indicate whether it is an example of making a probability statement (about samples,...
For each scenario, indicate whether it is an example of making a probability statement (about samples, using knowledge about a population or parameters) or of inference (about a population or parameter, using data), briefly explaining why (1 sentence). (Example format: “Inference, because ___.”) a) Using a percentile chart, we figure out how likely it is one of the next 20 babies born in this hospital will be above the 99th percentile for weight. b) Through census data we know the...
Scenario 1: You are playing soccer and your team has just finished their third game of...
Scenario 1: You are playing soccer and your team has just finished their third game of the day. The day has been very hot with temperatures in the 90s with no cloud coverage. Suddenly, one of your teammates collapses. They seem to not be fully awake and do not respond to questions you ask them. Their breathing is rapid and shallow, and they are unable to get up from the ground. Their skin is very red and hot to the...
1. Mention three main ideas of the classical school, which were accepted by Karl Marx .
1. Mention three main ideas of the classical school, which were accepted by Karl Marx .
An inspector has the job of checking a screw-making machine at the start of each day....
An inspector has the job of checking a screw-making machine at the start of each day. She finds that the machine needs repairs pairs one day out of ten. When the machine does need repairs, all the screws it makes are defective. Even when the machine is working properly, 5% of the screws it makes are defective; these defective screws are randomly scattered through the day's output. Use a calculator to get approximate answers to the following lowing questions. What...
Facebook Investigation Scenario Part 1 Spring 2017 Note: the following scenario is fictional as are all...
Facebook Investigation Scenario Part 1 Spring 2017 Note: the following scenario is fictional as are all parties named in the story Initial Complaint: March 20, 2017– 8:41 AM. Mary Jones, a junior at the University of New Haven has contacted local police stating that sometime between midnight on October 11th, 2016 and 8 am on March 20, 2017, her ex-fiancé, Pete Sampson, posted semi-nude pictures of Ms. Jones on his Facebook page and also called Ms. Jones several derogatory names...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT