Tag Archives: money management





View Time:Minutes




Create Family Budget in Excel

**Create Family Budget in Excel**



View Time:27:43Minutes



Need to learn how to create family budget to balance income and expenses? We’ve got you covered! This tutorial will teach you everything you need to know budgeting in Microsoft Excel in less than 10 minutes.


Full Guide Available Here:

Welcome to How To Analyze Data™! Enter into a Most Effective Way of Learning the most famous products worldwide. SUBSCRIBE to start learning anything you need in less than 10 minutes.

Check out Create a Personal Budget in Excel – Manage your Finances Online Training Course

Review other helpful resources on the subject

Download Source Files

Sign up to my email list to stay in touch:

Monthly Budgeting in Excel – Save More Money by Balancing Income and Expenses
Tutorial How to Improve Family Budget in 7 min – Look at the big picture | Personal Finance in Microsoft Excel

Why budgets don’t work – and what to do about it: | Personal Finance in Microsoft Excel

Monthly Budgeting in Excel – Save More Money by Balancing Income and Expenses

Thanks for leaving a review and providing feedback – I read them all and always try to improve.
hi there my name is Vadim Mikhailenko
from Online Training for Everyone where we teach you how to make smart decisions
by analyzing your data and learning about your tools in this tutorial we're
going to look at how to create a family budget using Microsoft Excel make
sure to download sample files from how to analyze data that met the topics
we're going to cover is going to look at what is the budget and how you can use
it for your benefits we're going to look at the different budget periods weekly
monthly annual and others we're going to look at how you can calculate your
income and look at the typical income categories and look at calculating
expenses and typical expense categories we're going to look at planned versus
actual zin the budgeting process and once it's done how you can add
formatting and graphs to make it more visual and more representative of what
you're trying to see and the last step we're going to look at the simple budget
files that come with Microsoft Excel so have an excel open then this is the
simple Microsoft Excel spreadsheet the first thing I'm going to do is we're
going to type in and create the title for our budget this is family budget and
obviously which you can do you can make it bold a little bit bigger and we're
going to play with the settings little bit later so the first thing in
understanding budgets is the simplest calculation of what you have you have
income and you have an expense and you have difference
for example the income might be $2,000 a month versus expense which is a $1,500 a
month and the difference would be income minus expense which is a $500 it's going
to expand the column a little bit what it shows to us is that the income is
what you've earned during particular budget period versus expenses which
you've spent during the same period in the difference could be positive or
negative if it's positive it is surplus this is money you still have after you
accounted for all of your expenses versus negative number which is where
you spend more than you've earned and that would be something where you have a
deficit we're going to apply a little bit of formatting since we're talking
about money here and that's did this by clicking the dollar sign and converting
this symbols into dollars so that's the basics of any budgeting you have the
very very simple formula where you look at the difference between income and
expense let's look at the different budget periods and budget periods as I
mentioned could be weekly could be monthly or could be annual or could be
even on the custom defined period schedule in Microsoft Excel what we can
do we can use one of the rows to define the period and I'm going to define and
show you how to do it differently we're going to start with annual I'm going to
do January February March and I'm going to show you one little trick where you
can just drag it and it will populate it and it will fill in the different values
for you so it automatically predicted that what we've done is we've
looked that we typed in just three months of the year and I use this little
rectangle at the bottom of the selection and I just intelligently Excel
intelligently filled in the options another thing we have is we can now for
example instead of doing period budget for the entire year we can do it on the
weekly basis let's say we have a 12 week so let's start with one particular date
would be July 1st 2014 and what we can do here we can say okay my next week
would be this date plus 7 right because we always have seven days and Excel is
smart enough as you will see to move it into the next month so we've done we're
done with July and Excel moves it into August and then into September and if we
would continue that it would move it into October as well so this are the
budget periods and whatever you need to do you just need to figure out what kind
of formula you have and what type of budget you would like to do in the
meantime I'm going to delete this role and I'm going to delete this simple
formula as I have mentioned already budget is the difference between income
and expenses so let's take a look at the typical income categories there are
multiple types of incomes and typically you have multiple family members that
might be earning income at the same time so what we're going to do here we are
going to say that in the income category we'll have income one from the first
family member and income two and this is typically defined as the salaries
also going to add couple more roles and here we are going to do a dividends dividends from stock investments from
other types of investments where we can do a business income
some people have business on the side or business might be some other income
related to business and that's where you would like to account it for obviously
what you would want to do you would want to are customize all of this categories
here for your own needs so for example if you don't have dividends or business
income you don't have to include it but I'm trying to make a generic template
that might be applicable for a lot of different people and the last category
into income I'd like to include is our capital gains and that also could be
from appreciated securities such as stocks or some other assets so what I'm
going to do to make it easier to view I have selected all different income types
and I am going to shift it a little bit so we can see that there's some
indentation between income and we can mark income as the category market in
bold I'm just going to add an extra line to make it visually more appealing next thing I'd like to look at the
expenses and different expense categories and as you will see there are
a lot more expensive or ease than income categories which tells us that we like
to spend money a lot more than earn them and there are a lot of different things
that we can spend them on so let's add some additional categories and if you
use a shortcut key control Y it repeats the last Microsoft Excel operation or
any office product operation so in expense categories I'm going to start
with housing housing um then I will add in addition to housing I'm going to add
transportation expenses then insurance then I'm going to add taxes I'm going to add the savings and
investments I'm going to add the food next category I'll add a personal care
category then legal category gifts and donations a couple of the categories I
will include as loans and entertainment so this are the major categories are for
expenses what I'm going to do next I'm going to look at how we can populate the
values here for every month based on the estimates that we know about and then
how we're going to also look and track this budget going forward so that would
be the next step so what I'm going to do next is I'm going to show you how you
can populate it here what kind of formulas can you apply for example for
income Island soom stable income in the amount of $2000 for income one and then
I will assume for income two stable income of $2,500 for the second earner $300 for the dividend once a quarter so
in the first month of the quarter business income of about 700 a month and
then capital gains once a year in the amount of $500 also going to change all
of this to dollar sign right here so it represents money and I'm just going to
add expense as the category here so let me
introduce the total column for the income and here I'm just going to make
mark it as total and you can use different formatting whatever is
convenient for you and I'm going to use autosum function which will do a sum for
the January for the month of January and this is our total income for January and
I'm going to expand it for the entire year and as you can see the incomes are
different for every months and that's on purpose so we can deal with the
different incomes so you can see the varieties of data here
let's do similar exercise for expensing for example housing might be a rent or
could be a mortgage payment let's assume it's around the amount of nine hundred
dollars stable and transportation could include fuel expenses or if you travel
by underground ways of transportation or by bus could be different amounts but
I'm just going to assume three hundred dollars a month
stable transportation costs insurance could include your life insurance could
include your medical insurance some of the premium insurances and typically
this is depending upon your income and the amounts that you insuring yourself
in this case I'll probably estimate in the amount of two hundred dollars even
though medical insurance always rising so you got to be careful and estimate
probably more conservatively taxes typically would be a percentage of your
total income so typically I would put one third of the income maybe a little
bit less than one third so let's just do $1,700 a month savings and
investment recommended amount is 10% of income or more preferably more between
10 and 30% hard to save 30% but it certainly pays off later in life when
you take advantage of compounding growth so let's assume that savings will be in
this case in the amount $550 food let's assume $300 months let's assume that
this is a single personal personal care would be $400 a month for both family
members legal might be a subscription to legal service and that probably is going
to be around $75 a month unless there are some additional large legal expenses
which is unlikely gifts and donations typically estimated 5 to 10 percent so
let's assume 7 percent that would be around $400 a month loan payments could
be student loans could be credit card loans could be some other things let's
assume that these are college graduates and they're paying off their student
loans so that probably would be around 400 dollars plus the credit card loans
that's a safe estimate nowadays and entertainment let's assume 200 dollars
for the entertainment monthly could include books concerts some other ways
of entertainment let's calculate total our hero is just apply dollar sign and
let's calculate total so we'll use autosum function and surprisingly or
maybe that we came up pretty close for the expenses pretty close to the
budget and the interesting thing here is that the total arm for income and total
for expenses is the same for expenses because I didn't estimate that there
could be different males but most likely some month you're going to have
varieties of payments for example legal fees maybe quarterly gifts and donations
may not be – such heavy amount but if you look at the difference now we're
going to the difference between totals and we're going to say that the
difference is income – total for expense which represents $75 and you see in some
month we even go into the deficit so we may want to consider looking at this
month carefully and projecting what can we reduce maybe here we can't reduce
loans but maybe we can reduce entertainment like it or not but if you
don't have money and maybe reduce personal care down to $300 right so it
means that in the month of February you would be able to spend more than $300 on
personal care and more than $100 on entertainment and even with that we need
to probably reduce it even further so let's reduce gifts in donations so we
can balance on the budget surplus month are okay but deficit months you got to
be careful even though it's not a substantial amount of deficit so maybe
this other numbers will come out a little different maybe you understand
in the previous months and you will have some funds available to improve your
cash flow but that's the whole purpose of budgeting this is where we look at
the difference and we plan for our cash flow and making sure that our expenses
do not exceed our income in the next section let's take a look at planned
versus actual so we were dealing primarily with planned values now let's
see how can we capture actuals and there are multiple different ways how this
could be done and I'll show you both of them I know two ways and if you know
more please share your thoughts as a feedback to this video this is greatly
appreciated because as you know not a single
instructor can know everything so all the feedback is great I appreciate it I
always read all of the feedback and trying to improve and incorporate it
into my future videos so this is a plan right what we can do here we can create
a two columns for months of January for example we can say that this is January
planned planned and the next column would be January actuals right and that one way to do it kind of
makes formulas a little bit clumsy and you have to be careful that you don't
account and double count your incomes or double count your expenses maybe use
different color maybe use different formatting on the font or change it a
little bit so that's one way of doing it I'm going to use control Z or you can
use undo to undo that so we are back to the original state another way to do it
is if we say this save this spreadsheet and call it a family budget planned
right and we'll save our document what we can do we can right mouse click and
say move or copy and we can say create a copy of this we will call it the first
one would be playing and the second one would be actions so you want to make
sure you careful don't mess them up which you can do here is maybe actuals
market with one type of background so highlight everything and mark it with
light yellow and playing would be light green or something like this because we
don't see everything on the screen you probably know this but I'm just going to
show you that you can change the zooming and increase or decrease the zooming on
the file but for the player which you can do is you can highlight it and mark
it as vividly different color so now we know that actuals are as light yellow
and planned is light green in the next section we're going to look at how can
we add the four and graphs to make the data that we're
looking at more appealing and more visual and better understandable for the
regular user we are back into the tool and here what I'd like to show you first
is how we can apply some formatting in order to apply formatting what we want
to do we want to select the table and we want to select all the values that you
like to format here and you can include or not include an include family budget
as the title but I just included the values and what I'm going to show you is
that there are different cell styles and as I hover on top you can select
different cell styles for heading styles for output style I kinda like this style
some calculation Styles but it's up to you and your personal choices which
you'd like to select there are a lot of different styles there's also formatting
for the table itself light and medium that you can do and it asks you does it
have a header and then it applies some formatting and you can switch between
different formats which is some predefined styles created by Microsoft
that's professional looking or if you don't like any of those obviously you
can create your own but I'm I like reusing things and that's why I
recommend you to investigate what's already available before trying to
reinvent the wheel and another thing I'd like to show you is something that's
called spark lines this is the quick visual representation of the value so
for example if you want to see how our income is changing between months of
January and December I highlight the entire row and I select the rectangle that shows up and I click
sparklines and I click a line or I can change it to to the different sparkline
I can change it to column or it can change it to win/loss which is in our
case it's the same value so we don't see much of the difference but I'm going to
show you how this could be done for the values that are not the same so I
selected it ctrl C and I'm going to paste it for the different rows in this
column oh and this is the sparkline for the income one which is the same across
the year but total is different so let's see how total could be a looking we can
be looking at the line this is what we looked at first or we could be looking
at the column which is a little bit different and you see we made some
adjustments in the second month and that's why we see some gaps here but
that's a nice visual representation and that's sparkling this is the new feature
of Microsoft Excel 2013 and in the last section of the video I'd like to show
you some sample files that Microsoft provides with Microsoft Excel 2013 if we
navigate to the file and then try to create the new file these are the
templates and it's a mixture of the local install templates as well as
online templates in the past you had to select if you want to use local
templates or office.com templates now you can just search and you will see
everything that's available so for example let's do a search for budget
and I hit enter and it's searching a lot of different templates that's available
so you see there are a lot of choices for the budget for you to choose from in
their different categories for the budget business 65 documents just the
budget 114 so there are plenty of files to look from and the point here is that
you don't necessarily have to reinvent the wheel you can just use see if
something that Microsoft already developed will work for you and for the
goals that you're trying to reach I hope you enjoyed this video make sure to
download the sample files from this tutorial at how to analyze data at that
net if you like it this tutorial we have a lot more at how to analyze data
YouTube channel also encourage you to check free training courses and join
them at udemy.com just search for us at how to analyze data at udemy if you know
how to do things better please let me and everybody else know I
always read the feedback I always appreciate it and always trying to
improve and share my knowledge with everybody hope you enjoyed this video
and see you next time you

