Discover the Best Dental Receipt Template for Enterprises

Dental receipt template for enterprises

[Music] hello in this video I'm gonna walk you through the financial model example template I will show you the main inputs the core outputs reports and charts oh let's get started [Music] on the dashboard you may input core inputs on drivers for your model and see the core financials and chord charts based on the assumptions so the model starts from modeling of your annual marketing expenses you can input by ears for example on credit and 50,000th and additionally 50 thousands per year for example then you can input costs to acquire a new patient for years you can grow also with some predicted amount per year and based on these assumptions you have total new patients by years as an object then you can change your patient based assumptions which is percentage of new patients attained it means that the patient was on the first initial treatment and what is the percentage of retention after this first treatment you can also input your patient base monthly shirin which means that your retainer patients are tend to charm romances and based on these assumptions you may see the patient base or active patients at the end of the year additionally you are able to change the seasonality of your marketing expenses on the seasonality tab so you may change the assumptions they break down by years if you don't need any seasonality you can just input 1/12 just roughly eight point three percent and you do not have any seasonality just flat amount by Maxis the next step is revenue tab where you can input your domain services revenue you have initial service which will use 100 percent of your patients and then we have up to nine services or treatments so you can in service a service B or whatever name you want to use and you have uses frequency means that 20% of initial patients will use your service a over the year and you may input the price per service just dollars month or one treatment the next set of inputs is cost of goods sold for the same set of services you can input Cox as a percentage for cost of materials and Cox as a direct label this is also changeable by years so you may change the assumptions in the way you need additionally you have extra products revenue in Cox assumptions have up to five different products is different launch dates which you can change the sales of units per month the annual sales grows the product price and map gene to calculate the costs all these values are also changeable so you can play with it in the way you need the final things you need to input on the dashboard this is safety stop for your extra products to calculate the inventory and payment delay days or your accounts payable both these calculations you may seen here and balance sheet inventory and accounts payable roles as a final point you can see the revenue breakdown profitability cash flow and cumulative cash flow once you finish the input of your variable expenses fix-it expenses and wages on the financial chat step you may see two sets of charts 24 months is broken down by months and five years also broken down by months in the top set of charts and we see the main revenue streams break down which is extra product revenue and my in services revenue and also the same chart broken down by five years below you may see the main services revenue break down by nine different services and initial service and extra product revenue break down down by up to five different products below you may see operating cash flow you can down by cash inflow cash outflow your cash balance and your ABG is break down my total revenue cogs and operation expenses on the operational charts you may also see two sets of charts you can down by 24 months and five years here we see the employee productivity which is revenue per one employee and a box per one employee and average monthly revenue per patient broken down by 24 months and broken down by five years on the benchmark step you may find five different industry benchmarks you may also change these benchmarks depending on the values for your industry and your country for example gross margin in your country 70 percent and to me see that Ross margin which marks chart is updated with 70 percent value as industry benchmark the same we may change for profit margin wages as a percentage of revenue average monthly revenue per patient average net profit per patient the calculations based on the inputs and the model is here to the right of industry which marks and you may see the five charts his projected values and with industry benchmark values [Music] on the income statement tab you may see your main components of your profit and loss which is total revenue total cost of goods sold gross margin total variable expenses total admin salaries and wages total fix-it expenses a BGA depreciation and amortization habit interest expense net profit before tax your corporate tax and as a result net profit after tax please note that each category has its own subcategories so you may click on this plus button and see the details ation for example or fix it expenses or for variable expenses or for example for arriving on the cash flow statement you may see your cash flow all broken down by cash flow pro protein activities cash flow from investing activities and cash flow from financing activities the same information you may see on the cash flow statement and direct method operation investing and financing activities but more colopsis form just easier to see the information here and the balance sheet will show you the breakdown of your current assets non current assets current liabilities non current liabilities and equity by its subcategories the summary of three statements will be find on the financial statement summary tab on the top you have lookup statement brokered online five years and the selected here which you can change here you can down by Mathis you'll you may see the same information on the chart form the next set of tables and charts will show you the balance sheet main key is broken down by five years and select gr by Monza's and the last part will show you the cash flow statement breakdown for the five years and twelve months for the selected year as well as charts with the same information [Music] put the top revenue tab you will find your revenue breakdown by my in services and extra product and also broken down by years and broken down by absolute values here and we can down by percentage allocation here below the numbers you can see the charts with the same information is breakdown by absolute values and whisper down by percentages you can also use revenue tips and monthly run rate charts to see the detail at breakdown of some year which you can choose here and we see this as a numbers and as a percentage rate down below also even find the revenue breach and you can also choose the selectors to set the first year and the last year and you will see the difference between first year and last year and the main drivers of your revenue growth just main services and extra product [Music] on the top expenses tab you may find a breakdown of top for expenses categories and all other expenses collapse it into other category we see the breakdown of absolute values broken down by years with the total below and also to the right you may see the percentage breakdown of these expenses the same information you may see on the charts below which you may find the percentage breakdown and the absolute values breakdown and a couple of charts below you may find expenses depth and monthly run rate for selected TR you are able to change this year and you may see the absolute values and percentage breakdown on the pie chart and the expenses breach you will find the main drivers of expenses gross between these two years this year's us are also changeable so you may select the first year and here we sell at the last year and you may see that total expenses started in 2020 will change to total expenses in 2024 by this waterfall on the break-even tab even find the calculation of revenue break-even level and break-even chart for this particular particular use case you may find that your revenue break-even level is less than actual revenue calculation this means that company is profitable on the valuation tab you may see the calculation of company valuation based on the cost of equity which may input here cost of Lords you previously imported on the dashboard calculation of resource share you may see here there is also tax rate and here we find the weighted average cost of capital in the valuation model there is two valuation methods which is a BGA multiple and revenue multiple we must select one of them and below you may input multiple of methods based on this information we can see terminal value which is calculated on a library at free cash flow you may see the present value of unlevel free cash flow and PvE and multiplicator evaluation for this particular company [Music] the codon in the model is very simple you may change any yellow cell and any yellow sheet within the model this means that this yellow cell has some input assumption or driver which imparts the calculation within the model blue sheets means that on these sheets there are some charts reports and other information which can be useful for reporting purposes on the tabs without color you have some extra calculations related to revenue to depth equity inventory an aberration which is needed for the report reporting additionally you have contents tab which allow you to navigate across the model very simple so you may click on any report and you can go back just broken down by reports assumptions statements and setup there is short explanation about what each tab does but if you want to know more you can go to how to and to see more detail decks detailed explanation on what each dot does and what inputs you will find on this sheet and what kind of outputs you may find on this sheet as well any header of this section is also clickable so you may click on for example Boca sets and you go directly to this day [Music] on the range of steps you can input your head comma categories this fire and fire date whose annual salary is ability to input different number of employees per years whose annual salary rise percentage is monthly bonus tax rate let me give you a couple of examples let it be CEO you're going to hire March 20 you're not going to fire him so the fire date will be December 24 so annual salary can be $50,000 and see the one see here over the time so you may see one see fuel which is one could count starting from March to the end of the model which is December 24 also you can input 5 percentage seller growth rate you may see the amount by year's connected to this annual salary and ducted by Staniel cellular eyes let's set up 10 percent monthly bonus and 5 percent of tax rate so you may see below the calculation of salary broken down by manses monthly bonus which is 10 percent and 5 percent of months taxes related to the payroll another option to be admin account which will start April which will grow to the end of the model is annual salary of $30,000 that will be here number 1 2 4 6 8 and 10 headcount super Santa job and your salary rose 5 percentage of monthly bonus and five percentage federal tax rate so in here you may see total stuff numbers just two of the year number one twenty twenty started from year 2021 you have for that six eight and ten the last year of the model again calculation of salaries for this tool in this case for that counts population of bonuses and calculation of monthly base taxes we see in income statement total salaries and wages and here you may see the total amount of bonuses payroll taxes and wages for this on the fix it expands a step will be input up to 15 line items for your fixed expenses let me show you how it works for example we have utilities you will start pay starting from March 20 till the end of the model which is December 24 let me see it here let's pretend periodicity will be daily use the amount of $50 per day so you may see this amount here this calculated based on count of days within this month so obviously March 20 you have City Mondays it's why we will have featured hundreds and 50 in April you have 30 days this means this will be featured hundreds dollars also you have ability to input some growth rate here over here once you input this growth rate you will see that your utilities will grow over year all year let me give you a couple of other expenses types for example advertising let it start in March and finish in August 24 this will be on weekly basis is the amount of $100 without any gross or start started from March to August 24 you have four hundred dollars per month which is four weekly payments each month and that's it another option is be weekly for example five hundred dollars you can start from July for example and you'll have two payments which is to be weekly payments within two months $500 multiplied by two you have one thousand dollars per month again you can input some go straight and you will see that your advertising expenses will grow here all year till the August 24 which is a last date of this expense type another option office setup which can be one-time payment which will happen in February 20 is amount of $5,000 obviously you should not input a Negro straits because this is just one-time fee and you may see that office setup will happen in February 20 is this amount another option insurance let it be start from 10 you 20 to the end of the model and it can happen monthly with $1,000 per month is five percentage of gross first year three percentage of gross second year two percentage of gross short and one percentage year number four so let me see this calculation here starting from January 21 it will grow five percent which is $50 and starting from January 22 it will grow four three percent which is additionally $32 another option quarterly you may see that insurance will be paid $1000 each quarter you can start it for example from February and this will be shifted to one month forward another option semi-annually in this case you have insurance payments once for half a year again with the percentage of growth and the last option is annual payments or yearly payments you'll pay one time per 12 months starting from February to December 24 for each expense type we can use growth rate and the calculation you may see in here also in income statement when we find total fixed expenses group if you will ungroup this section you can see these amounts broken down by manses and by pictured expenses line items [Music] on the variable expenses tab you can find up to six line items to forecast your variable expenses as a percentage of total revenue first one item is marketing expenses this is a bit unique the calculation of marketing expenses is driven by the dashboard amounts we've put in here and also seasonality of marketing expenses spread by masses another five line items you may change and forecast your variable expenses is a percentage of total revenue let me give you some example for example dire labor you can set for example 15% of total revenue other variable expenses 10% etc on the top you may see the total revenue as the basis of calculation for variable expenses and below you can fight the calculation marketing expenses and other five line items by studies input when we find your variable expenses breakdown by months by line items in income statement in the section variable expenses and see this values as a total here [Music] you may input up to 20 development expenses categories let me give you a couple of real examples example to see the kitchen Houser development expenses you can input purchase date or each kg billion example February and March you can input spending $2,000 ten thousand dollars for example you can also use payment delay feature which means that if you will select for the kitchen - manses you will pay in April of the kitchen and for example three months is for other development expenses which means that you will pay for it in June wedding the total amount of development expenses connected to the asset step let me see it here by default use the full time for development capex is five years so let me see the calculation of depreciation and Plaza net book value we are also able to input up to six other assets example Houser capex is launch date for example June three years beautiful time with five thousand dollars cost let me see the calculation here so in this step you have calculation of capital expenditure book depreciation and close the net book value the total amounts you may see in income statement tab in depreciation section for the cash flow you can see the fixed assets capital expenditure and in the balance sheet you may see fixed assets as its closing Book value and capex to payments in case of prepayment repay these amounts and you'll pay in some answers after you have kept xpl because it's the top two and three months is payment delay you may see that we have kept expel I can also move here or select zero manses in this case capex payable will be zero but you have just fixed assets amounts broken down by monsters the capitalization table you can input different founders and investors contributions broken down by different dates of finding is different cost of share for each series and you can see the dilution of shares after each round and pre-money total equity and post money total equity let's pretend that we have two founders on the 1 5 to 2 so total amount of shares for founder 1 can be 10,000 were found the number 220 thousands let's imagine that cost of share will be $2 and the data found in his February this means that investment for 500 won $20,000 were found the two is $40,000 in total they invest $60,000 which we see here the dilution is 34 33 to 67 percentage of shares so let's pretend that for serious a we have one investor and the date of issuance is my cost per share is five dollars per share and number of shares is 1,000 so total amount of investment will be five thousand dollars we seeded before the series a total equity was sixteen thousand dollars after sixty five thousand dollars and investor one you have 3.23 percentage of shares and the shares of founder one and for the two also diluted thirty two point twenty six and forty six point 52 percent which you can also input some amounts for Sirius B at CDC the same way you can set up the date cost of share and up to five investors is up to five placeholders for number of shares the amount of funding you may see in the cash flow in the ordinary equity risings and when we see the balance sheet it shows you the total equity by ounces [Music] also on the top of the dashboard yes that's assumptions let me show you how it works so for the each depth are able to select the depth type there are 2 DEP types in the model which is energy and usual energy means that each monthly payment which consists your debt repayment plus interest expenses equal each month in case if you will select usual your mind depth repayments will be equal parts and interest will be just interest on the depths close in balance let me give you an example how it works so you might input a amount of the depth the launch date term will be 60 ounces and interest can be 5% you may also input the grant which is just simple amount which is paid in some specific months and that's it no repayments no charms in terms of interest so all the calculations of the depth when we see on the capital tab calculations for the depth number one tip number two step number three total depth with grants these calculations in parts make up statement interest expenses the cash flow interest rate tab drawdowns debt repayments and on the balance sheet we have the depth Clause and balance [Music] on the top of the dashboard you have currency denomination and taxes set up so currency inputs means that you can input all your drivers for the model using one currency you have currency outputs it can be the same as currency inputs and it can be different from currency inputs so let me give an example the new input in the United States dollars you have euro as an output and for this case you can set up currency exchange rate this is one point two for example in this case you have in the model all your inputs in United States dollars all your outputs in euros and there will be conversion rate between currency inputs and currency outputs additionally you have denomination which means that you can denominator all your outputs on the reports in this example you have denomination is 1000 means that your output is denominated by 1000 you can select Millions you may see now it is in million dollars you can set also billions or without any denomination additionally you have corporate tax setup you can change this number and this will impart tax expenses in your income statement I hope you enjoyed my video thanks for reviewing this you can find more on my website in models lab calm and we'll see you later in the next videos [Music] you [Music]