



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 6
This page cannot be seen from the preview
Don't miss anything!
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.