Question
In: Finance
Your 40-year clients, who have a 12-year old child, plan to retire at the age of...
Your 40-year clients, who have a 12-year old child, plan to retire at the age of 62. Assume 360-day year and 30-day month in your calculations.
They have a current salary at an annual rate of $144000, being paid equally at the end of each month. They expect a 3% raise in their salary every year until they retire. They deposit 12% of their monthly salary to their 401(k) account that generates an annual rate of return of 10%, compounded daily. In addition, their employer matches their contribution with 5% of their salary to the same 401(k) account.
At the end of each year, your clients will receive a bonus of 15% of their annual salary. Your clients commit to deposit part of their annual bonus, $15,000, in a 529 Plan account each year for financing their child’s college education. They will keep contributing to the 529 account until their child finishes college. Any remaining amount from the annual bonus check will be deposited in an IRA account. Both of these accounts are expected to generate an annual rate of return of 9%, compounded monthly.
1. Determine the cash flows pattern of their contributions to the IRA account; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. And calculate their IRA account balance upon their retirement.
2. Determine the cash flows pattern of their contributions to the 529 Plan account; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. And calculate the 529 Plan account balance at the time their child starts college.
Solutions
Expert Solution
| Assumptions | 360 day year and 30 days a month | Return | 9% | compounded monthly | |||||||||||||||||||
| Current Salary | $ 144,000 | Rate of Return | 0.8% | ||||||||||||||||||||
| Rise | 3% | ||||||||||||||||||||||
| 12% deposited to 401K account | |||||||||||||||||||||||
| End of each year | 15% | bonus of annual salary | |||||||||||||||||||||
| $ 15,000 | deposited in 529 plan account | ||||||||||||||||||||||
| Remaining amount deposited in an IRA account | |||||||||||||||||||||||
| $ 6,600 | |||||||||||||||||||||||
| IRA and 529 Cash Schedule | |||||||||||||||||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| Salary | $ 144,000 | $ 148,320 | $ 152,770 | $ 157,353 | $ 162,073 | $ 166,935 | $ 171,944 | $ 177,102 | $ 182,415 | $ 187,887 | $ 193,524 | $ 199,330 | $ 205,310 | $ 211,469 | $ 217,813 | $ 224,347 | $ 231,078 | $ 238,010 | $ 245,150 | $ 252,505 | $ 260,080 | $ 267,882 | $ 275,919 |
| Bonus | $ 21,600 | $ 22,248 | $ 22,915 | $ 23,603 | $ 24,311 | $ 25,040 | $ 25,792 | $ 26,565 | $ 27,362 | $ 28,183 | $ 29,029 | $ 29,899 | $ 30,796 | $ 31,720 | $ 32,672 | $ 33,652 | $ 34,662 | $ 35,702 | $ 36,773 | $ 37,876 | $ 39,012 | $ 40,182 | $ 41,388 |
| 529 Plan | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 |
| IRA account | $ 6,600 | $ 7,248 | $ 7,915 | $ 8,603 | $ 9,311 | $ 10,040 | $ 10,792 | $ 11,565 | $ 12,362 | $ 13,183 | $ 14,029 | $ 14,899 | $ 15,796 | $ 16,720 | $ 17,672 | $ 18,652 | $ 19,662 | $ 20,702 | $ 21,773 | $ 22,876 | $ 24,012 | $ 25,182 | $ 26,388 |
| Compounded Annual Return for IRA Account | $ 47,450 | $ 47,640 | $ 47,565 | $ 47,263 | $ 46,766 | $ 46,104 | $ 45,304 | $ 44,388 | $ 43,378 | $ 42,291 | $ 41,144 | $ 39,950 | $ 38,723 | $ 37,472 | $ 36,208 | $ 34,939 | $ 33,672 | $ 32,412 | $ 31,165 | $ 29,936 | $ 28,728 | $ 27,545 | $ 26,388 |
| Compounded Annual Return for 529 Account | $ 107,841 | $ 98,593 | $ 90,137 | $ 82,407 | $ 75,340 | $ 68,878 | $ 62,971 | $ 57,571 | $ 52,633 | $ 48,119 | $ 43,993 | $ 40,220 | $ 36,770 | $ 33,617 | $ 30,734 | $ 28,098 | $ 25,688 | $ 23,485 | $ 21,471 | $ 19,630 | $ 17,946 | $ 16,407 | $ 15,000 |
| I used compounded monthly because in question it is given that the rate of return is 9% compounded monthly | |||||||||||||||||||||||
jeff jeffy answered 2 years agoRelated Solutions
Your 40-year clients, who have a 12-year old child, plan to retire at the age of...
Your 40-year clients, who have a 12-year old child, plan to
retire at the age of 62. Assume 360-day year and 30-day month in
your calculations.
They have a current salary at an annual rate of $144000, being
paid equally at the end of each month. They expect a 3% raise in
their salary every year until they retire. They deposit 12% of
their monthly salary to their 401(k) account that generates an
annual rate of return of 10%, compounded...
Your 40-year clients, who have a 12-year old child, plan to retire at the age of...
Your 40-year clients, who have a 12-year old child, plan to
retire at the age of 62. Assume 360-day year and 30-day month in
your calculations.
They have a current salary at an annual rate of $144,000, being
paid equally at the end of each month.
They expect a 3% raise in their salary every year until they
retire.
They deposit 12% of their monthly salary to their 401(k) account
that generates an annual rate of return of 10%, compounded...
You are currently 40 years old and intend to retire at age 60. To make your...
You are currently 40 years old and intend to retire at age 60.
To make your retirement easier, you intend to start a retirement
account. At the END of each of years, you will deposit some money
to your retirement account till your retire. You expect the account
will earn 7% per year. After retirement at age 60, you want to
withdraw $10,000 from your retirement account at the END of each
year for 10 years. How much money should...
You have a couple who are 31 years old, and want to retire at the age...
You have a couple who are 31 years old, and want to retire at
the age of 67. Knowing that, the couple has a combined annual
income of $95,000 today.
1. They are curious to find out if college costs $90,000 per
year when their child gets into college in 19 years, how much is
the total cost of a college education (that lasts for 4 years) in
today’s dollars if the cost of money is 8%? Assume you pay...
You are 40 years old and want to retire at age 65. Each year, starting one...
You are 40 years old and want to retire at age 65. Each year,
starting one year from now, you will deposit an equal amount into
an investment account that pays 4% interest. The last deposit will
be on your 65th birthday. On your 65th birthday, you will switch
the accumulated savings into a safer bank account that pays only
4.2% interest. You will withdraw your annual income of $110,000 at
the end of that year (on your 66th birthday)...
You are 40 years old and want to retire at age 60. Each year, starting one...
You are 40 years old and want to retire at age 60. Each year,
starting one year from now, you will deposit an equal amount into
an investment account that pays 4.6% interest. The last deposit
will be on your 60th birthday. On your 60th birthday, you will
switch the accumulated savings into a safer bank account that pays
only 4.2% interest. You will withdraw your annual income of
$130,000 at the end of that year (on your 61st birthday)...
Your clients, both just turned 40, will retire when they turn 62. They have a current...
Your clients, both just turned 40, will retire when they turn
62. They have a current salary at an annual rate of ($10,000*salary
scalar + $100,000), being paid equally at the end of each month.
They expect a 3% raise in their salary every year until they
retire. They deposit 12% of their monthly salary in their 401(k)
account that generates an annual rate of return of 10%, compounded
daily. In addition, their employer matches their contribution with
5% of...
Connor is not married and supports Connor's 12 year old child who lives with Connor and...
Connor is not married and supports Connor's 12 year old child
who lives with Connor and has gross income of $2,650 (the child's
gross income). Connor works as a self-employed realtor and earned
commissions of $146,000 during 2019. Connor’s business expenses
were $18,900 and the only other income was interest of $7,300.
Connor’s other information follows:
Contribution to solo(k) retirement
plan
$ 5,500
Loss on sale of Alphatech stock held 2
years
-3,200
Mortgage interest on primary residence 6,950...
A couple will retire in 40 years; they plan to spend about $37,000 a year in...
A couple will retire
in 40 years; they plan to spend about $37,000 a year in retirement,
which should last about 20 years. They believe that they can earn
7% interest on retirement savings.
a. If
they make annual payments into a savings plan, how much will they
need to save each year? Assume the first payment comes in 1 year.
(Do not round intermediate calculations. Round your answer
to 2 decimal places.)
b.
How would the answer to part...
A couple will retire in 40 years; they plan to withdraw $39,000 a year in retirement,...
A couple will retire in 40 years; they plan to withdraw $39,000
a year in retirement, and they
will make 20 withdraw. They believe that they can earn 8%
interest on the retirement
savings.
- If they make annual deposit into their retirement savings, how
much will they need to save
each year? Assume the first deposit comes at the end of the
first year, and the first withdraw
comes at the end of year 41.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Jane is the financial manager for Alpha Corporation. She has been asked to perform a lease-versus-purchase...
- 7. Choose the bond that is least polar (how would you do this without looking at...
- SCHEME [4 marks] Define a procedure called valid_date? that takes three arguments representing the year, month,...
- Suppose a company is looking to hedge a risk in the derivatives market. What, fundamentally, is...
- Training and Development assignment. Describe the usage of Computer Based Training (CBT) in McDonald's Company training...
- PUT IN JAVA PROGRAMMING LANGUAGE The Rectangle class: Design a class named Rectangle to represent a...
- Journal article summary on inter-group conflict Peer Reviewed Journal article from past 3 years. Please include...
ADVERTISEMENT