Streamline Your Vet Bill Template for Enterprises with airSlate SignNow

Vet bill 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 so let's get started [Music] on the dashboard tab you may input court inputs for your model and also see the call financials and called charts based on the assumptions input in the model let's start the top of the model from their revenue sheet where we can set the starting point of population for example 100,000 people in your region and population growth rate year-over-year example let's say it will be 10% so in the year 2024 based in this calculation you will have 146 thousands of population the next set of assumptions is patient base assumptions so in here when we input up to five different treatment names for example treatment a and B whatever name you need your model and here you may input what is the percentage of population need this treatment in other words percentage of patients based on the total population another assumptions will be patient's percentage this means that what is the percentage of patients will use your your services in other words services which your business provides below you will find the input or count of visits per patient this means this annual visits for example for treatment a 100 visits per year or patients which needs treatment a and not hydroton 2013 non-hydrogen 40 and on hydroton 50 this you can input based on years and based on different treatment types and also below you can input price per visits which you can input depends on the treatment and appends on the year additionally on the revenue tab you can input patient's growth rate this means that these patients 27% will be increase it for 1% the next year 0% we are after 2 percent and 1 percent in the last year these percentages are also changeable so you may see the calculation of patient share depending on the amount which input on the dashboard in here and fashions growth right here so 27 percent the starting point plus 5 percent and in the next year we will have 32 percent for the treatment a etc etc so based on all these assumptions of the revenue tab the export tab you have the calculation of patients and new patients by years and by treatments with some total moms additionally you can input seasonality for the patient acquisition or new patients requirement and the visit seasonality across the year in case if this treatment is seasonal based so once you set up all these inputs for revenue for seasonality the patient based inputs your variable fixation wages expenses you may see the chord charts which is profitability the revenue break down the cash flow cumulative cash flow and physical financials by main categories and by years on the financial chat step you may see two sets of charts which is 24 months where you break down by months and five years pale looking down by months on the top set of charts when you see the revenue break down by five treatment types for 24 months and for five years the next set of charts will show you your passion for catch alcohol related to operating activities the next cash balance and the last one will show you the IBGE broken down by revenue variable expenses other Opik switches wages and fix-it expenses and as a result your ABG on the operational chart step you can see also two sets of charts in the same vector by three to four months and by five years on the top you may see the general cleaning statistics which is total active patients and total number of visits by manses you'll revenue by patient type revenue for one treatment one patient second treatment patient etcetera etc and this is broken down by percentage allocation your optics productivity which is topics a mile per one patient and topics amount for one visit and your work is for the TVG which is revenue per employee and public's pyramid on the keeper benchmark step we may see five main industry benchmarks which are all also changeable depending on your industry depending on your country or region example in your country which mark of gross margin for this business seventy percent so let me see on the gross margin keep a tab the industry gross margin is updated and this is also works for all other four main key benchmarks for example profit margin is 15% just also change it on this chart and you can also change wages as a percentage of revenue your average revenue per patient and your average net profit per patient all these values are calculated by years to paint it on the inputs and drivers in your model and can you see the graphical information on the charts will show you your DPS or your metrics based on model and industry metrics [Music] of the income statement tab you see your mind profit and loss line items which is right when you broken down by treatments variable expenses gross margin salaries and wages fix-it expenses ABG depreciation and amortization a bit interest expense not profit before tax tax expense and as a result net profit of the text on the cash flow tab you may see cash flow statement breakdown by operating activities financing activities investing activities and as a result net increase or decrease in cash help the more collapse formed a small statement direct method it is the same operating activities investing activities financing activities and your cash movement the more perhaps for the balance sheet you may see your current assets which is cash non current assets current liabilities non current liabilities and your equity broken down by manses for the five year model on the summary tab you may see the summarization of all the three ports done by five years and also the breakdown of one particular year which you can sell it here let me see your income statement breakdown and the main line items of the charts below your balance sheet collapse form and the main line items and your cash flow statement also in collapse it form and the main line items which is operating and wasted in its net cash wall and closing cash on the charts below the top revenue tab you see the breakdown I feel revenue by products and also by years with absolute values and percentage breakdown the same information you may see on the charts below here may see the percentage breakdown and absolute values breakdown below you may see the revenue depth and multi-run rate chart you can select the year and based on this year you will see the information of revenue by products as absolute values and percentage revenue breakdown on the pie chart on the revenue bridge you may find the main revenue drivers of growth you may select the first year and you may serve the last year and between these years you will see the waterfall chart and you may see which are the main drivers of your revenue grows which specific products grows faster and which specific products grows slower on the top expenses step and we find the breakdown of top for expenses categories and all other expenses collapse into other category here we see the breakdown of absolute values broken down by years with the total below and also to the right to 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 on the couple of charts below you may find expenses depth and monthly run rate for selected TR you are able to change this year and when we see the absolute values and percentage breakdown on the pie chart and the expenses breach you will find the main drivers of expenses grows between these two years this year's us are also changeable so you may select the first year and you may select 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 you will 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 you may input here cost of loans you previously imported see 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 you must select one of them and below you may input multiple of method based in this information we can see terminal value which is calculated on a library at free cash flow you may see the present value of one laboratory cash flow and PV [Music] the color cotton in the model is very simple when we change any yellow cell in any yellow sheet within the model this means that this yellow cell has some input assumption or driver which imparts the calculations within the model blue sheets means that on these sheets there are some charts reports and other information which can be useful for approaching purposes on the tabs without color you have some extra calculations related to revenue to depth equity inventory and narration which is needed for the report to report them 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 can go back it is 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 detail explanation of what each tab does and what inputs you will find on this sheet and what kind of outputs and we find on the condition as well any header of this section is also clickable so you may click on for example Boca sets and you go directly to the step [Music] when the variable expenses step when we find up to twelve placeholders to input your variable expenses by different line items you have different options of how to forecast your variable expenses your type is forecast as a percentage of total revenue and for each treatment you have two line items to forecast your variable expense as dollar per one visit for particular treatment on the top you may see the main drivers for this calculation so you have total revenue and you have different counter visits by masses for each treatment type and below you may input your assumptions so for relative expenses as a percentage of total revenue you can input different percentages and for next 10 line items you can input dollar amount for one visit for this particular treatment below you may find the calculation of all these line items and in income statement the variable expenses section when we see these mounds by masses on the wages step you can input your head column by categories this fire and fire date is annual salary use ability to input different number of employees per years this annual salary rise percentage is monthly bonus and tax rate let me give you a couple of examples let it be CEO you're going to hire in 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 CEO 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 five percentage of salary growth rate you may see the amount by years connected to this annual salary and bucked advice annual salary rise let's the top 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 mean account which will start April which will grow to the end of the model whose annual salary of $30,000 that'll be here number 1 2 4 6 8 and 10 head counts sue percentage of annual salary rose 5 percentage of monthly bonus and 5 percentage payroll tax rate so in here let me see total stuff numbers just two of the ER number one twenty twenty started from year 2021 we have four that six eight and ten the last year of the model again calculation of salaries for this to in this case for what 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 [Music] on the fixed expenses step if we input up to 15 line items for your fix-it 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 and we see it here let's pretend periodicity will be daily with the amount of $50 per day so you may see this amount sit here this calculated based on count of days within this month so obviously March 20 you have city 1 days that's why we will have fidget cards at 50 in April you have 30 days this means this will be featured hundreds dollars also you have ability to input some growth rate year-over-year once you input this growth rate you will see that your utilities will grow or year or 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 in the amount of $100 without any gross so start starting from March till 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 multiply it by two you have $1,000 per month again you can input some prostrate 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 off is set up which can be one-time payment which will happen in favor of 20 is the amount of $5,000 obviously should not input a Negroes rates 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 join you 20 to the end of the model and it can happen monthly with $1000 per month is 5 percentage of gross first year 3 percentage of gross second year 2 percentage of gross short and 1 percentage year number 4 so it may see this calculation here starting from January 21 it will grow for 5% which is $50 and starting from January 22 it will grow for 3% which is additional is $32 another option quarterly you may see that insurance will be paid $1,000 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 a percentage of gross and the last option is annual payments or yearly payments you'll pay one time for 12 months starting from February to December 24 for each expense type you can use growth rate and the calculation you may see in here also in the income statement you may find total fixed expenses group if you will ungroup this section you can see these mounds broken down by manses and by fix-it expenses line items [Music] you may input up to 20 development expenses categories let me give you a couple of real examples for example to see the kitchen other development expenses you can input to chase date or each category example February and March you can input expansion $2,000 $10,000 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 for the kitchen and for example three months is for other development expenses which means that you will pay for it in June 20 the total amount of development expenses connected to the assets step we see it here by default use the full time for development capex is five years so when we see the calculation of depreciation and closing net book value we are also able to input up to six other assets example hauser capex this launch date for example June is three years beautiful time it's $5,000 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 repayments in case of prepayment prepare these amounts and you'll pay in some answers after we'll help capex payable because they set up two and three months is payment delay we see that we have kept expel I can also move here or select 0 masses in this case capex payable will be zero but you have just fixed assets amounts broken down by months at the capitalization table you can input different founders and investors contributions broken down by different dates or pondan is different cost of share for each series and you can see the dilution of shares after each round and pramana total equity and post magnitude of equity let's pretend that we have two founders only one five two two so total amount of shares for founder one can be ten thousand were found the number two twenty thousands let's imagine that cost of share will be two dollars and the data found in this February this means that investment for Faulkner one twenty thousand dollars were found to is forty thousand dollars 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 $5 per share and number of shares is 1,000 so total amount of investment will be $5,000 we seeded before the serious a total equity was $16,000 after is $65,000 and investor one who have 3.23 percentage of shares and the shares found the one in front the two also diluted so to 2.26 and four to 6.52 percentage 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 amounts of finder 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 chef that's assumptions let me show you how it works so for the each depth you are able to select the depth type there are two depth types in the model which is energy and usual energy means that each monthly payment which consists your depth your payment plus interest expenses will be equal each month in case if you will set it to zero you're my depth repayments will be equal parts and interest will be just interest on the depths close and balanced let me give you an example how it works so you may input an amount of the depth the launch date term will be 60 months 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 depths let me see on the capital tab calculations for the depth number one tip number two step number three total depth with grants these calculations in Part C income statement interest expenses the cash flow interest page tab drawdowns debt repayments and on the balance sheet you have the depth closing 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 and the 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'll have in the model all your inputs in United States dollars all your outputs in euros and there will be a conversion rate between currency inputs and currency outputs additionally you have denomination which means that you can denominator all your outputs on the reports this example you have denomination is 1000 means that your output is denominated by 1000 you can select Millions let me see now it is in million dollars you can set also billions or without any denomination additionally you have corporate tax setup 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]