Docstoc

MSC Financial Template

Document Sample
MSC Financial Template Powered By Docstoc
					     Dear Esteemed Clients,

            Thank you for your interest in obtaining the MSC status for your company. We will assist you in preparing
            the financial projection for the application.

            Should you need any assistance in preparing this financial projection, our contact are as follow

            Mohd. Zaffri Basir      03-8315 3171               zaffri@mdc.com.my
            Yong Chi Kin            03-8315 3178               chikin@mdc.com.my

            Kindly key-in the applying company's name below in the yellow-coloured cell below.



     Please proceed with the instructions below. Thank you.


     Instructions to complete the Financial Templates

        1              Please fill-in all the "yellow" coloured cells in the following sheets:-
                       a. Financial Summary
                       b. P&L
                       c. BS
                       d. CFS
                       e. Notes 2

                       *Please do not fill-in the auto-linked "light green" coloured cells.


        2              Please do not add or remove any row to/from the financial templates (5 sheets mentioned above in note 1) as this will affect the
                       other tabs, which will result in failure to process the application accordingly. However, you are allowed to change the
                       description/s of the expenses to be more reflective on your business actvities.


        3              Please put "0" to item/s which is/are not applicable to your company.

        4              Please state all the assumptions and important calculations used in the projections in "Notes" tab.

        5   Table F2 Table F2: Breakdown of Revenue - The table is to show the source of revenue generation for the company. The revenue stream/s
                     should be the same as the company's proposed MSC activities described in the business plan. Further working calculation of the
                     revenue streams are necessary and kindly provide the workings in "Notes" tab.


        6   Table F3 Table F3: R&D expenses - Please note that the underlying assumption used on the treatment of these expenses is such that the
                     Hardware and Software acquisition for the purpose of Research and Development works will be capitalised in the Balance Sheet
                     and subsequently amortised every year. The other R&D expenses as stipulated in Table F3 will be written-off completely in the
                     Profit and Loss during the year they incurred.


        7   Table F4 Table F4: Past Financial Performance - For the company that has been in operation for more than 1 year, please provide us with
                     the audited Sales and the Profit before Tax figures.
        8              Throughout this template, additional information / instruction can be found in the cell marked with the red triangle on the top
                       righthand corner.
        9              The coloured item contains hyperlink to different relevant section of the financial projection.
       10              For easy printing of all the pages, press "Ctrl" + "Shift" simultaneously and and without releasing it, click on the sheet/tab you
                       want to print. Then, click on "Print".




                                                Printed
Instructions / 0ad6a628-e134-403c-b72f-7bae9289f921.xls on 10/26/2011 at 11:43 AM                                                                    1 of 7
             Back To Instructions
                                                                             Co. name:                        0

             F1 : FINANCIAL PROJECTIONS (RM)


                                                Year                                               2002                    2003                   2004
             Sales (Local)                                                                                  10                      40                      90
             Sales (Exports)                                                                                90                     160                     210
             Total Sales                                                                                   100                     200                     300
             Net profit (loss) before tax                                                                 3,265                   5,789                  25,815
             Net operating cash flow                                                                        45                     152                     236
             Liquid Assets                                                                                9,442                14,480                    34,452
             Stocks ( Inventory)                                                                             0                       0                       0
             Trade Debtors                                                                                  20                      33                      50
             Current Assets                                                                               9,462                14,513                    34,502
             Fixed Assets (net)                                                                            417                     317                     217
             Current Liablities                                                                              1                       2                       3
             Long-Term Liabilities                                                                        6,687                   5,853                     20
             Paid-up-Capital                                                                                50                      50                      50
             R&D Investment ( at cost)                                                                      70                     140                     210
             Networth ( cumulative )                                                                      9,999                14,952                    34,932


             F2 : Breakdown of Sales (RM)                                                Back to                  Intro                   ProfitLoss


                                               Item *                                              2002                    2003                   2004
             Content Edition/Enhancement
             Interractive Services
             E-Commerce                                                                                    100                     200                     300
             Software Integration
             Website Development Income
             Hosting Fees
             i-directory listing
             Sale of Portals
             Fulfillment charges
             Licensing
             Subscription
             Transaction Fee
             Advertisement
             Data Centre Management
             Call Centre Management
             System Intergration and Testing
             Others :-
             Others :-
                                               Total                                                       100                     200                     300


             F3 : Breakdown of Research & Development (RM)                               Back to                  Intro                   Balance Sheet


                                               Item *                                              2002                    2003                   2004
             R&D staff salaries **
             --R&D Electronic Engineers
             --R&D Embedded Software Engineers
             --R&D Software Engineer
             --R&D Quality & Security Engineer
             --Chief Designer
             --Web Designer                                                                                 10                      20                      30
             --Web Engineer
             --Linguists
             --Language Translators
             --Content Developers
             --Others:-(please specify)
                                             Sub-total                                                      10                      20                      30
             Technology acquisitions - Hardware
             --Computer Servers
             --Personal Computers
             --ISDN Lines Connection                                                                        10                      20                      30
             --Workstations Hardware & Accessories
             --Furniture & Fittings
             --Others:-(please specify)
                                             Sub-total                                                      10                      20                      30
             Technology acquisitions - Software
             --Software Licencing for Windows NT
             --Software for Hardware Development                                                            10                      20                      30
             --Design Tools
             --Others:-(please specify)
                                             Sub-total                                                      10                      20                      30
             Prototypes
             --Content & Design Fee
             --Mould Making
             --Prototyping Costs                                                                            10                      20                      30
             --Others:-(please specify)
                                             Sub-total                                                      10                      20                      30
             Consumables / Incidental Costs                                                                 10                      20                      30
             Patenting & Copyrights                                                                         10                      20                      30
             Others:-(please specify)                                                                       10                      20                      30
                                           Grand Total                                                      70                     140                     210
             * Please adjust the items according to the nature of your business
             ** For R&D staff salaries, please indicate (PT) for part-time or (FT) full-time .


             F4 : PAST FINANCIAL PERFORMANCE                                      Back To Instructions
                             No. of Audited Financial Statement (max. of 3 years)          0
             Past Perfomance                                                            1999                               2000                   2001
             Sales

             Profit/Loss before tax




