STATEMENT OF CASH FLOWS John and Asha Patel For this Year (Expected) INFLOWS Salary-Asha Salary-John Savings Interest Vacant Lot rental fees TOTAL INFLOWS OUTFLOWS Savings 529 plans - split equally Asha's 403(b) Savings Total Savings Living expenses Food and household supplies Clothing Lessons for Alexander Entertainment and travel Utilities Home maintenance/repairs Auto maintenance and gas Medical, dental, vision expenses Charity Misc (gifts, pet care, etc.) Total living expenses Debt payments Mortgage payments (1) Student loan payments (2) Auto loan payments(3) Total debt payments Insurance premiums Automobile Homeowners Medical $102,000 80,000 $400 $4,000 $186,400 $10,000 $10,200 $16,800 $37,000 $16,000 $4,200 $2,860 $7,000 $8,600 $8,000 $7,200 $6,000 $2,400 $6,993 $69,253 $17,756 3,597 $6,386 $27,739 $2,300 $2,800 $6,000 RETIREMENT INFORMATION John and Asha would like to retire at age 65. They expect their living expenses in their first year of retirement to be equivalent to 70% of their current earned income (as adjusted for inflation). They assume their life expectancy in retirement will be 30 years. John has a rollover IRA from a previous employer's 401(k) plan, invested in a low-cost 2045 target date fund with a major investment firm. Historically, the two major asset classes in the fund are large cap domestic stocks and corporate bonds. He has not made IRA contributions. Asha's IRA (also a rollover from a previous employer's plan) is invested in the same mutual fund as John's. She has not made IRA contributions. Asha defers 10% of her salary into a 403 (b) associated with the university. The university matches the first 5% of salary contributed, dollar for dollar. The employer contribution is subject to a vesting schedule, and Asha will be 100% vested in 6 months. The account is invested in a large cap/growth mutual fund. They consulted the Social Security Administration website and determined their monthly retirement benefits at FRA would be \$2,100 (in today's dollars) for John and \$2,600 (in today's dollars) for Asha. The current value of Playful Paws, Inc. is $400,000. However, John is hoping one of the children will get involved in the business. and therefore he does not want to include the business's value in the assets available to fund retirement. As the children age, he will reevaluate his plans for the business. STATEMENT OF FINANCIAL POSITION John and Asha Patel January 1, 2023 ASSETS 1 Liquid assets Joint checking account $5,000 Joint savings account $42,000 Total liquid assets Investments 529 Plans for the two children Asha's IRA Asha's 403(b) John's IRA Playful Paws, Inc. shares Vacant land Total investments Use Assets Residence Personal property Vehicles Total use assets TOTAL ASSETS Liabilities Mortgage on residence Auto loan Student Loan Total liabilities NET WORTH $31,000 $47,000 $68,000 $84,000 $105,000 $400,000 $120,000 $808,000 $600,000 55,000 $35,000 $690,000 $1,545,000 $318,897 $17,756 $3,501 $340,154 $1,204,846 The Patels are looking to retire at age 65 , as described in detail in the RETIREMENT INFORMATION section of the case study. What balance do they need on the first day of retirement to support this goal, taking their Social Security benefit into account? Assume a 7% investment return on their retirement portfolio before they retire and a 5% return after they retire, and that inflation will average 3% for their entire lives. Please include your calculator steps and inputs in your