#Budgeting, #Household Math - Budgeting Basics - Expenses

Question

How do I budget for expenses? 

Answer

This will take a few posts to do, but in this one we simply identify all the possible outlays you experience and put them in a spreadsheet.

Analysis

As we start preparing a budget, it's important to first identify where money goes. Do you pay rent or a mortgage? Pay for a car? Insurance? Gas? Or perhaps transit - maybe a daily fare or a monthly transit pass? Utilities? Cable? Phone (landline and/or mobile)? Food?

Let's first list out those items that you know about into a list (we'll be modifying the list, and so using a program like Excel (PC), Numbers (Mac), or Sheets (Google - it's free and can be used online). Here's a sample:

Mortgage
Condo Fees
Condo Insurance

Water
Electricity
Gas (Note: the heater and stove are natural gas)
Cable

Phone, landline
Phone, mobile

Groceries

Dining out

Auto payment
Auto insurance
Auto fuel
Auto maintenance, repairs


And perhaps you have other expenses that need to be added into this list. If you think of it, write it down!

Once you've done that, take a look at your credit card statement for the past few months. Do you see things there that aren't on the list? Clothing? Add it. Video games? Add it. Go ahead and put in all the categories you think of.

I've built a google spreadsheet to follow along with these posts (it's view only):

https://docs.google.com/spreadsheets/d/1ZxwZz7Nn5ZYVV-x6HgPavTP6wkfIswP8-NTvV9gTTR4/edit?usp=sharing

In our next step, we'll add numbers.

This post is part of a series on budgeting - Budgeting 101

~~~~~

As always, questions and comments welcome!

#Budgeting, #Household Math - Budgeting... What's it good for?

Question

It's great that I read everywhere about the need for a budget, but what is it?

Answer

A budget is a tool that people use to figure out their financial health.

Analysis

I like this definition enough that I'll repeat it:

A budget is a tool that people use to figure out their financial health.

The most basic question that can be answered is "Am I living within my means?". More complicated questions can also be answered, such as "Can I afford that expensive thing?". Questions involving more involved financial questions, such as "At what age can I retire?", will probably require a Personal Wealth Plan of some sort - simply analyzing monthly spending probably will be insufficient to answer that kind of question.

The main idea behind the budget is to see where your financial strengths and weaknesses are. Where there are financial weaknesses, you can then develop strategies to deal with them. For instance, if it turns out expenses are higher than income, the budget can identify that that is the case and then steps can be taken to address it.

To budget, we look at the two sides of financial life - Money coming In and Money going Out. In future posts, I'll reference topics in the post about the Statement of Cash Flows for a business because there will be some overlap in concepts.

The first place to start is to think about your expenses and how often they occur. For most people, the big expenses occur once per month (rent/mortgage payment usually being the biggest of them all). And so, in general, it's best to work with a budget that looks at a monthly timeframe (we'll deal with non-monthly expenses and incomes in their respective sections).

I think the last thing to say about what a budget is is that it's something that can be quite individualized. Depending on how exacting you'd like to be can greatly affect the budget. What are the items you want to track? What are the items you don't want to track? Generally if there is a lot of guilt and shame involved, like perhaps the "amount of money spent at coffee shops" or "the amount of money spent online shopping", those are items that need the most attention!

In future posts, we'll talk about the How of budgeting...

This post is part of a series on budgeting - Budgeting 101

~~~~~

As always, comments and questions are welcome!

#Accounting, #Household Math - Moving the accounting into the home...

Question

Do accounting principals apply to my personal financial life?

Answer

Absolutely! See below for a few ideas...

Analysis

Bookkeeping and accounting really only refer to the tracking of financially-related transactions over the course of the life of a financial entity. That entity can be a company, a government, or a person/family - to anything that conducts any sort of business, accounting applies. Of course, as the complexity of the entity increases, so do the challenges of recording those transactions and making sense of the resulting information.

One of the ways we see how this applies is in the preparation of tax forms. When filling them out, you are essentially asked to account for income that's been made (from various sources and it matters where money comes from because the tax treatment can change based on the source). Alongside that, you are also asked to account for specific types of expenses - say for instance mortgage interest - because those monies spent are treated as deductions (and again, the reasons for those payments will determine how the tax calculations are done). For most people, taxes are a nightmare requiring frequent sleepless nights, gathering information. However, if an accounting system is implemented and used throughout the year, the burden (physically and mentally) of filling out the forms would be greatly decreased.

