Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Brock and Sam started to create a budget (based on last year's income and expense statement) but got stuck. They know that you have learned
Brock and Sam 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): Brock and Sam Wilson For the year ending: As of December 31 Dollars In addition to the statement, you will need to know the following information: Income Name: Brock Wilson Name: Sam Wilson Brock's bonus $ 20,500 18,450 2,050 Wages and salaries Bonuses and commissions (1) Total Income: They estimated their net annual income (after taxes and employer deductions) at $15,375 for Brock and $13,838 for Sam Insurance is paid at the end of each calendar $41,000 quarter Expenses Housing Utilities Sam purchases her commuter pass on the first of $6,756 756 372 1,356 3,780 3,000 1,126 9,738 3,500 875 $31,259 $9,741 each month The parents' loan is money they borrowed from Sam'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 Rocky Mountain Power AT&T Groceries Auto loan Public transportation Food Transportation Insurance Taxes Fun money Parents' loan (2) Total Expenses: Surplus (Deficit): Cruise to Mexico
Step 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