Financial Plan for a Startup (Example Restaurant)

With this file you can learn how to create a financial plan for a Startup. The example refer to a Restaurant, that is an activity that everybody understand. You can easily adapt to any other business type.

Country: Universal | File type: Double-Entry Accounting | Category: Business

Luke's Restaurant

Accounts
Group Account Description Gr
    BALANCE SHEET  
    ASSETS  
  CASH Cash on hand 1
  BANK Bank account 1
  CUSTOMERS Customers account 1
  FURNITURE Furniture 1
  INVENTORY Inventory 1
1   TOTAL ASSETS 00
       
    LIABILITIES AND EQUITY  
  SUPPLIERS Suppliers 2
  LOAN Loan 2
  EQUITY Owner equity 2
PL   Profit(-) or loss (+) from current year 2
2   TOTAL LIABILITIES AND EQUITY 00
       
    PROFIT AND LOSS STATEMENT  
    INCOME  
  SALES Income from sales 4
  INTINC Interest income 4
4   TOTAL INCOME 02
       
    EXPENSES  
  PERSON Personnel expenses 3
  GOODS Cost of goods 3
  RENTAL Rental and related expenses 3
  ADMIN Administrative costs 3
  INTEXP Interest expense 3
  DEPREC Depreciation 3
3   TOTAL EXPENSES 02
       
02   Profit(-) Loss(+) from Profit and Loss Statement PL
       
00   Difference should be zero (void)  
       

Create a financial planning and liquidity projections

Whether you're planning to start a new business, or setting up a business plan, it is of the utmost importance to manage your liquidity projections. Especially at the beginning of a new activity, this could easily happen to land yourself in financial difficulties.

Banana Accounting software offers you the possibility to set up your financial planning and liquidity projections, allowing monitoring on a daily basis, with a high degree of accuracy.

Banana Accounting software allows you to project your accounting into the future and manage the years ahead of you in your ledger. By entering your income and expenses transactions, you will be able to generate all the necessary provisional reports such as Balance Sheet, Profit & Loss Accounts, Transactions Reporting, according to your projections.

Below you have an example of a monthly planning that Banana Accounting 8 software can make easy for you.

Financial planning and liquidity management of Luke's Restaurant

The below example will explain how to create a financial planning, taking the opening of a restaurant as a showcase for the way Banana Accounting  software and it's functionalities operate.

Luke plans to open a restaurant in 2017 and is preparing a financial plan, including all the necessary details.

  • The financing of his project includes his proper means and a loan from a third person.
  • In January 2017, he rents the premises, redecorates and furnishes them and starts his commercial activity.
  • The Financial Planning is established for the period from January 2017 to December 2020.

Economical forecasting and liquidity management

This model will help you to learn about the different features of Financial planning in Banana Accounting 8 software. Some features, such as formulas, will be used in more advanced cases.

  • Use of budgeted transactions
  • Repetitive transactions
  • Using Quantities and Price
  • Using Formulas
    • Using Variables
    • Calculation of interest on Asset and Liability Accounts
    • Carrying forward of account balances
    • Carrying forward of transactions recording
  • Budgeting for one financial year divided by quarter, including results and liquidity projection
  • Budgeting for several financial years, including results and liquidity projection

 

The File Properties

Opening date is 1st of January 2017 and closing date December 31st 2017.

This is also the period of calculation that will be used for the Total column in your Budget .

 

The Chart of Accounts

This example is intended to explain the functioning of your Budget table of forecasts.

  • The Chart of Accounts, reduced to it's essence.
  • Comprehensive name for accounts are used to illustrate the use of Banana Accounting 8 software.
  • Opening Basic Currency. The activity starts from scratch, so there are no opening balances.
  • Budget Basic Currency. It's the overall budget at the end of the accounting period. Notice that this represents the balance sheet and income statement at the end of the budgeting period.

Create your own Chart of Accounts

The Chart of Accounts defines the elements of Expenses, Income and Investments. In case you want to subdivide the expenses more in detail, you need to add other accounts.
Rather than starting with a very simple Chart of Accounts and add on accounts and groups, it is recommended to start with a more structured Chart of Accounts. Banana Accounting 8 software offers different Charts of Accounts templates, and it is recommended to choose and adapt the one closest to your needs and then add the Budget tab .

The Budget table

The budget table (see also explanation on columns) is where you insert recordings relative to the planning.

