10. Preparing a cash budget Aa Aa Dan and June started to create a budget (based on last year's income and expense statement) but got stuck. They know that you have leamed 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): Dan and June Kuryaki For the year ending As of December 31 Dollars In addition to the statement, you will need to know the following information: Income Name: Dan Kuryaki Name: June Kuryaki Dan's bonus 21,000 18,900 2,100 Wages and salaries Bonuses and commissions (1) Total Income: They estimated their net annual income (after taxes and employer deductions) at $15,750 for Dan and $14,175 for June Insurance is paid at the end of each calendar quarter $42,000 Expenses Housing Utilities June purchases her commuter pass on the first of $9,456 1,056 528 1,896 4,860 4,200 1,576 9,975 3,500 1,225 $38,272 $3,728 Puget Sound Energy Verizon Groceries Auto loan Public transportation each month The parents' loan is money they borrowed from June's parents to pay off their student loans. How much they pay each month is determined by them Food Transportation The fun money listed on the statement is thee Insurance Taxes Fun money Parents' loan (2) Total Expenses Surplus (Deficit): 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 Cruise to Mexico 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