Make Bill in Excel for Financial Services with Ease

Make bill in excel for Financial Services

hey everyone it's mark i'm here to help you take control of your life through personal development smart money habits and entrepreneurship if those things sound good to you then please let me know by clicking the like and subscribe buttons down below now let's talk about how you can save a lot more money if the story of your relationship with money goes something like this oh boy money [Music] then this might be one of the most helpful and impactful videos you'll ever have to break that lifestyle if you want to start saving more money and actually hold on to it the first step is to create a real budget and no i'm not talking about the difference between a pretend budget versus a real budget but rather a real budget r-e-a-l record everything and live it and you know what i've decided that this real budget thing is so important that i'm gonna create one with you right now let's head over to my computer and we'll build it out together all right let's go ahead and create your real budget made that a little bit bigger here labeled at the top now to start off with what i'll do is i'm going to label uh this will be your monthly expenses okay and then go ahead and just list out all of the things that you spend on a monthly basis so this is stuff like your rent or your mortgage your utilities any amazon purchases streaming uh car payment if you have one what else would be maybe a car wash gas your gym membership or fitness memberships haircuts dry cleaning pharmacy phone bill grocery restaurant toll roads etc whatever your monthly expenses are here just make a list of all the different categories in in different rows here and then we'll put total at the bottom and now you want to actually estimate as close to the real world spending habits as you can so rent maybe that's like you know 12 55 and utilities is equal to um 75 amazon you might budget 150 a month now streaming you might have a multiple different um services so let's do equals 9.99 plus sign 799 and let's say you have like netflix and something else and when you hit enter it will sum those two together car payment let's say that's like 249. uh and just go ahead and go down and do all these so like for gas how many times do you fill up per month and then how much is it per phillip so let's say it's 65 per fill up from empty and you do it four times a month to do times it's asterisk 65 asterisk four so there is 260. what else would be you like that grocery let's say it's 200 per trip you go four times a month so 200 asterisk 4 200 times 4 800. okay so fill out all these categories out and highlight them too and then make them uh into accounting format to get the dollar signs and then for the total what you'll do is go equal s u m for sum open the parentheses and then highlight all of those different rows then close the parentheses and hit enter and there's your total so again it was a sum and does b4 so there's b4 all the way down through b18 which would be the last one here under tall roads so um that's equals sum and then the range which is the starting cell colon last cell is very very useful because it adds everything up for you so do that for all your monthly expenses and then we'll do the same for non-monthly as well so this might be like your auto registration auto maintenance auto insurance in case you don't pay every month i only pay once every six months for example this could be your amazon prime membership that you pay once per year eye exam dental exam uh maybe a costco membership um and anything else so stuff that you don't pay every single month make that bold as well and then same thing over here too we'll put the estimated amounts so auto registration equals 500 maintenance maybe i don't know 350 that you set aside auto insurance maybe that is 600 times two you pay it twice a year prime membership i believe that's like 1 19 plus tax so just call it like 120 eye exam let's say that's like 75 plus 250 for your glasses okay dental exam just a cleaning might be 80 bucks cost of membership about 60 per year and same thing we can write total and then we go again equals sum open parentheses highlight all this let go close the parenthesis and enter and we can also highlight these and make them into accounting format as well perfect um let's see and now we also want to break this down into so this will be like per year and this can be per month so now we want to do here is just go equals this cell nets to it slash for divided by 12. it can be the same thing all the way down equals the the year the amount divided by 12. and to save time you can actually take the first cell see the little dot in the corner when your cursor changes to that black cross click and drag all the way down to use the same formula all the way down to the bottom and then for this one here you can again do some of all these but since we did that with here this one is the sum of everything above it we can just click and drag this formula sideways and then that will copy the same formula to do all the sum of all the ones here above i'll make these bold as well so now we can see the non-monthly expenses we have on a yearly basis as well as on a monthly basis made these bold made this total bold as well just so it stands out okay cool so we've set up the monthly expenses and the non-monthly expenses and we put the non-monthly and monthly terms let's highlight the non-monthly and just move them over click and drag after you highlight and make the columns you know fit everything nicely again and what you want to do across the top here is just do all the months so like january february you can actually highlight these two and then drag them across march april may june july august september october november and i'm out of room zoom out a bit we'll move this over a little more december okay so now you've got all the months going across and as you go spend your money in all these categories let's say we're in january you paid your rent so you go equals 12.55 but then you go out to eat at a restaurant that's down here and let's say the first time you spend 15 so equals 15. and then the second time you eat out you can go back to the same cell and go plus um 12.32 cents and then the third time you eat go back plus um 21.55 cents and that total will continue to run up so of course as you make your initial restaurant budget that should be you know averaging out let's say it's equal to 15 dollars per meal times 25 meals per month enter 375 is your is your monthly estimated budget so now as you record each individual time you spend money this will increase and you always can compare it to your actual budget so i'm going to highlight this over here fill that with a gray so it stands out so there you go and you can always keep track of everything as you move forward i'm going to move this non-monthly over a bit so i can see what they are perfect and then for all these totals again i can take the formula here which is the sum of everything above it and we can just drag that across all of the months here at the bottom and let go so now as you populate things the the totals will um add themselves up automatically for you okay now i'm going to make the non-monthly section over here just fill it with a different color so that stands out as well okay and now down here what we can do is this can be um we call this total income total expenses leave a space left over and then we can do pay yourself and fun money okay now for total income of course there are 26 pay cycles per year but we're just going to look at this on a monthly basis on an average type of situation so let's say you get two paychecks a month um each one let's say it's like 2 000 bucks just to use an easy number and you get two of those so it equals two thousand asterisk for times two enter four thousand dollars your total expenses will be equal to your monthly budget plus your non-monthly in the monthly term so let's add those two numbers together uh equals sum open parentheses the first cell b20 which is your total monthly and then we'll do comma the second number to 1958 so this is going to be the non-monthly uh in monthly terms close the parentheses awesome now we got 340156 for leftover we can go equals your total income minus total expenses enter 598 leftover pay yourself that can be the flat rate just like equals you know 300 enter or it can be a percent if you want to do a percent that could be equal to the leftover amount p21 times let's say 0.5 for 50 enter so 299 and then fun money will be equal to the leftover amount minus pay yourself because that's going to be now what's left over at the very end enter 299.22 of course these will be exactly the same because this one here the pay yourself was exactly half of what's left over but let's say we changed this to like you want to save 60 times 0.6 okay now you have 239 left over for your fun money so those are the most important things you can do um to really get a handle on all these different categories i'll make sure these are all accounting format now that you've completed your real budget tip number two is to open up four accounts two checking accounts and two savings accounts the first of the two checking accounts will be for your income so no matter if you're working for somebody else another company or you're doing your own thing you've got some side kids whatever it is if money comes into you that money goes into the first checking account the second checking account is money that you can spend freely with no guilt now a lot of banking accounts allow you to nickname your account so you might even want to go in there after you open and call it fun money or something like that but this is the money after you've covered all your expenses you've saved some money this you can go out and spend at a bar you can go to you know take a vacation whatever you want this is your fun money account now we have your two savings accounts and the first of those two is what i call your set aside account that's the money you literally set aside every month to cover your non-monthly expenses and the second savings account is where you're going to pay yourself so after you've covered all your expenses you've set aside some money to cover your non-monthly expenses whenever those pop up now you're going to pay yourself it can be a flat rate per month or a percentage of whatever's left over so now you'll notice here the total income is really your uh checking account number one i'll put that here in red so all the money you get in goes into that checking account then your second checking account is your fund money and you can go go ahead and spend that as freely as you want your first savings account will be to pay yourself so this would be savings one i'll put that one in green and then the savings account number two will actually be right here savings two put that green and this will be your uh set aside amount okay and that's equal to this non-monthly set-aside here so we can just go equals that cell lastly we have tip number three and that's to change your identity and your focus by identity what i mean is you're now a saver you are now actively somebody who saves every month and you got to change your brain and train yourself to actually believe that and when i say change your focus you're now focusing on increasing your income going forward if you only focus on the funds coming in and managing your small budget then that's the world in which you'll live remember the purpose of creating a real budget in the first place was to get you on a budget and you live that out so when you go out you're not spending more than that budget all of that takes care of itself now that you actually have the awareness and understanding of where your money is going and what you have available to spend if you want to start taking steps toward financial freedom in your life you first have to get control of your expenses keep them low then increase your income by finding new opportunities to make more money and the third phase which would be a topic for a completely separate video is to take those leftover funds and multiply them if you enjoyed this video and believe it could benefit others then please help me get in front of more people by liking this video subscribing to the channel and turning on notifications i'd also love to know if you have questions about anything we covered in today's video let me know down in those comments below i'll see you guys again soon and remember you are great