Another place accounting shows up in a household is through budgeting (company's call it financial forecasting or some such other term). What is anticipated that will be made in income? What is anticipated that will be spent? Is the income number bigger than the expenses number???

And one more place I'll mention is in the area of Needs vs Wants - or the making of financial decisions. For instance, while there is a need for a car, does that mean you need the newest Mercedes? On the other hand, is it financially better to buy an old clunker, given that it'll need more repairs and work?

~~~~~

Comments and questions always welcome!

#Household math - Which is the better value? Loose tea or tea bags?

Question

There's a lovely tea shop I go to sometimes. Which is the better way to buy tea, loose or in bags? The instructions say to use 3-5 g of loose tea in a pot. Here's a photo I took to help:

Answer

Financially, under my assumptions, the tea bags are a better way to go.

Analysis

First off, and probably to the dismay of tea lovers around the world, I'm going to assume that the tea experience from loose leaves and from a bag is the same.

In order to understand the financial aspect of this question better, we need to express the tea usage in terms of servings. I'll assume that 1 tea bag is a serving and that it's equivalent to the 3 - 5 grams mentioned in the question.

I'm also going to assume that the price points on the teas are for the same categories of teas (the selections of Lesser, Medium, and More Expensive teas are the same).

Let's chart out the cost per serving:

~~~~~

As always, feel free to ask a question!

#Household math - Which size is the better option?

Question

While shopping online for tea I found a type of tea I like with 2 options for buying it: 16 bags for 134.30 of my currency and 24 bags for 169.89 of my currency. Which is the better option?

Answer

It's far cheaper to buy the bigger box assuming you are actually going to drink the tea. If you are more of a tea collector than a tea drinker, it's better to buy the smaller box.

Analysis

To answer this type of question, we need to set up equal terms so that we're comparing "apples to apples". One way we can do that with this problem is to look at the price per tea bag. We can set up the math for this in this manner:

Price / number of tea bags = price per tea bag

For the two options:

134.30 / 16 =  8.39 units of currency per tea bag

169.89 / 24 = 7.08 units of currency per tea bag

There is roughly a savings of 1.30 units of currency per tea bag, which is a big savings (when looking at this in percentage terms). To look at this problem in that way, we take the savings and divide by the better price per unit:

1.30 / 7.08 = 18.4%

And so the first method of buying the tea is wildly more expensive than the second.

The only caveat on this result is that, if you are like so many people who do more collecting of tea than of drinking it, then buying less is better. However, if you are intending to drink the tea, it's far better to buy the bigger box.

~~~~~

Please feel free to ask a question!

#Accounting - What's a T account? Why use them?

Question

What's a T account? And why use them?

Answer

A T account is a simple but effective way to organize the activity in any given account.

Analysis

Let's first talk about accounts. An account is a way to gather similar activity in one place. For instance, over the course of a year, let's have Sample Co. have a number of sales throughout the year. We can sum up those sales to see the sales activity for the year. For an example, let's have Sample Co have sales of $100,000 for the year.

This $100,000 sales figure is made up of smaller sales throughout the year. We list them individually as they happen. A part of that list might look like this:

$500
$1000
$250
$300

and so on.

Some transactions will increase the balance of the account and some will decrease that balance. Take the account Cash for instance - as sales are made, cash comes into the company. As inventory is purchased, salaries are paid, and other outflows are accounted for, the balance of the account decreases.

One way to show this would be to list out all the transactions in a single list:

 $1,000
-$350
-$15
-$25
$300

and so on. Which can get messy.

Another way to look at the accounts is to put all the amounts that increase the account in one list and all the amounts that decrease the account in another list. To save space and to keep things organized, we can draw a T, put the account name above the crossbar of the T, and have amounts on one side of the T's vertical line increase the account and on the other side put those amounts that decrease it. It'll look something like this:


        Cash
------------------
$1000 |
           | $350
           | $15
           | $25
$300   |

~~~~~

As always, if you have a question, please ask!

#Household math - Which is the better way to pay for an online school when dealing with referral credits?

Question

I'm looking at joining an online school website that has over 22,000 courses in all sorts of different topics (I'm interested in some portion of them that relate directly to my interests). The cost for joining this website is $15/month but if I join for a year, I pay $99. To make things more complicated, I have 2 coupons for 1 month off each (one is the usual offer from the website and the other is as a referral coupon - I got one and the person who referred me also got one). What's the best way to join the website?

Answer

It's best to subscribe for a year, unless you are going to receive 2 or more referrals every month. 

Analysis

