Docstoc

Business Plan Templates

Document Sample
Business Plan Templates Powered By Docstoc
					Business Plan CashFlow

From (date)                         1 Jan 05         1 Jan 06       1 Jan 08                                        DayCount          6.00                                                              Interest on Surpluses/Shortfalls
Base                                1 months         3 months      12 months                                        Periods          +12.00                                                             Surplus           2%
                                                                                                                                                                                                        Shortfalls        5%
Start Proj.                         1 Jan 05
ProjMode

Unit Sales Forecast - Initial Fixed Annual Rates                                                                    Thereafter: Unit Sales Growth Forecast                                                                                    Sales    Cost Of Sales    Gross                 Price Growth Forecast
From Date                         1 Jan 05           1 Jan 06                                Finish                 From Date        1 Jan 06     1 Jan 08                                                                 Selling Price   Debtor Days Creditor Days   Margin                 From Date     1 Jan 05    1 Jan 06
Product 1                           1,000              1,000                                1 Jan 10                Product 1         2.00%        3.00%                                                Product 1              20.00         30 days      30 days      30.00%                 Product 1      2.00%       2.00%
Product 2                           1,000              1,000                                1 Jan 10                Product 2         2.00%        3.00%                                                Product 2              20.00         30 days      30 days      30.00%                 Product 2      2.00%       2.00%
Copy Down for additional products                                                                                                                                                                                                                                                             Price Change Frequency   12 months


Loan Net Advances (Repayments)                                                                                      Interest Rates
                               1 Jan 05              1 Jan 06                              repayment                From Dates>      1 Jan 05         1 Jan 06                                          Loan DayCount          6.00
Loan 1                           1,000                 1,000                                1 Jan 10                Loan 1            5.00%            5.00%                                            Loan Periods          +12.00
Loan 2                           1,000                 1,000                                1 Jan 10                Loan 2            5.00%            5.00%
Copy Down for additional loans


CASHFLOW                                                                                                 1 months       1 months       1 months         1 months      1 months   1 months    1 months        1 months          1 months       1 months    1 months      1 months   3 months     3 months    3 months      3 months   3 months   3 months   3 months   3 months   12 months   12 months   12 months
                                                                                                         1 Jan 05      1 Feb 05       1 Mar 05         1 Apr 05      1 May 05    1 Jun 05    1 Jul 05      1 Aug 05           1 Sep 05       1 Oct 05    1 Nov 05      1 Dec 05    1 Jan 06    1 Apr 06    1 Jul 06      1 Oct 06    1 Jan 07   1 Apr 07   1 Jul 07   1 Oct 07   1 Jan 08    1 Jan 09    1 Jan 10
Unit Sales
Product 1                                                                                                     83               83           83               83            83         83          83                83              83             83          83            83        250          250        250           250         255        255        255        255       1,040       1,072
Product 2                                                                                                     83               83           83               83            83         83          83                83              83             83          83            83        250          250        250           250         255        255        255        255       1,040       1,072
Copy Down for additional products

Turnover
Product 1                                                                                                     54          1,672          1,715            1,668         1,667      1,668       1,667           1,667             1,668          1,667       1,668        1,667       1,668        1,702      1,700         1,700       1,702      1,771      1,769      1,769       1,771       1,843       1,871
Product 2                                                                                                     54          1,672          1,715            1,668         1,667      1,668       1,667           1,667             1,668          1,667       1,668        1,667       1,668        1,702      1,700         1,700       1,702      1,771      1,769      1,769       1,771       1,843       1,871
Copy Down for additional products

Total Turnover                                                                                               108          3,345          3,429            3,337         3,333      3,337       3,333           3,333             3,337          3,333       3,337        3,333       3,335        3,404      3,400         3,400       3,404      3,541      3,537      3,537       3,542       3,686       3,742

Cost Of Sales             Calculated using the gross margin per product
Product 1                                                                                                    (38)        (1,171)        (1,200)          (1,168)       (1,167)    (1,168)     (1,167)         (1,167)           (1,168)        (1,167)     (1,168)       (1,167)    (1,167)      (1,191)     (1,190)       (1,190)    (1,192)    (1,239)    (1,238)    (1,238)     (1,240)     (1,290)     (1,310)
Product 2                                                                                                    (38)        (1,171)        (1,200)          (1,168)       (1,167)    (1,168)     (1,167)         (1,167)           (1,168)        (1,167)     (1,168)       (1,167)    (1,167)      (1,191)     (1,190)       (1,190)    (1,192)    (1,239)    (1,238)    (1,238)     (1,240)     (1,290)     (1,310)
Copy Down for additional products

