(Solved): Create Income StatementUse the following to create an income statement (excel template provided belo ...

Create Income Statement

Use the following to create an income statement (excel template provided below).

• You pay a $350 car payment.
• You receive your monthly gross salary of $2,700.
• You receive a rent payment from your roommate of $450 per month.
• You pay your medical insurance of $75 a month.
• You pay your condo insurance of $25.
• You pay your car insurance of $100.
• You pay for monthly groceries of $275.
• Your monthly utilities are due. You owe $185.
• You pay $25 toward your credit card.
• Your monthly bill for gasoline comes in and you must pay $175.
• It’s your mother’s birthday. You purchase a $50 present.
• Taxes come out of your paycheck. Federal Tax $250 and State Tax $50 and Social Security $250.
• You go to a movie with a friend that costs $40.
• You put $100 into a savings account for a vacation at the beach.
• You put $200 in your Roth IRA and $125 in your employer's 401k. Your employer also matches your contribution 100% for the 401k.
• You hit a pothole and have a flat tire. You must pay $65 for a new one.
• You go out to dinner with friends. Your bill is $45.
• You find the perfect outfit for your date this weekend. You pay $100 for the outfit.
• You pay your condo mortgage payment of $750.
• You just received your income tax refund of $1,000. You decided to spend half on a flat-screen TV.
• You pay a $150 student loan payment.