This is an interesting question because of the twists and turns in what's available in terms of options. The key is going to be to put everything on equal terms so that we're comparing "apples to apples".

Let's look first at what happens if we look at the options without regard to the coupons. We're comparing the regular monthly cost of $15 vs the monthly cost of $99 over 12 months, which is $8.25 per month. Clearly it's better to pay less per month! But... what if you don't use the site for all 12 months? What's the number of months that'd you have to use the site on the yearly plan to have it cheaper than paying $15/month?

We can find that by dividing the yearly cost of $99 by the monthly cost of $15. This gives 6.6, or in other words, it's better to pay by the month if you'll use the site for 6 or less months. For 7 or more months, it's better to pay the yearly amount.

Now let's look at the coupons. When paying by month, the coupons give 2 free months (and so for the cost of 1 month for $15, you get 3 months). When paying by year, you get 14 months for the cost of 12. What that works out to be is, when paying monthly, $15 for 3 months is $5 per month. When paying yearly, $99 for 14 months, that's $7.07 per month. And so there appears to be a better financial result to pay for 1 month and pay $15, use the site for 3 months, then change over to a yearly plan. However, that ignores a couple of factors, and so the best way to calculate this is to calculate the monthly cost over the course of the annual plan, then look at the associated monthly cost.

Using the yearly plan, you get 14 months for $99. Using the monthly plan first and then paying for the year, you get 15 months for $15 + $99 = $114. To compare the two, we divide the $114 by 15 (to get the per month rate), then multiply by 14 to get to the same number of months under the yearly plan:

And so it's best to pay for the year and get the 2 free months added on.

The one exception to this would be if there is an expectation of receiving 2 or more referral codes per month. If that's the case, it'd be better to stay with the monthly plan until the likelihood falls off of getting those referral codes. At 1 referral code or less per month, it's better to pay yearly.

~~~~~

As always, feel free to ask a question!

#Accounting - Accounting requires organization, not advanced math...

Question

I want to study accounting but I'm afraid to do it because I'm not good at math. What are your thoughts?

Answer

The good news is that accountancy rarely goes beyond basic arithmetic (adding, subtracting, multiplying, dividing). In fact, accountancy is far more about organizing and classifying information rather than manipulating it. 

Analysis

As a for instance, let's take a sample transaction and look at how an accountant would treat it.

Stan's Superheroes (a store specializing in superhero collectables) sold a Baitman figurine (it's a knockoff of Batman - this one is of a cowled fisherman who fights crime on the docks) for $10. The customer paid cash. Stan originally bought the figurine for $3. How do we book this transaction?

And now let's watch how an accountant works through this question.

• Cash has increased by $10, so the account Cash is increased (Debit)
• Sales have also increased by the same amount, and so the account Sales is also increased (Credit)
• The inventory has decreased by the amount originally paid for the figurine, and so it decreases by $3 (Credit).
• The last account, which is the Cost of Goods Sold, increases by $3 (Debit).

Accountancy also gets into reasonableness. For instance, would it be reasonable to conclude that Stan's Superheroes makes $1,000,000 per year from sales of Baitman? Probably not - and it's the role of the Auditor (a type of accountant) to examine those types of situations.

Bottom line, most accounting does not involve anything more than basic math. If however you are interested in stretching your math muscles within the accounting world, Cost Accounting might be for you (it's a type of managerial accounting that does it's best to examine a business from top to bottom, in all its processes, and put them into financial terms so that the management of a company can make better business decisions).

~~~~~

Questions and comments welcome!

#Household math - How many times use a purchase to make it worthwhile...?

Question:

If I buy a table for 590 THB and I want to use it for art. Paying for a latte in a shop is approx. 60 baht per beverage and I consume anywhere from one to three lattes when I draw. How many days of drawing at home will it take for me to pay off the table?

Answer

A minimum of 4 art days out, a maximum of 10 art days out.

Analysis:

Let's first talk about Sunk Cost, which is the concept that once money is spent, it's gone. Nothing you do subsequent to buying the table is going to make the money come back. And so any decision you make concerning having coffee has no bearing on the cost of the table.

Now to the question at hand.

If we look at the number of lattes it takes to exceed the cost of the table, that's:

cost of the table/cost of a coffee = coffees equal to the cost of the table:

(on the 10th coffee, the coffees are worth more).

If we assume 1 coffee per art day, that's a maximum of 10 art days out.
If we assume 2 coffees per art day, that's 5 art days out.
If we assume 3 coffees per art day, that's 4 art days out.

