Telecentre Financial Planning Template Copyright © 2000 Futureworks Inc. Overview: This Telecentre Financial Planning Template is intended to be used in conjunction with a one-day workshop. Refer to the workshop materials for additional information. You will need a basic understanding of Microsoft Excel to get the most from this template. The template is "protected" to make it more difficult (although by no means impossible) to change the model inadvertently. How to Use This Template: This template is intended to help you model the finances of your Telecentre, primarily with a view to planning and managing your cash requirements. This model does not address financial statements, such as a balance sheet and income statement (but it will help you generate the information to produce such statements, should you need them). To model your Telecentre: 1) Enter the name of your Telecentre in place of "Telecentre Name" at the top of the Cash Flow sheet. It will be automatically copied to the other sheets. 2) Enter the information for your Telecentre in the Cash Flow sheet, Personnel sheet and In-Kind Contributions sheet. Start with "Month 1" in each sheet. For items that are of a repeating nature, the template is programmed to take the value for the preceding month. Thus, if you enter 100 in a cell for Month 1, 100 will also appear in Months 2-36. If you then change Month 13 to 200, 200 will also appear in Months 14 to 36. Once you have changed the value in a month other than the first month, it looses its relationship to the value in the preceding month. If you later change your mind, you will need to re-create the formula (or copy and paste it from a month that you didn't change). 3) Fill in the information for the rest of the months, based on your plan for your Telecentre. 4) For lines that have descriptions that don't apply to your Telecentre, you can either delete the row, or change the description to something you do need. To delete a row, click on a cell in the row you want to delete, then press and hold the
key and press "d". To insert a new row that copies the values from the previous month, click on a cell in the row below where you want the new line, press and hold the key and then press "n". IMPORTANT: Don't insert a new line above the first line of a group that is summarized. If you do this the values in that row will not be included in the totals. If you want a new row that does not copy the previous month's values insert a new row as above and delete the contents of the month cells whose values are not what you want. Notes: Template Protection: The template has been "protected" using Excel's protection feature. If you find yourself prevented from doing something you want to with the model, feel free to unprotect it and tinker. You may want to save the file with a new name so you can return to the state the model was in before you started tinkering. Column Widths: Numeric columns have been set to accommodate values up to 999,999,999, which should be sufficient for most currencies. If you need to make the columns wider or narrower, you will first need to unprotect the sheet. Select Protection from Excel's Tools menu and choose Unprotect Sheet. If you want to re-enable protection use the same menu and select Protect Sheet. Printing: Because the template will be used by so many different people, with different needs and probably different customary paper sizes, no attempt has been made to pre-format the sheets for printing. Before printing, you will need to select your paper size and set page breaks and other printing options to make your model look good on paper. This can be done without the need to unprotect the sheets.
workshop. Refer soft Excel to get
to planning and balance sheet hould you need
heet. It will be
Contributions programmed to appear in Months e changed the month. If you later
w, or change the te, then press vious month, then press "n". his the values in month's values
find yourself ou may want to
hich should be ed to unprotect enable
Before printing, ur model look
Telecentre Name Cash Flow Model Years 1-3 Month 1 Cash Inflows: Financing Cash Flows: Equity Investment Loan Advances Startup Grants Sustaining Grants Sale of Assets Total Financing Cash Inflows Operating Cash Inflows: Membership fees Internet subscriptions Telephone use Fax Photocopying Scanning Printing (laser, inkjet) Computer rental Word processing Desk top publishing Newsletter production Consulting services Research services Web site design Web site hosting Training (Onsite) Training (Distance) Sales of Products Other (replace with description) Total Operating Revenues Cash Outflows: Purchase of Assets: Vehicle Computers Computer peripherals Computer network Software Photocopier Office equipment Furniture Leasehold improvements Satellite dish 0 0 0 0 Month 2 Month 3 Month 4
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
Total Asset Purchases Operating Costs: Personnel costs (from Personnel sheet) Vehicle operating costs Consulting services Rent Equipment leases Electricity Telephone Internet connection Postage and Courier Water Equipment maintenance Software upgrades Insurance Staff training Travel Office supplies Computer supplies Books Magazine subscriptions CD ROM's Promotional materials Advertising Goods for resale Loan repayment Loan interest Taxes Total Operating Costs: Net Cash Flow (Total cash in less total cash out) Cumulative Net Cash Flow Reserve for Capital Replacement Unallocated Net Cash
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
Month 5
Year 1 Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0
Month 12
Yr 1 Total
Month 13
Month 14
Month 15
Year 2 Month 16
Month 17
0
0 0 0 0 0 0 0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0
0 0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
Month 18
Month 19
Month 20
Month 21
Month 22
Month 23
Month 24
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0
Yr 2 Total
Month 25
Month 26
Month 27
Month 28
Month 29
Year 3 Month 30
0 0 0 0 0 0 0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
Month 31
Month 32
Month 33
Month 34
Month 35
Month 36
Yr 3 Total 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0
Personnel Costs
Month 1 Salaries: Telecentre Manager Assistant/Receptionist Marketing Co-Ordinator Trainer 1 Trainer 2 Technician 1 Technician 2 Total Salaries Overhead percentage Overhead costs Total Personnel Costs 0 0 0 0 0 0 0 0 0% 0 0
Month 2 0 0 0 0 0 0 0 0 0% 0 0
Month 3 0 0 0 0 0 0 0 0 0% 0 0
Month 4 0 0 0 0 0 0 0 0 0% 0 0
Month 5 0 0 0 0 0 0 0 0 0% 0 0
Year 1 Month 6 0 0 0 0 0 0 0 0 0% 0 0
Month 7 0 0 0 0 0 0 0 0 0% 0 0
Month 8 0 0 0 0 0 0 0 0 0% 0 0
Month 9 0 0 0 0 0 0 0 0 0% 0 0
Month 10 0 0 0 0 0 0 0 0 0% 0 0
Month 11 0 0 0 0 0 0 0 0 0% 0 0
Month 12 0 0 0 0 0 0 0 0 0% 0 0
Yr 1 Total 0 0 0 0 0 0 0 0
Month 13 0 0 0 0 0 0 0 0 0% 0
Month 14 0 0 0 0 0 0 0 0 0% 0 0
Month 15 0 0 0 0 0 0 0 0 0% 0 0
Year 2 Month 16 0 0 0 0 0 0 0 0 0% 0 0
Month 17 0 0 0 0 0 0 0 0 0% 0 0
Month 18 0 0 0 0 0 0 0 0 0% 0 0
0
0
Month 19 0 0 0 0 0 0 0 0 0% 0 0
Month 20 0 0 0 0 0 0 0 0 0% 0 0
Month 21 0 0 0 0 0 0 0 0 0% 0 0
Month 22 0 0 0 0 0 0 0 0 0% 0 0
Month 23 0 0 0 0 0 0 0 0 0% 0 0
Month 24 0 0 0 0 0 0 0 0 0% 0 0
Yr 2 Total 0 0 0 0 0 0 0 0
0
Month 25 0 0 0 0 0 0 0 0 0% 0 0
Month 26 0 0 0 0 0 0 0 0 0% 0 0
Month 27 0 0 0 0 0 0 0 0 0% 0 0
Month 28 0 0 0 0 0 0 0 0 0% 0 0
Month 29 0 0 0 0 0 0 0 0 0% 0 0
Year 3 Month 30 0 0 0 0 0 0 0 0 0% 0 0
Month 31 0 0 0 0 0 0 0 0 0% 0 0
Month 32 0 0 0 0 0 0 0 0 0% 0 0
Month 33 0 0 0 0 0 0 0 0 0% 0 0
Month 34 0 0 0 0 0 0 0 0 0% 0 0
Month 35 0 0 0 0 0 0 0 0 0% 0 0
Month 36 0 0 0 0 0 0 0 0 0% 0 0
Yr 3 Total 0 0 0 0 0 0 0 0
0
Telecentre Name In-Kind Contributions Years 1-3 Month 1 Contribution of Assets: Vehicle Computers Computer peripherals Computer network Software Photocopier Office equipment Furniture Leasehold improvements Satellite dish Total Asset Contributions Contributions Displacing Operating Costs: Personnel costs (from Personnel sheet) Vehicle operating costs Consulting services Rent Equipment leases Electricity Telephone Internet connection Postage and Courier Water Equipment maintenance Software upgrades Insurance Staff training Travel Office supplies Computer supplies Books Magazine subscriptions CD ROM's Promotional materials Advertising Goods for resale Total Contributions Displacing Operating Costs: Month 2 Month 3 Month 4
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Month 5
Year 1 Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Month 12
Yr 1 Total
Month 13
Month 14
Month 15
Year 2 Month 16
Month 17
0
0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Month 18
Month 19
Month 20
Month 21
Month 22
Month 23
Month 24
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Yr 2 Total
Month 25
Month 26
Month 27
Month 28
Month 29
Year 3 Month 30
0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Month 31
Month 32
Month 33
Month 34
Month 35
Month 36
Yr 3 Total
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Telecentre Name Financial Summary Years 1-3 Year 1 In-Kind Contributions Contribution of Assets Contributions displacing operating costs Total In-Kind Contributions Year 2 Year 3
0 0 0
0 0 0
0 0 0
Cash Flows: Cash Inflows: Total Financing Cash Flows Revenue From Operations Total Cash Inflows Cash Outflows: Purchase of Assets Operating Expenses Total Cash Outflows Net Cash Flow Less Reserve for Capital Replacement Unallocated Cash at Year End
0 0 0
0 0 0
0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0