PROJECT FINANCIAL MODELING & VALUATION
[Saturday and Evening Class Virtual Workshop; you can choose day 1 only, day 2 only, or full day 1 + day 2]
Day 1 : Building Project Financial Model with Microsoft Excel (6 CPD hours)
» Best Practices in Financial Modeling
» Microsoft Excel techniques in Financial Modeling
» Developing Assumptions & Scenarios
» Forecasting & Constructing
– Revenue Schedule
– Costs Schedule
– PP&E and Depreciation Schedule
– Working Capital Schedule
– Debt Schedule
» 3-Statements Financial Model
– P&L
– Balance Sheet
– Cash Flow Statement
» Capital Structure
» Project Valuation formula
» Executive Dashboard (Dynamic Chart)
» Financial Model Review and Audit
Day 2 : Use Cases & Decision Making in Project Financial Model (6 CPD hours)
» Evaluating the relevant/incremental project cash flow
– Sunk Cost
– Opportunity Cost
– Side-Effect (Synergy and Erosion/Cannibalism)
– Finance Cost & Allocated Cost
» In-depth Analysis of Project Valuation Metrics, including the problems and weaknesses
– NPV
– IRR, MIRR
– PI
– Discounted Payback
» Stakeholder concern and perspective
– Shareholder/Owner
– Project Sponsor & Project Manager
– Lender
» Risk Assessment in Financial Model
Trainer:
Michael Romero Virga, SE Ak, MBA, CA Indonesia, CPA Australia, CMA United States, CPMA, ACPA, AFM, FMVA, CBCA, MCE, MOS Expert
Training delivery will be in English.
Get the e-Certificate from Singapore Business Advisors & Consultants Council (SBACC).
PUBLIC TRAINING (Online via Zoom)
[PAST] 11 May 2024 (Saturday, 9.30-17.00 SGT)
(include 1.5 hours lunch break and 1×15 minutes break)
[PAST] 16 & 17 May 2024 (Thursday & Friday, 19.00-22.00 SGT)
(include 1×10 minutes break)
TRAINING PARTNER
SUPPORTED BY