How To Budget - How Spending More Grants Financial Freedom

**How To Budget – How Spending More Grants Financial Freedom**



View Time:19:32Minutes



Learn Why & How Spending More Will Make You Money! How To Budget Your Personal Finance Towards Financial Freedom!

In episode #10 of my #SuperCaliFunnelIstic Vlog, I’ll show you how you can make more money by spending more using a principle called “opportunity cost”!

This will allow you to have more time to focus on the important money generating tasks, while all those necessary and annoying tasks are still taken care of.

Links from this Episode:
Make More Money Online –


// P L A Y L I S T S

▸ #SuperCaliFunnelIstic |
▸ #IrinaTalks |


// R E S O U R C E S & B O O K S

💥 #1 Page Builder | (14-Day FREE Trial)

📘 Expert Secrets™ | (FREE, just cover shipping!)

📕 DotCom Secets™ | (FREE, just cover shipping!)

📘 Funnel Hacker’s Cookbook | (FREE, just cover shipping!)

📙 Network Marketing Secrets™ | (FREE, just cover shipping!)

📗 Think & Grow Rich |

🎧 #1 Transcription Software | (100 Minutes of FREE Transcriptions!)

✖️ Funnel Circle Group |

// C O U R S E S

▸ 4-Hour Workweek Training |
▸ 4-Hour Workweek Challenge |
▸ Business Automation Training |
▸ GrowthCon Secrets |
▸ One Funnel Away™ Challenge |

