Question: 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 learned


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 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): 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 $20,000 18,000 2,000 Wages and salaries Name: Dan Kuryaki Name: June Kuryaki Dan's bonus . They estimated their net annual income (after Bonuses and commissions (1) Total Income: taxes and employer deductions) at $15,000 for Dan and $13,500 for June Insurance is paid at the end of each calendar quarter $40,000 Expenses Housing Utilities June purchases her commuter pass on the first of $9,456 1,056 528 1,896 4,320 4,200 1,576 9,500 3,500 1,225 $37,257 $2,743 each month Rocky Mountain Power AT&T Groceries Auto loan Public transportation 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 the Food Transportation . The fun money listed on the statement is the money spent for a cruise to keep track of any other entertainment expenses (such as dinners out and movies) incurred during the year Mexico. They didn't Insurance Taxes Fun money Parents' loan (2) Total Expenses: Surplus (Deficit): 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. Three-Month Cash Budget (By Month) Name(s): Dan and June Kuryaki For: Three months Ending: March 31 Total for Three Months January February March Income Dan's salary June's salary Total income Expenses Rent Utilities: Rocky Mountain Power AT&T Food Automobile Public transportation Insurance Parents' loan Fun money Total expenses Cash surplus (deficit) Cumulative surplus (deficit)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
