Suppose karen has $2000 each month that she can allocate between mortgage payments and retirement. That is, if she pays $1200 toward her mortgage, then she can put the remaining $800 into her retirement account each month. She plans to retire in 30 years. If she goes with the 15 year home loan, then the first 15 years she will have to split the $2000 between mortgage and retirement, but then the last 15 years she can put all $2000 into her retirement account. If she goes with the 20 year home loan, then the first 20 years she will have to split the $2000 between mortgage and retirement, but then the last 10 years she can put all $2000 into her retirement account. If she goes with the 30 year home loan, then she will split the $2000 between mortgage and retirement for all 30 years. Her best retirement option offers her a nominal rate of 5.5%, compounded monthly. Calculate the value of her retirement account in 30 years under each of the 3 plans. Which plan will give her the most in her retirement account? Considering the amount of money she will LOSE through interest on her home loan AND the amount of money she will GAIN on interest through her retirement account, which of the 3 plans is best?
Suppose karen has $2000 each month that she can allocate between mortgage payments and retirement. That is, if she pays $1200 toward her mortgage, then she can put the remaining $800 into her retirement account each month. She plans to retire in 30 years. If she goes with the 15 year home loan, then the first 15 years she will have to split the $2000 between mortgage and retirement, but then the last 15 years she can put all $2000 into her retirement account. If she goes with the 20 year home loan, then the first 20 years she will have to split the $2000 between mortgage and retirement, but then the last 10 years she can put all $2000 into her retirement account. If she goes with the 30 year home loan, then she will split the $2000 between mortgage and retirement for all 30 years. Her best retirement option offers her a nominal rate of 5.5%, compounded monthly. Calculate the value of her retirement account in 30 years under each of the 3 plans. Which plan will give her the most in her retirement account? Considering the amount of money she will LOSE through interest on her home loan AND the amount of money she will GAIN on interest through her retirement account, which of the 3 plans is best?
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 8E
Related questions
Question
Part B) Suppose karen has $2000 each month that she can allocate between mortgage payments and retirement. That is, if she pays $1200 toward her mortgage, then she can put the remaining $800 into her retirement account each month. She plans to retire in 30 years.
- If she goes with the 15 year home loan, then the first 15 years she will have to split the $2000 between mortgage and retirement, but then the last 15 years she can put all $2000 into her retirement account.
- If she goes with the 20 year home loan, then the first 20 years she will have to split the $2000 between mortgage and retirement, but then the last 10 years she can put all $2000 into her retirement account.
- If she goes with the 30 year home loan, then she will split the $2000 between mortgage and retirement for all 30 years.
Her best retirement option offers her a nominal rate of 5.5%, compounded monthly. Calculate the value of her retirement account in 30 years under each of the 3 plans. Which plan will give her the most in her retirement account? Considering the amount of money she will LOSE through interest on her home loan AND the amount of money she will GAIN on interest through her retirement account, which of the 3 plans is best?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning