Create a personal expense analysis

Assignment Help Other Subject
Reference no: EM132266715

Budget Assignment

In this project you will create a personal expense analysis for a three monthperiod and then create a chart of your expense data. Take a look at a sample spreadsheet to get an idea of what you'll be doing.

1. Start Excel and begin a new blank workbook.
• Type Personal Expenses and your first and last name at the top.
• Type in the current month as your first column heading, and use the fill handle to create a series so that three consecutive months display as column headings.
• Type Total and Percent of Total to the right of the months as your last two column headings.

2. Enter Income as your first row heading.
• Below Income, enter at least six row headings for your monthly expenses. Some of the items you might list include, but are not limited to: Rent, Utilities, Daycare, etc.
• After you have entered all of the categories, type Balanceand Expense Total as the last two row headings.

3. Enter the amounts that you anticipate spending in each category for the next three months.

4. Create formulas to show totals.
• In the Total column, enter formulas to calculate category totals.
• In Percent of Total column, enter a formula to calculate the percentage of the overall total that goes towards each expense (category).Hint: If you use an absolute cell reference for the first formula, you can use the fill handle to copy it to the other cells.
• In the Balance row, enter a formula that calculates income minustotal expenses for each month.
• In the Expense Total row, enter a formula that calculates total expenses for all three months.

5. Format the worksheet by adjusting column width and wrapping text, applying appropriate financial number formatting, adding borders and fill colors, and adjusting the fonts and font sizes of the title and column headings.

6. Create a 2-D Pie chart that shows the percentage breakdown of your expenses by category.
• Make sure your pie chart includes data labels.
• Size and move the chart so that it displays centered below the worksheet data.
• Choose an appropriate layout and design.

Save your file as an Excel Workbook (.xlsx)
Include the term Budgetand your First Name when saving your file. Example:Budget_David.xlsx
Upload your completed document using the Browse button, and then click the Submit button.

Attachment:- budget assignment.rar

Verified Expert

The analysis of personal expenses reflects the highest portion of food and grocery expenses to the total expenses, which is around 22.63% of the total expenses. Utility expenses are at second place of forming highest portion to the total assets due to it is around 20.74%. Personal loan installment is at the 3rd place due to of forming around 18.02% portion of the total expenses. Rent expense is at fourth place for significant expense because of forming around 14.42% of the total expenses.

Reference no: EM132266715

Questions Cloud

Explain the value to the patient of incorporating cultural : Describe the cultural beliefs and values presented in the videos - Explain the value to the patient of incorporating cultural awareness in the education
Particular issue in critical thinking : Discuss how more recent thinkers have further unfolded the initial idea - Perhaps there are criticisms of the initial idea. What are they
Clinical reflection on the patient and dying process : Group Clinical Supervision Reflection Assignment - The assignment is to reflect on the patient and the dying process
Write a one to two-page summary of the article : Demonstrate your ability to summarize, paraphrase, and appropriately quote the work of others using technical writing standards and correct citation format
Create a personal expense analysis : Create a personal expense analysis for a three monthperiod and then create a chart of your expense data. Take a look at a sample spreadsheet to get an idea
How your arousal manifested itself physically : How would you describe how your arousal manifested itself physically? Were there distinct differences in physiological arousal associated
Describe the process of extracting data from images : Read the article about Extracting EXIF Data from Image Files then Describe the process of extracting data from images
Evaluate significance of pr within motorsport activity : MR2323 - Motorsport Public Relations - Myerscough College - Evaluate the significance of PR within motorsport activity - Create a plan for a short video
Evaluate the root cause for medicare fraud in this case : Speculate as to why Mr. Emeigh participated in the scheme. Explain what you might have done to prevent this from happening.

Reviews

len2266715

3/26/2019 4:40:30 AM

In this project you will create a personal expense analysis for a three month period and then create a chart of your expense data. Take a look at a sample spreadsheet to get an idea of what you will be doing.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd