Finance tables Guide. - Amazon S3

[Pages:16]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.

Developed from concepts and copyright resources of

1

Webtraining Australia Pty Ltd - July 2015

Purpose of the Finance Tables

N.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.)

Developed from concepts and copyright resources of Webtraining Australia Pty Ltd - July 2015

2

What do you have to do?

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 Australia Pty Ltd - July 2015

3

Home page

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.

Developed from concepts and copyright resources of Webtraining Australia Pty Ltd - July 2015

4

This 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

1. Set Up

Developed from concepts and copyright resources of Webtraining Australia Pty Ltd - July 2015

5

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.

Developed from concepts and copyright resources of Webtraining Australia Pty Ltd - July 2015

6

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.

Developed from concepts and copyright resources of Webtraining Australia Pty Ltd - July 2015

7

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.

Developed from concepts and copyright resources of Webtraining Australia Pty Ltd - July 2015

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download