Cash Flow Projections - Pure Service Business


Step 1: Enter Business information





Step 2: Enter the Services you provide along with their prices


NAME OF SERVICES

SERVICE Price





Service price increase in this year


NAME OF SERVICE

SERVICE Price

% Increase

new Service Price




Service price increase in this year


NAME OF SERVICE

SERVICE Price

% Increase

new Service Price




Step 3: Service Completion time

We need to calculate how long it takes for you to complete each service.




Step 4 : REVENUE BY UNITS


Now I would like to establish the relationship between your best and worst month in terms of sales.

You should know if your best month is 2, 3, 4 or more times better than your worst month. And you should have a fair idea by product.

Questions:

1. In which month do you believe you will be providing the least amount of this service (we should do this by product)?

2. How many of each service do you think you will be providing per day, week or month in this month?

3. In which month do you believe you will be providing the most amount of this service (we should do this by product)?

4. How many of each service do you think you will be providing per day, week or month in this month?

With each question above, you're still giving your best worst case scenario. Please stay away from optimism.
While a supposedly good way to look at life, it will not endear you to any bank.


Check box maintains the same ratio for each month based on a single month value entered


Totals

 

What Is Your Subjected Tax Rate ?



Per Unit REVENUE Increase



Totals

 




Per Unit REVENUE Increase



Totals

 




Step 5: PAYROLL EXPENSES


Are you going to have employees? Even if you're not going to employ someone, you should be a paid employee.

Name of Position

Count

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC






PAYROLL EXPENSES Increase


Name of Position

Count

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

% ^



PAYROLL EXPENSES Increase


Name of Position

Count

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

% ^



Step 6 : Business Expenses


Expense Category

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC



Step 12 : Business Expenses Increase


Expense Category

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

% ^



Business Expenses Increase


Expense Category

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

% ^



Step 7 : Pre Start values


Receipt Category

Amount



Payments Category

Amount




Step 8 : Year 1 Summary


Pre-Start

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

Totals

Receipts

Payments




Step 9 : Year 2 Summary


Pre-Start

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

Totals

Receipts

Payments




Step 10 : Year 3 Summary


Pre-Start

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

Totals

Receipts

Payments




Step 11 : Export Data





In this step you will be able to export your data to a Excel file.