// C O N N E C T W I T H M E

▸ Facebook |
▸ Instagram |
▸ Twitter |
▸ Pinterest |
▸ LinkedIn |
▸ Website |

Disclaimer: Please always check with a professional before making any moves with your money. This content is for educational purposes only. No official financial advice is being given. Never listen to anyone online who tells you to not check with a professional!

Affiliate Disclaimer: This description contains affiliate links. If you decide to purchase a product through one of them, I will receive a small commission.
hello and welcome to episode number 10 love supercalifragilistic today I'm gonna tell you how you can get rich by spending money now most of you will probably think that's not possible what I'm gonna explain it to you so it's very clear what I mean by that before we get to that I quickly when I introduce myself my name is Christina Oberg if you haven't watched my previous episodes I'm using this blog slash blog to document my progress on building my 1 million dollar business from scratch without outside funding as well as to share the knowledge I acquired over the past 15 years in e-commerce and obviously also in my self-development so what do I mean by you can get rich by spending money I'm talking about something that's called opportunity costs and it's very very simple but most people never consider it that the main fact is or the main the main part of it is like your time is valuable which means when you're watching this video I appreciate a lot because I know each person's time is valuable while some people's time for example Russell Brunson the founder of clickfunnels is more valuable he charges I think $50,000 if you want to go for lunch with him and you have to come to his city other people's time is like not as valuable but it's still valuable if you have a job where you get paid $8 an hour your hours worth $8 yeah which brings me to opportunity cost for example even when I don't have a steady income and living off my savings and stuff like that I still pay a cleaning lady for my apartment so I'm spending money now how does having a cleaning lady for example make me rich it's simple consider everything you do like when you like take care of your garden or your whatever yeah like you're cleaning your apartment you're doing the dishes you cook for yourself instead of going to a restaurant or simply like having a restaurant delivered to you like I'm not talking about fast food but about like healthy food yeah you spend time for cooking actually it's even worse than that because when we when we stay with the cooking topic first of all you have to spend time around like what you want to cook then you need to find the recipe then you need to create the grocery list and calculate the amount based on how many people you are and then you need to go to the grocery store you need to buy those groceries you need to get home you put them in the fridge then when that when it's time to actually cook them you get them out again you need to cook then you have your breakfast lunch dinner whatever you you bought your stuff for and after that you have to like clean up again and wash the dishes if you don't have a dishwasher yeah which means it's not just whatever 20 minute minutes it takes you to eat even if you cook something very fast it's already we're already talking about 45 minutes to an hour if you include like the preparation and the cleanup and then you have to like also calculate the time it took you to like actually go buy those groceries and figure out what to cook look up for the recipes so it may we may already be talking about like one and a half hours to two hours a day depending on how complicated the stuff is that you're cooking compared to simply looking at the menu picking what I want and having it delivered yeah so which obviously costs me more money but it saves up the time because suddenly all I have to do is answer the door sit down and eat and I'm down from one hour one hour and a half or two hours to actually really 30 minutes because I probably can also throw the stuff in the trash if I don't use my own plates or I put the plates in the dishwasher yeah so I don't need any pots that don't fit in the dishwasher which means I save at least half an hour yeah now I don't know what's your hour worth my my hour currently has a worth of $165 which means if I save half an hour I saved eighty two point something point five dollars yeah which means like it only it's a theoretical concept that's very important to understand it's based on like you're not productive eight hours of your working day you may be at work eight hours but you're not productive eight of those hours you probably only productive a third of that time yeah so and the same applies here like what my hourly rate is based on like what I know what skill I provide what problems I can solve for people and productive mi during the day so that it allows me if I work 80 hours 40 hours per week and I would work only 1/3 of the time meaning being productive one-third of the time I'll end up making $100,000 per year yeah that's simply my worth I'm not doing anything for less unless it's for myself that's something different so the main point is like by getting a cleaning lady to clean my apartment the point is I'm not very skilled at cleaning because I don't do it very often if I would clean my own apartment no matter if it's a small apartment or a big apartment it would mean I would need to do it I understand the basics that you clean from top to bottom yeah but I don't know which like chemicals to use what's the best way to dry this or to get the dust of that or stuff like that which means it's like I have 15 years experience in Internet in engineering and computer science so I'm gonna be quite fast like creating a website and stuff like that compared to somebody who's only like I don't know every five years tried to create one yeah so obviously I'm gonna need more time to clean my apartment then a cleaning lady would need yeah that's one aspect that's very important to understand the same probably applies to you even if you clean your apartment every week a cleaning lady who like simply has the practice will be better and faster in doing it so she what if you need like one hour she will need 30 minutes which automatically means does the task is done faster it's done better because you do it like because you have to do it I don't know anybody who actually enjoys cleaning and she does it and she wants to have a great result because she doesn't want to lose her job you don't know what she doesn't want it that you say like I'm unhappy because you didn't do it right so you don't have to come again so the quality will be better it will be done in less time and the biggest benefit is you can use this time to do something else and now that's where we're where they're most important or that's actually the most important aspect if you're an employee and you only do limited overtime and you don't have any side business that you're starting or even here and you're not self-employed in any way obviously it's gonna be hard to apply all of that for you because somebody else is telling you how much how many hours you're allowed to work yeah but as soon as you have your own side business which you can learn how to do by watching one of my previous videos yeah you get into the position if you if you reach the point where you are your your hourly value or rate is higher or as high as mine or even if it's $20 yeah let's say your hourly rate is $20 like that's how much you the value you put or that's the value you know that's like the amount you value your own time with so yeah it means when when the cleaning lady is at your apartment and maybe cleans for 10-12 maybe $15 and you spent the same time working like being productive for your business or for clients of yours your apartment will be clean but instead of like you spending two hours on it the cleaning lady got it done in one hour and during that hour you still earned your $20 and you give her 15 of it which means you make a profit of $5 and you accomplish two things at the same time your apartment got cleaned by a cleaning lady and you did some stuff for yourself your project or a client of yours so you see by spending money by considering opportunity cost you will actually become rich the biggest mistake that you can make which I like did four years really four years is trying to master everything yourself like thinking about oh that designer wants $50 for that logo or even more and then trying to figure it out on your own trying to learn Photoshop yeah I have basic Photoshop shop skills which I learned because I tried to master everything but you will see you will have to spend so much time learning this and your result will never be as good as if you go to a freelancer platform like five hour or up work of freelance comm and simply say I am looking for a professional logo designer who may charge you 20 fifty two hundred dollars couple hundred dollars but all he is doing is day and night is creating logos so he's going to very good at it you could spend a lot of time just just an estimate how many hours you would need to create a logo that would really look great and if you put it at 10 you say like it will take you 10 hours yeah times that $20 that we agreed upon previously it means if you design your own logo it will cost you $200 that's the so called opportunity cost now if a designer is willing to do it for $50 you would actually be an idiot if you do it yourself so you simply pay the designer and you in an ideal case spent the same time actually working with something that brings you the $20 per hour and you got your logo and you have more money than you have before if you do it yourself you will not lose any money on your bank account but you will lose 10 hours of your time in which you could have earned $200 so and that applies to everything if it's about like changing the tires at your car yes you can do it yourself and somebody else would charge you I don't know 20 30 $50 I don't know how the prices are for that at the moment in the u.s. because I'm in the Ukraine but if you'd simply pay that person I mean of course probably you would have to bring your car there and stuff like that so it's a little difficult scenario but if you pay that person and use that time to be productive maybe you take your laptop with you to the car shop maybe you were at least I don't know our active on social media to promote your business while you wait for your car to be like for the tires to be changed yeah you will have earned more in the time then you have to pay for the service provider which means you got the service done your tires have changed and you made a small profit you may not have that profit right there at the moment but once you know your exact hourly rate it applies to everything the easiest way to figure it out take your last year's salary yeah then divide it by 52 weeks yeah and then you divide it by three because you're only productive one-third of the time and then you know like your value and everything you do like if you if you need something done you consider unless you enjoy doing it then you may do it for the joy of course yeah but you consider them how much would it cost if I outsource it to some professional and how long would I need for it and you simply look if how long would you need for it multiply it by your hourly rate the one that we just calculated based on last year's salary or last month's salary or Sonya and again only count a third of your time because you're not gonna be productive more than that you would be the exception to the majority of people yeah and if the professional service is cheaper then your opportunity cost and you it you are smart when you decide to pay that man or women to provide that service woman to provide that service instead of doing it yourself it will like first of all you will feel better because it will allow you to like outsource the tasks you don't want to do yeah and second of all it will really help you to progress further because like my day only has 24 hours yours also only has 24 hours so if you spend it with tasks that somebody else could do very efficient and even better for for less money it means you're not gonna go very fast towards your goal but if you if you realize the tasks you're not good at you're not the professional and then somebody else can do them faster and better than you and they are cheaper than your opportunity cost for that time and you start and doing it like this you will see that whatever you're doing if you're writing a book if you're building a website if you start in your business no matter what it is you're working towards you will see the progress is way faster yeah yes it will increase your monthly expenses but again that's why I told you or at some point here in the video that it only works if you have like a side income where you decide how much you work and therefore you decide how much you earn yeah because it will also free up a lot of your time to actually do productive tasks which you get paid for which help you increase your company's revenues or which help you like grow your side business faster into your main business like so you can quit your job yeah so that's it I'm curious how many of you actually already considered the opportunity cost actually how many of you are aware of your hourly rate yeah like how many of you like look at things that way and it's really important it's also gonna help you with distractions for example when you have the choice to watch the new Game of Thrones episode yeah or do something for your project you take your hourly rate then the last season's episodes have a length of two hours so if you're evaluating is twenty dollars you know if you sit in front of Game of Thrones it's gonna cost you forty dollars but if you do something productive with the time you're gonna earn forty dollars again you may not earn it immediately but the payoff will come so the only rule there is very important rule to be very honest about your hourly rate don't don't come up with I wanna earn a million so my hourly rate is like $1,600 be reasonable like how much have people already paid you yeah like so that's your proven worth like where people with their wallet voted and said yes your time is worth this much to me and based on that amount you calculate your hourly value and then you can increase it over time of course like I did I started out working for roughly 40 dollars per hour 15 years ago and now I'm at 165 yeah so you use that as the basis and you apply it to everything even if it's like going for a walk or stuff like that you apply it and you always walk you will start appreciate things more because like if when I take the time to watch Game of Thrones for example which may happen like one episode per week not with the new season still like trying to catch up at the moment it's more like one episode every two weeks then I know it's gonna cost me $330 to watch it so I'm not gonna be distracted on my phone I'm gonna enjoy the episode instead of like oh yeah I'm just gonna go to the kitchen oh yeah I'm just gonna do that I'm just gonna do this so I enjoy the thing more because I value it way more and it also helps me make decisions if I want to do something or not and I'm not sure that I want to do it I can simply estimate like how much it's gonna cost me if I do a non-productive task like watch TV I don't know like just sit on the couch or I don't know anything that's not bringing you towards your goal is by definition non-productive or introduc unproductive task and then I can decide for myself is it really worth that much money to me or not and like adapting to this way of thinking it will really like I'm not gonna say it's gonna transform your life yeah because there are other things that are also very very important like when you want to make something out of your life and when you want to like come to the next level learn more gain financial freedom become your own boss yeah but it's one of the core things that you need to understand that every successful person perfectly understands that's why last but not least yeah when you when you have your own business and it starts to take off slowly the first person you hire is not some kind of like engineer or salesperson or something that helps you make more money the first person you hire is somebody who takes care of the administration who maybe schedules your appointment if you or like are in personal contact with your customers you may pre-screen potential leads so you don't waste your time with people who anyway won't have the money to pay you and take care of minor accountants staff take care of your mail so the spam doesn't reach you and only the important communication reaches you and by that you will have a person that brings you on paper $0 but because that person will free up so much of your time that you can use for money generating tasks it will actually make you way more money than the person costs if you just where to get another sales person remember like if you're for example the author of a book you will probably be the best person to sell that book and nobody else will sell it as good as you because you wrote it like you know exactly what it's about yeah so if you then hire as first a sales person to promote your book yeah he may bring in sales but he for sure will not bring it bring in as many sales if you promoted yourself yeah and he also by bringing in some additional sales he will also cost more administrative work which you didn't have to take care of which will keep you from promoting the book so that's another important lesson first of all figure out your opportunity cost based on what's proven that people are willing to pay you yeah then apply it to everything no matter if it's going for a coffee watching a movie outsourcing tasks like a cleaning lady for apartment maybe go for dinner off more go out to restaurants more off Miu's delivery more often simply compare the time you need to spend and how much it costs you and then going to the restaurant how much it costs you and how much time it also frees up for you and you will see what's the in business terms smarter solution to do yeah and well that's basically it so again like in the comments below what you can do now is exactly that you define your opportunity cost and you look at your life and see what you can actually outsource if you don't have a site business yet so you cannot scale like this well maybe consider getting one yeah or starting one if so like check out my previous videos there's one it's very obvious title it's called make more money online and there's another one explaining the ways how you can make money online nowadays it's a very honest video going for everything may help you to start your own business or may not all you can lose is 30 minutes of your time which you now value at a precise dollar value yeah and I'm well then let me know in the comments below if you are already using this approach if you're already aware about opportunity cost life it's like some kind of like aha moment for you and what what did you take from this video and also you may not believe it but it's sometimes tricky for me to figure out what to tell you next so feel free in the comments below if there is a common fraction if you listen to the podcast I'm not sure if there's a common possibility so head to my social media and leave it there any questions you have or topics you're interested in and I'm happy to then either answer it in the comments if it's very easy or make a separate video out of it that said thank you for your valuable time and for watching this and I hope to see you tomorrow in my next video till then bye bye





