Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Personal Budget Spreadsheet Analysis, Assignments of Statistics

A personal budget spreadsheet that tracks monthly income and expenses. The spreadsheet includes estimated and actual values for various expense categories such as rent/mortgage, utilities, insurance, credit card payments, car payments, gasoline, cable/internet, cell phone, food, clothing/personal care, and entertainment. The document also discusses how changes to the spreadsheet can affect the overall budget and deficit. The analysis includes creating a pie chart to visualize the expense categories, describing the part-to-whole ratio of where most of the money goes, calculating a part-to-part ratio using two actual values, and comparing the table of values to the pie chart. This document could be useful for university students, high school students, and lifelong learners interested in personal finance, budgeting, and data analysis.

Typology: Assignments

2023/2024

Uploaded on 04/30/2024

Somecreepystuff
Somecreepystuff šŸ‡ŗšŸ‡ø

2 documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Budget Spreadsheet
Monthly Income Estimated Actual Monthly Outcomes
Income from job $ 1,800.00 $ 1,825.00 Total Monthly Income
Other Income 1 $ 300.00 $ 300.00 Total Monthly Expenses
Other Income 2 $ 2,100.00 $ 2,125.00 Difference of Income - Expenses
Total $ 4,200.00 $ 2,125.00
Monthly Expenses $ 4,200.00 $ 2,125.00
Rent/Mortgage $ 725.00 $ 725.00
Heating $ 80.00 $ 90.00
Electric $ 75.00 $ 75.00
Water/Utility $ 50.00 $ 55.00
Credit Card $ 100.00 $ 80.00
Car Payment $ 200.00 $ 200.00
Insurance $ 150.00 $ 150.00
Gasoline $ 200.00 $ 175.00
Cable & Internet $ 150.00 $ 150.00
Cell Phone $ 60.00 $ 60.00
Food $ 200.00 $ 210.00
Clothing/Personal Care $ 20.00 $ 30.00
Entertainment $ 80.00 $ 75.00
Other cost 1 $ 2,090.00 $ 90.00
Other cost 2 $ 2,090.00 $ 2,165.00
Total $ 6,290.00 $ 4,330.00
This person (much like myself) estimated that they would have enough money to cover their expenses for the month
as the Estimated Total Monthly Income ($4,200.00) exceeds the Estimated Total Monthly Expenses ($6,290.00), which
results in a deficit of $(2,090.00).
However, in actuality, the person did not have enough money to cover their expenses for the month, (probably
because of their dog, Ulta, bars, and shopping.)
The Actual Total Monthly Income ($2,125.00) is less than the Actual Total Monthly Expenses ($4,330.00), resulting in a
deficit of $(2,205.00).
When I changed the value in cell C13 to 50, it affected the Total Estimated Monthly Expenses, causing it to decrease.
This will subsequently affect the Difference of Income - Expenses for the Estimated column, resulting in a change in
the deficit amount, (and the cycle continues.)
pf3
pf4
pf5

Partial preview of the text

Download Personal Budget Spreadsheet Analysis and more Assignments Statistics in PDF only on Docsity!

Budget Spreadsheet

Monthly Income Estimated Actual Monthly Outcomes

Income from job $ 1,800.00 $ 1,825.00 Total Monthly Income Other Income 1 $ 300.00 $ 300.00 Total Monthly Expenses Other Income 2 $ 2,100.00 $ 2,125.00 Difference of Income - Expenses Total $ 4,200.00 $ 2,125. Monthly Expenses $ 4,200.00 $ 2,125. Rent/Mortgage $ 725.00 $ 725. Heating $ 80.00 $ 90. Electric $ 75.00 $ 75. Water/Utility $ 50.00 $ 55. Credit Card $ 100.00 $ 80. Car Payment $ 200.00 $ 200. Insurance $ 150.00 $ 150. Gasoline $ 200.00 $ 175. Cable & Internet $ 150.00 $ 150. Cell Phone $ 60.00 $ 60. Food $ 200.00 $ 210. Clothing/Personal Care $ 20.00 $ 30. Entertainment $ 80.00 $ 75. Other cost 1 $ 2,090.00 $ 90. Other cost 2 $ 2,090.00 $ 2,165. Total $ 6,290.00 $ 4,330. This person (much like myself) estimated that they w as the Estimated Total Monthly Income ($4,200.00) results in a deficit of $(2,090.00). However, in actuality, the person did not have enou because of their dog, Ulta, bars, and shopping.) The Actual Total Monthly Income ($2,125.00) is less deficit of $(2,205.00). When I changed the value in cell C13 to 50, it affect This will subsequently affect the Difference of Incom the deficit amount, (and the cycle continues.)

Monthly Expenses Actual Rent/Mortgage $ 750. Utilities $ 205. Insurance $ 160. Credit Card $ 80. Car Payment $ 200. Gasoline $ 175. Cable +Internet $ 150. Cell Phone $ 60. Food $ 210. Clothing/Personal Care $ 30. Entertainment $ 75. i. Highlight your data and insert a pie-chart. ii. Give the chart a meaningful title. iii. Format your chart so that each pie slice shows both the percent and category labels. iv. Write a sentence describing where most of the money goes, using the sentence form of a part-to-whole ratio (why?). v. Calculate a part-to-part ratio using two actual values of your choice from the table and write a meaningful sentence describing it. vi. Do you prefer the table of values or the pie chart? Why? Save your spreadsheet with the changes and answers to the above questions and submit the completed file via IvyLearn.