Business plan financial template for excel

How to set up as a freelance translator? Getting Started as a Freelance Electrician. Getting Started as a Freelance Photographer. How to Start an Electronics Repair Business. How to Start a Publishing Company. How to Start a Car Dealership. How can I create a sole proprietorship in France? How To Start a Beekeeping Business. Free Excel Financial Plan Template for small business and startup. Starting a Business in Cameroon.

How to create a business forecast. Need help putting together the rest of your business plan? Check out our free simple business plan templates to get started. You can learn how to write a successful simple business plan here. Visit this free non-profit business plan template roundup or download a fill-in-the-blank business plan template to make things easy. If you are looking for a business plan template by file type, visit our pages dedicated specifically to Microsoft Excel , Microsoft Word , and Adobe PDF business plan templates.

Read our articles offering startup business plan templates or free day business plan templates to find more tailored options. Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change.

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed.

Try Smartsheet for free, today. Get a Free Smartsheet Demo. In This Article. Financial Plan Templates Download and prepare these financial plan templates to include in your business plan.

Business Financial Plan Template. See how Smartsheet can help you be more effective. Financial Plan Projections Template for Startups. Income Statement Templates for Business Plan Also called profit and loss statements , these income statement templates will empower you to make critical business decisions by providing insight into your company, as well as illustrating the projected profitability associated with business activities.

Small Business Profit and Loss Statement. Cash Flow Statement Templates for Business Plan Use these free cash flow statement templates to convey how efficiently your company manages the inflow and outflow of money. Simple Cash Flow Template. Balance Sheet Templates for a Business Plan Use these free balance sheet templates to convey the financial position of your business during a specific time period to potential investors and stakeholders. Monthly and Quarterly Balance Sheet Template.

Yearly Balance Sheet Template. Sales Forecast Templates for Business Plan Sales projections are a fundamental part of a business plan, and should support all other components of your plan, including your market analysis, product offerings, and marketing plan. Basic Sales Forecast Sample Template. Break-Even Analysis Template for Business Plan A break-even analysis will help you ascertain the point at which a business, product, or service will become profitable.

Break-Even Analysis Template. Simple yet highly effective, it allows business owners to figure out which loans are the right fit. Failing to secure the right loan is one of the most common causes of small business failure. It is ideal for showing to employees and business partners. The sheet compares future goals with current spending habits, creating a map for future growth.

It allows owners to view their debts and create strategies for paying off each one in given time intervals. It tallies the expenses against the potential benefits of creating the site. No site should be created without a budget template to keep track. Getting an SEO campaign right requires a lot of focus and automation with the use of useful Excel templates. Without some kind of assistance, it is easily to focus on all the wrong things.

The data is pulled from multiple sources and is then compiled into aesthetically pleasing charts and graphs. It will make it easy to observe whether you have too many bulk links from low authority sites. Healthy sites should have a nice bell curve with a good mix of sites. Google will distrust sites with only high DA and only low DA links, as it will look unnatural. This is an incredibly useful sheet for webmasters.

It is perfect for small businesses who are launching internet campaigns. It collects a huge variety of metrics and places all of them into awesome charts and graphs. Business owners need to regularly conduct these audits, at a minimum of once every 1 — 3 months.

A social media strategy that is not regularly audited will not succeed over the long-term. The sheet can be used to track progress on nearly any conceivable metric and the data is presented in graph form.

The template makes it easy to determine the profitability of manufacturing and marketing a new item. A business will not grow if costs get out of hand. This template consolidates a number of key metrics and is a comprehensive tool, without the need for any additional sheets. KPIs can be viewed in both table and graph forms. An overview of revenue, revenue breakdown, and time to market are shown. This template is ideal for showing to stakeholders and to see which products have been the most profitable in the given time period.

It provides KPIs for a number of tasks including the resources allocated along with the total days per project and current financials. This is very useful for business owners who are simultaneously working on a number of projects and need the information displayed in an easy to read manner.

This is a highly detailed sheet that can help you to really pin down business goals over the next 12 months. It outlines a wide variety of key metrics across each month and further breaks down each month into weekly sections. The template identifies the business goals, target audience, tactics, budget, and marketing strategies. Failing to create a meaningful social media strategy with tracking and monitoring is why most businesses do not benefit from social media platforms.

SWOT is a primary technique used by business owners and a common project management strategy, as it allows to objectively look at a business project in its entirety. This template allows the investigation of both internal and external factors.

The template is useful because it tracks the employee across key metrics without being overly detailed. If you do not want to include any dividends in your cash flow projections, you can simply specify a dividend percentage of zero percent.