The financial plan is inserted via normal entering in double-entry bookkeeping in the Budget table. The budget table provides additional columns that greatly facilitate the preparation of the financial plan.

  • Repeat
    If you specify "M" = Monthly, for example, this will generate monthly registration for all subsequent months.
    If the cell is left empty, the operation will be performed only once.
  • End (Date)
    Used in combination with Repeat, setting the last date when the operation will occur. 
  • Total
    The total amount recorded in the current year.
  • Quantity, Price
    Allows for indication of the combination of values ​​on the basis of which the amount will be calculated.
  • Formula
    Allows you to specify a formula for calculating the amount.
    The formula has priority for the calculation of the amount.

Transactions for January

Those are identical to entering in the transactions table, because there is no Repeat yet.

This is the first month of the Coffeehouse's explotation and these are the registrations of the owner's equity, payment of the furniture and the accession to a loan.

The entering shown in the below screenshot, such as first month's rent, were included as not repetitive recordings, to illustrate some simple recordings that contain no Repeat.

Repetitive transactions for February

In  February, enter the transactions that will occur on a monthly basis

  • The rent from January to June is of 1'000 per month and increases to 1'200 as per July.
    • Doc 5:
      The first rent was paid cash. There will probably also be the payment of a guarantee.
    • Doc. 50: 
      The rent of 1'000 is budgeted rom February to June.
      • On 2nd Februar the rent is paid from the bank account. 
        In the following months the payment of the rent will figure on to 2nd of each month.
      • End Date is 30th June.
        The last rent of 1'000 will be on 2nd June.
      • Repeat. M = monthly.
      • Total 5'000 (5 x 1'000, automatically calculated) is the total amount for the transactions during this period. 
    • Doc 51:
      Rent Budgeted from July onwards.
      • Date 2nd July.
        In the following months the payment of the rent of 1'200 will figure on to 2nd of each month.
      • End
        As no date is indicated, this expense will be repeated for all the following months and years.
      • Repeat. M = monthly.
      • Total 7'200 (5 x 1,200), automatically calculated.
        Represents six months' rent from July to December.
  • Doc. 52.
    The leasing for the cash register.
    • Date is 10th of February.
    • End (of lease) January 31st 2019. When the last instalment on the lease is due. 
    • Repeat M = monthly.
      The operation will be repeated each month, the last time in January 2019.
    • Debit A/C Administrative fees.
    • Credit A/C BANK (used for payment).
    • Amount 200.00 monthly lease rate.
    • Total 2,200 (200 x 11 months).
  • Doc. 53.
    Payment towards the lease redemption.
    This operation only takes place in 2019, but is included here, because it is linked to the monthly lease.
    • Date is 10th February 2019.
    • Debit A/C Administrative fees.
    • Credit A/C BANK (used for payment).
    • Amount 400.00 the release amount.
    • Total empty because there is no expenditure in the current year.
  • Doc. 54: 
    Monthly salaries.
    • Date: 25th February.
    • Repeat. M = monthly.
      The operation will be repeated on the 25th of each month to come..
    • Total 55,000 (5'000 x 11 months).
  • Doc. 55.
    Administrative expenses (this is an approximation: for a correct budgeting entering for each separate expense will be necessary).
    • Date is 28th February.
    • Repeat is ME = Month End.
      The operation will be repeated every month on the last day of the month.
      In March it will be on 31st, in April 30th and so on.
    • Amount 300.00.
    • Total 3,300 (300 x 11 months).

Budgeting for income and purchase of goods

Depending on the type of business activity, the most appropriate way to specify the revenues must be chosen.

Income and goods purchases are itemized below as monthly amounts, taking into account that there might be important monthly fluctuations.
It might prove more appropriate to use seperate turnover figures for drinks or/and food.

February's Repeat column is empty, as we expect a higher figure for he next year and this will be added at a later stage.
From March onwards the turnover is considered to be representative for the years to come.

Indications of forecasted income and merchandise costs, calculated on a monthly basis.

  • Doc 101
    Income indications for February
    • Date: 20th February. 
      Income occurs on every day of a month. We choose a date towards mid-month as an approximated level for liquidity.
    • Repeat Empty (no repetition).
      A higher figure is expected next year and will be recorded in the successive year..
    • Debit A/C Cash register receipts that are deposited in BANK.
    • Credit A/C Provenance of receipts in SALES account.
    • Amount 10'000.00.
    • Total 10'000.00 The next operation falls within next year, hence the total represents one single amount.
    •  
  • Doc 102
    Indications of forecasted costs for goods, on 20%a pro rata monthly basis.
    • Date 21st February. The day after the entering of the sales transaction.
    • Repeat no repetition.
      The operation will be repeated on the 21st of each following month. Therefore, each month cost for goods will be calculated as a percentage of purchases of sales account transactions.
    • Debit A/C GOODS costs to be recorded in goods Account.
    • Credit A/C BANK payment of goods costs through the bank.
  • Doc 103
    Two lines, which are similar to Doc 101 and 102, but for March.
    • Repeat Y=Yearly. Turnover and costs for the month of March for subsequent years.
  • Doc 104 through to Doc 112: Each 20th of the month projected sales for the different months of the year are indicated.

Following Years' Proceeds

Transactions can also be indicated for the following years..
These data will be used to establish budgets for the years to come.
The Total column will remain empty, as these values are ​​out of scope and only refer to the current accounting period.

  • Doc 151
    Transaction entering similar to the previous year
    • Date 20th January.
    • Repeat Y = Yearly.
      This will be repeated in the subsequent years.
    • Total empty (calculated automatically).The Total column will remain empty, as these values are ​​out of scope and only refer to the current accounting period.

End of quarter

Indications of some typical entries that are repeated at the end of a quarter.

  • Doc 70
    Here's an example for the use of the quantity and price column.
    Known bank charges are 50 per month and we indicate the amount for a 3 months.period.
    • Date 31st March.
    • Repeat 3ME=3 Months End.
    • Debit A/C ADMIN. Administrative costs, this would normally be financial bank charges.
    • Credit A/C BANK. Administrative costs.
    • Amount 150 (Automatically calculated) by multiplying the quantity by the unit price.
    • Total 600 (Automatically calculated) 150 quarterly until the end of the year.
  • Doc 71
    Interest on the loan that must be paid quarterly.
    • Date 31st March.
    • Repeat 3ME=3 Months End.
    • Debit A/C INTEXP interest expense on liabilities.
    • Credit A/C LOAN interests are added to the loan.
    • Amount interest for current quarter.
    • Total interest for the current year.
  • Doc 72
    Interest accrued on the LOAN are payed from the Bank count.
    • Date 31st March 31.
    • Repeat 3ME=3 Months End.
    • Debit A/C LOAN interest expense account.
    • Credit A/C BANK the account used to pay interest.
    • Amount the result of the formula, i.e the interest for this quarter.
    • Total total interests for the current year.
  • Doc 73
    Interest earned on current account with the Bank.
    • Date 31st March 31.
    • Repeat 3ME=3 Months End.
    • Debit AC BANK Bank account.
    • Credit A/C INTINC interest income.
    • Amount interest income for this quarter.
    • Total total interest for the current year.

Year End

These are some year-end operations. Here we use Repeat "Y" in order for them to be carried out for subsequent years.

  • Doc 200
    Attribution to staff of a 1% commission on annual sales at the end of the year.
    • Date 31st December.
    • Repeat Y= calculation is repeated each year.
    • Debit A/C PERSON Personnel expenses.
    • Credit A/C BANK Bank account.
    • Amount is the commission payed to the sales staff.
    • Total identical to Amount.
  • Doc 201
    Reimbursement of 10% of he outstanding loan
    • Date 31st December.
    • Repeat Y calculation will be repeated each year.
    • Debit A/C LOAN Loan account (your liability).
    • Credit A/C BANK Bank account used for reimbursement.
    • Amount 6'000 is the equivalent of 10% of your total Loan.
    • Total identical to Amount.
  • Doc 202
    Use for the amortization of your furniture.
  • Doc 203
    Use for adjustment of your inventory.
    This is non-repetitive, because the assessment should be based on the asset values of your inventory.

Compositions

Use the create new compositons command to generate new compositions for the printout including print parameters already preset in Budget and enhanced for groups.

You can preset the prints configuration according to your requirements.
If you understand how compositions functions, you will be able to use it with other commands and create prints or other adapted to your own purpose.

Reports in the Accounts table

In the Accounts tab, view Budget to access the updated budget amounts.

Financial and liquidity planning for the first year

With Command

  • Account1-> Quarterly forecast 1. evolution during the first year can be seen.

The composition that has been set up can be visualized

  • Breakdown by Period -> Quarter

These two prints will allow you to apprehend:

  • The economic forecast (expenses and income) and budgeting of current financial year..

  • The detailed evolution of liquidity in your bank's current account.

Modifying or Creating a new composition will give you a breakdown by month.

By month

Financial and liquidity planning for a four year period

With Command

  • Account1-> Budget 4 years

This will display the predefined composition for:

  • Period from 01/01/2017 to 31/12/2020
    In this report, you can specify a period that differs from the accounting period. The program will then project the data for the specified period.
  • Subdivision per year.

Account card

After opening the Budget table, click on the BANK cell and all budgeted transactions contained in the account card will be displayed.

 

 

 

Share this article: Twitter | Facebook | Email