The user can quickly generate his personalized business plan by changing a few details in an example of the Business Plan Templates. Business & Financial Plan Excel Template commbank.com.au. Elizabeth Wasserman is editor of Inc.' You do this in a distinct section of your business plan for financial forecasts and statements. 'Ideally you want to project in spreadsheet blocks.
Posted in category Whether you are already running a business, or making plans to start one up, financial planning is a vital part of ensuring your success. Not knowing your expected income and expenditure will make it difficult to plan, and hard to find investors. This 5-Year Financial Plan spreadsheet will make it easy for you to calculate profit and loss, view your balance sheet and cash flow projections, as well as calculate any loan payments you may have. Whilst the wording on this spreadsheet is focussed around products, it can just as easily be used for businesses who largely provide services to their customers. How to use Financial Plan Model Inputs Use the Model Inputs sheet to enter information about your business that will be used to model results seen on the other pages. Forecasted Revenue The forecasted revenue section allows you to estimate your revenue for 4 different products. Simply use the white boxes to enter the number of units you expect to sell, and the price you expect to sell them for, and the spreadsheet will calculate the total revenue for each product for the year.
If you want to give your products names, simply type over the words 'Product 1', 'Product 2' etc. And these names will be carried through to the rest of the spreadsheet. Cost of Goods Sold Your margins are unlikely to be the same on all of your products, so the cost of goods sold allows you to enter your expected gross margin for each product into the white boxes in Column B. The spreadsheet will automatically calculate the annual cost of goods sold based on this information, along with your forecasted revenue. Annual Maintenance, Repair and Overhaul As the cost of annual maintenance, repair and overhaul is likely to increase each year, you will need to enter a percentage factor on your capital equipment in the white box in Column B. This will be used to calculate your operating expenses in the profit and loss sheet. Asset Depreciation Use the white box to enter the number of years you expect your assets to depreciate over.
This may vary greatly from business to business, as assets in some sectors depreciate much more quickly than they do in others. Tax In most parts of the world, you will have to pay income on your earnings. Enter the annual tax rate that applies to your circumstances in the white box in Column B. If you have to pay any other taxes, these can be entered later on the Profit and Loss sheet.
![Business Plan Financial Spreadsheet Business Plan Financial Spreadsheet](http://karamatsews.com/wp-content/uploads/2018/08/startup-business-plan-financials-template-business-plan-financial-projections-template-business-startup-financial-plan-template-projections-business-plan-financial-spreadsheet-template-startup-busines.jpg)
Inflation Although you cannot be certain of the level of inflation, you will still need to try and plan for it when coming up with a 5-year financial plan. The provide forecasts for a number of countries, so is a good place to look if you are unsure what to enter here. Simply enter your inflation rate in the white box. Product Price Increase As a consumer, you are no doubt aware that the price of products goes up over time. Enter a number in the white box to show the expected annual price increase of your products to enable the spreadsheet to calculate income in future years.
If you are unsure what to put here, increasing your product price in line with inflation is a good starting point. If your business is just starting out, you may be able to command higher prices for your products or services as the years go on, as you build up brand recognition and a good reputation.
Funding The funding section allows you to enter information about your business loan. To use this section, simply fill in the three white boxes representing the amount of the loan, the annual interest rate and the term of the loan in months - for example, 12 for 1 year, 24 for 2 years, 36 for 3 years, 48 for 4 years, or 60 for a 5 year loan.
Profit and loss This sheet calculates your profit and loss for each year over a 5 year period. The profit and loss assumptions, along with income, are automatically calculated using information entered in the model inputs sheet. Non-Operation Income You may have, or be expecting some income in addition to your operating income. These can be entered manually in the white cells in Column B for Year 1, Column C for Year 2 and so on. There are pre-entered categories for rental, lost income and loss (or gain) on the sale of assets, as well as an additional row where you can enter your own non-operation income. Operating Expenses Some parts of this are already filled in based on information you put on the Model Inputs, for example, depreciation, maintenance and interest on long-term debt. Years 2-5 are also filled in for you across all categories based on the inflation information entered in the Model Inputs sheet.
You therefore only need to enter your Sales and Marketing, Insurance, Payroll and Payroll Tax, Property Taxes, Utilities, Administration Fees and any Other Expenses into the white cells in Column B for Year 1. Non-recurring Expenses This section is for entering any expenses that you will not be paying on an annual basis. The Unexpected Expenses row allows you to enter a contingency for unexpected expenses, whilst the Other Expenses row allows you to enter any other one off expenses you may be expecting to make, for example the purchase of new equipment part way into your 5 year plan.
Taxes Income Tax is filled in based on the information you enter into the model inputs. Depending on where your business is based, you may find yourself having to pay other taxes.
These can be entered in the Other Tax row. You can rename this row by typing over the 'Other Tax (specify)' text. Balance Sheet The annual balances for Years 1-5 are, in most cases, filled in for you, based on the information you have entered on the Model Inputs sheet and in the Initial Balance column of the Balance Sheet column itself. This makes it very easy to use. Current Assets This is where you can enter the value of any of your current assets, with spaces to enter information about Cash and Short-term Investments, Accounts Receivable, Inventory, Prepaid Expenses and Deferred Income Tax.
At the bottom of this section is a space for you to enter any other current assets you may have that do not fall into any of these categories. Property and Equipment Depending on the nature of your business, you may have assets such as Buildings, Land, Capital Improvements and Machinery. Enter the value of these assets into Column B, and these values will be copied over to each of the 5 years of the plan.
The depreciation information entered into the Model Inputs sheet will be used to calculate the depreciation expenses, which allows a total for property and equipment to be calculated automatically. Other Assets This section is for entering information on any assets that don't fit in the other sections. These could be Goodwill Payments, Deferred Income Tax, Long-term Investments, Deposits, or any Other long-term assets.
Enter the information into Column B, and it will be carried across to the yearly columns automatically. Current Liabilities As well as assets, your business is likely to have liabilities. There are spaces to enter Accounts Payable, Accrued Expenses, Notes Payable and Short-term Debt, Capital Leases and Other current liabilities. Just leave blank any rows where you do not have any liabilities, and the totals will be calculated for you. Debt Your long-term debt/loan information will have already been entered in the Model Inputs sheet, so the only thing to do here is to enter any other long-term debt. Unlike much of the rest of the Balance Sheet, you can manually enter different amounts for each year, as you may, for example, be expecting to take on another loan to purchase some new equipment in Year 3 as your business expands. Other Liabilities Use this section to enter any liabilities not covered by the pre-defined labels.
You can amend the text in Column A, in order to specify the liabilities, and then enter the cost of these liabilities in Column B. Equity Your business is likely to have some equity, and this can be entered into this section. You can fill out the Owner's Equity, Paid-in Capital and Preferred Equity in Column B. Your retained earnings are automatically calculated based on the Profit and Loss sheet. Cash Flow Much of the information on the cash flow sheet is based on calculations in the Balance Sheet.
It is important to plan your cash flow carefully, so that you know what funds you will have available to buy new stock and equipment. Operating Activities Much of this section is automatically filled in based on your balance sheet. There are only three rows to fill out, which are Amortization, Other Liabilities and Other Operating Cash Flow. You only need to fill out the white boxes in Column B for Year 1, as these values will automatically be carried over into subsequent years for you. Investing Activities Your capital expenditures and sale of fixed assets will be automatically populated if you have filled out the relevant sections of the Balance Sheet.
They will be blank if they do not apply. As investing activities can vary year on year, you will need to fill out any investment activities for each of the 5 years in the appropriate columns for Acquisition of Business, and any Other Investing Cash Flow items. Financing Activities The long-term debt/financing row will be pre-filled based on the loan information previously entered. Use Column B to fill out your Preferred Stock, Total Cash Dividends Paid, Common Stock and Other Financing Cash Flow items for Year 1. This information will automatically carried over to Years 2-5. Loan Payment Calculator There is nothing to enter on this sheet, as it is for information only. Whether or not you already have a loan, or are using this spreadsheet as a part of a business plan to help you obtain one, it allows you to easily see how much you will be paying each month, showing how much you are paying off your loan, and how much you are paying in interest.
This will allow you to get an idea of whether or not you can afford to borrow a bit extra, if you feel it would allow you to push your business into higher places, or whether you need to shop around for a better interest rate or adjust the loan term in order to afford the loan payments. Related Content.
After the success of last year’s Dive Deeper festival, we have planned another immersive weekend for those who truly wish for a more profound understanding and experience of the Tantric teachings. We believe that Tantra should be available to all, because it represents a way to truly master the art of living, allowing us to fulfil our entire potential on all levels of existence.
The tantrics say that the way a person is in the bedroom, shows us how they are in life (and vice versa!). Considering this, we take the opportunity to deepen our intimate experiences in order to deepen our experience of life itself In this festival, inspired by the famous yet misunderstood often text the Kama Sutra we will glimpse into the world of sublime Eros, discovering the sacred dimension of intimacy.
Moving away from the idea of ‘having’ sex, towards making love as an art, rediscovering its purity and the true nature of sensuality. The ‘Dive Deeper’ festival itself is smaller and more exclusive, where the game of polarity is experienced directly, and where beauty, love and intensity merge together in a full experience of the reality beyond.
‘Dive Deeper Kama Sutra & Sacred Eros’ will be held on the 24-26th May 2019, in Tara Yoga Centre, London, just a few minutes walk from Old Street station. Beginning on Friday evening with the opening ceremony and the first in depth sessions, the festival continues on Saturday from 10am till late (with special evening activities), and Sunday from 10am till the evening’s closing ceremony and show at 9pm. The festival will run in 3 halls simultaneously, with workshops and talks facilitated by some of your favourite teachers from previous festivals who will guide us into the depths of our existence, towards the core of tantra and of life itself. ‘Kama’ is defined as: the enjoyment of appropriate objects by the five senses of hearing, feeling, seeing, tasting and smelling, assisted by the mind together with the soul. The ingredient in this is a peculiar contact between the organ of sense and its object. The consciousness of pleasure which arises from that contact is called Kama. The text of the Kama Sutra, as well as Tantra as a path in itself, are nowadays much more famous than truly known, yet their importance to humanity, however, is priceless.
The way they offer us a coherent and constructive sexual education has the potential to revolutionise our experience of erotic intimacy. In this FREE lecture we will first explore and review their historical background and extract some practical notions hidden within the mysterious text of the Kama Sutra. @ Tara Yoga Centre 25-31 Ironmonger Row, Old Street, EC1V 3QW FREE, but you have to reserve your place! Business plan financial spreadsheet template We can only accept payments in GBP.
You must be 18 years or over to attend this event. Tantra Festival staff reserve the right to refuse entry if proof of age cannot be established. Returns Policy Tickets for festivals and other events bought through this website are fully refundable for 14 days following payment (up to 1 week before the event).
Refunds cannot be issued 7 days before the event. After this period tickets are non-refundable. The named person on a ticket is transferable at any time up to the day of the event. For more information please. Delivery & Shipping Policy Your transaction will be confirmed to you via email. This email will act as you ticket for entry on the day of the event. Please ensure you bring this with you.
Entry to any event will not be permitted without a valid email.