If you want to include dividend calculations, you need to specify a dividend percentage which will be applied to the profit for the period in order to calculate the dividend value. You also need to specify the frequency in months of dividend payments and the first payment month.

The frequency of dividends determines when the dividends are included on the income statement and the first month of payment determines when the dividend payment is included on the cash flow statement only has an effect if the dividend payment option is Subsequent.

You can also specify whether the dividend is paid in the month of calculation Cash option , the month after calculation Next option or in a subsequent month. When you elect the subsequent month option, the payment of the dividend will be included based on the relative position of the first month of payment in relation to the year-end period which is determined based on the template start date at the top of the Assumptions sheet.

Example: If you want to include a dividend in the last month of each financial year, select a payment frequency of 12 months and month 12 as the first payment month. Then select the Cash option in order to include both the dividend on the income statement and the payment in the last month of the year. Example: If you want to include a dividend in the last month of each financial year but delay payment to the first month of the next financial year, select a payment frequency of 12 months and month 12 as the first payment month.

Then select the Next option in order to include the dividend on the income statement in the last month of the financial year and the payment in the first month of the next financial year.

A dividend payable amount will then automatically be included on the balance sheet at year-end. If you need to compile cash flow projections for an existing business, you will need to include the opening balance sheet balances at the start of the cash flow projection period. The opening balances that are entered here are included in the first column on the balance sheet. You can use the trial balance as at the end of the period immediately before the start of the cash flow projection period for this purpose.

The opening balances should also balance to a total of nil as with any accounting system trial balance. If you enter balances and the total of all balances is not nil, the entire opening balances section on the Assumptions sheet will be highlighted in orange. You then need to fix the imbalance by adjusting the opening balances so that the total comes to a total of nil. The orange highlighting will then be removed automatically.

Also note that the cash flow projection balance sheet cannot balance if the opening balances do not balance. Note: If you are preparing a cash flow projection for a new business, you can include zero balances for all the balance sheet items in the opening balances section.

Intangible assets balances are calculated in much the same way by adding the purchases of intangible assets as per the cash flow statement for the first 12 months and the Assumptions sheet for year 2 to 5 and deducting the appropriate amortization charges as per the income statement. The calculation of the investments balances on the balance sheet is a bit simpler in that only the purchases of new investments as per the cash flow statement for the first 12 months and the Assumptions sheet for your 2 to 5 are added to the previous period's balance and there is no depreciation or amortization on investments.

The purchases for the first 12 months need to be entered on the cash flow statement and the purchases for year 2 to 5 need to be entered on the Assumptions sheet. The inventory balances on the balance sheet are calculated based on the inventory days assumption which is specified on the Assumptions sheet. The number of days that are entered here is applied to the monthly cost of sales in order to calculate the appropriate inventory balance.

This calculation is based on the actual number of days in each month if the inventory days assumption is greater than the number of days in the appropriate month. Example: If you enter an inventory days assumption of 60 days and the month is April, the entire cost of sales value for April will be included in the inventory balance because April only has 30 days.

After including the 30 days in April, there is a difference of 30 days between the 60 days assumption and the 30 days in April. The March cost of sales balance will therefore be used, divided by the 31 days in March and multiplied by the 30 remaining days. The inventory balance at the end of April will therefore consist of the cost of sales total for April and an equivalent of 30 days of the 31 day cost of sales of March. Note: The above calculation principle is applied regardless of the number of days which are entered as the inventory days assumption on the Assumptions sheet even if the value of the inventory days assumption requires the inclusion of more than 2 months.

This method of calculation is the most accurate way of projecting inventory balances even for businesses where there is significant sales volatility. Note: If your business does not carry inventory, you can simply enter a nil value in the inventory days assumption on the Assumptions sheet. The inventory line on the balance sheet will then also contain nil values. If you want to include variable monthly inventory days, you can do so by changing the inventory days assumption in the Workings section of the balance sheet which has been included below the section with the ratios.

Simply replace the formula which links the inventory days assumption to the value on the Assumptions sheet by overwriting it with the appropriate inventory days value.

The year 2 to 5 inventory balances are calculated by applying the annual turnover growth percentage to the inventory balance at the end of year 1. This method ensures that the monthly trend in year 1 is reflected in the year 2 to 5 balances.

If you amend the inventory days in the Workings section of the balance sheet, the amended days for the appropriate year will be used in the calculation. The trade receivables balances on the balance sheet are calculated based on the debtors days assumption which is specified on the Assumptions sheet.

The debtors days number can be determined based on the average trading terms which has been negotiated with customers. The debtors days is applied to the monthly turnover in order to calculate the appropriate trade receivables balance.