Total Cost Of Sales                                                                                          (75)        (2,341)        (2,401)          (2,336)       (2,333)    (2,336)     (2,333)         (2,333)           (2,336)        (2,333)     (2,336)       (2,333)    (2,335)      (2,383)     (2,380)       (2,380)    (2,383)    (2,479)    (2,476)    (2,476)     (2,479)     (2,580)     (2,619)

Gross Operating CashFlow                                                                                      32          1,003          1,029            1,001         1,000      1,001       1,000           1,000             1,001          1,000       1,001        1,000       1,001        1,021      1,020         1,020       1,021      1,062      1,061      1,061       1,063       1,106       1,123

Operating Costs                                                                            Then Annual
Stepped Rate Costs                                                                          Growth of
Rent                      From                       1 Jan 05       1 Jan 06    1 Jan 07       3%             (8)              (8)              (8)          (8)           (8)         (8)        (8)                (8)             (8)           (8)         (8)           (8)       (30)         (30)        (30)          (30)       (39)       (39)       (39)       (39)       (160)       (164)       (169)
                          Rate p.a                      100            120         155
PayRoll                   From                       1 Jan 05       1 Jan 06    1 Jan 07       3%             (8)              (8)              (8)          (8)           (8)         (8)        (8)                (8)             (8)           (8)         (8)           (8)       (30)         (30)        (30)          (30)       (39)       (39)       (39)       (39)       (160)       (164)       (169)
                          Rate p.a                      100            120         155
Copy Down for additional costs

Annually Growing Costs
Stationery                From,To,Rate,Growth        1 Jan 05       1 Jan 20      100          3%             (8)              (8)              (8)          (8)           (8)         (8)        (8)                (8)             (8)           (8)         (8)           (8)       (26)         (26)        (26)          (26)       (27)       (27)       (27)       (27)       (109)       (113)       (116)
Insurance                 From,To,Rate,Growth        1 Jan 05       1 Jan 20      100          3%             (8)              (8)              (8)          (8)           (8)         (8)        (8)                (8)             (8)           (8)         (8)           (8)       (26)         (26)        (26)          (26)       (27)       (27)       (27)       (27)       (109)       (113)       (116)
Copy Down for additional costs

Costs Projected from a Curve
Marketing                 Date                       1 Jan 05       1 Jan 07    1 Jan 09    1 Jan 11          (8)              (8)              (9)          (9)          (10)       (10)        (11)               (11)            (12)          (12)        (13)          (14)       (44)         (48)        (53)          (57)       (62)       (66)       (70)       (74)       (333)       (390)       (440)
                          Annual Rate                   100            200         400         450
Copy Down for additional costs

Total Operating Costs                                                                                        (41)           (41)           (42)             (43)          (43)       (44)        (44)               (45)            (45)          (46)        (46)          (47)      (155)        (160)       (164)         (169)      (192)      (196)      (200)      (204)       (871)       (944)     (1,010)

Operating CashFlow                                                                                            (9)          962             987             958           957         957         956            955                956            954         955          953         845          861        856           851         829        866        861        857         191         162         112

Capital Costs
                                     Start            Finish         Amount      Skew         Peak
Amounts Spread By an S-Curve
eg Factory Equipment           1 Jan 05              1 Jan 06             100     1.00        1.00            (4)              (6)              (8)         (10)          (11)       (11)        (11)               (11)            (10)           (8)         (6)           (4)
Copy Down for additional costs

Periodically Repeating Amounts                                     Abs Finish    Total       Interval
eg Maintenance                 1 Jan 05              1 Jan 06       1 Jan 11      100       18 months         (8)              (8)              (8)          (8)           (8)         (8)        (8)                (8)             (8)           (8)         (8)           (8)                                (25)          (25)       (25)       (25)                             (100)        (50)        (50)
Copy Down for additional costs

