we are creating a simple budget here and we're going to display our planned
expenses vers versus our actual expenses and this is this is for january i've
renamed my sheet here January and so we have our income here and would say we're
taking home four thousand dollars a month and then let's go down the list
okay let's let's say our mortgages 1500 and our power is 150 and the gas is 80
and the food plan to spend 600 and the car payment is 350 and we normally spend
three hundred dollars a month on entertainment
now to calculate your savings what were you going to do is used to going to
subtract all of these expenses from your your total income or your take-home
income so let's go do a little formula here and we'll go equals will select our
income and then we're going to - or subtract the total of all these expenses
so let's put a bracket in here
let's go some let's put another bracket and then let's select all these and then
we're gonna close that bracket and we're going to close the other bracket and
press enter
and so if everything works out the way its plan will have 1020 dollars
that we're going to put in our savings account every month but let's see what
our actual looks like compared to our plan
so the mortgage payment is still the same but the power is only 120 this
month and the gas was only sixty dollars but our food budget we went a
little overboard with 675 car payment is still 350 that's the same
our entertainment we went a little overboad and we spent
five hundred dollars on our Entertainment
so now let's calculate let's calculate the total savings we have actually
so once again with the equals and then we're going to select our income and
we're going to go - then we'll put an open bracket and local some now will
this opening bracket again we're going to select our expenses and we're going
to close that bracket closing bracket and actually we're only going to put in
795 dollars in our savings this month
so let's put a graph on this so let's select the values that we have
let's go to insert on the menu bar and let's go on
let them recommend a graph that we're going to have all this one looks pretty
good so let's select this one and we're going to say ok so now there we have a
graph of our plan versus our actual expenses
so what we can do is double click here and change it to on expenses
perfect ok so now i'm now we've got January done so we like this to do this
for february March April May that type of thing
so let's go let's go to sheet2 and we're going to double-click on sheet2 and
we're going to rename it february and press enter now what we're going to do is we're
going to go back and we're going to select all up sheet 1
just close this so we can see everything and so what we're going to do is go to
this box in between the a and the one right here and we're going to go control
C and then we're going to go
press ENTER and here you have everything bought for for you so let's just play
around a little bit to fix up the graph now
so these are January expenses so let's put in some february expenses
the planned is all the same so your power
this month was 170 and your gas was 75 and your food with 600 and your car
payment is always the same and your entertainment you only spent 300
so you have a savings of a thousand fifty but if you notice this graph
doesn't reflect this
so what we're going to do is we're going to right click on our graph and we're
going to go
select data
ok so if you look at the top here it says january so let's take that January
out here and that's putting family tree in Febraury
ok
and so now you have a graph that that reflects your your
february expenses so you could continue doing this for the rest of the year to
track how things are going so that's a pretty simple budget that you can copy
for each month
please subscribe i have videos once a week