Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your assignment is to create a workbook for planning a personal budget for yourself Your workbook will have two worksheets, one with your budget and

image text in transcribed
Your assignment is to create a workbook for planning a personal budget for yourself Your workbook will have two worksheets, one with your budget and one with a chart. Your budget will be based on a real job that you hope to have and realistic costs of living in this area. Therefore, you will begin by choosing an entry level job and figuring out what your annual starting salary will be. Assume you are living on your own in your own House or Apartment. You could also use a current or past job if that is better for you. Use monster.com or careerbuilder.com or another website to help look up the salary. After looking up the annual salary, then just for consistency have a gross pay line, then take a percentage of taxes/deductions out-you decide 15%, 20%, 25%-up Assig Res to you ; have a line item and calculate a formula for the tax Once you have found the job of your choice you will begin creating your budget worksheet Your budget worksheet should include appropriate formulas and formatting. . o o o Show two decimals on all values/results with Accounting Format Bold all headings Center a title with Your Name YEAR Family Budget merged and centered across all columns used. Make the font size larger than your other text. The worksheet should include your monthly income; assume you will be working . full time. Your budget worksheet should be for a year; starting in January 2019 Rename the worksheet tab to a more appropriate name other than Sheet 1 Change the color of the worksheet tab to your favorite color. Include at least seven expenses broken down by month. Remember some months certain expenses may be higher than other months. Some expenses you don't pay every month. For example, I pay a water bill for my home-but it's quarterly Gas or Electric may be higher in winter to heat your home (or you may pay the . . same amount each month on a budget payment schedule), school major expenses only really come at the beginning off each semester. You may not spend money on clothes every single month, but may put money every other month or every three months. hava . 11se some of these and J

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Eco Management The Elmwood Guide To Ecological Auditing And Sustainable Business

Authors: Ernest Callenbach, Fritjof Capra, Lenore Goldman, Rudiger Lutz

1st Edition

1881052273, 978-1881052272

More Books

Students also viewed these Accounting questions