Collaborate on Free Pro Forma Template for Corporations with Ease Using airSlate SignNow

Free pro forma template for corporations

hey all my name is paul boroski and i am the owner of quality business plan and what i want to do today is to show you all how to have your trucking company business plan financial projections ready in about 30 minutes or less so it sounds like a um pretty pretty steep fee especially when a lot of people really struggle with their financial projections but if if you use a proven financial model um that is you know available on my website you can go ahead and customize that and you know have your business plan financial projections ready for your trucking company uh lickety-split so let me show you how to do that what i'm going to do is first and foremost set your expectations for the video give you a little bit of background about me and then once i'm done with that we're going to dive into the business the financial model that i've got as a template show you how to customize that to have your trucking company business plan financials ready and then finally if you like what you see i'll introduce you to my website where you can go ahead and purchase those financial model all right so let's go ahead and zip on through this little powerpoint presentation here so first and foremost the the whole purpose of this video is to show you how to take a financial model that's already geared towards the trucking industry how to update it modify it and make it yours that you can use in your trucking company business plan specifically for the financial models and the pro forma financial projections so what is it good for it's great for business plans any business plan that i've seen that i've written you always want to have financial projections in there and a you know it's just a template a boilerplate financial projection for a trucking company it's really it it might flip the bill because you know let's be honest you know trucking companies you're gonna you're gonna haul for it you're gonna make a lot of money it's as simple as that and the only thing that's really gonna change is gonna be the mileage and the you know how much you're how much how many miles you're gonna drive a day and how much money are you going to make per mile and then you've got some variable costs for gas and such but i'll go into all that stuff in just a little bit all right so what is this good for it's good for your business plan it's also good for sales projections if you've got a load or if your average loads are you know 350 or four dollars an hour or four dollars a mile you're going to be able to plug that into the financial model and see you know estimate what your profits are going to be and it's also good for benchmarking you know if you want to make 150 175 000 in a year well guess what you're going to have to start today in order to get that 150 000 in a year and you're going to have to have benchmarks throughout the year to make sure you're on track the financial model that i'm going to introduce you to that you can customize it's going to be beneficial and helpful for that now there are some restrictions to my financial model it's not the end-all be-all of every financial model that's ever been created there are some restrictions first and foremost it is an excel file you do need to have a microsoft office specifically excel in order to manipulate it and update it also if you do buy my financial model my business or my business plan template it is i i do if you have questions before you make the purchase be delighted to answer them about you know what the financial model will do or what the business plan template will do but after you make that purchase i provide you with templates and i'm sorry i provided you with tutorials on how to modify and update it a tutorial such as this so just keep that in mind before you make the purchase for the on the trucking company template be delighted to have the conversation afterwards i'll give you i'll steer you towards the um the financial i'm sorry but the the the the the tutorials that i've already created i've i've created like seven or eight nine ten different tutorials um based on my models and my templates so i'll steer you that way all right anyways final is going to be my experience i am a professional business writer also a professional financial modeler um and what that means is it doesn't mean i'm going to model clothes but it means that i i create financial models for companies um you know for just about any industry you can think of especially the trucking industry love those um as a professional modeler if you have some challenges if you write up your trucking company business plan and you're ready to go with it but you're still getting tripped up with the financial projections even after watching this video and the other tutorials that i have out there for you you're still getting tripped up get pick up phone give me call somebody text some email be delighted to help you with your financial projections if you want some help with understanding what the heck these financial projections mean yes you got me put your information in there but you really have no clue what this information means i'm going to go to amazon.com and put my name in there paul borowski i do have some financial projection books out there to help you understand the financial terms and finally my education i am an adjunct professor specifically um business and finance as well as a subject matter expert so again need some help your financials pick up phone give me call love to help all right with that said if you go ahead and um in a little bit i'll show you how to buy my template for the um trucking company but if you're going to start a trucking company the template that i do sell online it comes with a word document which will help you write your business plan for your trucking company but also a financial financial model that is geared towards the trucking company this is the financial model so if you buy that template you will get a financial model and in the financial model you're going to have four tabs you're going to have the information tab you're going to have the profit and loss tab the income statement tab and then projections which have some charts and graphs and some summary information all of the changes that you want to make are going to be on the information tab so it's broken up into again categories on each tab the categories are going to be your daily sales for the trucking company it's going to be your miles so if it's under number it could be miles and the price is going to be how much you're going to be charging but we'll get to that in a second your labor if you've got additional employees you'd update that information here startup cost would be right here monthly fixed cost right here and the miscellaneous information specifically your tax rate your monthly ground your your growth rates annually and then also right here is your loan in your loan information interest rate and the term all right so if i was to um customize this we're going to say that my trucking company i'm going to start with three drivers if you're only going to start with one driver then what you would do is you would highlight driver one and two make sure it's zero right here right click and click on hide and now that information is gone but we're going to start with three drivers we're going to say the first driver they're going to cl they usually knock down about 500 miles the price so right now we're going to say that we're probably we're charging about three dollars and 50 cents per mile now for the variable cost the variable cost with my trucking companies what i usually do when i write trucking company business plans is i'm going to say the variable cost of about 45 if i'm going to be the owner operator if i'm not going to be an owner operator then i'm going to probably push this closer to 55 variable cost the variable cost is going to include your fuel it's going to include your driver pay and it's going to include your maintenance so and the reason i include the the fuel the maintenance and the driver pay and the variable cost is because if your truck's not running you're not paying fuel you're not paying maintenance and you're not paying a driver so you're you're set ready to go with that next i'm going to go ahead and i'm going to put this at about 40 because i'm going to say i'm the owner operator for the first truck next we're going to have an inexperienced driver they're going to probably be pulling about 400 miles a day and the price for this one right here we're going to say again it's 350 because we're not going we're not doing anything less than 350 a load um so it's gonna be three dollars and fifty cents per mile so that's gonna be the price is gonna be per mile the number isn't the miles driven so for driver one we're saying there was gonna be about 500 miles per day we're gonna clear about three dollars and fifty cents and our variable cost maintenance and fuel is about forty percent driver twos they're not going to be driving as much as us so that number is gonna their mileage probably could be about 400 a day we're still charging the same price per mile 350 and we're going to bump this up a little bit higher to 55 variable cost because we're going to include the driver pay into the variable cost and again we talked about there's gonna be three drivers so we're gonna go ahead and make this as 55 variable cost for we're going to say this person is going to clear 450 they're a little bit more experienced so once we have that set up right there we are now we what we now have is our daily sales and right here it says the word drivers are going to be working six days a week if it's going to be five then we change it to five days a week but most drivers are going to be pulling six days i wouldn't change this number right here that that's just going to um yeah just leave that alone next is going to be the labor so we're going to pay ourselves a salary so the salary is going to cover the executive team and we are going to be the executive team so we're going to want 5 000 a month so we're going to change that to 5000 a month also for employees we might need a cleric somewhere for clerical for billing and we might need a dispatcher so we're going to say the number of employees are going to be two and then the average rate of pay we're going to say is we're going to pay them probably 18 an hour with the labor what i like to do is i'm going to include the taxes whatever taxes i got to pay or whatever you know whatever i need to cover and the rate i'm going to i'm going to include that in the rate of pay so if it's if you're paying somebody 16 an hour then for this financial model make it eighteen dollars an hour if you have no employees then just put zero and it's gone and you don't have to worry about it but for this example we're gonna say we got two employees next is gonna be our startup cost how much money we need to get the party started here um first section right here the first two sections is going to be the investment how much money do we need to invest to get this started we're going to say we're going to drop 25 000 into this so we're coming to the table equity investment out of our pocket twenty five thousand dollars but we are going to take a loan out so let's say each truck for three trucks 150 000 um then we're gonna have trailers so let's say it's two hundred thousand dollars each so we're gonna say it's about six hundred thousand so 150 for the truck uh and then 50 000 for the trailer gives us 200 000 each two um three trailers three tucks three trailers six hundred thousand so we're going to say that we need six hundred thousand dollars and then we're also going to include in here um we're gonna we're gonna probably bump this up to fifty thousand so we need a total of six hundred fifty thousand dollars and we're then going to go down here to the startup cost we got per truck purchase i'm going to change this to truck and trailer so we're going to get trailers as well and then i might even put next to it three just signifying that we're going to have three trucks three trailers and we're going six hundred thousand dollars right there office equipment we're probably gonna need a little bit of office office equipment uh maybe thirty five hundred dollars for office equipment miscellaneous and licenses and prepaids so i'll i'll include some prepaids because we're gonna have some prepaid insurance prepaid and we're gonna bump this up to four eight twelve we're gonna say fifteen thousand dollars for prepaids we're gonna up the office equipment um so we can just get a closer of it to an even number so we're going to add 4 500 to that so let's go with 8 000 at too high 7 000. all right so what we've got here we've just modified some of the startup costs so we're seeing right now that we're going to invest fifty thousand dollars we're going to get a loan of six hundred thousand dollars so total investment is six hundred fifty thousand dollars however we've spent six hundred and thirty thousand dollars so we need to add twenty thousand dollars somewhere i like to make my at additions when i have extra money at the working capital working capital all that is is how much money do you need to have in the bank day one once you start your business to keep the lights on the trucks running until you start getting you know the piles and piles of cash coming in and that's gonna be your working capital so based on this right here what we've done is we just modified our startup costs to include three trucks three trailers working capital office equipment and some prepaids that comes up to six hundred fifty thousand dollars our loan is six hundred thousand word put into it fifty thousand dollars total six hundred fifty thousand dollars so just in a few minutes we've now aligned our startup cost for our business into categories next thing we need to do is we need to go ahead and update our fixed costs so since we've got three drivers and a couple of employees we're probably going to need a location so we're going to have to drop some rent so let's say our rent's going to be 15. let's go a little bit higher because we're going to probably have to park our truck there so we're going to go with rent at 2 500 if we have rent we're going to have to pay utilities and gas and and such like that so let's say that's going to cost us 600 bucks office expenses go probably a little bit higher three trucks let's go with a buck 25. insurance wow that is a little low we're gonna have probably fifteen hundred dollars um fifteen hundred three forty five hundred dollars a month for insurance whatever your insurance is gonna be for your trucks per truck make sure to add it all together and put it into the insurance spot next is going to be our accounting and legal uh thirty dollars for accounting illegal let's bump it up to a hundred and ten advertising a lot of truckers are gonna go ahead they're gonna be hitting the um they're load boards they're gonna be hitting the brokers so that might cost you know about 150 dollars a month other there's always going to be surprises anytime a business has started what you can expect besides taxes and death is going to be surprises you're not going to be able to plan for everything so we're going to save 5 000 a month for surprises all right so in just a few minutes we've now have our revenues lined up we've got our labor taken care if we've got our startup costs lined up and we've got our fixed monthly cost all taken care of the only thing that we really need to do now is to slide on down here and to take a look at our inter our loan amount so we've got a loan of six hundred thousand dollars interest rate of five percent seven years might be a little low so we're going to say all right um we're going to say our term is going to be 10 years once we make that change then what we're going to do is we're going to go over to the income statement and we're going to take a look at it make sure this looks good so based on these changes we've got revenues of 1.7 million cost of goods 855 000. all the way down here it's going to show us a net profit of 347 000 and then from there it just grows um for year two three four and five and then in the projection section here what we now have here is if you want to go ahead and do a financial highlight you know in your business plan then i've got an information summarized for the annual revenues for each year the cost for each year and the net profits for each year also profit margins you know based on our expectations here it's going to be 20.7 twenty per 20 seven percent profit margin for the first year it's going to grow to year five to twenty five point nine two percent um funding amount six hundred fifty thousand dollars working capital twenty eight thousand dollars and then right here is a nice little chart showing our revenues our expenses and our net profits that you can go ahead and include in a business plan all right so hopefully this information was helpful and you're going to have a better understanding as to how you can go ahead and customize a financial model to best suit your needs based on a temple that is geared towards the trucking industry if this looks good you'll like it and you want to go ahead and buy it all you got to do is go over to my website qualitybusinessplan.com forward slash trucking company business plan template and i do offer numerous tutorials that's going to help you um with your not only your business plan with also but the financial model as well i do have two trucking company business plan templates available it's a let's see here it is the the basic trucking company uh don't don't worry about the price prices do change uh the basic trucking company um and then i also have an advanced trucking company on business plan template as well all right so hopefully this information was helpful if you like to give me a thumbs up on youtube if you you want to go ahead and use my financial model and zip on over to my website and enjoy as always have a fantastic day thank you