Monthly Budgeting

Using the photo attached, answer the following  c. What is Ben’s total investment value at retirement (age 65)? DO NOT USE EXCEL TO ANSWER

The case study is written below and i need help answering questions A-E please!   The Johnsons consider retirement planning. Harry Johnson’s father, William, was recently forced into early retirement at age 63 because of poor health. In addition to the psychological drawbacks of the unanticipated retirement, William’s financial situation is poor because he had not planned adequately for retirement. His situation has inspired Harry and Belinda to take a look at their own retirement planning. Together they now make about $200,000 per year ($110,000 for Belinda and $90,000 for Harry) and would like to have a similar level of living when they retire. Harry and Belinda are both in their early 40s and they recently received their annual Social Security Statements indicating that they each could expect about $22,000 per year in today’s dollars as retirement benefits in 25 years at age 67. Although their retirement is a long way off, they know that the sooner they put a plan in place, the…

Throughout this book, we will present a continuing narrative about Harry and Belinda Johnson. Following is a brief description of the lives of this couple.Harry is 28 years old and graduated five years ago with a bachelor's degree in interior design from a large Midwestern university near his hometown in Indiana. Since graduation Harry has been working in small interior design firm in Kansas City earning a salary of about $45,000.Belinda is 27, has a degree in business administration from a university on the West Coast, and has been employed in a medium-size manufacturing firm in California for about five years. Harry and Belinda both worked on their schools' student newspapers and met at a conference during their junior year in college.After all these years they met again socially in January in Kansas City, Missouri where Belinda was visiting relatives and by chance she and Harry were at the same museum. After getting reacquainted they started dating and in only a matter of months…

Your clients Aiden, 35, and Delora, 37, have had many life changes in the past year. Aiden secured a new job and a large raise. They welcomed their second child and now have two children under four years old. To accommodate the baby, they renovated and refinanced their existing mortgage. Delora will be a stay at home mom and no longer has group insurance coverage through her employer. They meet with you to discuss how these changes might impact their needs for insurance. Which of the following statements concerning Aiden and Delora's insurance needs is correct? a) The newborn child is a minor and will be covered under the existing coverage. b) Their insurance needs should not consider Delora since she is no longer earning an income under her stay at home mom status. c) The mortgage was refinanced and the bank would be responsible for providing mortgage insurance. d) Aiden may need additional coverage if his new employer offers less group life insurance than his previous…

Danny and Sandy have come to your office to discuss some retirement planning issues.  Danny will be turning age 65 in five months and Sandy is currently 63. Danny has not started collecting Social Security benefits yet because he is still working, and he is unsure whether he will retire this year or wait a few more years. Sandy has never worked outside the home.  If he continues to work, Danny will have health insurance for both himself and Sandy through his employer with a $250 annual per person deductible, a 90% coinsurance, and a maximum out-of-pocket limit of $5,000.  Danny’s share of the premium is $50 per pay.  Many of their retirement questions have to do with Medicare and health insurance because both Danny and Sandy have existing health issues.  All the following statements are proper advice for you to give Danny and Sandy, EXCEPT: Danny should delay enrollment in Medicare Part B until he is no longer covered under his employer’s health plan. Sandy will be eligible for…

See image

Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure that they are financially sound in 30 years. So, Lindsay plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which Lindsay contributes. (a) Construct a spreadsheet model that will calculate Lindsay's retirement savings given a fixed annual amount saved and a fixed annual interest rate of return. If Lindsay invests $13,000 at an annual return of 7%, how much will be in the retirement account (in dollars) at the end of 30 years? (Round your answer to the nearest dollar.) $  (b) Develop a two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of 0% to 12% in increments of 1%. Using the table, what are the minimum annual investments Lindsay must contribute (in dollars) for…

Samantha Montgomery (age 42) is employed by Canon Company and is paid an annual salary of $62,430. She has just decided to join the company's Simple Retirement Account (IRA form) and has a few questions. Answer the following for Montgomery: Round your answer to the nearest cent. a.  What is the maximum that she can contribute into this retirement fund? $fill in the blank 1 b.  What would be the company's contribution? $fill in the blank 2 Note: For items c. & d. below, round interim amounts to two decimal places. Use these values in subsequent computations then round final answer to two decimal places. c.  What would be her weekly take-home pay with the retirement contribution deducted (married, 2 allowances, wage-bracket method, and a 2.3% state income tax on total wages)? Click here to access the Wage-Bracket Method Tables. $fill in the blank 3 d.  What would be her weekly take-home pay without the retirement contribution deduction? $fill in the blank 4

Velma, a 59-year-old minority woman who works as a teacher, contacts you about getting a loan to purchase a condominium. As you’re chatting, she indicates that she’s hoping to retire from teaching in three years. You take her financial and personal information and see that you should be able to get her the amount she needs to purchase the home and now you need to discuss terms. You share some loan options with her and she insists that she’s only interested in an adjustable-rate mortgage because she wants the lower monthly payments to start and is convinced the interest rates will stay low or go down even further. 1. What should you share with Velma about an ARM loan given her situation? Are you obligated to help her apply for the loan she wants?

