Managing your Personal Finances Apartment Expenses C114 1

Managing your Personal Finances Apartment Expenses C-114 1

Do Now n Review Friday’s notes and answer the following on today’s Lesson Handout: List three (3) apartment amenities n Please create a list of apartment utilities n Please answer: n How can being organized improve your ability to track monthly apartment expenses? n 2

Do Now(continued) n Please answer: n How can being organized improve your ability to track monthly apartment expenses? n Name 1 way to organize this: 3

Standard 4. 1 Students will be able to understand factors associated with the cost of living space choices and furnishings 4

Lesson Goals • Students will be able to understand the typical expenses associated with an apartment • Students will be able to complete simple tasks within Excel

Quick Review You used the www. apartments. com website to research four apartments. n You chose one of them based on criteria important to you. n Some of the more important criteria were location, price, layout, and amenities. n 6

Monthly Rent n Average cost of a one bedroom apartment in South Jersey n $800 - $1200 7

Landlord’s Insurance n Landlord carries business insurance that covers: any structural damage due to vandalism, fire and certain inclement weather n personal liability for accidents occurring outside of the units. n 8

Renter’s Insurance n Renter should carry insurance that covers: loss of personal property due to theft, fire or other covered loss n personal liability for accidents occurring within their unit n 9

Personalize n n What does sentimental mean to you? What are some important or sentimental items you would want insured? 10

Renter’s Insurance n Determine if insurance is actual cost or replacement cost Actual cost will be current market value (depreciated cost) n Replacement cost is price paid when purchased a. k. a. original price (typically higher) n 11

Renter’s Insurance Pricing Typical Policy provides: n $30, 000 Property Coverage n $100, 000 Personal Liability Coverage n Cost is around $12 per month n Might require additional insurance for certain breed of pets n 12

Renter’s Insurance Tips Keep a list of possessions and their receipts to prove what was stolen or destroyed n Keep a video recording of your possessions (panoramic view of each room) n Keep the list of receipts and recording in a safe place outside your apartment n 13

Electric n Lights, appliances, TV, computer, etc n n Air Conditioning – central or window n n Average $60 per month Monthly Bill will depend on outside temperature and settings Possibly cooking, hot water, heat Monthly Bill will depend on usage and outside temperature and settings n Could be very expensive n 14

Gas n Cooking, hot water, heat Monthly Bill will depend on usage and outside temperature and settings n Could be very expensive n 15

Cable n n n Basic Cable Premium Channels n HBO, Showtime, Sports Package (Red. Zone, Soccer) High Definition DVR Broadband Internet Router/Wi. Fi 16

Personalize n n n How many hours per day(average) do you watch TV? What cable channels are a necessity to you? Which ones do you want? 17

Telephone n Landline n n Going the way of the dinosaurs Discussion n Give me good reasons why you might keep your landline? 18

Cell Phone/Tablets n Typically requires Wi. Fi n Hot topic: Can you live without it? n How much is your monthly bill? n Average monthly bill is $73 19

Excel Mini-lesson Open Microsoft Excel Average Apartment Monthly Expenses Bill Renter’s Insurance Electric Gas Cable Cell Phone Monthly $900 $12 $60 $40 $125 $75 Annually $10, 800 $144 $720 $480 $1, 500 $900 $1, 212 $14, 544 20

Let’s add it up… Rent - $900 n Insurance - $12 n Electric - $60 n Gas - $40 n Cable - $125 n Cell Phone - $75 n 21

Using the Excel spreadsheet 22

Formulas in Excel Total = sum(A 1: F 1) n Multiply = A 1*B 1 n Divide = A 1/B 1 n 23

Advantages of Using Excel n n Accurate calculations Copy and paste features Better organization of information Performs “What if Analysis” example: What will my salary have to be in order for my rent to be within the 30% rule? 24

On Your Own – Excel Activity n Quick Guided Practice Calculate yearly expenses by using monthly expenses * 12. n Calculate both monthly and yearly income (salary) amounts needed. n Change a few expenses. What happens? n 25

Exit Ticket(Part 1) n n Can you think of a better way of organizing your spreadsheet information? Please write and share your thoughts with a neighbor. Which one of the monthly expenses discussed today surprised you? 26

Exit Ticket List two (2) ways Microsoft Excel simplifies or allows you to keep accurate records and predict future expenses: 1. _____________________________________________ 27