Annual Budget Calculator in Excel
Chloe Boreham September 24, 2020 Budget
Hey everyone. Uh, welcome back to my post. Just wanna give you an update on the last post I kinda went through at a recent response that i had to my other post saying that they would like to see an annual budget with some college expenses and stuff like that. But, I decided to just do an annual budget calculator because we'll just go step by step and to show how I've done that. So, what we're gonna do is take the monthly budget calculator in the post that I use last one you can click in the right corner there and watch the last post to catch up with this one. But this is another simple setup you can do for an annual budget. So if you go to here annual budget and you can download this excel document in the tabs.
How To Create Annual Budget in Excel ?
You'll see here what I did for this kind of boilerplate model summary. I took the same look of the monthly budget and just made twelve rows for each month. Use the same categories rent, mortgage, utilities, expenses, subscriptions, and extra as I did in the monthly budget, except I'm using months now for each one of them because you're gonna be using the total amount for each month in each category. And you're probably wondering, how am I going to do that. So what you're going to do here is you're going to make twelve sheets. You're gonna copy this monthly budget, make twelve sheets January, February, March, etc for each month. And as the year goes on, you're gonna use those sheets to complete your full list of.
Budgets that you have for the month for your rent and all that kind of stuff. And then you're gonna use this annual budget here to see how you're doing you're to date. How you're doing at the end of the year kind of how everyone use this, but this is going to be a quick way to show you what you're spending the most money on. Which usually is gonna be written mortgage. But you can also see where you can cut down on in this total category and again, you can make these exactly what you want. You can make them into frankly, whatever you wanna have.
Let's go into the rent mortgage and just show you how you can total that for January. Yeah, so you're gonna click into this cell and this cell is. and you're going to look at January. In this January sheet, you see that your total amount that you spend is nine fifty, now remember, we used a formula in the last post to get that nine fifty and that was equal sum of c seven three c twenty-six. Now what we're gonna do is we're going to take the total here of rent mortgage and we're going to put that to the corresponding month in the annual budget.
Go back to the excel annual budget. You're gonna go to January. You can use this formula to reference that page. So, equals January if i can spell exclamation point c twenty seven plus zero, that'll give you the amount. Then that's in c, twenty seven. On this page, this formula here. Equals January is the page that you want to reference and here's the formula one c twenty seven plus i did plus zero just so that you get that dollar amount that's there coz i had to close off the formula. So January is c seven, and that's the total that you're gonna see on your annual budget calculator and you're going to do the same for February equals. Should i be wary. Exclamation point c twenty seven plus zero. I had to think their authorities go to February wrong. Okay, and then you give equals March exclamation point c twenty seven plus zero. So you kind of get what I'm doing here is I'm just referencing that page and referencing that cell to put that amount on this total sheet.
So then what you're gonna is we're gonna just totally help just like we did a month of budget. So go down to this cell and you're just going to do equals some just like the last post of this cell shift, click to sell eighteen, enter easy. So at this point in the year. If you were to do in January through March, you already spent twenty eight hundred dollars, twenty eight hundred dollars on rent and mortgage. So what does this mean, this means that you already have.
You know a consistent budget month to month, you can do this with all the utilities expenses, which i guess I'll just show you right here. So if you go into January, you're going to do the same thing. So you're going to use it, e twenty seven. Because we're doing the sum of this cell through this cell equals e twenty seven. So you're just gonna reference that number in the month of January, here equals January exclamation point e twenty seven plus. And again, that zero is just because it needs to complete a formula, so it will give you that just dollar amount that you have in that cell on the month of January expenses you're going to do the same thing.
And we're looking at we're doing the sum of this, g seven g twenty six, and that's g twenty seven. Sorry, do you posted b twenty seven plus g twenty seven ,my apologies, g twenty seven plus zero. So you're seeing kind of how that works. So you're going to have expenses there at the bottom two hundred dollars and you can do the same thing again for this one January. We're going to be doing the total of this i twenty seven. And it goes i, p seven. You know, and January we'll do just the extra here.
Which is k twenty seven so people's January a twenty seven plus zero, boom enter. So now that you have these, you're going to do the same sum formula here, boom...boom. So your debate expenses is going to be equals some of the cell, the cell, the cell, this cell and this cell, you'll see that up here in the formula bar, or in the function bar, whatever you want to call it. That's gonna go in that cell. So, I don't want to screw things up for you here, so I'm just going to delete, equals some.
G nineteen plus i nineteen,plus k nineteen. so you're dead expensive so far, four thousand fifty one dollars and again. For this, you're just subtracting. This amount from that amount. So of course, at the end of the year, what we're hoping is that your your today expenses do not exceed your yearly come and this way you can solve exactly what your annual budget will be and it kind of give you maybe a projection in the next year or what section or category that you can cut down on, but this should be a good way to get you started. It's an easy annual budget calculator and in the post below, you can, uh, check that out and again. Watch my monthly calculator in the first post and, get a jump start on. Starting your annual budget calculator. So, thanks again for watching guys. Hopefully you've found that informative. Thanks.
Photos of Annual Budget Calculator in Excel
Bill Calculator Based on IncomeSep 28, 2020
Bi Weekly Budget CalculatorSep 27, 2020
Money Spending Calculator WorksheetOct 10, 2020
Annual Budget Calculator in ExcelSep 24, 2020