Income and Expense Statement Name(s): Brock and Sam Wilson For the year ending: As of December 31,20XX Dollars \begin{tabular}{lll} Income & & \\ \hline Wages and salaries & Name: Brock Wilson & $20,000 \\ & Name: Sam Wilson & 18,000 \\ \hline Bonuses and commissions & Brock's bonus & 2,000 \\ (1) Total Income: & & $40,000 \end{tabular} Expenses \begin{tabular}{lll} Housing & & $5,400 \\ \hline Utilities & Central Maine Power & 600 \\ & T-Mobile & 300 \\ \hline Food & Groceries & 1,080 \\ \hline Transportation & Auto loan & 4,320 \\ & Public transportation & 2,400 \\ \hline Insurance & & 900 \\ \hline Taxes & & 9,500 \\ \hline Fun money & Cruise to Mexico & 2,500 \\ \hline Parents' loan & & 700 \\ \hline (2) Total Expenses: & $27,700 \\ \hline Surplus (Deficit): & $12,300 \\ \hline \end{tabular} 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 $15,000 for Brock and $13,500 for Sam - Insurance is paid at the end of each calendar quarter - Sam purchases her commuter pass on the first of 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. Enter a value in each blank cell to get full credit for this exercise, and round all dollar amounts to the nearest whole dollar. Enter any cash deficit with a minus sign. Three-Month Cash Budget (By Month) Name(s): Brock and Sam Wilson \begin{tabular}{llll|} For: Three months & & \multicolumn{2}{l}{ Ending: March 31, 20XX } \\ & January & February & March \\ Income & & & \\ \hline Brock's salary & $1,250 & 1,250 & $,125 \\ \hline Sam's salary & 1,125 & $ & $ \\ Total income & 2,375 & $ & $ \\ \hline \end{tabular} Total for Three Months Expenses Rent 450450 $ $ Utilities: \begin{tabular}{|l|} $ \\ $ \end{tabular} $ $ $ $ $ $ $ $ $ Income and Expense Statement Name(s): Brock and Sam Wilson For the year ending: As of December 31,20XX Dollars \begin{tabular}{lll} Income & & \\ \hline Wages and salaries & Name: Brock Wilson & $20,000 \\ & Name: Sam Wilson & 18,000 \\ \hline Bonuses and commissions & Brock's bonus & 2,000 \\ (1) Total Income: & & $40,000 \end{tabular} Expenses \begin{tabular}{lll} Housing & & $5,400 \\ \hline Utilities & Central Maine Power & 600 \\ & T-Mobile & 300 \\ \hline Food & Groceries & 1,080 \\ \hline Transportation & Auto loan & 4,320 \\ & Public transportation & 2,400 \\ \hline Insurance & & 900 \\ \hline Taxes & & 9,500 \\ \hline Fun money & Cruise to Mexico & 2,500 \\ \hline Parents' loan & & 700 \\ \hline (2) Total Expenses: & $27,700 \\ \hline Surplus (Deficit): & $12,300 \\ \hline \end{tabular} 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 $15,000 for Brock and $13,500 for Sam - Insurance is paid at the end of each calendar quarter - Sam purchases her commuter pass on the first of 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. Enter a value in each blank cell to get full credit for this exercise, and round all dollar amounts to the nearest whole dollar. Enter any cash deficit with a minus sign. Three-Month Cash Budget (By Month) Name(s): Brock and Sam Wilson \begin{tabular}{llll|} For: Three months & & \multicolumn{2}{l}{ Ending: March 31, 20XX } \\ & January & February & March \\ Income & & & \\ \hline Brock's salary & $1,250 & 1,250 & $,125 \\ \hline Sam's salary & 1,125 & $ & $ \\ Total income & 2,375 & $ & $ \\ \hline \end{tabular} Total for Three Months Expenses Rent 450450 $ $ Utilities: \begin{tabular}{|l|} $ \\ $ \end{tabular} $ $ $ $ $ $ $ $ $