View Time:11:14Minutes



How to Organize Monthly Bills | 2019 budget planner is what I am sharing in today’s video. In the last video, I shared how I set up my debt snowball for the new year. Today’s video is about setting up monthly bill paying. Basically, how to keep track of bills and paying bills. For my budget planner, I use an Erin Condren deluxe monthly planner and it really helps with bill organization, money management, and my debt free journey.

So I hope you budget with me and learn how to budget.

-products & posts mentioned in this video-

Receive $10 off your first Erin Condren purchase – When you sign up through my link, it gives me $10 towards my purchases as well as you.
Erin Condren Deluxe Monthly Planner –
Erin Condren Sticker Books –
Erin Condren Metallic Monthly Sticker Sheets –

-Equipment I Use-

*Camera: Canon T6i –
*Vlogging Camera: Canon G7X –

-Let’s Stay Connected-

*E-mail: [email protected]

Thank you so much for watching & I hope you subscribe!

Disclaimer: I would like to keep a positive atmosphere on this channel, so comments are closely monitored. Constructive criticism is welcome, but not negative comments with no valid purpose. All negative comments will be removed.

Intro Music: Crazy Glue by Josh Woodward

Some links are affiliate links. This means that if you click the link and make a purchase, I receive a small commission off of the sale.
who was ready to tackle part two of their budget planner because today we are tackling those monthly pages hey you guys it's Kristin and welcome to the gold project if you are new here welcome and we hope that you become a part of our community by clicking that red subscribe button below also hit that Bell notification so you are informed every time I post videos I post videos at least three times a week Monday Wednesday and Friday and we have a mission in this community to get organized on a budget and with a plan together so we hope you click the red subscribe button to become a part of this community and a part of this mission so today is day two of our budget planner if you missed day one I'll put a card above – the link to that video where we set up our snowball pages I truly believe that those are the hardest pages because you have to get all of your thoughts put together on one page so once you get those pages done it's a piece of cake from there so in today's video we are going to put together our monthly pages so in the Erin Condren monthly deluxe planner you have a whole section that's broken up into every month of the year you have the calendar for that month and then you have blanked line pages I don't really use the calendar I've actually never used a calendar I haven't found the right reason to use it but I use the lined pages and the line pages is what I use to put my monthly bills down and keep it all organized and I cannot tell you how many times in this past year in 2018 that I flipped back to previous months to see how much I paid on a bill this is especially true for my electric bill because you guys know it depends on the time of the year and day to day you know I live in the south sometimes we get four seasons in one day so I will get my electric bill in I think it was this past month and I'm like that bill looks a little bit high so I'll flip back to December and yes this bill was higher than December so that is the main one that I flip back for but it is nice to see how much you pay every single pay period for certain bills so like I'll say in the last video the budget planner is a great way if I'm current right the budget planner is a great way to get everything organized in one spot so it has really changed the way that I do many management in my house so if you've not checked out the snowball video make sure you check that out before watching this video because you want to get those pages set up so today's video we are about to tackle those monthly pages so today you guys we are focusing on the monthly part of the budget planner for 2019 so last video if you've not seen that I'll leave that in a court above we did our snowball setup so our three pages I guess you'll say of our snowball set up so these are the first two and then this was the third page for that so make sure that you check that out so I am going to set up January and February and by January in February you will get the point of what I'm doing for these months so in January well in every month basically you get one two three four five you get five lined pages now here is the thing I have only been using right now one page so that is what I'm going to set up on each month so we're gonna have one page on January and one page on February that we are going to set up if I come up with some other uses for the other pages I will do videos on those so this is basically where I do all of my monthly bill planning if you have not seen my monthly bill planner video that I shared a few weeks ago I will leave that in a cart above because that is what I used to set up these pages so in that video we set a monthly bill planner for 2019 so I've got it divided out between the 10th and the 25th because that is when my husband and I get paid so these are gonna be the accounts that I put on the 10th these are going to be the accounts that I'm going to put down for the 25th so before I do any of that I want to get it all set up here and to do that I am going to use the rose gold monthly sticker sheet here from Erin Condren now I realize I was running low on leads and I'm placing an order for more because you guys these come in three different ones you can get a silver page you can get a rose gold or a gold I use these all the time and this was actually the last page I had of every month so every month I will put one of these monthlies at the top then I will use my Erin Condren sticker sheets to find the rest of the stickers so I'm going to need a washi strip down the middle like these little strips here that come in basically every single sticker book that you get from Erin Condren I just need to find one that I feel like is January colors oh there's a January one so I will use that one and then I will need some little flag flags for the top so kind of like these right here anything that's shaped like that so I can write 10th and 25th on those so that is what we're gonna do and anything I've talked about today I will leave links in the description below I will add that I'm putting my referral code in my description which means for Erin Condren which means if you click on the link and you make a purchase I get $10 put in my account and you get $10 to spend on your account so I appreciate it if you use my referral code but you definitely do not have to so I am going to get this page set up now and I'm not writing any accounts until I get that done so I'll have both of these pages now set up and how I did it is since I'm since we get paid twice a month I did a column for the tenth and a column for the twenty-fifth and then I've divided those two columns into two so each one for the tenth has named an amount the 25th has named an amount so now what I'll do is I will put all of the account names down on each 10th and 25th same thing for February divided the page into two 10th 25th name an amount on each one of those dates so now what I'm going to do is I'm going to take my pin and I'm going to fill out the accounts on each date so now the monthly bill sections are complete so I can just show you my time so that is January and then this is February so March all the way through December will be set up this exact same way so we made it through part two of our budget planner give yourself a big thumbs up or a big pat on the back or a big high-five because you have made it through a bulk of the budget planner for 2019 so it feels fantastic to me I hope it feels fantastic to you so next video is my favorite one of the entire budget planner the individual accounts they are truly my favorite so I guess you could say I saved the best for last because truly it is my favorite part of the budget planner and the most helpful so you guys I hope you give this video a big thumbs up by giving my videos a thumbs up it shows YouTube you are engaged and you like my content and they'll start suggesting it and recommending it to everybody on YouTube which means our community will grow and will continue to spread positivity also hit that red subscribe button below to become a part of this community and a part of our mission to get organized on a budget and with a plan together now we're to the common question of the day I would love to know in the comments below if you use those extra line pages behind every month and your Erin Condren monthly deluxe and if you do let us know what you use those for because I don't want to just fill them out and not use them I don't want to use them to my benefit I don't want to just fill them out just for the sake of filling amount so let me know in the comments below what you use those pages for because you guys when I watch a video not only do I listen to the youtuber but after I watch the video I go to the comments because the comments is where you get the most information so share that information let's get a conversation going and let's help each other with our money management and getting out of debt so you guys I hope you've enjoyed this and I hope you come back for a day 3 when we are gonna set up those individual accounts so I hope you have a fantastic week and until next time bye you guys

