Business plan financial projections calculator free

We do the work - saving you Time and Money while getting your plan done right Our team has the Experience you need to take the next step Honest and Ethical team to point your company in the right direction Get Funded by working with a leading business plan consulting firm We only create top Quality business plans customized to your business We have Proven Results with Stellar Customer Feedback We have a strict Confidentiality Agreement to give you peace of mind Business Plan, Financial Projections, and Market Research As a leading financial analysis and business plan development company, Butler Consultants prides itself on providing customers with customized documents that are thorough, well-researched, and expertly written.

Business plan financial projections calculator free

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 business plan financial projections calculator free 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. 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.

business plan financial projections calculator free

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.

PROJECTION SOFTWARE

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. 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 International Monetary Fund 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.

Financial Projections: Analysis: Business Plans: Butler Consultants

Non-Operation Income You may have, or be expecting some income in addition to your operating income. 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 are also filled in for you across all categories based on the inflation information entered in the Model Inputs sheet. 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 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. 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.

business plan financial projections calculator free

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.

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.

Just leave blank any rows where you do not have any liabilities, and the totals will be calculated for you. 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.section 3 - financial projections INFORMATION In the previous section, you covered the vision of your business - the products you will sell, your customers, how you stack up against your competition, the equipment you need, your marketing plan, and so on.

This 3 year financial projection calculator is a free online tool. The calculator produces income statements, balance sheets, and cash flow statements for the next 3 years, and provides a quick and easy way to test the outline feasibility of your business idea.

Free Business Plan Template - Financial Projection - alphabetnyc.com - Custom Built Financial Statements for Business Plans. Free Business Budget Templates for Any Company Sticky Bar Title.

Projections & Cash Models, Financial Analysis, Free Business Tools & Calculators for Consultants, CFOs, & Business Owners.

My Simple Financial Projection Calculator At the beginning of each new year, along with my annual goals and business plan, I review my firm’s financials. I look at where we’ve been over the past 12 months and I prepare a projection to plan for the year ahead. Download a free 5-Year Financial Plan template, which helps when planning a launch of a new products with involvement of a long-term financing. 5-Year Financial Plan includes, Profit and Loss, Balance Sheet, Cash Flow and Loan Amortization. A business plan is all conceptual until you start filling in the numbers and terms. The sections about your marketing plan and strategy are interesting to read, but they don't mean a thing if you.

FREE BUSINESS TOOLS & CALCULATORS ONLINE No registration is required! We have tax planning tools, loan refinance analysis, reference tables, & much more.

5-Year Financial Plan | Free Template for Excel

Our free business plan narrative is perfect for a typical bank. Free Business Calculators. This page contains links to business calculators and accounting templates for use with the main Financial Projections Template..

These free resources are available for you to download and use for your own personal development or business, and to teach or train others.

Butler Consultants Financial Tools, Research and Partner Websites