Discover the Best Hotel Stay Bill Format for NPOs

Hotel stay bill format for NPOs

[Music] [Applause] hey this is adam hoeksema from projection hub and today i'm going to walk you through our hotel an event center a financial projection template now this template has a revenue revenue model for kind of your standard hotel a restaurant a spa and an event center so this is kind of your full service hotel financial model and there's quite a bit here so i'm going to walk through this with you in some detail and i've got example data already put into the model and i'm just going to walk through it and explain how you can use it for your own specific situation so the first thing you need to know is that every cell that's highlighted in blue is a cell that you can change without you know breaking the model so you can put your own company name in we're going to change this to 2022 now [Music] let's say you have a personal investment you're going to put in your own equity of 500 000 and there's going to be some outside investor that's going to put in 500 000 and we're saying that that's invested in month zero so that basically before before the operations get started because you're probably gonna have to invest at the beginning of the acquisition or construction project if you're constructing it the hotel and then definitely put that in first if you're acquiring an existing hotel also you'd probably be putting this in the equity piece in first and then we'll look at a loan down here in a second we're going to also have our accounts receivable terms here saying that most most of your revenue you're going to you're going to get paid for when you provide the service so you know you get paid the night that someone stays at the hotel um or if they use you know go to the restaurant they're getting paid immediately now there might be some maybe some event center revenue that you actually bill the customer for and you get paid within 30 days so that's that's what this breakdown is here 90 10. and let's say you have some just minimal supplies inventories the hotel maybe you should jump this up just a little bit you know five thousand dollars worth of kind of inventory and that you keep on hand as you go and now for fixed assets we're going to have the building is the primary fixed asset we in this example have this put in as a 2.7 million dollar hotel with a 20-year life expectancy i'm going to change that salvage cost we'll just put that as zero we're going to assume we'll depreciate this to to zero over the 20 years furniture of 200 000. this probably um this is probably a good example of you acquiring an existing hotel because if you're going to buy a new one you're going to spend more than 200 000 to outfit the the hotel but maybe you're acquiring a new or acquiring an existing hotel and just updating some of the furniture and fixtures where you're going to put in 200 000 maybe there's some light equipment needs and perhaps improvements to the land or the property as well and then you're going to have a loan you're gonna need a loan to acquire the uh the existing hotel in this example and so we've got a 2.5 million dollar loan at a 6.5 interest rate uh 360 months so it's a long long payback period here with payments starting on month one and then we'll jump over to our input revenue and cost of sales so this is the main bulk of the work here we have your different hotel rooms types of hotel rooms you can say how many how many of each of these types do you have so this is a 45 room hotel in this example your price point um this should be what you actually expect to get paid after all discounts and everything um on a weekday and then a weekend night put in your prices that you expect to get paid and then for each of these rooms what's the average spend on room service or a minibar per night and then average spend on in-room entertainment per night and then you're gonna have your housekeeping cost per night per room so what does it cost to to clean a room a single room and so you have those costs there and these are just you know some estimates i you know you need to do your own research and work on your specific um you know your specific location what labor costs are in your area um as well as just how much time it takes to clean these rooms and whatnot and then same thing with some estimates here for landing costs per room per night and toiletry costs so once you have all that matrix filled in then you're going to say what percentage capacity are you filled on weeknights and weekends and then we have the ability to add a growth rate so let's say we start out at 40 capacity on weeknights 60 on weekends but we're going to grow 10 percent annually so you'll see that capacity increase over time and all that will end up giving you your total hotel revenue now for the variable expenses for the hotel you can see what those amount to here and now let's say this uh this hotel has two different restaurants owned by the hotel and we've got a max capacity of 100 people 100 customers at any one time per restaurant we're going to say that it is forty percent uh filled and that the max capacity field that ever really gets is eighty percent um so it can't go over 80 percent here and that you're open 70 hours and that the average customer your average table is going to spend two hours per visit um so this determines you know how many times you're going to be able to turn over that table so just as an example if i change that to one your revenue or your your total number of customers doubles um and thus your revenue would also double in this example and then your average spend on food and drinks per customer along with the annual increase so then you've got your total monthly restaurant revenue and you've got variable costs assumptions that you can put in for for your restaurant as well an average food cost how many hours you're going to have just opening and closing the restaurant where you're not actually open but you're having to pay staff to be there to open and close and then the number of bartenders servers chefs needed well that's going to give you a variable expense for your restaurant for both restaurants in this case then we have a spa example here so you have different services with average price point number of spots that are available by yeah so number of spots per day that are available and then a a labor cost and a supplies cost for each service and then a capacity used so you've got you know these spots you know let's say 10 spots per day available for massage but we're saying that we're only using 25 capacity so on average we're having two and a half massages uh per day is what that would be saying uh and that's you know starting out on month one but we're going to grow hopefully here with annual growth rating capacity of 15 that gives you your spa revenue and your spa expenses as well and now we jump into our event revenue and so here you get to put in your average number of events per month i mean you can just put that in manually you may have some seasonality you may have a growth rate here with a maximum number of events per month and then you have these different ability to add these different event packages and price points and costs associated with each package and then right here what you can say is okay of of these five events let's say in this month of these five events fifty percent of the events are package one twenty percent of the events are packaged to you twenty percent or package three and ten percent are package four that's what that is is telling you here and this should add up to a hundred percent you wanna make sure it does that that will help you generate your event revenue along with event staff costs food and other costs as well so all that added together is going to give you your total revenue for this hotel facility now we're going to jump over to just operating expenses and this i have not spent a whole lot of time working on um you know specific numbers so accounting surely for a large operation like this um if you're not doing this internally you're probably not i'm gonna be spending a lot more than 250 a month um your software and subscriptions you have software for the hotel probably software for the restaurant software to manage the spa this is probably also going to go up quite a bit maybe even more than than that you have credit card fees um now this is a percentage of total revenue so four percent is probably high because you're probably gonna be more like three percent or typical credit card rates insurance probably going to be a lot higher per month professional services this could be attorneys maybe marketing services designers that sort of thing office supplies utilities are going to be much higher than that for a large hotel let's say i have no idea it's going to be different based on your location and energy efficiency and all sorts of stuff um so you'll need to do your own research on your location and what you expect utilities but that that will be a major cost for you let me bump that up even more and expand this out so you can see that and then you have uniforms maintenance on the property that's probably going to be much higher per month property taxes much higher per month of course it's all who knows it really depends on where you're located in your specific situation and if if you'd like our help uh to come up with some more realistic numbers for your specific business model we can we can help with that but the details and the specific numbers are so dependent on your specific location and situation so we would really need to work with you and talk you through um how to how to estimate those expenses um but what we're doing here is just trying to get get a rough idea of some projections here so um and then you're surely you're gonna have other expense categories and so you can type in down here other expense categories as you think of them so maybe you have security um you can add that in here so maybe you've got 2000 a month for security as an example and you could drag that across if you wanted okay so there's your general operating expenses now we're going to get to staffing this is salary positions for your different business units so your hotel your restaurant spa defense coordinator other staff and what you have the ability to do is add their individual salaries and benefits what month they start in what month that position ends if it does end and then the number of that particular position so we're saying we actually have two hotel managers in this case um both at eighty thousand uh one restaurant manager but we've got two restaurants so maybe we should make that two restaurant managers one spa manager one event coordinator and then four additional staff that are all starting on month one and then let's say in month 25 here so the start of year three we're adding three additional staff here so that's what that would be saying and then you can have an owner draw um here so maybe the owner is taking out uh 10 000 a month we'll drag that across the five years and you know let's say this is a little higher and maybe you have you have maybe a property manager as a whole the entire the entire complex is managed by someone making maybe 125 a month and they start at month one and then 160 you have one and you can give them five percent raise so let's just say that's that's good enough for now as a as an example and so what you'll see here uh the at a glance tab with a number of different charts tables graphs um that are going to show you kind of when you break even what your different startup costs will look like sales forecasts you have some seasonality there perhaps and different margin levels to see how you compare return on capital what your profit margin looks like and then you've got your income statement five year income statement projection summary projected cash flow summary for five years balance sheet summary for five years and then an income statement that cash flow statement and balance sheet that are all monthly projections so you can see what those look like on a monthly basis as well and and that's really it so the only other thing i wanted to just mention here is that um you know you may have some kind of different setup of your revenue model uh or um maybe different additional revenue line items that you'd like to add you can request a modification here so if you click on this it's going to take you to a page on our website where we can have you fill out this form tell us what you need and we can get back with you on a quote of what it would take for our our team or cpa to help customize a model so it works exactly for your hotel or facility so i hope that was helpful if you have any questions reach out to us at support projectionhub.com thanks