Create a worksheet in Excel of your monthly income and expenses. Note: You don't have to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a worksheet in Excel of your monthly income and expenses. Note: You don't have to use your actual monthly income and expenses unless you want to. I won't share this with anyone. It should include the following: I. A well formatted and visually appealing data sheet that covers Jan. thru December with the following parts. You should have at least 10 Monthly expense categories. • Monthly income i) Your income 11) Spouse/partner income (if any) iii) Any other interest, dividends etc. Monthly expenses (examples) i) Food ii) Eating out and/or Starbucks . iii) Transportation iv) Medical v) Education (tuition books, etc.) vi) Entertainment vii) Rent or Mortgage viii) Utilities ix) Insurance x) Internet/Cable/Phone (cell and/or landline) xi) Grooming (Haircuts/nail polish, etc.) xii) Pets (food, vet, etc.) xiii) Other or Misc. (those things that don't fit above) • Total your income for each month (write a formula) • Total your expenses for each month (write a formula) • Show your net income for each month. The net income is the amount left over after you subtract expenses from income. (write a formula) • Create a running total of your net income from January to December. See Module 3, case problem 1 and/or Week 4 extra help on Running Totals. • Format the amounts as currency with 0 decimal places with a comma separator for thousands. • Sparklines: At the end of each row for your income and expense categories, insert sparklines (use a line Sparkline). • Name the worksheet "Monthly Income and Expenses" II. Create an appropriate column chart* of your total income, total expenses and net income for each month of the year. Move the chart in its own worksheet. Name the worksheet Budget Chart. • Choose a chart style • Change the Chart title to Income & Expenses. • Make sure the chart has a legend. • Make sure the chart has axis titles too. • Make the chart readable and visually appealing. See Module 4 if you need help III. Documentation worksheet • Create a worksheet labeled "Documentation" Put the Documentation worksheet before the Income and Expenses worksheet. Include name, title, and date in cells A1:A3 of the documentation worksheet. List your name, "Monthly Budget" and today's date (use the TODAY function) in Cells B1:B3. IV. Page layout • Make the orientation of each of the worksheets landscape • Make sure that each worksheet fits on one page. • Make a custom footer with your name on left, page # in middle and worksheet name on right Create a worksheet in Excel of your monthly income and expenses. Note: You don't have to use your actual monthly income and expenses unless you want to. I won't share this with anyone. It should include the following: I. A well formatted and visually appealing data sheet that covers Jan. thru December with the following parts. You should have at least 10 Monthly expense categories. • Monthly income i) Your income 11) Spouse/partner income (if any) iii) Any other interest, dividends etc. Monthly expenses (examples) i) Food ii) Eating out and/or Starbucks . iii) Transportation iv) Medical v) Education (tuition books, etc.) vi) Entertainment vii) Rent or Mortgage viii) Utilities ix) Insurance x) Internet/Cable/Phone (cell and/or landline) xi) Grooming (Haircuts/nail polish, etc.) xii) Pets (food, vet, etc.) xiii) Other or Misc. (those things that don't fit above) • Total your income for each month (write a formula) • Total your expenses for each month (write a formula) • Show your net income for each month. The net income is the amount left over after you subtract expenses from income. (write a formula) • Create a running total of your net income from January to December. See Module 3, case problem 1 and/or Week 4 extra help on Running Totals. • Format the amounts as currency with 0 decimal places with a comma separator for thousands. • Sparklines: At the end of each row for your income and expense categories, insert sparklines (use a line Sparkline). • Name the worksheet "Monthly Income and Expenses" II. Create an appropriate column chart* of your total income, total expenses and net income for each month of the year. Move the chart in its own worksheet. Name the worksheet Budget Chart. • Choose a chart style • Change the Chart title to Income & Expenses. • Make sure the chart has a legend. • Make sure the chart has axis titles too. • Make the chart readable and visually appealing. See Module 4 if you need help III. Documentation worksheet • Create a worksheet labeled "Documentation" Put the Documentation worksheet before the Income and Expenses worksheet. Include name, title, and date in cells A1:A3 of the documentation worksheet. List your name, "Monthly Budget" and today's date (use the TODAY function) in Cells B1:B3. IV. Page layout • Make the orientation of each of the worksheets landscape • Make sure that each worksheet fits on one page. • Make a custom footer with your name on left, page # in middle and worksheet name on right
Expert Answer:
Answer rating: 100% (QA)
There is no functionality to upload an excel file he... View the full answer
Related Book For
A Survey of Mathematics with Applications
ISBN: 978-0134112107
10th edition
Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde
Posted Date:
Students also viewed these organizational behavior questions
-
Develop a monthly budget by estimating your monthly income and your monthly output. Your monthly income should equal your monthly output.
-
1 Outline the advantages and disadvantages of Mo Cheng's decision to pilot her questionnaire with her friends. 2 Critically review Mo Cheng's approach to sampling and her subsequent data collection...
-
Find the average maximum temperatures for each month of the year for two or more locations (e.g., Cambridge, England, and Cambridge, Massachusetts; there are lots of towns called Cambridge) and graph...
-
A) Suppose you wanted to make a photoconductor that interacts in the visible, green light range (500-570 nm). Which of the following semiconductors would be your best choice, and why? Si, AIP, InAs,...
-
Hot-air heating control systems for large buildings may involve significant dead time if there is a large distance between the furnace and the room being Heated (Figure P12.19). Proportional control...
-
In health communication, what are the major implications of the potential tension between patients health beliefs and desires? Can you provide a practical example or personal experience that...
-
A smooth, flat plate of length \(\ell=6 \mathrm{~m}\) and width \(b=4 \mathrm{~m}\) is placed in water with an upstream velocity of \(U=0.5 \mathrm{~m} / \mathrm{s}\). Determine the boundary layer...
-
The trial balance for Hanna Resort Limited on August 31 is as follows: Additional information: 1. The balance in Prepaid Rent includes payment of the final month's rent and rent for August 2014. 2....
-
When the engine falls out of Rhonda's old car, it's time to shop for something newer. She is hoping to keep her monthly payment at $160, and a loan will be 5.4% simple interest for 48 months with a...
-
Ricky Bobby is divorced with two dependent children, ages 9 and 11. During 2022, Ricky had the following gross receipts: Salary income Passive loss from Alpha Partnership (Ricky is a limited partner...
-
What real-world examples exist for applying lean, agile, kanban, and scrum methodologies in industries outside of construction? How have these methodologies contributed to improving project agility...
-
1. Suppose you are a portfolio manager of a U.S. mutual fund. Your portfolio consists entirely of British government bonds. For simplicity assume that the bonds have a face value of 3,000,000 and...
-
The electricity supply of a certain U.S. state needs to be increased. The state is very cloudy and rainy from October to April. There are several large rivers, and there are almost no areas with high...
-
TASK 1 Makeit Pty Ltd is a local manufactures. The company wishes to use all available small business concessions to minimise taxable income. Makeit Pty Ltd has prepared the following Profit & Loss...
-
Using the information above, prepare the statement of activities and the statement of net position on a government-wide basis (using full accrual accounting). The beginning fund balance in the...
-
Common Distributions Normal X N(, 0) 1 f(x)=- exp (x-) 20 27 E.g. the height of the entire population Please describe a way to generate 30 data points or realizations of the Random Variable (R.V.)....
-
Ltd. has one class of shares. The company issued 5,300 shares on January 1, 2022, at $4.15 per share. On December 15, 2022, the company issued an additional 9,800 shares at $ 6.30 per share. On March...
-
If there is an unrealized holding gain on available-for-sale investments, it is reported as?
-
Write an equation that has solutions -1 and 3.
-
Morgans is the largest department store in New York. So shop at Morgans and save money. Discuss the statement and tell what possible misuses or misinterpretations may exist.
-
Convert 149 lb to kilograms. Choose the best answer.
-
Why is the definition of quality critical to the success and acceptance of a project?
-
What would the QA/QC planning grid (see Figure 12. 6) look like for a project you have been involved in? Data from Figure 12. 6 Table 12.6 QA/QC planning grid, with examples Quality assurance...
-
What quality systems and standards exist in your organisation to 1) ensure quality across the project and 2) ensure quality within the products and services produced by your projects?
Study smarter with the SolutionInn App