Streamline Your Billing with Our Moving Company Invoice Template for Planning

Moving company invoice template for Planning

in this video I'm going to show you how to create Financial projections for a startup moving truck company to help you figure out how to project your revenue and your expenses and then ultimately determine how much profit you might be able to generate depending on the number of trucks and Crews that you have on the team before I dive into how the template works just a little bit of my background my name is Adam hooksema 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 Industries and businesses I also spent a decade as an SBA lender have a good understanding of SBA loan process and kind of come with that experience into into this work so I want to mention that we have a link to this template in the description of the video below so you can go and grab that 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 to get a discount on this template as well so with that let's go ahead and dive in to show you how it works so here we are on the at a glance tab so this is kind of the end of the process after we have entered in all of our revenue and expense assumptions and the number of trucks that we have in the financing for those tracks and all that sort of thing this is the end of the process so you can see some key financial statement numbers some key ratios some graphs and charts that you'll be able to throw into a business plan or pitch deck for investors we also all of our templates have a five-year income statement summary a five-year cash flow summary a five-year balance sheet summary and then the income statement cash flow and balance sheet all broken down by month for each of the five years as well so you get the monthly detail as well as the annual summary detail but in order to produce all of these reports we have a little bit of work to do so I'm going to jump back now to our input assumptions Tab and walk you through how to fill this out so you can enter in your company name the start month of your projections here and then if you are making any personal investment you could put in a personal investment into the business or you could also include other outside investors here so you could list there's some additional slots you could list additional investors and the value that they're investing and what month you expect them to invest now we also have this account receivable terms assumption here so this is assuming that you're going to get paid 100 of your your Revenue when you deliver the service when you move the company or the individual they're going to pay you up front for that we're assuming also that you're paying 100 of your expenses in the month you're incurring those expenses so you're not getting any terms with vendors or suppliers you're just paying 100 up front now on the inventory side I've set this default to zero expecting that most moving companies probably don't have inventory but let's say you maybe you have some boxes uh and tape and packing material that you would sell to your customers so you could put let's say you had some initial inventory you want to have five thousand dollars worth of initial inventory on hand and then in order to make sure that you keep some inventory on hand you'd want to put like a small percentage in here for average inventory carried as a percentage of sales so maybe 10 would be a good number for you all right so now you have the ability to add in fixed assets so let's say you own a building or you rent a facility you could you could put that in here so you put the value in here this this is all set to zero because the expectations you probably don't I don't own a building probably just have trucks and so maybe you have some light equipment maybe you could put in ten thousand dollars for you know some different lift equipment and and whatnot to help with certain jobs okay so now the main fixed assets you're probably going to have are the moving trucks right and so what I have done here is I pre-filled this in assuming that over a period of time you're going to acquire six different trucks and so we can put in the number of trucks that we're purchasing in each month here we can select whether we're purchasing the truck or leasing the truck so right now you'll see if I I have it selected to purchase the track and it asks me what the purchase price is and kind of the Salvage cost after the useful life of 10 years so for Salvage cost this basically just helps us calculate depreciation of the truck and so you could put in a small value the idea here is what would you sell the truck for kind of once you're done with it right and then you can pick the month that the purchase of the truck occurred or the lease starts and you can also set up how much of the truck purchase price is financed so let's say the purchase price was 95 000 but we're going to finance and get a loan for 87 500 at a seven percent rate over 120 months so a 10-year term on that okay so let's say we're going to lease the truck instead of purchase we come to this drop down here and we select lease and what you'll notice is that it blacks out the fields the purchase Fields because we don't need those anymore it still has the month which you the lease would start and then instead of a loan you would have truck payment or a lease payment so you could put the lease payment in here so let's say you're paying 2 500 a month for the lease payment for the truck so that's how you could enter in at least trucks or purchase trucks okay so I'm gonna undo that so that we're kind of back to assuming these are all purchased you'll notice here that I've got the purchase month so we're buying two trucks in month one two trucks in month 13 so the beginning of year two and two trucks in the beginning of year three so we're kind of growing our Fleet of trucks here all right so now let's go to our input Revenue tab here and this is going to calculate the number of trucks that you have so we start out with two remember so up here we we see two and then in month 13 we jump up to four and so on and then it's going to ask you okay how many days are you going to be operating the business a week so we set five days Monday through Friday maximum hours per day per truck so how many hours could the truck be operating we're going to say 10 hours per day and the average hours per move we're going to estimate at eight and a half hours okay so this will then allow you to calculate it's going to calculate the maximum hours per day the billable hours per day that you could charge for so it's just 10 hours times the two trucks so we've got 20 hours a day and then this will calculate okay how many moves could we do per month if the average move is eight and a half hours and we're working five days a week up to ten hours a day how many moves could we do what's our maximum capacity so it's 51 moves per month and then from there we can set our capacity okay what capacity how many 51 is our capacity what percentage of that are we actually going to do so you're saying okay this projection starting in June of the year and so maybe June is our busiest time so hey we're going to start out with 91 capacity and it's going to go down during the winter unless people are moving you can see in January we're down to 23 capacity then we start going back up towards the summer months again so then based on your capacity it will estimate okay how many buildable hours per day are you actually going to bill for and how many buildable hours per month how many moves will you do so these are all just calculations from there we're going to estimate what are you going to charge your customers per hour for your Moving Service we're saying we're going to charge 135 dollars per hour and that's going to include you know the truck and two movers two workers that are going to help move the items and so we put average number of movers per job as two we have mover or driver pay per hour plus taxes and benefits at 22 an hour then we have some variable costs so we're assuming some fuel costs per hour so fuel cost per hour is four dollars and five cents tires 1.35 repairs and maintenance four dollars and five cents and these are calculations that's why the odd numbers here I I assumed three percent of Revenue so you can see I'm taking the 135 dollars per hour times 0.03 as our variable cost there so three percent of revenue for fuel one percent of revenue for tires and so on okay so once we enter in all these expenses uh variable expenses we are going to be able to calculate our moving Revenue as well as our direct labor and variable costs so the the fuel tires repairs and maintenance here uh for for moving services and we also have a slot here for other revenue and so let's say you are also selling you know packaging materials you could just put let's say we're selling a thousand dollars a month of packing materials so you could put a thousand in there and grow that at some rate over time if you wanted to so that's how that would work and then maybe you are building the boxes out for customers too so you could have some labor costs involved with that so let's say we had a 15 labor cost for the boxes that we're selling plus a 20 material cost so that helps us calculator labor and material cost for this kind of other Revenue category okay and so once we've done that now we can move on to our input other expenses tab here and we can enter in some different expenses here so we've got things like rent advertising uh royalties because maybe there's a lot of moving franchises so we're assuming maybe this is a franchise insurance payroll processing you can see the different options here but the main thing I want to point out is that you can categorize these expenses in different categories you can also set the expense as a fixed dollar amount meaning it'd be the same dollar amount each month or a fixed dollar amount per truck so for example if you had Insurance it might be on a per truck basis so you can see my insurance cost here I've got selected as a per truck per month expense so that will scale as we add more trucks that expense will increase then we have other expenses is that are we're assuming are a percentage of total revenue so we just assume hey we're going to spend six percent of our Revenue a month on Advertising our royalties if we're a franchise we're going to spend you know X percent on those royalties and then our last expense tab here is our salaries tab so let's say in month one so we can say month started this position this office manager is going to start at a salary of thirty eight thousand four hundred dollars benefits are going to be 10 of their salary they've got employer taxes here and we're going to have this office manager charging right away and and going through month 60 or the end of The Five-Year projection model but let's say in year two so month 13 here we're going to add a sales rep because we've got four trucks now and we need somebody out there giving quotes and trying to you know sell and so we have a sales rep salary here that we've added in now okay so once you've done that we are back to where we started on the at a glance Tab and you can see the results and so what we would recommend is to make sure that your once you've done this at your profit margins makes sense with the industry averages that you can Google and make sure that if you take a look at your cash flow statement so if you come to this monthly cash flow statement what you want to do is check this cache at the beginning of the period just make sure this never goes below zero you don't want this to go below zero it means you're out of cash and so with that I think that is everything we want to share now I did want to just mention again that we offer a discount code on this template and so you can go to the description of the video below click the link to the template there's also a link to a form down there if you fill out the form we'll email you a discount code that you can use at checkout as a thank you for watching to the end of the video and our appreciation for you all right so with that best of luck if you have any questions at all reach out to us at support projectionhub.com thanks foreign