Discrete Amounts at Precise Dates
eg Computers                   1 Jan 05              1 Jan 06       1 Jan 07    1 Jan 08    1 Jan 09        (100)                                                                                                                                                                     (100)                                             (100)                                        (100)       (100)
                                 100                   100            100         100         100
Copy Down for additional costs

Total Capital Costs                                                                                         (112)           (14)           (16)             (18)          (19)       (20)        (20)               (19)            (18)          (16)        (14)          (12)      (100)                     (25)          (25)      (125)       (25)                             (200)       (150)        (50)

CashFlow Before Tax and Finance                                                                             (121)          948             970             940           938         938         936            936                938            938         940          941         745          861        831           826         704        841        861        857          (9)         12          62

Financing Costs
Loan 1                    Interest                                                                            (4)              (4)              (4)          (4)           (4)         (4)        (4)                (4)             (4)           (4)         (4)           (4)       (25)         (25)        (25)          (25)       (25)       (25)       (25)       (25)       (100)       (100)
Loan 2                    Interest                                                                            (4)              (4)              (4)          (4)           (4)         (4)        (4)                (4)             (4)           (4)         (4)           (4)       (25)         (25)        (25)          (25)       (25)       (25)       (25)       (25)       (100)       (100)

Overdraft                 Interest                                                                            (0)               3               5                6          8          9          11                12              14             16          17            19         65           76          80            85         89         92         97        101         420         424         394

Total Financing Costs                                                                                         (8)              (5)              (4)          (2)           (1)         1           3                  4                6            7           9            10         15           26          30            35         39         42         47         51         220         224         394

Tax

CashFlow After Finance Costs                                                                                  (8)              (5)              (4)          (2)           (1)         1           3                  4                6            7           9            10         15           26          30            35         39         42         47         51         220         224         394

Finance Advances
Loan 1                    Net Advances (Repayment)                                                         1,000                                                                                                                                                                     1,000                                                                                                                 (2,000)
Loan 2                    Net Advances (Repayment)                                                         1,000                                                                                                                                                                     1,000                                                                                                                 (2,000)

Overdraft                 Net Advances (Repayment)                                                        (1,871)          (942)          (967)            (938)         (937)      (939)       (939)           (940)             (943)          (945)       (949)         (951)    (2,761)        (887)       (861)         (861)      (743)      (884)      (908)      (908)       (211)       (236)      3,543

Total Finance Advances                                                                                       129           (942)          (967)            (938)         (937)      (939)       (939)           (940)             (943)          (945)       (949)         (951)      (761)        (887)       (861)         (861)      (743)      (884)      (908)      (908)       (211)       (236)       (457)

CashFlow After Finance                                                                                       121           (948)          (970)            (940)         (938)      (938)       (936)           (936)             (938)          (938)       (940)         (941)      (745)        (861)       (831)         (826)      (704)      (841)      (861)      (857)          9         (12)        (62)

Balances - End Period
Loan 1                                                                                                     1,000          1,000          1,000            1,000         1,000      1,000       1,000           1,000             1,000          1,000       1,000        1,000       2,000        2,000      2,000         2,000       2,000      2,000      2,000      2,000       2,000       2,000
Loan 2                                                                                                     1,000          1,000          1,000            1,000         1,000      1,000       1,000           1,000             1,000          1,000       1,000        1,000       2,000        2,000      2,000         2,000       2,000      2,000      2,000      2,000       2,000       2,000

Overdraft                                                                                                 (1,871)        (2,813)        (3,780)          (4,718)       (5,655)    (6,594)     (7,533)         (8,473)           (9,416)       (10,361)    (11,310)     (12,262)    (15,022)     (15,909)   (16,770)       (17,631)   (18,374)   (19,258)   (20,165)   (21,074)   (21,285)    (21,521)    (17,978)

                                                                                                             129           (813)        (1,780)          (2,718)       (3,655)    (4,594)     (5,533)         (6,473)           (7,416)        (8,361)     (9,310)     (10,262)    (11,022)     (11,909)   (12,770)       (13,631)   (14,374)   (15,258)   (16,165)   (17,074)   (17,285)    (17,521)    (17,978)

				
DOCUMENT INFO
Description: Business Plan Templates document sample