Question: Create spreadsheet for the frequency budget in Exercise 8. In Exercise 8 Frequency Budget Plan Income Amounts 2,800 500 After-Tax Income Categories Primary Employment Secondary
In Exercise 8
-1.png)
-2.png)
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.42 Rating (158 Votes )
There are 3 Steps involved in it
See the spreadsheet below for the formulas in the spreadsheet AFTER TAX INCOME 1 CATEGORIES 2 Primar... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
790-L-A-L-S (2102).docx
120 KBs Word File
