Collaborate on Proforma Template for Product Quality with Ease Using airSlate SignNow

Proforma template for Product quality

hey um my name is Paul Borowski and I am the owner of quality business plan and what I want to do today is show you all how to quickly and easily create short-term home rental pro forma Financial projections using my short-term home rental business plan template so the way this video is going to work out is first and foremost I'm 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 from that point in time I'm then going to walk you all through my short-term home rental financial model that will help you you know create your pro form of financial projections for your next 12 months as well as your pro forma income statement on projections for the next five years all right so let's go ahead and zip through this little handy dandy PowerPoint presentation so first a little bit about me again Paul Broski owner of quality business plan I am an MBA as well as a doctoral candidate 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 foreign email I would be delighted to write your business plan for you so I do offer custom business plan writing services my contact information is right here I am also a business plan a business Mentor so if you need some assistance some some professional guidance for starting or growing your business I do offer mentoring services and then finally if your business plan is all set ready to go but those financial projections are giving you some problems I do offer a financial projection Consulting and I I do offer the um to create your financial projections for you just let me know further I am also a published author on amazon.com specifically for business plan books so if you want some reading material check me out on Amazon and then finally I'm an Adjunct professor and subject matter expert in both business and finance so I do have a little education backing up my thoughts and ideas for my business Consulting business mentoring business plan writing Financial projections all that good stuff all right so without further Ado let's go ahead and introduce y'all to the star of the show which is my financial model that is customized for the home rental business home rental industry so in my if you are interested in buying my templates for the home the home rental business plan template it does come with a Word document and the word document would be right here so here is my word document say hello Word document so it does come with the word document the tutorials for the word document is in a separate video um this video what we're doing is we're focused on the financial model and so for the financial model that's included in my business plan template it comes with four tabs your information on page comes with your projection summary all the summary of your financials your profit loss statement broken up quarterly for the next 12 months and also your income statement um that is for the next five years and this is your income statement all right so any changes made to the information page will automatically update your projection tab your profit loss for the first year as well as your income statement and for this tab I do again breaking into sections sections as well which is going to be your daily sales your labor your startup cost your monthly fix cost your growth rates and then also your loan information and so let's make this a little bit bigger so it's a little bit easier to read all right so for the first section it's going to be your daily revenues and anywhere you see the darker colored cells or the um changes you're going to want going to want to make so it starts with average room rental so if you're renting a house you'd want to change it from room rental to house rental and then the number here means is how many houses or how many rooms are you renting out on a daily basis for this example I'm saying we're renting out four rooms each room is rented out for um 205 dollars or it could be four houses we're renting out daily at a 205 dollars a night and our variable cost is 20 variable costs are usually going to cover maintenance in any kind of cleaning phase next is going to be how many days are you going to be on operations typically if you're renting your house or you're renting rooms you're going to be renting those seven days a week um so you'd put seven if it's going to be six days a week and you put six um but that's this is the information you're going you're going to change right here in the labor the labor is the next section for labor under salary that's how much you want to pay yourself so if you want your salary to be 3 000 a month put three thousand if you wanted to be twenty five hundred dollars a month but 2500 and then employees if you're going to have an employee however many employees you're going to have put the number here whatever the rate of pay would be here and then 186 represents a 40 hour work week for your employee if it's going to be part-time then just reduce this number ingly just make sure it's out on the hours are monthly next section is going to be startup some startup cost first two lines are static um you can't change the titles here but you can definitely change the dollar amounts and this is going to be your Investments so how much are you dropping out of your pocket for um Equity investment and then if you're going to have a loan how much is your loan going to be you're going to put it right there now once you put the loan information here for in this example we're saying you're taking out a loan of 150 000 and you're doing an equity investment of fifty thousand dollars this loan information is going to automatically populate down here under your loan information and then all you have to do is change your interest rate and change the term of your loan and then your payments will automatically be calculated not only will they be calculated but they will also populate into the projections your profit loss statement and your income statement as well all right next section is going to be so once we have um our equity and our debt investment taken care of for example again 50 000 Equity investment 150 000 loan so we've got a total investment of two hundred thousand dollars the next part under the startup cost is how you're going to allocate those funds you've got two hundred thousand dollars you're investing into the game where is that money going and that's where this information is right here so you're going to go ahead and describe whether it be inventory supplies advertising uh purchase and build out working capital whatever it's going to be go ahead and put that information right here and again just remember these three lines cannot be changed and needs to stay a build out cap working capital miscellaneous equipment all these other titles can change and then all these dollar amounts here can change as well the next section is going to be a monthly fixed cost section and you know how much your utility is going to cost your office expenses Insurance County legal advertising and then other whatever those costs are going to be you're going to want to update that information right here next section is going to be your tax rate how much you think you're going to be paying the taxes to make that change right here and these are your growth rates for the next five years the first five is going to be your revenues growth and the next is going to be your average cost growth for your on various costs all right once you update this information then that will automatically again populate into your projections tab your profit loss Tab and your income statement Tab and the next thing you're going to want to do is you're going to want to go ahead and replace the financial projections that are in the template with your updated information and the way to do that for example is going to be to copy let's make this a little bit bigger again so you're going to want to go ahead and copy your income statement hit control C then you're going to want to zip on over to your um Your Word document for and you're going to want to go all the way down to where it says Pro foreign income statement you're going to want to delete the placeholder and hit Ctrl V and when you do that all your new information will now be updated Into Your Word document portion of your business plan all right so hopefully this information was helpful so let's go ahead and wrap it up sum it up so in summary if you are interested in buying my short-term home rental business plan template it does come with a Word document and the word document where is where the business plan the actual business plan is and I have I cover that in a separate tutorial it also comes with the basic financial model which we just covered there are some limitations to my in my short-term home rental business plan template first it is not compatible with Google Docs it's also not compatible with the Google pages and Google Sheets so just keep that in mind if you have a Mac but you have a Microsoft 365 on it you should be good to go but if you're trying to use the Apple products Apple Pages or anything like that there's is not going to be compatible next if you have questions if you want to give me a call saying hey Paul I want to talk about your short-term home rental business plan template be delighted to have a great conversation with you my contact information is right here send me a text send me email give me a call whatever works for you be delighted to talk about my short-term home rental business plan template however if you do have questions after you buy the the template I would refer you to my business plan tutorials you can go ahead and go to this link right here and you can view my business plan tutorials before you buy after you buy the template or even during while you're buying the template it's up to you those two template those tutorials are free and you can access them by going to this website right here and then finally if you don't want to mess around with a business plan template you just want somebody to write the darn business plan for you I do offer custom business plan writing services I offer mentoring Services I also offer a financial projection services and strategic planning Services any any of those Services just check out my visit my link right here and you'll be able to see the prices for my various services and then finally if you do want to buy the short-term home rental business plan template I'll just visit this link right here all right hopefully this information was helpful as always go out make a little bit of money and have a great day thank you