Larry Kraft owns a restaurant that is open 7 days a week. He has 25 fulltimeemployees, but he has fairly high employee turnover. He believes thathe can stabilize his workforce if he has a pension plan for his employees.Larry hears about a small business retirement plan called the SIMPLE IRA.What are the qualifications and limitations for him to establish this plan?

Sam is currently 30 years of age. He owns his own business and wantsto retire at the age of 60. He has little confidence in the current SocialSecurity system. He wants to retire with an annual income of $72,000a year.a. If Sam believes he will live to age 90, how much does he have to accumulateby the time he reaches age 60 to receive $72,000 at the end of each yearfor the rest of his life? Sam believes he can earn 8 percent on his money in astock mutual fund.b. How much does he have to accumulate if he wants the payment of $72,000at the beginning of each year?c. What dollar amount of interest will Sam have earned during retirement if hereceives his $72,000 at the beginning of each year?

A client needs assistance with retirement planning. Here are the facts:  The client, Dave, is 21 years old. He wants to retire at 65.  Dave has disposable income of $2,000 per month.  The IRA Dave has chosen has an average annual return of 8%.  Question 1. If Dave contributes half of his disposable income to the account, what will it be worth at 65? Question 2. How much would he need to contribute to have $5,000,000 at 65?

George Clausen (age 48) is employed by Kline Company and is paid an annual salary of $42,640. He has just decided to join the company's Simple Retirement Account (IRA form) and has a few questions. Answer the following for Clausen: a. What is the maximum that he can contribute into this retirement fund? $ 12,500 ✓ b. What would be the company's contribution? $ X Note: For items c. & d. below, round interim amounts two decimal places. Use these values in subsequent computations then round final answer to two decimal places. c. What would be his weekly take-home if he contributes the maximum allowed retirement contribution (married, allowances, wage-bracket method, and a 2.3 % state income tax on total wages)? Click here to access the Wage-Bracket Method Tables. $ X d. What would be his weekly take-home pay without the retirement contribution deduction? X

With the photo attached, answer the following  a. In your assessment, who will have the higher retirement value at age 65, Ben or Arthur (no calculation required)? Justify your response. NO EXCEL....full working  DO NOT USE EXCEL TO ANSWER

Solve this question is accounting question

Molly Lincoln, a 25-year-old personal loan officer at First National Bank, understands the importance of starting early when it comes to saving for retirement. She has committed $3,500 per year for her retirement fund and assumes that she'll retire at age 65.   How much will Molly have accumulated when she turns 65 if she invests in equities and earns 8 percent on average? Round your answer to the nearest dollar. Molly is urging her friend, Isaac Stein, to start his plan right away, too, because he's 45. What would his nest egg amount to if he invested in the same manner as Molly and he, too, retires at age 65? Round your answer to the nearest dollar. 2a. Nest egg at 4% 2b. Nest egg at 8%

STORY (very similar to what was shown in class): YOU and your BEST FRIEND just graduated from college. You both went to the same college and majored in the same field. You both started working at age 22 in the same workplace. Each of you decided upon a different course of action for your respective retirement plans. Assuming each plan earned 10% and both of you decided to retire at age 60, calculate the earnings each plan generated. Upon the advice of your Personal Finance professor (hint, hint), YOU began immediately putting $6,000 per year in an individual retirement account (IRA) and $19,500 per year in a 401K. You contributed for a total of 15 years. After 15 years, you made no further contributions into the account. Your BEST friend, did not contribute to their retirement accounts until they turned 30, even though you both worked in the same place and received the same plans. They had planned to simply invest $6000 and $19,500 each year for the remaining years until they retired…

STORY (very similar to what was shown in class): YOU and your BEST FRIEND just graduated from college. You both went to the same college and majored in the same field. You both started working at age 22 in the same workplace. Each of you decided upon a different course of action for your respective retirement plans. Assuming each plan earned 10% and both of you decided to retire at age 60, calculate the earnings each plan generated. Upon the advice of your Personal Finance professor (hint, hint), YOU began immediately putting $6,000 per year in an individual retirement account (IRA) and $19,500 per year in a 401K. You contributed for a total of 15 years. After 15 years, you made no further contributions into the account. Your BEST friend, did not contribute to their retirement accounts until they turned 30, even though you both worked in the same place and received the same plans. They had planned to simply invest $6000 and $19,500 each year for the remaining years until they…

Victor and Maria Hernandez Look at Future Income Throughout this book, we will present a continuing narrative about Victor and Maria Hernandez. Following is a brief description of the lives of this couple.Victor and Maria, both in their late 30s, have two children: Jacob, age 13, and Nicholas, age 15. Victor has had a long sales career with a retail appliance store in Fargo, North Dakota earning $55,000 annually. Maria works as a medical records assistant earning $31,000. Victor and Maria regularly buy and sell a number of items on eBay, Craig's List, and through the free community newspaper, from which they earn about $5,000 each year. What is the accumulated future value of those annual amounts over 22 years if the annual earnings were invested regularly and provided a 5 percent return each year? (Hint: Use Appendix A-3.) Round your answer to nearest dollar. Round Future Value of Series of Equal Amounts in intermediate calculations to four decimal places $   What would Victor and…