This calculation is based on the actual number of days in each month if the debtors days assumption is greater than the number of days in the appropriate month. Example: If you enter a debtors days assumption of 60 days and the month is April, the entire turnover value for April will be included in the trade receivables balance because April only has 30 days.

The March turnover balance will therefore be used, divided by the 31 days in March and multiplied by the 30 remaining days. The trade receivables balance at the end of April will therefore consist of the turnover total for April and an equivalent of 30 days of the 31 day turnover of March. Note: The above calculation principle is applied regardless of the number of days which are entered in the debtors days assumption on the Assumptions sheet even if the value of the debtors days assumption requires the inclusion of more than 2 months.

This method of calculation is the most accurate way of projecting trade receivable balances even for businesses where there is significant sales volatility.

Where sales tax is applicable, the appropriate sales tax value relating to monthly turnover will be added to the trade receivables balance. Sales tax codes are defined on the Assumptions sheet and the codes in column A next to the turnover amounts on the income statement are used to determine the appropriate rate of sales tax to be used. The trade receivables calculation will also only include lines that are coded with a sales tax rate code in the first two characters and a "C1" at the end of the code.

The C1 part of the code refers to credit sales while the inclusion of a C0 code at the end refers to cash sales. Cash sales do not need to be included in the trade receivables calculation and turnover lines with C0 or no code in column A are therefore ignored when calculating trade receivable balances. Example: If the standard rate sales tax code is V1 and the appropriate turnover line needs to be included in the calculation of trade receivables, the code V1C1 needs to be added in column A of the appropriate turnover line on the income statement.

Example: If you do not want a particular turnover line to be included in the trade receivables calculation, you can include any sales tax rate followed by C0 in order to exclude the line in the trade receivables calculations.

For example, a turnover line with a code of V1C0 would not form part of the trade receivables calculations. Note: If your business has no trade receivables, you can simply enter a nil value in the debtors days assumption on the Assumptions sheet. The trade receivables line on the balance sheet will then also contain nil values.

If you want to include variable monthly debtors days, you can do so by changing the debtors days assumption in the Workings section of the balance sheet which has been included below the section with the ratios. Simply replace the formula which links the debtors days assumption to the value on the Assumptions sheet by overwriting it with the appropriate debtors days value. The year 2 to 5 trade receivables balances are calculated by applying the annual turnover growth percentage to the trade receivables balance at the end of year 1.

If you amend the debtors days in the Workings section of the balance sheet, the amended days for the appropriate year will be used in the calculation. If you therefore want to increase or decrease these balances, you need to add the amount of the increase or decrease to the line with a matching description on the cash flow statement under the changes in operating assets section for the first 12 months or the Assumptions sheet for year 2 to 5.

If you therefore want to increase or decrease these balances, you need to add the amount of the increase or decrease to the line with a matching description on the cash flow statement or Assumptions sheet. Note: The shareholders contribution line on the cash flow statement can be found under the cash flow from financing activities and the reserves line on the cash flow statement under the non-cash adjustments. The retained earnings balances on the balance sheet are linked to the retained earnings for the year which is calculated on the income statement.

Loans with the same repayment terms can be grouped together in the appropriate line item. There is no difference between the treatment of loans 1 to 3 and leases. If you do not have finance leases and have loans with 4 different sets of repayment terms, you can use the Leases sheet and rename the appropriate line items accordingly. Note: The loan repayment period in years is limited to a maximum period of 30 years.

If you want to include a loan repayment period which exceeds this period, you need to change the data validation settings in the appropriate input cell by selecting the data validation feature from the Data tab on the Excel ribbon and editing the maximum value of 30 which has been set in the loan repayment period cells.

Each of the loan repayment terms can be specified in the Loan Terms section on the Assumptions sheet. The loan terms include the annual interest rate, loan repayment period in years and a selection field which can be used to indicate interest-only loans.

These loan repayment terms are then included at the top of the appropriate loan amortization sheet on the Loans1 to Loans3 and Leases sheets.

Note: A set of loan terms can be specified as interest-only by selecting the "Yes" option from the interest-only drop-down list in the appropriate loan terms on the Assumptions sheet. If this selection is made, the loan will be interest only and not include any loan repayments. All the calculations on the amortization sheets are fully automated. The only user input that is required on these sheets is entering the additional loan amounts in column C. The loan terms are taken from the Assumptions sheet and the opening balances in the first row of the amortization table are based on the opening balances that are entered in the balance sheet opening balances section of the Assumptions sheet.

The loan repayments, interest charged and capital repayments are calculated based on the outstanding balances at the beginning of each period.