I only need question 7 answered. I provided the other questions, answers, and case study to help answer question 7.

7. Based on how much Mike needs to save and what you have gathered from the case, what type of retirement plan would you recommend, if any at all? Justify your answer.

1. How much is Mike's pension worth in today's dollars?

$82,213.75

2. How much are Mike and Maria's Social Security benefits worth today?

$293,785.42

3. Mike wants to set aside $75,000 for Michael's education. If he set aside all of his other cash and investable assets for the purpose of retirement, approximately how much would he need to save every year to fund his retirement?

$33,452.60

4. How much is Mike's self-employment tax for 2021?

$24,232.14

5. How much could Mike contribute for himself in 2021 if he set up a SEP with a 25% contribution?

$42,875

6. What risks does Mike have that need to be considered?

Investments like his Exxon stock are subject to market fluctuations. Mike and Maria should establish a will to handle their estate appropriately. They have no disability or liability insurance. This puts them at huge risk as self-employed business owners. Revenue can fluctuate, and injuries at the facility and equipment maintenance can occur. While they have a savings account, a separate emergency account would benefit them for unexpected expenses.

Statement of Financial Position 1/1/2023 Statement of Financial Position Mike and Maria Roman Balance Sheetas of 1/1/2023 Assets' Liabilities and Net Worth Cash and Cash Equivalents Liabilities Cash 55,000 Home Mortgage $307.808 Savings Account 325,000 Credit Card Balance Visa 32,000 Total Cash and Cash Equivalents $30,000 1.200 Investment Assets Auto Loan - Mike\" 526,444 Brokerage Account $70,000 Auto Loan - Maria' $9,918 Municipal Bond Portfolio 520,000 Total Liabilities 5347370 Education Portfolio 510,000 IRA $20,000 Total Investment Assets $120,000 Total Net Worth $335.630 Personal Use Assets Personal Residence 200,000 Land for Home & Baseball Field $200,000 Jeep - Maria $18,000 Ram Truck - Mike $35.000 Furniture & Personal Property $80,000 Total Personal Use Assels $533,000 Total Assets 5683,000 Total Liabilities & Net Worth $6831,000 1. Assets are stated at fair market value. 2. Liabilities are stated at principal only as of January 1, 2023 (prior to January payments). 3. The home and land were financed with a $350,000 loan, seven years ago at 5% over 360 months. 4. They typically spend about $1,000 per month on each credit card, but the balances are higher after the holidays. They do not maintain these balances. 5. The Ram truck was financed with a loan of $20,000, 6 months ago at 3% over 48 months. 6. Mike's brokerage account is highly correlated to the market In fact the account has a correlation with the market of about 99%. However, because Mike has some leveraged mutual funds in the account, the beta of the portfolio is approximately 20% greater than the market. Mike's brokerage account is a margin account, which has an initial margin of 50% and a maintenance margin of 35%. 7. The Jeep was financed with a loan of $13,000, 12 months ago at 3.5% over 48 months. 8. The municipal bond portfolio has a modified duration of 5 and a current YTM of 7%. CASE ASSUMPTIONS Required return - use the required return as stated in the case. For retirement and other long-term goals, assume cash and cash equivalents are added to investment accounts for purposes of projections and asset allocation decisions. Assume the education portfolio is not available to fund retirement. Assume Social Security benefits begin at age 67. Financial Statements Statement of Income and Expenses Statement of Income and Expenses Mike and Maria Roman Statement of Income and Expenses for 2022 and Expected (Approximate) for 2023 CASH INFLOWS Totals | Salaries | RBI Gross Revenue 245,000 Total Cash Inflows $245,000 | CASH OUTFLOWS Taxes Federal Estimated Tax Payments $40,000 | Property Tax Principal Residence & Land $10,000 $50,000 Debt Payments . Principal Residence $22,547 Auto Loan - Jeep $3.488 Auto Loan - Ram $7.968 | Credit Card Payments $13.000 Total Debt Payments $47.,002 | Living Expenses Utilities Principal Residence $3,900 Gasoline for Autos $3.500 | Gifts $1,000 Entertainment $1,750 | Vacations $2.000 Church Donations $500 | Clothing $2,000 Auto Maintenance $2.000 | Satellite TV 2,000 | Food $4,650 Total Living Expenses $23.300 | RBI Expenses Fees Paid to the Three RBI Coaches $60,000 | Utilities for Batting Cages $2.500 Baseball Field Maintenance $7.000 | Baseball Equipment $1,000 Other Baseball Business Expenses $3.000 Total RBI Expenses 73.500 | Insurance Payments | MLB Health Insurance Premium $6,000 | HO Insurance Principal Residence $3.000 | Auto Insurance Premiums $3.300 | Life Insurance Premiums [Policy A &B) $2.472 Total Insurance Payments _ 514772 Total Cash Outflows $208.574 | NET DISCRETIONARY CASH FLOWS ~ $36,426 Retirement Information Mike would like to retire at age 60 and quit working. Mike met the requirements for the MLB minimum pension of $34,000 per year, which is what he expects to receive. This pension begins at age 62 and the amount is fixed for life (both his and his spouse's life). It is not inflation adjusted from today or during retirement. Mike expects his Social Security benefits will equal $30,000 in today's dollars at full retirement age, which is age 67. Maria does not have 40 quarters of Social Security coverage. Gifts, Estates, Trusts, and Will Information Neither Mike nor Maria have prepared a will or any other estate planning documents. Mickey Roman Mickey is Mike's dad and is an \"old school\" baseball coach. He turned 72 on December 22, 2022. He has a pension payment from the USPS of $2,000 per month and he and his wife receive a monthly payment from Social Security of $2,200. He also has an IRA with the following balances: = S$80,000 as of December 31, 2021 $85,000 as of December 31, 2022 = 590,000 as of December 31, 2023 99 000 as of December 31, 2024 Since his wife will continue to receive Social Security and his pension in the event he dies, he has named his grandson Michael as the beneficiary of his IRA. Mickey also has Exxon stock that was distributed from a qualified plan 30 years ago. The distribution was a lump-sum distribution in which the FMV of the stock from the plan was $100,000. Mickey deposited the stock in his brokerage account and included $20,000 in his taxable income in the year of the distribution, based on the Form 1099-R. Mickey still owns the stock, which is now worth $324,340 and is held in the same brokerage account. He is hoping to leave it to Mike when he dies. INTERNAL INFORMATION Insurance Information Life Insurance Policy A Policy B Insured Mike Face Amount $150,000 540,000 Type Term Term Cash Value $0 30 Monthly Premium $156 $50 Who pays premium Mike Mike Beneficiary Maria Mike Policy Owner Mike Settlement options clause selected None Health Insurance Mike and Maria are covered under the Major League Baseball policy. The plan includes a family deductible of $12,600 at a cost of $500 per month. Long-Term Disability Insurance Neither Mike nor Maria are covered by any disability insurance. Homeowners Insurance The Romans have an HO3 policy with endorsements for replacement value and open perils for personal property. The current dwelling coverage is 100% replacement value with an inflation rider. Automobile Insurance RBoth of their cars are covered. Bodily Injury $100,000/$300,000 Property Damage $50,000 Medical Payments | $5,000 per person | Physical Damage Actual Cash Value Uninsured Motorist Bodily Injury | $100,000/$300,000 | Uninsured Motorist Property Damage 50,000 Comprehensive Deductible | $1,000 | Collision Deductible $1,000 Premium (annual $3,300 Personal Liability Insurance Neither Mike nor Maria have PLUP coverage. Income Tax Information The Romans filing status for their federal income tax return is married filing jointly. Mike works 1,500 hours and the other coaches total 2,000 hours. His three coaches work the following number of hours and are paid $30 per hour: Mike's coaches have worked with him for at least five years. Mike's net income equals the fees less the expenses listed above. He reports his revenue and expenses on Schedule C of his personal income tax return. Personal and Financial Objectives for Mike and Maria Roman 1. Provide for retirement. They would like to retire when Mike is age 60. They want to plan on $100,000 of retirement income in today's dollars. They expect to receive Social Security and Mike has a pension with Major League Baseball (MLB). They would like to plan on funding potential retirement expenditures until they turn age 95 and would like to maintain the same level of spending, even if Mike or Maria died early. 2. Provide for the cost of Michael's college education. They expect Michael to receive a partial baseball scholarship, but they plan on paying $15,000 per year for each of his five years for college. 3. Establish a retirement plan for the income Mike earns at RBI. EXTERNAL INFORMATION Economic Information Inflation is expected to be 3.0% annually. = There is no state income tax. s The yield curve is slightly upward sloping. but relatively flat. # The historic and expected correlation between the equity markets in the modernized countries is relatively high. The correlation between these markets increase especially during economic crisis. = They have a required rate of return of 9 percent. * The economy is in a steady slow growth expansion phase with moderate unemployment. Bank Lending Rates * 15-year mortgage rate is 5.0%. = 30-year mortgage rate is 6.0%. Secured personal loan rate is 10.0%. Education Information Mike and Maria believe strongly in education. They want Michael to attend a college for learning, as well as baseball. As mentioned, they expect to fund $15,000 per year for five years in today's dollars for Michael's education. Tuition has been increasing at a 7 percent rate, which is expected to continue indefinitely. MIKE AND MARIA ROMAN Mike and Maria have come to you, a financial planner, for help in developing a plan to accomplish their financial goals. From your initial meeting together, you have gathered the following information. PERSONAL BACKGROUND AND INFORMATION COLLECTED The Family Mike and Maria Roman live in the country and operate a baseball academy on their property. They have a quaint home with a baseball field to the left of their house and two covered baseball batting and pitching cages. Mike played professional baseball for 15 years and now provides baseball instruction through RBI to children ages six to the early twenties. Mike currently coaches several college baseball players and is one of the most respected hitting and pitching coaches in the area. He also coaches a 9-year-old team and a 14-year-old team, both competing at the major division level. Maria has the tireless job of scheduling all of the lessons. Mike and Maria Roman Mike is 44 years old and loves his job. He is also an avid hunter and fisherman. Maria is also 44 years old and has done a wonderful job of raising their two kids, while helping with the family business. The Children Emily is 20 years old and is a Junior at Florida State University where she is double majoring in anthropology and communications. She has always been an excellent student and has a full academic scholarship. She also works part-time to earn additional spending money. Her brother, Michael, is 17 years old and is a junior at Mission High School, where he plays shortstop on the baseball team and is hitting over 300 for the year. Roman's Baseball Institute (RBEI) Mike started RBI seven years ago after he left professional baseball. He has built his reputation, as well as that of RBI over that time period. RBI is one of the premier baseball academies in the area, The primary source of income for RBI is fees from baseball lessons. Lessons are priced at $70 per hour. Mike has three other coaches who help him provide lessons (Mickey, Mr. Joe, and Joey). Mike's dad, Mickey, who is now retired from the Post Office, taught Mike how to play baseball, coached Mike growing up, and works with Mike now that he is retired. Mr. Joe also coached Mike as a child and now coaches for Mike. Joey is 20 years old, played baseball for Mike growing up and played in college during his freshman year before getting injured. RBI generates $245,000 in gross annual revenue and has the following expenses: \"Coaching fees to his coaches | 360,000 Utilities 2,500 Field maintenance 7.000 _Equipmr:nt (balls, etc.) 51,000 'Utherexlmnses | 83000