~~~~~

Please feel free to comment or ask a question!

#Household Math - Credit or coupon for defective goods

Question

I bought some art supplies for $65 and found that a portion of them are defective. I was given a credit of $20. Later, I found that the remaining part of them are also defective. The retailer is offering me a 10% off coupon on a future purchase. Should I accept the coupon or should I try for another credit?

Answer

In all likelihood, unless there is a very large purchase you'd like to make, the credit will be better than the coupon.

Analysis

There are a couple of things going on here, but the most relevant question is: Which is better? A 10% coupon or a credit of some amount?

So let's talk about the results from each possibility.

The 10% coupon will offer some money back on a future purchase. For this to be worthwhile, we first need to assume that there will be a future purchase! If you are so disgusted by the quality of the product and the retailer isn't trusted, then the coupon would be absolutely worthless.

Let's assume there is an intention to order again. To get the most out of the coupon, you'll want to order as much as you can in order to get the maximum benefit (keeping in mind that you don't want to buy more than you reasonably need!)

The credit is an unknown quantity, but we can assume that the company will offer, at most, the remaining $45 of the original purchase price.

So how much do you need to buy using the coupon in order to have it equal the potential credit?

For this, we can set up an equation.

On one side, we'll have C, the credit. On the other, we'll have B, the amount you'll buy. Since we'll pay 10% less than usual, the amount of benefit we get from the coupon is 10% X B:

C = 10% X B

We can multiply both sides by 10 to get:

10 X C = B

So what does this say? Let's throw in a number - if the expected coupon is $20, we'd have to buy $200 worth of goods for the coupon to worth just as much. If we expect to buy more than that, then the coupon is better. If we expect to buy less, then the credit is better.

ANSWER KEY (alternate variables)

At 10% coupon:

C = $10, B = $100
C = $30, B = $300
C = $45, B = $450

~~~~~

Please feel free to comment or ask a question!

#Admin - A new blog, a new beginning, a new conversation on math-y topics!

Hello one and all and welcome to Math Fact-orials!

In this post, the first of this blog, I'll talk quickly about me, this blog, what I hope to achieve, and all that.

About me

I love thinking and learning and sharing what I'm thinking and learning. Most recently, I was a Hero and Featured Answer Reviewer (Algebra, PreAlgebra, English Grammar) with www.Socratic.org, with (at the time of this writing, with roughly 2 weeks of life left in Socratic):

- over 890,000 views,
- 2400 answers, and
- 700 edits of existing answers.

But since that website is currently scheduled to be shuttered mid-August 2018, I've decided to start my own Question and Answer site (i.e. this blog) that will focus on things I find important/interesting/fun/etc.

Some more things about me:

- Formerly a Certified Public Accountant (in the USA) and a Chartered Accountant (in Canada)
- Holder of a Life Coaching certificate
- Spent a few years in the US Navy as a Supply Corps officer

About the blog

While I don't want to set anything in stone (this is a living blog after all, so it will morph and change as I do), there are a couple of areas I'll tend to focus on at the start: Combinametrics (or the number of ways of doing/arranging/organizing things) and something I'll call Life Math - this will encompass things like Business Math, Budgeting, Investing, Accounting, Financing, and all those non-sexy math topics that academics tend to shun. Life Math, by its very nature, is a bit more "squishy" than academic math - there typically are more "squishy" answers than in academic math. For instance, is a 10% discount on a shirt a good discount? It might be, but then again it might not be - it's up to the reader to decide. But in these kinds of questions and answers, I'll do my best to lay out some things to think about.

I intend to right about how to approach a problem as the first part of any blog post, and then to have an "Answer Key" below, which will show the various answers with changes in the starting facts. For instance, if a shirt that costs $30 has a 10% discount (with a final cost to the customer of $27 before sales tax), the same process will work if the shirt is $40 and there's a 20% discount (with a final cost of $32 before sales tax).

Questions are very welcome!!!

If you have math questions, please do ask! Post a comment (I approve all comments) and I'll be sure to respond and write on the blog in response. No names/specific locations will be used and so don't worry about anonymity!

And I think that just about does it - so Welcome! and I hope to hear from you.

Parz

Update, 22 Aug 2018

Through editing and updating the organization of the blog, I'm hoping it'll be more useful (and easier to find the information you are interested in!). Links, labels, and subjects are all being edited, reworked, and otherwise made better. Get ready for Math Fact-orials 2.0! (or maybe just 2!... - factorials and decimal points don't get along very well...)