Excel Series
Corporate Financing and Evaluation
Business Plan Analysis
Jakarta, April 29-30, 2009
Description
In this course, participants will learn to create Financial Modeling for Business Plan Analysis
They will also forecast values with trend lines and create scenarios.
Objectives
After completing this course, the participants will:
A. Identify different decisions at project cycle from pre-feasibility level, investment stage and operational phase.
B. Determine the information required such as marketing, technical, financial, organization and manpower, and social environment.
C. Understand Procedures in estimating initial investment, pre-operational costs, and working capital requirements.
D. Understand the criteria in evaluating the viability of the projects
Detailed Outline
1. Basic Elements of a Project Financing
2. SWOT and PEST Analysis
3. Assumption Analysis and Model
4. Optional ways to act to prove profitability of plans
5. Cash-flow-statements per business unit and in total
6. Income statements and Balance sheets Analysis
7. Equity and Cash Flow Analysis
8. The Lambrown Analysis Model
9. Investment Plan Analysis (NPV, XNPV, IRR, MIRR, XIRR, PBP, ARR and PI)
10. Corporate Valuation Methodology
11. Personnel plan and Appraisal Model (salary structure analysis)
12. Tax Computation Analysis (Corporate and Individual Case)
13. Working Capital Works Analysis
14. CAPEX and OPEX Analysis
15. Marketing Plan Analysis
16. Profitability indicators/ratios
17. MOS, DOL, DFL and DCL Analysis
18. Cost Volume Profit Relationships and BEP Analysis
19. ROI-indicators (DuPont and Altman Z-Score Analysis etc.)
20. Discount Factor Valuation and Sensitivity Analysis
21. Competitor and Competitive Analysis
Instructor
MUSLIM
· Financial Modeling Specialist
· Business Process Review Specialist
· Chairman and CEO of PT. MY Consulting
· Partner of Adi Jimmy Arthawan Accounting Firm
He is a registered accountant by profession as Partner of KAP Adi Jimmy Arthawan and is working as President Director for MY Consulting Indonesia.
With a very rich and varied work experience acquired by his employment in several different experiences, He commands the best knowledge of the theory and use of various Computer Applications, especially Microsoft Excel.
His experience as a middle level and top-level manager and also as a business owner has provided the perfect angle of top management thoughts and an easy-learning solution model with which he has tailored the learning approach.
Investment
IDR 5.000.000 (Five Million)
Send 4 delegates and the 5th comes for FREE
Methodology
Lecturers
Case Exercises
1 Participant to a computer (laptop by self)
Practical Computer Hands on Applications
Bring your own laptop and have all your financial modeling
Facilities
Hot-Spot Training Room
Start up Business Planning Manual- McKinsey – Text book (softcopy)
Business Plan - Deloitte – Text book (softcopy)
Excel for Project Manager – Text book (softcopy)
Powerful Proposal – Text book (softcopy)
Excel Guidelines – Text book (softcopy)
Yahoo Investor Presentation (softcopy)
GE and Merrill Lynch Annual Report 2007 (softcopy)
Three Samples of Business Plan (softcopy)
ONGC Company Analysis 2007 (softcopy)
ITC Ltd Financial Analysis 1998-2007 (softcopy)
Training Handout and Exercise (softcopy)
Certificate and Consultation
Lunch and Coffee break
Venue
Training Center MYC Academy
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA
In-house package (special terms)
Pay 9 for 14 participants
Venue and schedule as client confirmation
Tailor-made for teams of between 7 and 14 executives
Thanks and regards,
Yuniarti
Events Coordinator
PT MY Consulting
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA
Ph 62 21 5704791
Fax 62 21 5704918
yunie@myconsulting.us
No comments:
Post a Comment