Financial Models
The models below have been built for two purposes - commercial economic development and individual financial planning. These tools are free to use and download for non-commercial purposes - for commercial use, please reach out directly.
All information is for educational use only and does not constitute official investment advice. Note that the downloadable versions do not contain VBA Macros due to site and security constraints - macro-enabled workbooks that allow automation and advanced calculation are available upon request.
Investment Models
These Excel-based tools are built from scratch for commercial applications and provide a comprehensive framework for analyzing renewable energy projects. They cover a wide range of financial components – from cash flow forecasting to tax equity structuring – and showcase advanced modeling techniques.
-
Purpose: Evaluates a utility-scale solar project, leveraging debt and tax equity to reduce developer equity exposure.
-
Key Features: Includes project-level IRR, cash flow forecasting, tax credit optimization, and sensitivity analysis.
-
Intended Use: Designed as a high-level analytical tool for early-stage solar development. Not recommended for commercial deployment without customization.
-
Limitations: No construction funding logic, no balance sheet, and simplified treatment of financing fees.
-
Purpose: Models a basic tax equity financing using a “partnership flip” structure.
-
Key Features: Integrates a tax equity investor and back-leverage debt to reflect realistic project cash flows and investor returns.
-
Intended Use: Offers a foundational view of tax equity deal dynamics for educational and conceptual analysis.
-
Limitations: Does not include waterfall distributions, sponsor equity returns, or detailed depreciation schedules.
Personal Finance Models
These custom-built Excel tools leverage advanced techniques and VBA Macros to support personal budgeting, financial tracking, and long-term financial planning. Each model is designed to simplify complex financial decisions and improve accessibility for users with varying levels of experience.
-
Purpose: Tracks assets, liabilities, and equity for holistic personal financial management.
-
Key Features: Includes a user-friendly dashboard, net worth calculator, and monthly tracking tools.
-
Intended Use: Ideal for users seeking a flexible budgeting and financial literacy tool.
-
Extras: Macro-enabled version with enhanced automation available upon request.
-
Purpose: Compares multiple real estate investment opportunities side by side.
-
Key Features: Analyzes rental properties, leases, and homeownership options with dynamic assumptions.
-
Intended Use: Designed for users evaluating "rent vs. buy" scenarios or rental property investment.
-
Extras: Includes side-by-side ROI comparisons and customizable benchmarks.
-
Purpose: Supports portfolio evaluation, options pricing, and wealth forecasting.
-
Key Features: Includes Sharpe Ratio maximizer, Black-Scholes calculator, and Monte Carlo simulation.
-
Intended Use: Built for advanced users and investors exploring quantitative strategies.
-
Extras: Modular design allows for custom inputs and comparative performance charts.
-
Purpose: Calculates student loan balances, paydown timelines, and interest costs.
-
Key Features: Runs custom scenarios with different interest rates, monthly payments, and terms.
-
Intended Use: Designed for individuals managing debt without finance experience.
-
Extras: Helps reduce stress through clear payoff planning and timeline visualization.
-
Purpose: Teaches personal finance fundamentals to beginners, including high school and ESL learners.
-
Key Features: Covers budgeting, debt management, tax prep, and basic investing principles.
-
Intended Use: Education-focused slide deck for classrooms, workshops, or personal learning.
-
Extras: Accessible language and visual aids for non-native speakers and younger learners.