Question: Add row 43 to your matrix from Exercise 9. Calculate each month's total expenses. In Exercise 9 a. Draw a line graph to chart Laura's
In Exercise 9
-1.png)
-2.png)
a. Draw a line graph to chart Laura's monthly budgeted expenses. Include horizontal lines to indicate the average monthly expense and the monthly income.
b. What advice would you give to Laura based upon the graph you have constructed?
Frequency Budget Plan Income Amounts 2,800 500 After-Tax Income Categories Primary Employment Secondary Employment Interest Dividends Other Income Total Income Frequency 24 12 Annual Amount 67,200 6,000 73,200 Weekly Expenses Food Personal Transportation Public Transportation Household Childcare Dining Out Entertainment Expense Amounts 185 37 52 52 52 52 52 52 52 52 9,620 1,924 0 0 0 1,820 2,392 0 15,756 35 46 Total Weekly Expenses 303 Monthly Expenses Mortgage Utilities Land Line/Cellular Telephone Car Loan Education Loan Personal Loan Car Insurance Homeowner's Insurance Savings 2,400 110 120 200 150 80 60 50 300 12 12 12 12 12 12 12 12 12 28,800 1,320 1,440 2,400 1,800 960 720 600 3,600 1,920 600 44,160 160 12 12 Debt Reduction Total Monthly Expenses Other Frequency Expenses Medical/Dental Auto-Related Home-Related Life Insurance Tuition Vacation Gifts Contributions Repairs Taxes 600 700 250 150 1.500 1,200 200 400 600 2,000 700 2 4 2 3,000 1,200 2 600 2 4,000 Total Other Frequency Expenses Total Expenses Annual Surplus or Deficit 12,000 71,916 1,284
Step by Step Solution
3.30 Rating (168 Votes )
There are 3 Steps involved in it
a The January total for expenses is the sum of everything from B8 to B42 writ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
790-L-A-L-S (2093).docx
120 KBs Word File