Financial Summary / 0ad6a628-e134-403c-b72f-7bae9289f921.xls                                                              Printed on 10/26/2011 at 11:43 AM       2 of 7
           PROFIT AND LOSS ACCOUNT                                      Back To Instructions
           Co. name:                                       0

                                                           PROJECTIONS
                                                    2002       2003    2004
                                                    RM         RM      RM

           SALES                                       100       200          300

           less: COST OF SALES

           GROSS PROFIT                                100       200          300
           less:
           General & Administrative Expenses
                 Professional fees
                 Directors' remuneration
                 Insurance                              12        24           36
                 Medical fee
                 Rental of premises
                 Salaries,allowances & bonus            12        12           12
                 Utilities
                 Upkeep of office
                 R & D expenses                         40        80          120
                 Others:-
                 Others:-
                 Others:-

               Total G&A                                64       116          168
           Sales & Marketing Expenses
               Advertisement
               Entertainment
               Printing and stationery
               Salaries and commissions                 12
               Tender fee
               Travelling expenses
               Upkeep of motor vehicle
               Others:-
               Others:-
               Others:-

                Total S&M                               12          0           0
           Other Income                              3,333      5,833      25,833
           PBDIT                                     3,357      5,917      25,965
           less: Amortisation of R&D                     8         27          48
                 Depreciation                           83        100         100

           PBIT                                      3,266      5,790      25,817
           less: Financial Charges                       1          2           2

           PROFIT / (LOSS) BEFORE TAXATION           3,265      5,789      25,815
           LESS : TAXATION
           PROFIT / (LOSS) AFTER TAXATION            3,265      5,789      25,815
           Minority Interest                             0          0           0
           Distributable Profit                      3,265      5,789      25,815
           less: Dividend                                2          2           2

           Retained Profit / (Loss) For The Year     3,263      5,787      25,813
           Retained Profit / (Loss) B/fwd                0      3,263       9,049
           Retained Profit / (Loss) C/fwd            3,263      9,049      34,862




                                               Printed
ProfitLoss / 0ad6a628-e134-403c-b72f-7bae9289f921.xls on 10/26/2011 at 11:43 AM                3 of 7
           BALANCE SHEET                                              Back To Instructions
           Co. name:                                     0

                                                         PROJECTIONS
                                                  2002       2003    2004
                                                  RM         RM      RM

           Research & Development (net)               22        54           96

           Investment                                100        70          120

           FIXED ASSETS (net)
           Land & Buildings                           83        63           43
           Fixtures & Fittings                        83        63           43
           Office Equipment                           83        63           43
           Motor Vehicles                              0         0            0
           Others                                      0         0            0
                                                     417       317          217

           CURRENT ASSETS
              Trade debtors                            20        33          50
              Cash and bank balances                9,442    14,480      34,452
              Prepayments & Deposits                    0         0           0
              Stocks (non-tradeable)                    0         0           0
                                                    9,462    14,513      34,502

           Less : Current Liabilities
               Other creditors                           1       2             3
               Trade Creditors                           0       0             0
               Accruals                                  0       0             0
               Short Term Loans                          0       0             0
                                                         1       2             3

           NET CURRENT ASSETS                       9,461    14,511      34,499
           NET ASSETS                               9,999    14,952      34,932


           Financed By :
               Share Capital ( Paid-up capital)        50        50          50
               Share Premium Reserves                   0         0           0
               Retained Profit C/fwd                3,263     9,049      34,862
                                                    3,313     9,099      34,912
           Long term liabilities
              Grants                                6,667     5,833            0
              Debenture
              Long-term loans                         20        20           20

           SHAREHOLDERS' NETWORTH                   9,999    14,952      34,932

                                                         0       0            0




