Flowing a Process Templates by klz20337

VIEWS: 7 PAGES: 7

More Info
									      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@mdec.com.my
             Yong Chi Kin         03-8315 3178             chikin@mdec.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 on 4/12/2011 at 5:41 PM
Instructions / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls                                                                                  1 of 7
             Back To Instructions
                                                                       Co. name:                        0

             F1 : FINANCIAL PROJECTIONS (RM)


                                             Year                                                2003               2004                          2005                2006                2007
             Sales (Local)                                                                              0                        0                       0                   0                   0
             Sales (Exports)                                                                            0                        0                       0                   0                   0
             Total Sales                                                                                0                        0                       0                   0                   0
             Net profit (loss) before tax                                                               0                        0                       0                   0                   0
             Net operating cash flow                                                                    0                        0                       0                   0                   0
             Liquid Assets                                                                              0                        0                       0                   0                   0
             Stocks ( Inventory)                                                                        0                        0                       0                   0                   0
             Trade Debtors                                                                              0                        0                       0                   0                   0
             Current Assets                                                                             0                        0                       0                   0                   0
             Fixed Assets (net)                                                                         0                        0                       0                   0                   0
             Current Liablities                                                                         0                        0                       0                   0                   0
             Long-Term Liabilities                                                                      0                        0                       0                   0                   0
             Paid-up-Capital                                                                            0                        0                       0                   0                   0
             R&D Investment ( at cost)                                                                  0                        0                       0                   0                   0
             Networth ( cumulative )                                                                    0                        0                       0                   0                   0


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


                                             Item *                                              2003               2004                          2005                2006                2007
             A
             B
             C
             D
             E
             F
             G
             H
             I
             J
             Others :-
             Others :-
             Others :-
             Others :-
             Others :-
             Others :-
             Others :-
             Others :-
                                             Total                                                      0                        0                       0                   0                   0


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


                                             Item *                                              2003               2004                          2005                2006                2007
             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
             --Web Engineer
             --Linguists
             --Language Translators
             --Content Developers
             --Others:-(please specify)
                                                Sub-total                                               0                        0                       0                   0                   0
             Technology acquisitions - Hardware
             --Computer Servers
             --Personal Computers
             --ISDN Lines Connection
             --Workstations Hardware & Accessories
             --Furniture & Fittings
             --Others:-(please specify)
                                                Sub-total                                               0                        0                       0                   0                   0
             Technology acquisitions - Software
             --Software Licencing for Windows NT
             --Software for Hardware Development
             --Design Tools
             --Others:-(please specify)
                                                Sub-total                                               0                        0                       0                   0                   0
             Prototypes
             --Content & Design Fee
             --Mould Making
             --Prototyping Costs
             --Others:-(please specify)
                                                Sub-total                                               0                        0                       0                   0                   0
             Consumables / Incidental Costs
             Patenting & Copyrights
             Others:-(please specify)
                                         Grand Total                                                    0                        0                       0                   0                   0
             * 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                                                            2000                        2001                          2002                2003                2004
             Sales

             Profit/Loss before tax




Financial Summary / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls                                            Printed on 4/12/2011 at 5:41 PM                                                              2 of 7
     PROFIT AND LOSS ACCOUNT                                                            Back To Instructions
     Co. name:                                                     0

                                                                                        PROJECTIONS
                                                           2003            2004             2005               2006       2007
                                                            RM              RM               RM                 RM         RM

     SALES                                                         0                0                0                0          0

     less: COST OF SALES

     GROSS PROFIT                                                  0                0                0                0          0
     less:
     General & Administrative Expenses
          Professional fees
          Directors' remuneration
          Insurance
          Medical fee
          Rental of premises
          Salaries,allowances & bonus
          Utilities
          Upkeep of office
          R & D expenses                                           0                0                0                0          0
          Others:-
          Others:-
          Others:-

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

          Total S&M                                                0                0                0                0          0
     Other Income                                                  0                0                0                0          0
     PBDIT                                                         0                0                0                0          0
     less: Amortisation of R&D                                     0                0                0                0          0
           Depreciation                                            0                0                0                0          0

     PBIT                                                          0                0                0                0          0
     less: Financial Charges                                       0                0                0                0          0

     PROFIT / (LOSS) BEFORE TAXATION                               0                0                0                0          0
     LESS : TAXATION
     PROFIT / (LOSS) AFTER TAXATION                                0                0                0                0          0
     Minority Interest                                             0                0                0                0          0
     Distributable Profit                                          0                0                0                0          0
     less: Dividend

     Retained Profit / (Loss) For The Year                         0                0                0                0          0
     Retained Profit / (Loss) B/fwd                                0                0                0                0          0
     Retained Profit / (Loss) C/fwd                                0                0                0                0          0




                                                  Printed on 4/12/2011 at 5:41 PM
