Create Your Custom Airbnb Invoice Template for Enterprises Effortlessly

Airbnb invoice template for enterprises

if you're looking to create a set of financial projections for an Airbnb unit or maybe a number of Airbnb units that are seasonal in nature maybe you are your units on the lake and the summer months are the busiest and maybe you charge a higher rate and your occupancy is higher during the summer or maybe you're on the ski slopes in a ski resort town and uh and your rates are again higher in the winter and occupancy is higher in the winter and you need to be able to predict what your cash flow is going to look like for the entire year because you want to make sure in the slow months you can still make your mortgage payment and that sort of thing um if that's you then you've come to the right place we have created this particular Financial projection template built specifically for Airbnb or vacation rental units and and ones that are seasonal in nature so we have had a kind of a generic Airbnb template um and we've gotten a lot of feedback because it only allows you to put in one vacancy rate one occupancy rate across the entire year and so folks that have units that are variable or seasonal in nature didn't work very well for them so we we heard that feedback and we built this uh this template with a bit more flexibility there's a little more complexity to it um but I'm going to walk you through how to use it now I'm also going to put a link to this template in the description of the video below now if you buy the template this at this link you will end up getting both Airbnb templates so you'll get this template that is kind of seasonal and variable in nature and gives you more flexibility and then you'll get that maybe simpler more standard template that just allows you to pick one occupancy rate per unit across the board so with that I'm going to go ahead and dive into this template okay we're going to start here in the at a glance tab now once you have entered in all of your assumptions your Revenue assumptions and expense assumptions the individual units that you have you'll be able to then see kind of the profit and loss at a glance here in this table and you get to see some key indicators here performance indicators per property basis and net income per unit that sort of thing and then some nice graphs and charts as well you'll also get a five-year cash flow summary five-year income statement summary five-year balance sheet summary and then an income statement cash flow and balance sheet broken down by month and so that monthly cash flow statement here is really what we're going to need to pay attention to because we are we're going to be looking at how the seasonality impacts your cash flow and whether you you have enough cash to sustain the business during the slower months so in order to produce these reports out we have a little bit of work to do we have to fill this out so I'm going to start here on the input assumptions tab we've got Adam's Airbnb Empire projection start Year 2023. we're saying we're going to put in 150 000 of personal investment here in month zero to begin the model and uh we are adding in so Furniture so these are fixed assets other than the rental properties We'll add the rental properties down here so this could be if you're adding Furniture to uh to these individual units or maybe you're adding new um you know a new deck in the back or a new um hot tub or something like that equipment that you could enter in on a per unit basis and you can select the timing of that as well when you when you purchase that furniture what the cost is as well all right so now we're going to enter in our rental property so I've got three units already kind of entered here as a default and so we're going to say we've got a single unit Airbnb that we purchased for three hundred thousand dollars and we purchased it in month one and we got a loan of 70 so you can see uh we're just taking the purchase price times 0.7 here is what we're assuming um for the mortgage so you know we've got a we've got a five percent rate set here we're probably going to need to increase that you know it really rates have been moving up right now so let's just move these up to seven percent which is about where we're at right now and then the number of monthly payments uh 360 so a 30-year mortgage fixed rate that's what we're assuming here and then we've entered in a two more properties as well and you can see these we bought the beginning of year two and the beginning of year three so month 13 and month 25. now I've also got a slot here I'm going to remove this SBA loan but I've got a slot for other loans so you might be able to get maybe you get a friends and family loan and maybe it's just 75 000 of working capital to help you out and maybe you got the forensic family rate of four percent so it's it's a nice cheap rate of course you can adjust those all right so now we're going to go to our input Revenue tab and the first thing you want to look at in blue here it's so it's piped in the three units here and then what we've done here is we said okay we bought we purchased the property here and we've added uh the first month of rental so what we've done up here in that calculation you just said the purchased purchase month plus two so it's basically just adding two months for you to like get the unit ready to list and then you'll be able to start renting it out of course you can address that as well if it's ready to rent right away you can purchase it and get it listed immediately all right so then the next thing next assumption here is the number of units per property so we're saying this first one there's just one unit but on the second property there's actually two units available to rent and then the final one is just one unit as well all right so now we have these per property costs and we have annual utilities Insurance maintenance property tax and then just a slot for other annual costs here um and you have a couple different options so utilities you could actually prorate so it's Pro rate based on revenue or you can evenly divide it over 12 months so the idea with the pro radio note based on revenue is that uh you're probably going to assume that you'll have higher utility costs when the occupancy is higher and so we can say hey we think it's going to be this unit is going to have 7 200 worth of utilities across the year but we know what we want to do if we if we select prorate based on Revenue it's going to take that cost and divide it or prorate it across the months that have the most Revenue so you have more Revenue in one month you're gonna have a higher share a pro ratashare of the utility expenses in that month so hopefully that makes sense versus dividing that evenly um annual Insurance you know that probably is just going to be divided evenly over the 12 months maintenance you know maybe maybe that's divided evenly over 12 months as well taxes divided evenly but you may have some expenses like utilities would be a good example that that you might want to actually prorate along with as Revenue goes up or down so you have that option all right so now we're going to dive down here to the rent and Revenue and what you'll see here in is this box with pipes in the 10 properties and you can see how this is kind of grayed out and the reason that it's great at is because this is not available to rent yet and that is based on the fact that we're saying hey month three is the first month that this property is available to rent so you can see by month three it's it's populated there's not grayed out anymore but these other two properties are still grayed out now the way we have this built is what we want you to do is to go ahead and fill out each of these months for the first year fill out the maximum amount of rent you could potentially get the amount maximum amount you know of rent through Airbnb or wherever you have it listed so if you were 100 occupied every single day you know at your highest rent rate for that month what could you get and go ahead and enter that in uh for for each unit even if it's not um even if it's not open yet if it's not available yet so we'll go ahead and enter it into these first 12 months boxes here okay so you'll see that for the first 12 months we we enter those numbers in and you can see that they vary so you know what the way we've got it entered in we're saying hey for this first unit the summer months here are busiest so that's when we're at six thousand dollars a month and then our you know winter months are slower so we're down to 4 500 a month being the maximum rental amount we could generate and then the reason we want you to fill out all 12 months for that first year even if the property isn't open yet is because then going forward for for years uh two through five what we're going to do is just follow that same pattern that same seasonal pattern that you had in the previous year we're going to follow that but we're going to add a rental increase over time okay so um you can see here we've got 6300 and rent and that was compared to 6 000 in the previous year and that is because right up here we set a five percent annual increase in the monthly rent potential so that's where that that's uh coming from and now uh you do have the ability I will just mention you do have the ability to just overwrite these equations so we try to give you these equations and the ability to kind of uh not have to fill in 60 individual amounts of rent amount for all five years but if you want to you can overwrite these white sounds you can just put in you know six thousand or eight thousand or ten thousand whatever you want you can do that manually for all 60 months if you would like to okay so now we need to come down to our vacancy rate so this is the maximum if we were 100 occupied these are the maximum rental amounts that we could get but we're assuming hey we're not going to be at maximum capacity um so now we're looking at our vacancy rate um and just as a reminder up here we've got the maximum Revenue rental Revenue we can generate if we were 100 occupied so we had No Vacancy that's how much revenue we could generate but we assume that we will have some vacancy right and so what you can do down here is enter in the vacancy rate assumptions uh that you assume for each month so we see hey when the prices are high for this first unit six thousand dollars per month that's our busiest time of year and so we're only going to have a 10 vacancy rate meaning we're 90 occupied right and and then uh in the in the winter months for that first unit we're assuming you know uh 50 vacancy rate now again these these next Styles here are going to follow that same uh same pattern where it will then project what your vacancy your occupancy rate should be based on that same seasonal pattern as well as based on our annual decrease in vacancy rate so again we're assuming that over time you will have a lower vacancy rate because you'll get good reviews of your property and and hopefully it'll be occupied more often so so that's how you you'll enter that in and then that's going to then allow us to do all of our calculations to um project our revenue and our cost of sales then one more tab I wanted to show you here in in some detail is our operating expense tab so here you can enter in different expenses operating expenses and you can enter them in as fixed dollar amount so that means it's just the same dollar amount each month so your accounting cost might be 200 bucks a month kind of no matter what but you might have other costs like cleaning that would be on a per unit basis so in this drop down you can pick either a fixed dollar amount a per property a per unit because remember some properties might have multiple units so there could be some expenses that are per property like Lawn Care Landscaping type type of a thing but a per unit cleaning would be on a per unit basis and then we also have the ability to do a percentage of Revenue so you know the Airbnb host fee uh that's three percent of Revenue so we can just select percentage of Revenue and put that in there all right so now we'll jump over to our input salaries and owner drop tab so let's just assume we've got these three properties that we've acquired by month 25 and so we're saying Hey by month 25 it's going to be too much for for me to handle anymore and I'm going to hire a part-time property manager employee here I'm starting a month 25 through month 60 through the end of the end of the model all right once we have all of that entered now we get to see how our our numbers look here and we can see in the first year we are losing uh losing money in that first year but we get to a profitable Point by year five now let's look at our cash flow statement so um this is what you'll want to take a look at once you have entered everything in you want to take a look up here this cache at beginning of period so remember we took out a 75 000 um friends and family room plus we invested 150 000 of our own money into this and so based on that and the the revenue assumptions that we have in here we are still staying cash flow positive or I should say we are we we have positive cash in the first year okay but then you can see down here we get to the second year and uh we are no longer cash flow positive so we have you get a new loan here 350 000 that is used to purchase this next property but we don't have enough excess capital in our model to keep this cache at beginning a period positive so we are showing a negative eighty seven thousand dollar cash balance here and when we buy the next property we're even further in the hole so that is something you are going to going to want to look at closely and the way we would fix that in this example is to come back here and say okay we're going to need to put in either additional investment down payment into uh into the model so let's say personal investment again for the for the next property for that second property is going to be another hundred thousand and we're going to put that in in month 12. right before we buy it and then personal investment again for another oh let's say this is a 500 000 property and we're borrowing 350 so we're really going to need another 175 000 probably to be safe and that is in month we'll put that in month 24. so that we have that time to purchase now if we come back to our cash flow statement we're going to take a look at this so we're cash flow positive all of year one we've got positive cash in the bank all of year two we get down to just five thousand dollars in the bank but we escape cash flow positive oh and we still are a little bit short in those slow months it looks like uh in year three so again you can see though that that you're gonna have to go back and forth you're gonna need to look at your cash flow and and see based on the seasonality uh based on the properties that you're buying in the timing of that when you're going to need to come up with more money to put in or secure another loan as well for your property so I hope that's been helpful if you have any questions leave us a comment in the comment section of the video below or reach out to us at support projectionhub.com thanks