Monthly Budgeting

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…

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…

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?

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

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…

I need help in calculating the answers for c and d. The answers for a and b already done.  I have inserted the tables for c and d. Here's the question: 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: Round your answer to the nearest cent.  As we go to press, the federal income tax rates for 2023 are being determined by budget talks in Washington, and are not available for publication. For this edition, the 2022 federal income tax tables for Manual Systems with Forms W-4 from 2020 or Later with Standard Withholding and 2022 FICA rates have been used. a.  What is the maximum that he 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…

Karen has been moonlighting as a life coach. This year she made over $65,000 and would like to not realize some of those earnings, maybe in a retirement account. However, she already contributes $6,000 to her qualified retirement plan at her regular employer. What can she do? A : She can contribute some of the $65,000 in a Keogh plan, if she stops participating in her employer’s plan.  B : She can contribute some of the $65,000 in an employee stock ownership plan.  C : She can contribute some of the $65,000 in a Keogh plan.  D : She cannot do anything because she has a qualified retirement plan available at her employer.

Ben Bates graduated from college six years ago with a finance undergraduate degree. Although he is satisfied with his current job, his goal is to become an investment banker. He feels that an MBA degree would allow him to achieve this goal. After examining schools, he has narrowed his choice to either Wilton University or Mount Perry College. Although internships are encouraged by both schools, to get class credit for the internship, no salary can be paid. Other than internships, neither school will allow its students to work while enrolled in its MBA program. Ben currently works at the money management firm of Dewey and Louis. His annual salary at the firm is $65,000 per year, and his salary is expected to increase at 3 percent per year until retirement. He is currently 28 years old and expects to work for 40 more years. His current job includes a fully paid health insurance plan, and his current average tax rate is 26 percent. Ben has a savings account with enough money to cover the…

Ben Bates graduated from college six years ago with a finance undergraduate degree. Although he is satisfied with his current job, his goal is to become an investment banker. He feels that an MBA degree would allow him to achieve this goal. After examining schools, he has narrowed his choice to either Wilton University or Mount Perry College. Although internships are encouraged by both schools, to get class credit for the internship, no salary can be paid. Other than internships, neither school will allow its students to work while enrolled in its MBA program. Ben currently works at the money management firm of Dewey and Louis. His annual salary at the firm is $65,000 per year, and his salary is expected to increase at 3 percent per year until retirement. He is currently 28 years old and expects to work for 40 more years. His current job includes a fully paid health insurance plan, and his current average tax rate is 26 percent. Ben has a savings account with enough money to cover the…

Lindsay is 25 years old and has a new job in web development. She wants to make sure that she is financially sound in 30 years, so she 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 she contributes. (a) Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $13,000 at a return of 8% how much will she have (in dollars) in her retirement account at the end of 30 years. (Round your answer to the nearest dollar.) X (b) Develop the 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 annual rates ranging from 7% to 11% to accrue…

Lindsay is 25 years old and has a new job in web development. She wants to make sure that she is financially sound in 30 years, so she 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 she contributes. (a) Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $14,000 at a return of 11% how much will she have (in dollars) in her retirement account at the end of 30 years. (Round your answer to the nearest dollar.) $ (b) Develop the 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 annual rates ranging from 7% to 11% to…

Lindsay is 25 years old and has a new job in web development. She wants to make sure that she is financially sound in 30 years, so she 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 she contributes. (a) Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $12,000 at a return of 11% how much will she have (in dollars) in her retirement account at the end of 30 years. (Round your answer to the nearest dollar.) $ (b) Develop the 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 annual rates ranging from 7% to 11% to…

Lindsay is 25 years old and has a new job in web development. She wants to make sure that she is financially sound in 30 years, so she 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 she contributes. (a) Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $14,000 at a return of 9% how much will she have (in dollars) in her retirement account at the end of 30 years. (Round your answer to the nearest dollar.) $ 790582 X (b) Develop the 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 annual rates ranging from 7% to 11%…