BS / 0ad6a628-e134-403c-b72f-7bae9289f921.xls Printed on 10/26/2011 at 11:43 AM              4 of 7
            CASH FLOW STATEMENT                                                           Back To Instructions
            Co. name:                                                 -

                                                                           PROJECTIONS
                                                                   2002        2003    2004
                                                                   RM          RM      RM
            Cash flows from operating activities

                Cash receipts from customers                           80         187           283
                Cash paid to suppliers                                  0           0             0
                Cash paid to operating expenses & employees           (35)        (35)          (47)
            Net cash from/(used in) operating activities               45         152           236

            Cash flows from investing activities
                 Investment                                          (100)         30           (50)
                Purchase of fixed assets                             (500)          0             0
                Research & development                                (70)       (140)         (210)
            Net cash from/( used in) investing activities            (670)       (110)         (260)
            Cash flows from financing activities
                 Issuance of share capital                                50
                Share Premium
                Dividend Paid (-)                                         (2)       (2)           (2)
                Long term loan/borrowings (+)                             20
                Repayment of loan (-)
                Grant                                              10,000        5,000       20,000
                Interest income/(expense)                              (1)          (2)          (2)
            Net cash from/( used in) financing activities          10,067        4,996       19,996

            Net increase( decrease) in cash and cash equivalents    9,442        5,038       19,973

            Cash and cash equivalents brought forward                   0        9,442       14,480
            Cash and cash equivalents carried forward               9,442       14,480       34,452




CFS / 0ad6a628-e134-403c-b72f-7bae9289f921.xlsPrinted on 10/26/2011 at 11:43 AM                                  5 of 7
       Back To Instructions
                   Assumptions:-

       1.          Name of the Company                                   0
       2.          Projection Start (year)                             2002               2003         2004
                   Sales (must total to 100%)                          100%              100%          100%
                   -expexted Local Sales (%)                           10%                20%          30%
                   -expected Export Sales (%)                          90%                80%          70%
       3.          Trade Debtors Credit Period (month)                   2
       4.          Trade Creditors Credit Period (month)                 0
                   Other Creditors Credit Period (month)                 1
       5.          Interest Rate (%)                                    7%                 8%           9%
       6.          Depreciation Rate (%)                     refer to FA section below
       7.          Amortisation Rate (%)                               33%             Back to P&L
       8.          Period covered in 1st. Year (months)                 10


       9.          Fixed Assets Calculation                                              2002           2003           2004

                   Annual Acquisition:                      Back to Balance Sheet
                   Land & Buildings                                                         100                 0             0
                   Fixtures & Fittings                                                      100                 0             0
                   Office Equipment                                                         100                 0             0
                   Motor Vehicles                                                             0                 0             0
                   Others                                                                     0                 0             0

                                                                                            500                 0             0

                   Depreciation:                                          %                                         Back to P&L
                   Land & Buildings                                      20%                    17             20           20
                   Fixtures & Fittings                                   20%                    17             20           20
                   Office Equipment                                      20%                    17             20           20
                   Motor Vehicles                                        20%                     0              0            0
                   Others                                                20%                     0              0            0

                                                                                                83         100            100

                   Net Book Value:
                   Land & Buildings                                                             83             63             43
                   Fixtures & Fittings                                                          83             63             43
                   Office Equipment                                                             83             63             43
                   Motor Vehicles                                                                0              0              0
                   Others                                                                        0              0              0

                                                                                            417            317            217

       Assumptions:-                                        Back to :-                P&L            Cash Flow B Sheet

       Rental of Premises

       Cost of Sales




                                              Printed on 10/26/2011 at 11:43 AM
Notes 2 / 0ad6a628-e134-403c-b72f-7bae9289f921.xls                                                                                 6 of 7
       Co. name:                                                       0


       Notes to the Accounts

          1
          2
          3
          4
          5
          6
          7




       Please show all the relevant workings in this spreadsheet.




                                               Printed on 10/26/2011 at 11:43 AM
Notes / 0ad6a628-e134-403c-b72f-7bae9289f921.xls                                   7 of 7