BUDGETING PROBLEM 70 points Johnny is a recent graduate and has accepted a position with a Fortune 500 company. His start date 1/10 allows him to get paid for a (partial month) in January. In February he will get a full months pay. Johnny's gross income is 76,000.00 per year and he is paid on the 15th and the 30th of each. The first month (January) his expenses are approximately 30% of what they would be for a full month. His Health insurance starts after his first 30 days of employment His Federal Tax is withheld at 22% of his gross income. His state Tax is with held at 5%. City tax is 2% FICA is withheld at current rate; Health insurance is $211.00 per month. He moves into his apartment on the 15th of January and his rent is $1520. Since he lives in a city without public Transportation he decides to purchase a new the same day that he starts work and his first payment of $388.00 isn't due until March 10th. His additional monthly expenses are: Utilities-$200; Cable $49.99; Cell phone$100.00; Gas $100.00 Food (groceries) $374.00; dry cleaners $45; He plans to spend no more than 15% of take home pay on Dining and entertainment. Car insurance $110; he pays someone to clean his apartment for $50 per month; He joined a gym in Feb $30 per month; He gives to his church $100 per pay period and also gives back to his community$75 per month to the local YMCA. He gets a haircut twice a month $20 and his student loan payments begin March 1 $125; his goal is to put aside 5% for retirement and 5% in a personal savings per pay period. He got a credit card in December and the Balance owed is $250.00 on which he pays the minimum due in January 25th but plans to pay it off during February. He has to pay $125 per pay period in child support for his 3 year son who lives with his mother. Instructions: Using the worksheets provided prepare a budget for Jan and Feb for Johnny B i Income Calculator 2 Monthly Amount 1 Monthly Amount 2 3 GROSS INCOME * Category 5 Wages, Salary, Bonuses 6 Interest Income 7 Investment Income Other Income (e.... child support, alimony) 9 Monthly Amount Monthly Amount 10 TAXES WITHHELD AND PAYMENT DEDUCTIONS 12 Category 12 Federal Income Tax 13 State and Local Income Tax 14 Social Security and Medicare Tax 15 Employer Health Insurance Premium 16 Employer Retirement Plan Contribution (e.g., 401k) 17 Other 18 19 TOTAL Monthly Amount 20 Category 21 (Subtract taxes and deductions from gross income) Monthly Amount 0 0 22 Personal budget 1 2 3 4 INCOME 5 Wages 6 Interest/dividends 7 Miscellaneous 8 Income totals 9 EXPENSES 10 Home 11 Mortgage rent 12 Utilities 13 Home telephone 14 Cellular telephone 15 Home repairs 16 Home improvement 17 Home security 18 Garden supplies 19 Home totals 20 21 Daily living 22 Groceries 23 Child care 24 Dry cleaning 25 Dining out 26 Housecleaning service 27 Dog walker 28 Daily living totals 29 30 Transportation 31 Gas/fuel 32 Insurance 33 Repairs 34 Car Wash/detailing services 35 Parking 36 Public transportation 37 Transportation totals 3B Dues/subscriptions Magazines Newspapers Intemet connection Public radio Public television Religious organizations Charity Dues/subscription totals Personal Clothing Gifts Salon/barber 5 Books Music (CDs, etc.) 3 Personal totals 2 Financial obligations 1 Long-term savings Retirement (401K, Roth IRA) 3 Credit card payments 4 Income tax (additional) 5 Other obligations B Financial obligation totals 7 8 Misc. payments 9 Other 00 Other 1 Other 32 Other 33 Other 04 Misc. payments totals 35 06 Total expenses 07 Cash short/extra 08 BUDGETING PROBLEM 70 points Johnny is a recent graduate and has accepted a position with a Fortune 500 company. His start date 1/10 allows him to get paid for a (partial month) in January. In February he will get a full months pay. Johnny's gross income is 76,000.00 per year and he is paid on the 15th and the 30th of each. The first month (January) his expenses are approximately 30% of what they would be for a full month. His Health insurance starts after his first 30 days of employment His Federal Tax is withheld at 22% of his gross income. His state Tax is with held at 5%. City tax is 2% FICA is withheld at current rate; Health insurance is $211.00 per month. He moves into his apartment on the 15th of January and his rent is $1520. Since he lives in a city without public Transportation he decides to purchase a new the same day that he starts work and his first payment of $388.00 isn't due until March 10th. His additional monthly expenses are: Utilities-$200; Cable $49.99; Cell phone$100.00; Gas $100.00 Food (groceries) $374.00; dry cleaners $45; He plans to spend no more than 15% of take home pay on Dining and entertainment. Car insurance $110; he pays someone to clean his apartment for $50 per month; He joined a gym in Feb $30 per month; He gives to his church $100 per pay period and also gives back to his community$75 per month to the local YMCA. He gets a haircut twice a month $20 and his student loan payments begin March 1 $125; his goal is to put aside 5% for retirement and 5% in a personal savings per pay period. He got a credit card in December and the Balance owed is $250.00 on which he pays the minimum due in January 25th but plans to pay it off during February. He has to pay $125 per pay period in child support for his 3 year son who lives with his mother. Instructions: Using the worksheets provided prepare a budget for Jan and Feb for Johnny B i Income Calculator 2 Monthly Amount 1 Monthly Amount 2 3 GROSS INCOME * Category 5 Wages, Salary, Bonuses 6 Interest Income 7 Investment Income Other Income (e.... child support, alimony) 9 Monthly Amount Monthly Amount 10 TAXES WITHHELD AND PAYMENT DEDUCTIONS 12 Category 12 Federal Income Tax 13 State and Local Income Tax 14 Social Security and Medicare Tax 15 Employer Health Insurance Premium 16 Employer Retirement Plan Contribution (e.g., 401k) 17 Other 18 19 TOTAL Monthly Amount 20 Category 21 (Subtract taxes and deductions from gross income) Monthly Amount 0 0 22 Personal budget 1 2 3 4 INCOME 5 Wages 6 Interest/dividends 7 Miscellaneous 8 Income totals 9 EXPENSES 10 Home 11 Mortgage rent 12 Utilities 13 Home telephone 14 Cellular telephone 15 Home repairs 16 Home improvement 17 Home security 18 Garden supplies 19 Home totals 20 21 Daily living 22 Groceries 23 Child care 24 Dry cleaning 25 Dining out 26 Housecleaning service 27 Dog walker 28 Daily living totals 29 30 Transportation 31 Gas/fuel 32 Insurance 33 Repairs 34 Car Wash/detailing services 35 Parking 36 Public transportation 37 Transportation totals 3B Dues/subscriptions Magazines Newspapers Intemet connection Public radio Public television Religious organizations Charity Dues/subscription totals Personal Clothing Gifts Salon/barber 5 Books Music (CDs, etc.) 3 Personal totals 2 Financial obligations 1 Long-term savings Retirement (401K, Roth IRA) 3 Credit card payments 4 Income tax (additional) 5 Other obligations B Financial obligation totals 7 8 Misc. payments 9 Other 00 Other 1 Other 32 Other 33 Other 04 Misc. payments totals 35 06 Total expenses 07 Cash short/extra 08