Create Your Ups Invoice Template for Research and Development Effortlessly

Ups invoice template for Research and Development

hey if you're looking to create a set of financial projections for a UPS store then you've come to the right place we have uh built a financial projection spreadsheet template built specifically for uh The UPS Store uh business model now um we did use uh initial franchise uh data from The UPS Store FDD uh but uh if you have similar Concepts you know similar to The UPS Store but not the exact same you know franchise or concept um you should be able to use this template as well it should be a good starting point for uh for any sort of business model that's similar in nature to The UPS Store now this template is uh pretty powerful it's going to allow you to model multiple store locations that you might open over time so if you wanted to start out with just one store but you want to open multiple units over a period of time you can layer those in into the model you're also going to be able to get a full 5 year projection with a income statement cash flow and balance sheet you'll see here when I dive into the template just all the different details and aspects of the model but I wanted to just do a quick introduction to myself I'm my name is Adam hooka I am the co-founder of projection hub and we help Founders create Financial projections for potential investors and lenders specifically today I'm going to be focused on this UPS Store financial model but we have about a 100 different different industry specific Financial projection templates we help folks with the template we help folks fill the template out if they need that level of support as well so today I'm going to go ahead and walk you through step bystep how to fill this template out so let's dive in okay so I am starting out here on the add a glance tab so this is kind of the end of the process so after you filled out all the assumptions you're going to be able to see some profit and loss at a glance some key ratios a few different graphs and charts and then some key key performance indicators or summary data that would be useful to you here as well as some startup fund graphs and charts you're also going to get a five-year income statement summary a fiveyear cash flow summary 5-year balance sheet and then an income statement cash flow and balance sheet all broken down by month for each of the five years so you're going to get that monthly level detail this is uh what the SBA for example if you're looking for an ba loan they're going to be asking for U monthly detail at least for the first couple of years uh as well as annual summary data so in order to produce all these reports though we have a little bit of work to do so we're going to come back to our input assumptions tab here and so the thing that you need to know about the the blue input tabs in all of our models is that any cell that's highlighted in blue is an assumption that you can change without breaking something in the model so you know feel free to make changes without breaking anything one tip tip will be don't delete rows or delete cells you you can hide them but I would suggest not deleting you may create reference errors in the model so that's always a good tip to remember Okay so we've got our company name UPS Store and we have our projection start month January 1st and we have opening cash balance of $10,000 now let's say we're going to invest 250,000 of our of our own cash into this and then we also are going to borrow we're going to have a business loan of 150,000 down here as well and and another business loan for 200,000 so you can add in multiple loans let's say you're you know maybe you're buying the building as well and so this could be an example where maybe you own the real estate you're going to buy the building so that's why we've got this loan at a at a longer term the 360 month term and then this may be more of a startup or acquisition loan on a on a 10year term okay so you also have some other assumptions up here about your accounts payable and accounts receivable this just means that you're going to pay most of your bills 80% of your bills in the month incurred maybe some of your bills maybe you get your utility bill and you have 30 days to pay it or something like that so some of those bills may be paid on a on a one- month delay you'll also have accounts receivable here where you're going to get paid 100% of your Sal sales in the you know right away right you know customer comes in they're going to pay you right then you're not going to give them terms that you know they get to pay in 30 days or something like that but if you did have a unique situation where you have maybe large customers that you are invoicing at the end of the month or something then you could say okay some percentage of your sales are in a net 30 payment here you can set inventory assumptions so you can set inventory assumptions here where you can have an initial inventory balance at startup and then this percentage here would be how much inventory would you have on hand as a percentage of your of your monthly sales so you'll keep some inventory on hand and then surely you'll get you know additional shipments of of additional inventory as needed so for the fixed assets what we did here is we we took data from the FDD from The UPS Store franchise Disclosure document and and tried to populate uh with information from that FDD now some of the these items could be ranges they can change and so you know you'll always want to make sure you get the most upto-date version of the franchise Disclosure document and update these values to to what makes sense for your specific plan location and and time okay moving on to the input Revenue tab so here we can say you know how many days were open per week can set some just overarching like price growth and cost growth rates year-over-year and then here is where we would be able to open multiple UPS Stores so we could say okay we're going to do you know store number two here and we're going to open that in month 25 so the beginning of year three we're going to open a say we open a second store and and when you do that then the model will automatically build that additional store into the model you'll notice here that as we scroll over we're going to see okay and we're going to in year three if I scroll over far enough yeah so I can see that I now have two stores open once I get to that year three level okay yeah there it was right here we now we have two stores open one that's one-year-old one that's now three-y old a three-year-old store okay and so what we're gonna be able to do then is say okay one year after opening how many visitors is the store going to get per day and then as we kind of grow the stores will will grow and probably get more and more customers each day as they grow so you can set that kind of customer count here per store per year so once you get down here to the shipping and pack packing Services here what we can say is we'll we'll see how many visitors we're going to have per store per day then we can say what percentage of these customers here are going to uh purchase shipping services and so we're saying okay 70% are and 75% are and so this gives us an estimated number of customers per day and from there you can kind of break down okay what percentage of those customers are are individuals and what percentage over here what percentage are business owners and the reason we break that down is just because we you know individuals may have less items per transaction whereas businesses may be shipping multiple you know maybe multiple orders or you know multiple units so we have different assumptions there for kind of the breakdown between individual and business customers and the number of items that they are purchasing or shipping or packaging uh per transaction so then based on those assumptions we'll have the total number of items processed from all stores then you have this kind of breakdown where you can get into a lot of detail if you want now you could you could change this whole this whole box here and just say like small package medium package large package something like that if you want to make it simpler you you could just have a few different options but if you want to kind of have all the different options with the different average price points average shipping fees that you would expect to have and then the average store processing fee that you would have for each item and then you get to break down okay what percentage of customers are going to use us to ship a small package with standard ground shipping right so you've got you've got all these items 694 items that are being shipped in in month one we're saying 40% of them are going to be you know this line item 2% are going to be this SL item and we have this adding up here to 100% so you want to make sure that kind of as you break down the the different services that people are utilizing that that this adds up to 100% now you may also offer you know return shipments handled return shipments and so you can you can outline what the return shipments would look like so folks may also you know your visitors may make a purchase but they also may just come to the store for the sake of processing a return right and so so we can say okay 15% of of of the foot traffic of the customer traffic are coming to return an item and then this would be you know the the shipping cost and the store um processing fee uh for each of those return shipment options okay so that is your shipping service fee Revenue now we also have the ability to do packing Services you can have um different packing services with different price points your cost of Labor and cost of materials and then what percentage of customers are going to you know utilize the the packing service so this may not add up to 100 you know because not everyone's going to utilize you for packing Services maybe this should be you know less than 46 it might be 10% you know utilize utilize your packing services so that is another Revenue line item that you can you can include and then this is a commissions from carrier partnership so you have different carriers obviously and then you can get a a commission based on a volume based commission a value based commission getting a a 1% Commission on those items so that calculates here kind of what those commissions could could be then with your shipping Partners now we also have the ability to there's there's kind of lots of different Revenue models in in a UPS store so you also have the ability to do business support service revenue and cost of goods sold so again we can say what percentage of visitors to the store are going to take advantage of these these business support services and we can see you know what those would be so packaging materials office supplies office equipment you know notary services shredding document service scanning faing those sorts of things printing so all of those items can be handled and and kind of considered in this section and it doesn't end there we also have mailbox rental Revenue so that is another common Revenue model that uh UPS Store can have is mailbox subscribers so we can we can put how many new mailbox subscribers we're going to get each month here we can set an annual growth rate as well as a churn rate or cancellation rate so what percentage of those mailbox subscribers leave along with a maximum capacity so if the store has 200 mailboxes that that would be your capacity and you could grow that kind of Revenue line item until it hits that capacity and then it would level out you have the ability to say whether it's your those customers are going to pay monthly or annually and set a monthly or annual fee because there could be discounts if you pay annually so you can set those assumptions in there and ultimately that will give you your mailbox rental Revenue as well so that is the the pretty long Revenue model there 250 lines but there is a lot of a lot of Revenue options for a UPS store that we want to include now on the other expenses this can get pretty powerful as well we can set up expenses and we we can utilize data from the fin franchise Disclosure document so that's where we got a lot of these numbers so your initial marketing plan digital media you're advertising 4% of Revenue and then the royalty fee to UPS as a franchise 5% of Revenue you have credit card processing fees we set at three 3% of Revenue you can see other operating expenses here set up as monthly amounts as well and you can set these expenses and and put them in different categories here so if you want to add more categories you can add more categories up here and then you know categorize those expenses you can also set all these expenses to be a fixed dollar amount meaning it's the same dollar amount each month a percentage of Revenue a per store expense or a per employee expense so there's a lot of different a lot of flexibility here you know where you know for example training could be an expense per employee as you're training training new employees now this actually is probably training this should really be training for the for the owner probably for you as the owner you're going to do initial franchise training so we're going to set that as fixed actually but that would be an example of you could have you know ongoing training for for new employees as well all right so here you can set uh salaries so you can you know give an owner salary here so we've got owner salary let's say we're not starting that salary until month 25 maybe the business can't afford it initially and so let's say you know we're not starting to take a salary till month 25 and then you can set uh staff salaries here and you can set this as a per store staff team so again you can set the timing of when when these staff members would start and also the number so here I set you know we're going to have we start in month one with two staff now this could be this might be actually like four or six part-time staff that kind of equate to two two full-time staff you know you could you could treat it that way as well and then you could also you know it might be that you as the owner are working in the store initially without taking a salary and so maybe you have three staff initially right and then you add more staff as you grow so that is that is the input and that kind of brings us to our our end State here and you know what you'll want to look at is you know based on the assumptions that you have entered in um how how's the business cash flow does it cash flow you know are there expenses you need to look to decrease or their ways to increase Revenue in order to make sure that you know the the projections are cash flow positive so I always suggest looking at the cash flow statement here to make sure that your cash balance never dips below zero if that goes below zero that means you're out of money so we want to make sure that we get to a break even point before you know before running out of money so that's what you want to be make sure you're presenting to to your lenders so if you have questions or want us to review the projections for you after you've filled the model out I know there's a lot here and so feel free to send us your file to support projection hub.com and we'd be happy to review the model for free uh for you and give you some feedback um also happy uh to answer any of your specific questions um so again you can email support projection hub.com for that and also as I thank you for sticking around now to the end of the video we're going to put a link in the description of the video below to get a coupon code so you'll be able to get access to a coupon code where you can take a discount on this particular template we'll put a link to the template in the description of the video as well and make sure to take advantage of that discount all right I hope that's been helpful and we'd love to hear from you thanks