Collaborate on Proforma Template Word for Management with Ease Using airSlate SignNow

Proforma template word for Management

[Music] hey y' my name is Paul brosi and I am the owner of quality business plan and what I'd like to do today is to show youall how to quickly and easily create laundry mat Prof for of financial projections using my business plan and uh financial model so the way the video is going to play out is first and foremost going to go ahead and give you a little bit of background about me who I am what I do and why I do it and after that we'll dive into the financial model I'll show you how to use it what's in it and once we're done with it we'll wrap it up sum it up and call it a day all right let's get started real quick a little bit about me again Paul barosi doctoral candidate MBA I am a professional writer specifically a business plan writer so if you all want to avoid all the fun and excitement of writing your own business plan feel free to pick up the phone give me call to me text to me email I would be delighted to help youall with your business plan I am also a business Mentor as well as a business cons consultant so my services range anywhere from helping youall understand your financials to strategic planning executing those strategic plans to optimize in your operations all those wonderful things that a business consultant and a business Mentor does I do and then finally I am an Adjunct professor and subject matter expert in both business and finance so if you all have your business plan ready to go but you need those pesky Financial projections done again feel free to pick up the phone give me call me text to me email I'd be delighted to assist and with that said let's dive right back into it and enough about me let's go ahead and talk about the star of the show which is the financial model or the Excel file that's included in my laundry mat Prof Forma Financial projection model so if and when like I said if and when you do buy the business plan template for the laundry mat it comes with a Word document which is this right here and I cover the word document in a separate video but it also comes with the Excel file that's a financial model that I've custom for the laot laundry mat industry all right so like I said if you when you do buy it you open up the Excel template it does look like this and you're going to have four tabs your information tab your projections Tab and your projection tab well your information tab right here this is where you're going to enter all your information so any place in the darker colored cells and I'm going to go over in just a minute that that's where you can ahead make your changes and once you make those changes your projection tab your profit and loss Tab and your income statement tab will will update ingly so once you make your changes and like I said we're going to go over this in just a second you make these changes here your projection tab which is just a summary tab we will all be updated for you your profit and loss statements for the next 12 months broken up quarterly be updated as well and then your income statement will also be updated so as you change this information here your financials will update in the Excel file and then you just need to copy and paste the different Financial um statements Into Your Word document for your um business plan all right so the the way that the information page is broken up is you start with your daily sales and so you can go ahead and you can change your variable cost here number of customers that you can be servicing at your laundry mat daily here and then the price per customer you would change here so any of these darker color cells you would update this for your revenues and like I said everything will update ingly and then you've got this information right here which is going to tell you what your revenues are and your net profits for the first year the next section is going to be your labor how much money you want to pay yourself and then the number of employees the rate of pay make sure when you do the rate of pay you include any kind of benefits that you're going to be paying out and as Al also taxes and this this is how many hours they're going to be working on a monthly basis they're work fulltime 172 part-time or whatever their hourly um the number of hours they're going to work a month part time you put here next section is going to be your startup cost the first two lines right here is how you're going to fund your organization whether it's going to be Equity investment or a loan and then down here is going to be your um you know your different buckets that you're going to put your money in um biggest thing for your startup cost is these two lines right here should add up to here so you're going to take this 200,000 or whatever your startup um money is and you're going to divid it up in the various segments here's your monthly fixed cost your rent your utilities your insurance your accounting and advertising other and so on all this right here will add up here and this information will again pull into to your profit and loss statements as well as your performant income statement miscellaneous information whatever your tax rate is going to be you put it right there and then we've got our growth rates we've got our growth rates for the next um five years you can change the growth rates for revenues here and then your cost you can go ahead and change the growth rate for your cost here and then the final segment is going to be your loan information this loan amount right here will be pulled from the section right here so whatever dollar amount you put in for a loan it'll automatically populate here you put your interest rate you put your term and then the monthly payment will go ahead and pull into your proforma um proforma uh income statement as well as your profit loss but just keep in mind only your principle is going I'm sorry only your interest is going to be um pulled into that you you person Gap guidelines all right so hopefully this information was helpful so let's go ahead and wrap it up and sum it up in summary if you are interested in purchasing my business plan template it does come with a customizable Word document as well as a basic financial model that is customized for the industry I also provide various tutorials you can find my tutorials on this link right here the tutorials just help you with the various aspects of the business plan template completing them and those tutorials can be access before after you purchase a business plan template keep in mind there are some limitations to all my business plan templates you do need Microsoft Word and Microsoft Excel in order to make edits and also if you have any questions comments or concerns before you purchase a business plan template be delighted to have a great conversation with you my contact information is right here pick up the phone give me call some me text some email we can have a great conversation however after you purchase my template then I do not offer free phone support if you want me to help you fill out that template I do charge for the service the service is there it's mentoring um but like I said I do charge for it and then finally if you do want to buy my business plan templates or check out the various templates that I have the um link is right here and then finally if you don't want to mess around business plan templates you don't want to mess around with tutorials you just want a professional to write your business plan for you or you just want a a professional to do your financial projections I would be delighted to do so pick up the phone give me a call some me text some me email or visit my prices page right here and then finally uh please subscribe to my channel and that's it hopefully this was helpful uh go out make a little bit of money and have a great day thank you