Financial Modeling Learning Series
Download the Financial Modeling Resource Book Created by Paul Barnhurst
List of Articles in the Series
Learn more about the person responsible for this series Lance Rubin and his company Model Citizin
Mindset of Embracing the grey
Link: Article 1 of SS to FM- Mindset of embracing the grey | LinkedIn
Written by: Lisa Barham and Lance Rubin
The History of Spreadsheets & Financial Modeling
Link: The History of Spreadsheets & Financial Modelling | LinkedIn
Written by Dave Theron, Colin Human, Lance Rubin
Excel Spreadsheet vs. Excel model for FP&A
Link: Excel Spreadsheet vs Excel Model for FP&A | LinkedIn
Written by Cindy Rogers and Lance Rubin
Deal Models vs. Operational Model
Link: Deal Model vs Operational Model | LinkedIn
Written by Ruby Liu and Lance Rubin
Table Based Financial Modelling (TBFM)
Link: Table Based Financial Modeling | LinkedIn
Written by: Craig Hatmaker and Lance Rubin
ProjectFin deals vs. Other deal models
Link: Project Finance vs other Deal Modelling | LinkedIn
Written by: Matthew Bernath and Lance Rubin
Project Finance Operational models
Link: Project Finance operational models | LinkedIn
Written by: Mehid Assadi-Moghadam, Matthew Bernath and Lance Rubin
Fundamentals of 3-way cashflow modelling
Link: Fundamentals of 3-way cashflow modelling | LinkedIn
Written by: Furgan Baig and Lance Rubin
SaaS Startup financial models
Link: SaaS Financial Modelling | LinkedIn
Written by Chironjit Das and Lance Rubin
Scoping a Financial Model Built Primarily for Business Valuation
Link: Scoping a financial model built primarily for business valuation | LinkedIn
Written By: Joris Kersten and Lance Rubin
Financial Model Development
Link: Financial Model Development | LinkedIn
Written By: David Thompson and Lance Rubin
User Friendliness in Financial Modeling
Link: User Friendliness in Financial Modelling | LinkedIn
Written By: David Thompson and Lance Rubin
Corporate Finance Theory and Modelling
Link: Corporate Finance Theory and Modelling | LinkedIn
Written By: David Thompson and Lance Rubin
Data Sourcing for Financial Modeling
Link: Data Sourcing for Financial Modeling | LinkedIn
Written By: Paul Barnhurst and Lance Rubin
Workbook structure and hyperlinks for Financial Models
Link: Workbook Structure and Hyperlinks for Financial Models | LinkedIn
Written By: Jennifer Harrison and Lance Rubin
Best Practice Formula Construction for Financial Modeling
Link: Best Practice Formula Construction for Financial Modelling | LinkedIn
Written By: Jennifer Harrison and Lance Rubin
Error Checks for Excel and Financial Modeling
Link: Error checks for Excel and Financial Modelling | LinkedIn
Written By: Maarten Bessems and Lance Rubin
Special Edition: Financial Modeling for COVID-19 Uncertainty
Link: Special Edition: Financial Modelling for COVID-19 Uncertainty | LinkedIn
Written by: Danielle Stein Fairhurst and Lance Rubin
Model Audit and Model Review - Can I rely on this model?
Link: Model Audit and Model Review - Can I rely on this model? | LinkedIn
Written By: Ian Bennett and Lance Rubin
Special Edition: Dynamic Arrays
Link: How Dynamic Arrays are Revolutionising Financial Modelling | LinkedIn
Written By: Jeff Robson and Lance Rubin
Knowledge Regression in FP&A and Financial Modelling (And How We All Fix it Together)
Link: Knowledge Regression In FP&A and Financial Modelling (And How We All Fix It Together) | LinkedIn
Written By: Rob Trippe, Andrew Codd, and Lance Rubin
Developing a Portfolio of Key Performance Indicators (KPIs)
Link: DEVELOPING A PORTFOLIO OF KEY PERFORMANCE INDICATORS (KPIS) | LinkedIn
Written By: Betsy Maclean and Lance Rubin
How Sensitive is Your Model to Impacts?
Link: How sensitive is your model to impacts? | LinkedIn
Written By: Carl Seidman and Lance Rubin
Scenarios Analysis the Best Cure for Sensitivity
Link: Scenario Analysis the best cure for uncertainty | LinkedIn
Written By: Carl Seidman and Lance Rubin
Simulations
Link: Roll the dice many times with Monte Carlo Simulation and achieve better decision making | LinkedIn
Written By: Kerry Mayes and Lance Rubin
Macros/VBA
Link: VBA might be dying but it ain’t dead | LinkedIn
Written By: Benjamin Stoter, Marcus Small, and Lance Rubin
Getting a Financial Modelling Qualification
Link: Getting a Financial Modelling Qualification | LinkedIn
Written By: Danielle Stein Fairhurst, Mohamed Mostafa, Lance Rubin
The World Cup of Financial Modeling (FMWC E-sports)
Link: Financial Modelling as a Sport | LinkedIn
Written By: Lance Rubin
Automation in Modelling
Link: Automation in modelling | LinkedIn
Written By: Benjamin Stoter and Lance Rubin
How Financial Models Can Turn Lives Around
Link: How Financial Models can turn lives around | LinkedIn
Written By: Russ Wood, Alex Artajaya, and Lance Rubin
Visual Influence and Story Telling
Link: Visual Influence and Storytelling | LinkedIn
Written By: Aaron Parry, Jeffo Robson & Lance Rubin
Excel, Analytics & Power BI
Link: Excel, Analytics & Power BI - Perfect match for a new King | LinkedIn
Written By: Khaled Chowdhury and Lance Rubin
Google Sheets vs. Excel for Financial Modeling
Link: Google Sheets vs Excel: The ultimate comparison😁 | LinkedIn
Written By: David Benaim and Lance Rubin