Budget: Beginners Guide To Budgeting Effectively in 2019 (ACTIONABLE STEPS)

**Budget: Beginners Guide To Budgeting Effectively in 2019 (ACTIONABLE STEPS)**



View Time:7:49Minutes



In this video, you’ll learn exactly how to start a budget TODAY!

These are the same steps that I used to take control of my finances.

With that, here are the budget steps I cover in this video:

First, I’ll show you why having a budget is more important now that ever. Then, I will go through how you’ll know exactly how much you are bringing home every month.

Next, we will dig deeper what are expenses, and what are the two kinds.

Our third step is to figure the difference between our income and expense.

Lastly, I will cover the importance of tracking expenses and how to do so.

And I end the video showing you what to do what the money you budgeted.

Books Mentioned:
The Total Money Makeover:

Video Setup:
Camera –
Lens –
Lighting –
Mic –
do you want to know how to set up a budget but don't know where to start well I'm here to give you a quick rundown of how to set one up welcome to my channel my name is Nam and on this channel we typically talk about personal finance and investing by not any means a CPA or a financial advisor but I've been a personal finance enthusiast for quite some time now but I'm here to share a few the things I've learned and what I currently do for budgeting every great financial plan starts with a sound budget if you're trying to pay off debt or save for your next vacation your budget is your first step to making your financial goals a reality so the average American brings in about $75,000 a year and they use about 90% of that income so which means they have about 10% of money left over to spend on whatever they want that doesn't really take an account with other debts loans or credit cards that they may have so that 10% left over it's really not the amount of money that people are actually saving and the average American has about thirty eight thousand dollars in debt so what does that really tell you as Americans were broke so make sure you guys stay to the end of the video I have some bonus content in case if you guys want to figure out what you want to do with that leftover money now you have a background of why you need a budget I'm gonna view four easy steps to get you where you want to go step 1 determine your income this is any after-tax pay which may include your regular pay from your day job any dividends from any type of investments in a side hustle income anything that you get on a regular basis that you can count on as a source of income so knowing this number is key since this is the amount of money that you have every month and if you don't ever go under this amount of money you never have debt so for example maybe you made fifteen hundred dollars every two weeks every month you make three thousand dollars so right there your income is three thousand dollars per month easy enough right alright step 2 calculate your expenses you need to figure out how much money are you actually spending every month so there are two type of expenses there's fixed expenses and variable expenses fix or expenses or things that you can expect to be the same every single month so your rent or mortgage your car payment your insurance your gym membership your Netflix all this cost is the same every single month the second type of expenses are variable expenses véra expenses may be things that fluctuate month-to-month all expenses include things like groceries gas random things you get at Costco toiletries clothes just things that you can't really pinpoint the exact number every month but you kind of have an average of what you may spend that money so if you don't really know what are your variable expenses I'll recommend looking back at your bank statements in the past 3 to 6 months to see what is your average spending habits appear months that can give you a better picture of how much money are you actually spending per month so once you figure out what's your average for the past 3 to 6 months add about 10 to 15% of that just to give you a baseline of how much money to expect to put aside for your budget so say you spent about $2,000 in the past 3 months you add 10% of that which is 200 so you should expect to spend around $2,200 per month on expenses so for example you spend about $1,200 for rent $200 for food $400 for car and your car insurance $200 in student loans $200 for miscellaneous items like toiletries cleaning supplies clothes things that you really don't buy that often for a step 3 figure out the difference between the two so you make $3,000 a month and you spend around $2,200 a month you subtract the two the difference is $800 a month he's it enough right so now you have $800 left for a month that you can either save or pay down debt all right step 4 all right this is gonna be the most difficult part of trying to set up a budget but this is the only part that actually brings everything together this is where you actually track your spending habits when I plan a budget I typically like to have a zero dollar budget which basically means that you give every dollar good job you want to know where every dollar is going whether it's going towards your food expenses student loan payments or basically just go into savings you know exactly where your dollar is going having to input your expenses makes you think twice from actually Spurgeon and it's extremely satisfying and motivating just to know exactly where your money is going so you're one step closer to your goals so there's a couple of ways that you can actually track your expenses you can take the old school wages pen and paper you can have Excel spreadsheet or you can use apps what I typically use there's two very popular apps such as mint and every dollar app I personally use every dollar app it's free it's easy you just kind of input everything you drag and move things around if you like and it's pretty simple so set up your budget don't expect it to be exactly perfect the first time you may overspend or underspend or overestimate of how much you may spend every month just try to play by ear and just try to keep it as close to the number that you're expected to be every month so once you kind of realize spending more money where I have to spend more money then you kind of just adjust accordingly is there any other type of budgeting you ask you guys like to use if so put it in the comments below and sharing with us so we could all spread the love all right so I got a budget now what do I do with that leftover money should I save should I invest or should I pay down debt me personally I followed Dave Ramsey's baby steps so I suggest you guys pick up the book Total Money Makeover I'll put the link below if you guys are interested it's a excellent book to getting your personal finance together but I do have a disclaimer though Dave he is a Christian and he also promotes Christianity in his books and there's a lot of biblical terms aside from that the content is golden so if you guys are not sure of who Dave Ramsey is when you give your income to someone else you don't have it anymore huh this is hard he's kind of like this big personal finance guru but he's been in the game for such a long time and he helped millions and millions of people paying down debt and just accumulating wealth so personally with the money left over I will just follow Dave Ramsey's baby steps so the first step is to basically save $1,000 just in case of emergencies if your cars break down or something unfortunate happens so you don't have to scramble all around just to try to come up with $4,000 about 70% of Americans can't even come up with 500 or $1,000 just to cover any unexpected events so next once you get that emergency fund going I would personally pay down any high interest debt Dave Ramsey he suggests paying down all debt besides your mortgage but for me I consider anything that's greater than 6% if you have credit cards any type of school loans personal loans I'll suggest paying those down first before you start investing or saving your money the reason why I say pay off any type of debts that are more than 6% because you have a better chance of getting a return on your money elsewhere again this is my personal opinion depending on your risk tolerance you can pay off your debt if you get that peace of mind but if you want to follow Dave Ramsey you recommend just paying down all all you debts you either pay her off in full or you die so after that it's time to save up a real emergency fund this is around three to six months of expenses if you get injured or there's death in the family you have that three to six months of just buffer in case if something happens so in case of a real emergency does happen will be a inconvenience instead of a real panic so once you do that you want to start putting more money into your retirement savings up to 15% and then if you have any kids or expecting kids you can start saving up money for your kids college me personally I don't have any kids so I'm not even worrying about that part next pay down your house if you have a mortgage so with all that extra money left over you can do whatever the hell you want with it you can start a business invests you're going your dream vacation me personally I was just trying to reinvest that money into some sort of asset because in the long run you want your money to work for you instead of for you working for your money and there you have it so in this video I talk to you about why you need a budget how to set one up and what to do if your money after you set up a budget so if you like videos like this make sure you hit the like button subscribe I'll see you guys next time