ProfitLoss / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls                                                                       3 of 7
            BALANCE SHEET                                                                  Back To Instructions
            Co. name:                                                     0

                                                                                           PROJECTIONS
                                                                  2003          2004           2005          2006       2007
                                                                   RM            RM             RM            RM         RM

            Research & Development (net)                                 0             0              0             0          0

            Investment                                                   0             0              0             0          0

            FIXED ASSETS (net)
            Land & Buildings                                             0             0              0             0          0
            Fixtures & Fittings                                          0             0              0             0          0
            Office Equipment                                             0             0              0             0          0
            Motor Vehicles                                               0             0              0             0          0
            Others                                                       0             0              0             0          0
                                                                         0             0              0             0          0

            CURRENT ASSETS
               Trade debtors                                             0             0              0             0          0
               Cash and bank balances                                    0             0              0             0          0
               Prepayments & Deposits                                    0             0              0             0          0
               Stocks (non-tradeable)                                    0             0              0             0          0
                                                                         0             0              0             0          0

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

            NET CURRENT ASSETS                                           0             0              0             0          0
            NET ASSETS                                                   0             0              0             0          0


            Financed By :
                Share Capital ( Paid-up capital)                         0             0              0             0          0
                Share Premium Reserves                                   0             0              0             0          0
                Retained Profit C/fwd                                    0             0              0             0          0
                                                                         0             0              0             0          0
            Long term liabilities
               Grants                                                    0             0              0             0          0
               Debenture
               Long-term loans                                           0             0              0             0          0

            SHAREHOLDERS' NETWORTH                                       0             0              0             0          0

                                                                         0             0              0             0          0




BS / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls      Printed on 4/12/2011 at 5:41 PM                                             4 of 7
                    CASH FLOW STATEMENT                                                                                      Back To Instructions
                    Co. name:                                                                             -

                                                                                                                             PROJECTIONS
                                                                                                   2003           2004           2005               2006       2007
                                                                                                    RM             RM             RM                 RM         RM
                    Cash flows from operating activities

                        Cash receipts from customers                                                          0          0                0                0          0
                        Cash paid to suppliers                                                                0          0                0                0          0
                        Cash paid to operating expenses & employees                                           0          0                0                0          0
                    Net cash from/(used in) operating activities                                              0          0                0                0          0

                    Cash flows from investing activities
                         Investment
                        Purchase of fixed assets                                                              0          0                0                0          0
                        Research & development                                                                0          0                0                0          0
                    Net cash from/( used in) investing activities                                             0          0                0                0          0
                    Cash flows from financing activities
                         Issuance of share capital
                        Share Premium
                        Dividend Paid (-)
                        Long term loan/borrowings (+)
                        Repayment of loan (-)
                        Grant
                        Interest income/(expense)                                                             0          0                0                0          0
                    Net cash from/( used in) financing activities                                             0          0                0                0          0

                    Net increase( decrease) in cash and cash equivalents                                      0          0                0                0          0

                    Cash and cash equivalents brought forward                                                 0          0                0                0          0
                    Cash and cash equivalents carried forward                                                 0          0                0                0          0




CFS / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls                             Printed on 4/12/2011 at 5:41 PM                                                                5 of 7
        Back To Instructions
                  Assumptions:-

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


        9.         Fixed Assets Calculation                                        2003            2004            2005       2006           2007

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

                                                                                           0               0              0          0                 0

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

                                                                                           0               0              0          0                 0

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

                                                                                           0               0              0          0                 0

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

        Rental of Premises

        Cost of Sales


        Grant                                              First Drawdown         2003             2004            2005       2006           2007
                                                           No.of years to amortised 1
                                                           Brought fwd                     0               0              0
                                                           Addition                        0
                                                                                           0               0              0
                                                           P&L (Other Income)              0               0              0
                                                           carried fwd                     0               0              0

                                                           Second Drawdown
                                                           No.of years to amortised 1
                                                           Brought fwd                     0               0              0          0                 0
                                                           Addition                                        0
                                                                                           0               0              0          0                 0
                                                           P&L (Other Income)              0               0              0          0                 0
                                                           carried fwd                     0               0              0          0                 0

                                                           Third Drawdown
                                                           No.of years to amortised 1
                                                           Brought fwd                     0               0              0          0                 0
                                                           Addition                                                       0
                                                                                           0               0              0          0                 0
                                                           P&L (Other Income)              0               0              0          0                 0
                                                           carried fwd                     0               0              0          0                 0


Notes 2 / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls           Printed on 4/12/2011 at 5:41 PM                                                     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.




Notes / f62511fd-fc73-4b4e-a6c0-4f2e4ea0aafa.xls Printed on 4/12/2011 at 5:41 PM   7 of 7

								
To top