PLEASE ANSWER WITH EXCEL FORMULAS/ANSWERS!!!!!!!!!!!!!!!

To get the difference, please subtract the actual cost from the projected cost. To get the total difference, add all subtotals of the difference or subtract the total actual cost from the total projected cost. 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 DIFFERENCE (Actual balance minus projected balance) Income 1 Extra income Total monthly income $4,000 $300 Difference Difference Projected Cost $20 $20 $40 HOUSING Mortgage or rent Phone Electricity Gas Water and sewer Cable Waste removal Maintenance or repairs Supplies Other Subtotals Projected Cost Actual Cost $1,000 $1,000 $54 $100 $44 $56 $22 $28 $8 $8 $34 $34 $10 $10 $23 $0 $27 $15 $50 $33 ENTERTAINMENT Video/DVD CDs Movies Concerts Sporting events Live theater Other Other Other Subtotals $0 $0 $0 $0 $0 $0 Actual Cost $23 $0 $20 $0 $0 $0 $0 $0 $0 696969 Difference Difference TRANSPORTATION Vehicle payment Bus/taxi fare Insurance Licensing Fuel Maintenance Other Subtotals Projected Cost Actual Cost $350 $350 $0 $0 $35 $35 $0 $0 $100 $186 $50 $0 $0 $0 LOANS Personal Student Credit card Credit card Credit card Other Subtotals Projected Cost $0 $250 $75 $20 $0 $0 Actual Cost $0 $250 $75 $20 $0 $0 TAXES Projected Cost Actual Cost Difference Subtotals Difference Difference INSURANCE Home Health Projected Cost Actual Cost $120 $120 $50 $50 $42 $42 $0 $0 TAXES Federal State Local Other Subtotals Projected Cost $0 $0 $0 $0 Actual Cost $0 $0 $0 $0 Life Other Subtotals Difference Projected Cost Actual Cost $0 $0 $0 $0 $0 $0 FOOD Groceries Dining out Other Subtotals SAVINGS OR INVESTMENTS Retirement account Investment account Other Subtotals Projected Cost Actual Cost Difference $350 $310 $100 $145 $50 $40 Difference GIFTS AND DONATIONS Charity 1 Charity 2 Charity 3 Subtotals Projected Cost Actual Cost $0 $0 $0 $0 $0 $0 Difference PETS Food Medical Grooming Toys Other Subtotals Projected Cost Actual Cost $30 $25 $0 $0 $0 $0 $15 $20 $0 $0 Difference LEGAL Attorney Alimony Payments on lien or judgment Other Subtotals Projected Cost Actual Cost $0 $100 $0 $0 $0 $0 $0 $0 Difference TOTAL PROJECTED COST PERSONAL CARE Medical Hairails Clothing Dry cleaning Health club Organization dues or fees Other Subtotals Projected Cost Actual Cost $50 $0 $0 $0 $50 $100 $0 $0 $75 $75 $15 $15 $0 $0 TOTAL ACTUAL COST TOTAL DIFFERENCE