Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could someone please answer these? Kerry and Kim started to create a budget (based on last year's income and expense statement) but got stuck. They
Could someone please answer these?
Kerry and Kim started to create a budget (based on last year's income and expense statement) but got stuck. They know that you have learned how to create budgets and are asking for your help. They would like you to input the correct values for the first three months of next year. Income and Expense Statement Name(s) Kerry and Kim Lee For the year ending: As of December 31 Dollars Income Wages and salaries Name: Kerry Lee $19,500 Name: Kim Lee 17,550 Kerry's bonus Bonuses and commissions 1,950 (1) Total Income: $39,000 Expenses Housing $6,756 756 Utilities Puget Sound Energy Verizon 372 1,356 Food Groceries Auto loan Transportation 4,860 Public transportation 3,000 1,126 Insurance 9,263 Taxes Fun money Cruise to Mexico 3,500 Parents' loan 875 (2) Total Expenses: $31,864 Surplus (Deficit): $7,136 In addition to the statement, you will need to know the following information: They estimated their net annual income (after taxes and employer deductions) at $14,625 for Kerry and $13,163 for Kim Insurance is paid at the end of each calendar quarter Kim purchases her commuter pass on the first of each month The parents' loan is money they borrowed from Kim's parents to pay off their student loans. How much they pay each month is determined by them The fun money listed on the statement is the money spent for a cruise to Mexico. They didn't keep track of any other entertainment expenses (such as dinners out and movies) incurred during the year. Note: Enter a value in each blank celll to get full credit for this exercise, and round all dollar amounts to the nearest whole dollar. Note: Enter a value in each blank cell to get full credit for this exercise, and round all dollar amounts to the nearest whole dollar Three-Month Cash Budget (By Month) Name(s): Kerry and Kim Lee For: Three months Ending: March 31 February January March Total for Three Months Income Kerry's salary $ Kim's salary $ $ $ Total income $ $ $ Expenses Rent $ Utilities: Puget Sound Energy $ $ $ $ Verizon $ $ $ Food $ $ $ $ Automobile $ $ $ $ Public transportation $ $ $ Insurance $ $ $ $ Parents' loan $ $ $ $ Fun money $ $ Total expenses $ $ $ $ Cash surplus (deficit) $ $ Cumulative surplus (deficit) Looking at the completed budget, what single item would you recommend that they add to their budget? Looking at the completed budget, what single item would you recommend that they add to their budget? Dividend and interest income Pensions and annuities Savings and investments This is because: The couple needs to increase their distributions from their retirement plans. The couple needs to increase their taxable income. The couple needs to budget for contingencies and save for future goalsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started