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