finance tables guide. - amazon s3 · remaining tables for you. (note: input data into the white...

Finance tables Guide.

It is a step by step guide to completing the

finance tables. The final figures will later be

used in section 5 (Financial Plan) of your

business plan and sub-section 1.9 of the

Executive Summary

This is best used when you are working on

your tables.

1Developed from concepts and copyright resources of

Webtraining Australia Pty Ltd - July 2015

Purpose of the Finance TablesN.B. Your figures are best guess estimates over 2 years. Our

focus is for you to:

- determine your personal living costs –drawings

- consider business establishment costs

- determine business income/sales by product sales and

timelines (seasonality)

- determine business running costs - expenses

- estimate future Year 1 and 2 taxation obligations

- check monthly cash flow position for negative cashflow

periods

- determine business viability and risk rating

(Don’t forget to save your finance tables in this format

(SMITH John – Finance tables) and email as an attachment or

upload them to your coach.)

2Developed from concepts and copyright resources of Webtraining

Australia Pty Ltd - July 2015

What do you have to do?

3

The finance tables have 13 sheets, 7 of

which you have to complete and they are

coloured green. The remaining ones are

either self generating or for your mentor’s

use later on.

Developed from concepts and copyright resources of Webtraining


Home page

4

Has hints and

suggestions on how

to complete these

tables.

Has a spreadsheet

navigation to each

tab.

Don’t overlook that

you have already

completed a fair bit

of these tables

during feasibility.



1. Set UpThis page is your set up

template for year 1 and 2

for;

• Business Name and

proprietors

• NEIS payment

• Trading Period

• Products/Services

• Product Selling Price

• Cost of Goods Sold

• GST (YES/NO)

• Collection of Debtors



2. Drawings

Here you need to work through your personal/family budget.

If you have completed feasibility, you don’t need to complete this page

other than transfer the figures from you feasibility in one total to line 52.

Don’t forget to allow for other income outside NEIS and also a partner’s

income if the expenses include their expenses as well.



2 (con’t). Drawings - Year

Years 1. figures will carry through to year 2.

There is provision for you to adjust year 2. figures if you need to.



3. Personal

This sheet is a snap shot of

your Personal worth but

identifies what assets you

will be transferring over to

the business.

This is an important page if

you have to seek bank

finance.

These figures do not transfer

to any other part of the

Finance tables.



4. Establishment Costs

What assets do you already own

to use in the business. These

items will be transferred to your

Balance Sheet for depreciation

evaluation

What assets do you need to

purchase in order to start the

business from day one?

Expense items are only those

items you need to purchase in

your first month of trading and

ones you have already purchased

Do you need to borrow any

money in order to start the

business? If so please provide

how this will be achieved.

9Developed from concepts and copyright resources of Webtraining Australia

Pty Ltd - July 2015

5. Income - SalesAll you need to do for this sheet is to estimate the number of;

• Hours you will charge out per month or

• The number of units of product you will sell per month.

(Not the dollar values!)

The software will calculate the dollar value throughout the

remaining tables for you.(NOTE: Input data into the white cells only and allow for seasonality, a

holiday and building your business up from scratch. Year two should look

different as your first year would be slow whilst getting established and

you may have introduced different products/services or changed your

pricing structure.)



These figures transfer to the cashflow (Tab 6)

6. Cash flowMoney In

(Cash Inflows)

These figures come

from tab 5 –

Income - sales

Money Out

(Expenses)

You need to

estimate these

expenses

Closing Bank

Balance



7. Tax Calculator

Add any

private

taxable

income

Input the figures from the

tax calculator in manually

for year 1 and 2. The

system will then include

the figures into your cash

flow forecast.

NOTE

This sheet is done

last as any changes

to your figures will

effect the taxation

required to be paid

12Developed from concepts and copyright resources of Webtraining Australia

Pty Ltd - July 2015

8. Income Statement

Income (ex G.S.T)

Business Expenses (ex G.S.T.)

Net Profit/Loss (ex G.S.T.)

Dispersments



9. Balance Sheet

We have made this

easy for you – this

sheet self generates.

You have a business

start-up balance

sheet and an end of

year one balance

sheet.



10. Financial Plan Summary

Please make sure you

use these figures in

section 5 (Finance

Plan) of your written

business plan as well

as the Executive

Summary section 1.9



Mentoring Sheets

16

The last 3 sheets of the finance tables are for use

by your coach during the 12 month mentoring

period.

They will show you how to use them after you

have commenced onto NEIS.

Final note!

You will generally do 2/3 versions of the Finance

tables, until your coach signs off on them.



finance tables guide. - amazon s3 · remaining tables for you. (note: input data into the white...

Documents