Streamline Your Billing Process with Our Catering Invoice Template for Planning

Catering invoice template for Planning

hey if you're looking to start a catering company and you need a set of financial projections for a potential investor or lender then you've come to the right place because we have built a financial projection template built specifically for catering companies I'm going to walk you through the spreadsheet show you how to fill it out and show you how to create a five-year forecast now a little bit about me my name is Adam hoxima I'm the co-founder of projection hub and over the last decade we've helped over 50 000 entrepreneurs create Financial projections for all sorts of different businesses for potential investors lenders and just internal business planning and forecasting in this video I'm focused specifically on our catering template I put a link to the template in the description of the video below and also if you stick around to the end of the video I'm going to give you access to a coupon code that you can use as a thank you for listening and sticking around so with that let's go ahead and dive in all right so we're kind of starting here at the end of the process so this is our profit and loss at a glance tab where we have some key tables graphs use of funds some sales graphs and key ratios you'll also get a five-year income statement summary here a five-year cash flow summary and a five-year balance sheet summary and then you'll get an income statement cash flow statement and balance sheet statement all broken down by month for each of the five years so this will be helpful if you are looking to get an SBA loan for example all right so in order to produce all these reports though we have a little bit of work to do in terms of entering in our assumptions so I'm going to start in the input assumptions tab here and we've got a catering business so we're we're starting we're saying we're going to put in a personal investment of 20 000 here so one thing to note is that every cell that's highlighted in light blue throughout the model is an assumption that you can change so we put in a Assumption of a 20 000 personal investment to help get the business off the ground be getting an inventory of 2500 fixed assets maybe you have like you're leasing a kitchen space and you have to do some leasehold improvements so there's 15 000 leasehold improvements fifteen thousand in equipment and ten thousand in furniture and then maybe you got a loan a hundred thousand dollar loan over five years six and a half percent to help with the startup cost all right so now moving on to our input Revenue now this is really pretty straightforward um we just have the number of catering orders per month that you expect to to get and then an annual growth rate so we're starting out saying hey we think we're gonna have 75 catering orders we're gonna grow that 10 per year we think the average revenue per catering event is going to be four hundred dollars and then we can put in the average cost of the food per catering event and the average labor cost for catering to bet so um and you can have growth rates with those as well so that will give you your total catering revenue and then we've also calculated catering food costs and labor cost all right so now we're going to move to that direct labor Tab and this tab is probably not going to need to need to be used very much for a catering business the template that we're using here actually has the ability to put a full restaurant um and so that's what this tab is primarily typically used for would be for restaurant assumptions but again since we've kind of adjusted this template specifically for catering the main thing you'll want to want to note here is this employee hourly rate and the minimum number of employees per hour that you would expect to have for the number of hours that you're open and so again for catering we put all of our labor cost over here so the only reason you would need this to use these assumptions would be if you have staff that are kind of like back at the at the kitchen preparing preparing the food for all of the different events um and and then kind of sending staff out to the particular events um from there you could put kind of the the um the centralized kitchen staff in this table so you could put in you know what that employee hourly rate is how many hours you think that centralized kitchen is going to be open and need to be staffed and then the minimum number of employees that you'd expect to have during that time so um we'll move on to our other expenses here and here we can just enter in things like advertising accounting point of sale services so if you you know probably you're not going to be using uh like a credit card reader for a catering event because you're getting paid by the kind of End customer not the individual people that are eating at the event right but maybe maybe you have you know a bar that you bring also to the catering event and maybe that is a cash bar or something and and people aren't paying there you might have a point of sale system and you'd also have credit card fees so you could put in if you did have credit card fees you could assume 0.02 is the same as saying two percent so two percent of the total catering Revenue all right so you can pick the drop down here and make it a percentage of Revenue and then that way it would just assume that um your customers are paying you a credit card and you're going to have that two percent credit card fee right you also have the ability to add insurance costs rent supplies utilities internet and phone if that's relevant for your situation all right and then um again we've already added we have spots for labor on the import revenue and cost of goods sold tab the direct labor tab but if you have salaried positions as well and maybe that's just one kind of manager business manager um you can put in that salary position here you can select what month they start and end and the number of that particular type of employee so for example if you had like like shift managers and you had three shift managers you could just type in here you could just type in three and it would multiply that salary cost by three all right so that is everything you'll need to do to create a five-year forecast for your catering business and you can see here that we've got a your profit and loss at a glance you can see what your Revenue across you could sold the gross profit would be and you can see that in the first year we're projecting a net loss but growing to a 18 net income over time over the five-year forecast you can also see how you'll use your initial startup funds all right so that's really it if you have any questions please don't hesitate to reach out at support projectionhope.com and again as a thank you for sticking around to watch the whole video um there is a link to a form in the description of the video below and you'll be able to fill out that form and get a coupon a code that you can use at checkout to get a discount on this particular template so please take advantage of that and again if you have any questions at all leave a comment in the comment section below or reach out to us directly at supportproductionhub.com and we'll be happy to help thanks