FRANCIS O. MTAMBO
Salem,OR
Summary
Dynamic financial professional with a proven track record at EQC Health Services, excelling in pro forma modeling and advanced Excel techniques. Adept at enhancing financial reporting and forecasting accuracy, I leverage strong analytical skills and a passion for strategic initiatives to drive impactful decision-making and optimize portfolio performance.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Financial Analyst
EQC HEALTH SERVICES
Portland, OR
05.2023 - 09.2023
- Executed variance analysis and internal budgeting for regional healthcare provider.
- Monitored expenses and identified discrepancies in financial records.
- Streamlined financial reporting processes using Power BI to accelerate executive decision-making.
- Conducted forecasting to enhance financial planning accuracy.
- Improved data visualization tools to support strategic initiatives.
Lecturer – Finance & Financial Mathematics
BLANTYRE INTERNATIONAL UNIVERSITY
01.2020 - 01.2022
- Instructed graduate-level courses on Valuation Methods and Time Value of Money (TVM), the core logic used in real estate development underwriting.
- Guided students in building complex DCF models and performing scenario analysis for asset valuation.
Accountant
SEMA ACCOUNTANTS
01.2015 - 01.2018
- Managed full-cycle accounting, tax reporting, and financial statement preparation for corporate clients.
- Analyzed expense structures to identify profitability trends and operational efficiencies.
Co-Founder & Finance Lead (CFO)
TRADESTONE CAPITAL LIMITED
01.2013 - 01.2015
- Capital Allocation: Directed investment strategy that doubled total company assets within 24 months through disciplined risk-adjusted return analysis and capital deployment.
- Investment Underwriting: Led credit underwriting for a diverse portfolio, utilizing Debt Service Coverage Ratio (DSCR) and Loan-to-Value (LTV) metrics to mitigate default risk.
- Capital Raising: Successfully raised initial seed capital and secured grant funding to facilitate firm expansion.
- Financial Modeling: Built proprietary cash flow forecasting and liquidity monitoring models used to evaluate portfolio performance and IRR.
Education
Master of Science - Finance
Portland State University
Portland, OR06-2024
Master of Science - Financial Engineering
WorldQuant University
Online01.2024
Bachelor of Financial & Investment Analysis -
Amity University / University of Malawi
01.2013
Skills
- Pro forma modeling
- NPV analysis
- Waterfall splits
- Advanced Excel
- VBA programming
- Pivot tables
- Power Query
- Solver optimization
- Power BI
- Python programming
- R language
- SQL database management
- Asset underwriting
- Risk mitigation strategies
- Portfolio management
- Budgeting techniques
- Forecasting methods
Websites
Certification
- Life and Health Insurance License – Oregon & Washington
- Anti-Money Laundering (AML) Certificate – Oregon Division of Financial Regulation
- Financial Services Board Regulatory Certificate (Key Individual) – South Africa
Projects
Multifamily Acquisition Pro-forma, Developed a dynamic 10-year Excel model to evaluate a 75-unit value-add acquisition; integrated rent roll analysis, OpEx assumptions, and exit cap rate sensitivity. Joint Venture (JV) Waterfall Model, Built a 3-tier distribution model in Excel featuring preferred returns and promote hurdles to calculate GP/LP equity splits. Development Feasibility Analysis, Conducted NPV/IRR sensitivity analysis on a hypothetical mixed-use project to determine the impact of 100bps interest rate fluctuations on debt serviceability.
Timeline
Financial Analyst
EQC HEALTH SERVICES
05.2023 - 09.2023
Lecturer – Finance & Financial Mathematics
BLANTYRE INTERNATIONAL UNIVERSITY
01.2020 - 01.2022
Accountant
SEMA ACCOUNTANTS
01.2015 - 01.2018
Co-Founder & Finance Lead (CFO)
TRADESTONE CAPITAL LIMITED
01.2013 - 01.2015
Master of Science - Finance
Portland State University
Master of Science - Financial Engineering
WorldQuant University
Bachelor of Financial & Investment Analysis -
Amity University / University of Malawi