ASIA PACIFIC DILIGENCE SDN BHD Ó

                      Visit Our Website at:

            http://www.asiapacificevents.com

 

 Two Days Intensive Seminar                                SBL Claimable Subject to HRDF Approval

 

 

FINANCIAL MODELING, FORECASTING AND ANALYSIS USING EXCEL

 

 

4 & 5 February 2010

JW Marriott Hotel, Kuala Lumpur

 

 

Outline

 

Building Financial Models

·    What is modeling?

·    Spreadsheet uses and limitations

·    Modeling with flow charts and influence diagrams

·    Spreadsheet design principles

·    Graphing and presentation of outputs

·   Practice Case

    - Fruitty Belle

    - Constructing influence diagram

 

Financial Statement Modeling

·    Core Excel functions

·    Structuring a cash flow and amortization

·    Line by line building up of cash flows

·    Typical cash flow issues

·    Using financial statement models for valuation

·   Practice Case

    - The Boatman

    - Analysis of Financial Statements

 

Investment Modeling

·    Review of Time Value of Money and DCF techniques

·    Use and calculation of discount rates

·    Weighted average cost of capital

·    Payback

·    Practice Case

    - The Clover Residences

    - Concept of Time Value of Money

·   Financial Functions

·   Using NPV, IRR, MIRR and understanding its limitations

·   Investment modeling techniques

·   Practice Case

    - Balcones Investments

    - Investment Analysis

 

Building Your Own Models

·    Modeling with whatif analysis, sensitivity analysis,

    Scenario analysis & Monte Carlo simulation

·    Building your own financial models

·    Planning the financial model

·    Setting up the input, workings, output and other sheet(s)

·    Practice Case

    - Manchini Investment Group

    - Making investment decisions

 

 

Learning Methods

Through a combination of case studies, practical exercises and Excel (2003) based models you will learn how to adjust and apply the theoretical techniques used. Delegates are encouraged to ask questions and highlight areas of particular interest. The concepts taught are designed to be of practical benefit to attendees and are transferable to the workplace.

 

Course Level

Participants will need to have at least a fundamental understanding of the basics of finance and be familiar with how to use Microsoft Excel 2003, but will not need to have any prior modeling experience.

 

Who Should Attend

·   Lending Bankers/Real Estate Finance Executives

·   Analysts

·   Financial Managers and Consultants

·   Fund Managers

·   Investment Bankers and Consultants

·   Lawyers and Accountants

·   Corporate Property Managers

·   Property Fund Management Staff

·   Property Analysts and Developers

·   Real Estate Investors

·   Insurance Professionals

·   Valuers

·   Leasing Executives

·   Securitisation Executives

 

 

Conducted by Distinguished Speaker:

 

DR. LIM THOU TIN

 

Dr. Lim is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He is also a certified ITIL/BS7799 lead auditor.

 

Thou Tin’s work experience includes working for large local companies to MNCs in senior corporate, IT and project management position, with a background in IT, banking and finance.

 

He has served and continued serving in positions as corporate advisor, chief information officer and chief operating officer in

local startup companies. His consulting works also include working with both the financial and services industry to help them to develop corporate and knowledge models for decision making needs.

 

 

16-Point Star: REGISTER NOW FOR EARLY BIRDS!
 

 

 


 

 

 

REGISTRATION FORM

 

 

Early BirdsRM1888.00 per person                                                     REF: FEB10FMFA

(Registration and Payment by 18 January 2010)

 

Group Discount (Two or more persons from same organization) – RM1950.00 per person

 

 

Regular Fee RM2000.00 per person

 

 

The above fees are inclusive of lunch/tea-breaks/valuable seminar materials & certificate

 

 

Crossed Cheque/Bank Draft payable to ASIA PACIFIC DILIGENCE SDN. BHD.

Mailing Address: B-2-9A, Megan Avenue II, No.12, Jalan Yap Kwan Seng, 50450 Kuala Lumpur

Contact Person: Ms. Erna/Ms. Ai Wen/Ms. Chin  Tel: 03-2162 6828   Fax: 03-2162 7828 / 03-2163 7828

Email: apd@po.jaring.my   Website: http://www.asiapacificevents.com

 

Full Name: Dr./Mr./Ms. _______________________________   Position: _________________________

Full Name: Dr./Mr./Ms. _______________________________   Position: _________________________

Full Name: Dr./Mr./Ms. _______________________________   Position: _________________________

Full Name: Dr./Mr./Ms. _______________________________   Position: _________________________

Full Name: Dr./Mr./Ms. _______________________________   Position: _________________________

Company: ___________________________________________________________________________

Address: ____________________________________________________________________________

____________________________________________________________________________________

Tel: _______________________________________   Fax: ____________________________________

Email: ____________________________________   Contact Person: ___________________________

 

Cancellations & Transfers: If you are unable to attend, a substitute candidate(s) is welcome at no extra charge. Please provide the name and position of the substitute delegate at least 2 days prior to the seminar. A full refund less 25% administrative charge will be made for cancellation received in writing 2 weeks prior to the seminar. A 50% refund will be given for cancellation received 1 week prior to the seminar. Regrettably, no refund can be made for cancellation 3 days before the seminar. If registration is confirmed, a 25% administrative charge will be incurred for non-attendance.

                        The organizer reserves the right to change speakers/or modify the programme content without prior notice.

                                                                            Asia Pacific Diligence Sdn Bhd ©