23 Sep finance part one
| Create a Personal Monthly Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started. | |||||
| Title of this worksheet is in cell at right. Next instruction is in cell A5. | Personal Monthly Budget | ||||
| Projected Monthly Income label is in cell at right. Enter Income 1 in cell C5 and Extra Income in C6 to calculate Total monthly income in C7. Next instruction is in cell A7. | |||||
| Projected Balance is auto calculated in cell H4, Actual Balance in H6, and Difference in H8. Next instruction is in cell A9. | total monthly income | $8,000.00 | |||
| Actual Monthly Income label is in cell at right. Enter Income 1 in cell C10 and Extra Income in C11 to calculate Total monthly income in C12. Next instruction is in cell A14. | pre-tax deductions | deductions (multiplied by 4) | $2,756.00 | ||
| Medical | $20.00 | ||||
| dental | $20.00 | monthly Net Pay (total minus deductions) | $5,244.00 | ||
| vision | $20.00 | ||||
| 401 (k) | $100.00 | ||||
| Total monthly income | $160.00 | ||||
| Enter details in Housing table starting in cell at right and in Entertainment table starting in cell G14. Next instruction is in cell A27. | |||||
| State InsuranceTaxes | |||||
| social security | $120.00 | ||||
| medicare | $28.00 | ||||
| state disability insurance tax | $1.00 | ||||
| state unenemployment | $3.00 | ||||
| state family leave | $1.00 | ||||
| workers compensation | $0.00 | ||||
| Total monthly income | $153.00 | ||||
| Taxes | |||||
| Federal Income | $293.00 | ||||
| State income | $83.00 | ||||
| Enter details in Transportation table starting in cell at right and in Loans table starting in cell G26. Next instruction is in cell A37. | Total monthly income | $376.00 | |||
| HOUSING | Budget Cost | Actual Cost | |||
| Mortgage or rent | $1,000.00 | $1,000.00 | |||
| Phone | $42.00 | $42.00 | Total Budgeted Cost | $3,828.61 | |
| Electricity&Gas | $200.00 | $191.00 | |||
| Internet | $63.81 | $63.81 | Total Actual Cost | $3,538.52 | |
| Supplies | $0.00 | $0.00 | |||
| Enter details in Insurance table starting in cell at right and in Taxes table starting in cell G35. Next instruction is in cell A44. | Other | $0.00 | $0.00 | Total Difference | $290.09 |
| Subtotal | $1,305.81 | $1,296.81 | |||
| TRANSPORTATION | Budget Cost | Actual Cost | Savings | $1,805.48 | |
| Insurance | $236.45 | $236.45 | |||
| Fuel | $60.00 | $40.00 | |||
| Maintenance | $0.00 | $0.00 | |||
| Enter details in Food table starting in cell at right and in Savings table starting in cell G42. Next instruction is in cell A50. | Other | $0.00 | $0.00 | ||
| Subtotal | $296.45 | $276.45 | |||
| INSURANCE | Budget Cost | Actual Cost | |||
| Life | $29.00 | $29.00 | |||
| Subtotal | $29.00 | $29.00 | |||
| Enter details in Pets table starting in cell at right and in Gifts table starting in cell G48. Next instruction is in cell A58. | |||||
| FOOD | Budget Cost | Actual Cost | |||
| Groceries | $100.00 | $75.00 | |||
| Dining out | $20.00 | $19.00 | |||
| Other | $0.00 | $0.00 | |||
| Subtotal | $120.00 | $94.00 | |||
| Enter details in Personal Care table starting in cell at right and in Legal table starting in cell G54. Next instruction is in cell A61. | |||||
| PERSONAL CARE | Budget Cost | Actual Cost | |||
| Total Projected Cost is auto calculated in cell J61, Total Actual Cost in J63, and Total Difference in J65. | Hair/nails | $100.00 | $70.00 | ||
| Clothing | $157.35 | $100.00 | |||
| Dry cleaning | $20.00 | $10.00 | |||
| Subtotal | $277.35 | $180.00 | |||
| ENTERTAINMENT | Budget Cost | Actual Cost | |||
| Movies | $0.00 | $0.00 | |||
| Subtotal | $0.00 | $0.00 | |||
| LOANS | Budget Cost | Actual Cost | |||
| Student | $200.00 | $0.00 | |||
| Credit card | $400.00 | $30.00 | |||
| Credit card | $1,200.00 | $30.00 | |||
| Subtotal | $1,800.00 | $60.00 |
Sheet1
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.