Question: Apply Your Knowledge - Financial Destiny Project Please help me with the below spread sheet - the difference column should have a total on each
Apply Your Knowledge - Financial Destiny Project
Please help me with the below spread sheet - the difference column should have a total on each line. All other items to be answered are ____ .
| Personal Monthly Budget | |||||||||
| PROJECTED MONTHLY INCOME | Income 1 | $4,300 | PROJECTED BALANCE (Projected income minus expenses) _______ | ||||||
| Extra income | $300 | ||||||||
| Total monthly income | _____ | ACTUAL BALANCE (Actual income minus expenses) _____________ | |||||||
| ACTUAL MONTHLY INCOME | Income 1 | $4,000 | DIFFERENCE (Actual income minus projected income) ________ | ||||||
| Extra income | $300 | ||||||||
| Total monthly income | _____ | ||||||||
| HOUSING | Projected Cost | Actual Cost | Difference | ENTERTAINMENT | Projected Cost | Actual Cost | Difference | ||
| Mortgage or rent | $1,000 | $1,000 | Video/DVD | $20 | $23 | ||||
| Phone | $54 | $100 | CDs | $20 | $0 | ||||
| Electricity | $44 | $56 | Movies | $40 | $20 | ||||
| Gas | $22 | $28 | Concerts | $0 | $0 | ||||
| Water and sewer | $8 | $8 | Sporting events | $0 | $0 | ||||
| Cable | $34 | $34 | Live theater | $0 | $0 | ||||
| Waste removal | $10 | $10 | Other | $0 | $0 | ||||
| Maintenance or repairs | $23 | $0 | Other | $0 | $0 | ||||
| Supplies | $27 | $15 | Other | $0 | $0 | ||||
| Other | $50 | $33 | Subtotals | ||||||
| Subtotals | |||||||||
| LOANS | Projected Cost | Actual Cost | Difference | ||||||
| TRANSPORTATION | Projected Cost | Actual Cost | Difference | Personal | $0 | $0 | |||
| Vehicle payment | $350 | $350 | Student | $250 | $250 | ||||
| Bus/taxi fare | $0 | $0 | Credit card | $75 | $75 | ||||
| Insurance | $35 | $35 | Credit card | $20 | $20 | ||||
| Licensing | $0 | $0 | Credit card | $0 | $0 | ||||
| Fuel | $100 | $186 | Other | $0 | $0 | ||||
| Maintenance | $50 | $0 | Subtotals | ||||||
| Other | $0 | $0 | |||||||
| Subtotals | TAXES | Projected Cost | Actual Cost | Difference | |||||
| Federal | $0 | $0 | |||||||
| INSURANCE | Projected Cost | Actual Cost | Difference | State | $0 | $0 | |||
| Home | $120 | $120 | Local | $0 | $0 | ||||
| Health | $50 | $50 | Other | $0 | $0 | ||||
| Life | $42 | $42 | Subtotals | ||||||
| Other | $0 | $0 | |||||||
| Subtotals | SAVINGS OR INVESTMENTS | Projected Cost | Actual Cost | Difference | |||||
| Retirement account | $0 | $0 | |||||||
| FOOD | Projected Cost | Actual Cost | Difference | Investment account | $0 | $0 | |||
| Groceries | $350 | $310 | Other | $0 | $0 | ||||
| Dining out | $100 | $145 | Subtotals | ||||||
| Other | $50 | $40 | |||||||
| Subtotals | GIFTS AND DONATIONS | Projected Cost | Actual Cost | Difference | |||||
| Charity 1 | $0 | $0 | |||||||
| PETS | Projected Cost | Actual Cost | Difference | Charity 2 | $0 | $0 | |||
| Food | $30 | $25 | Charity 3 | $0 | $0 | ||||
| Medical | $0 | $0 | Subtotals | ||||||
| Grooming | $0 | $0 | |||||||
| Toys | $15 | $20 | LEGAL | Projected Cost | Actual Cost | Difference | |||
| Other | $0 | $0 | Attorney | $0 | $100 | ||||
| Subtotals | Alimony | $0 | $0 | ||||||
| Payments on lien or judgment | $0 | $0 | |||||||
| PERSONAL CARE | Projected Cost | Actual Cost | Difference | Other | $0 | $0 | |||
| Medical | $50 | $0 | Subtotals | ||||||
| Hair/nails | $0 | $0 | |||||||
| Clothing | $50 | $100 | TOTAL PROJECTED COST | _____ | |||||
| Dry cleaning | $0 | $0 | |||||||
| Health club | $75 | $75 | TOTAL ACTUAL COST | _____ | |||||
| Organization dues or fees | $15 | $15 | |||||||
| Other | $0 | $0 | TOTAL DIFFERENCE | _____ | |||||
| Subtotals | |||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help