Colin Ferrian
Co-Founder & CEO at deepgreen Follow 21

• views 4.7k
• users 278
• reviews 20
• Downloadable Best Practices 3

•  
• free

Colin Ferrian

Co-Founder & CEO at deepgreen

Discuss with Colin Ferrian!

mailPrivate message

Follow 21

mail

Hire Me!

Bio

I'm a financial analyst with experience in equity research, buy-side equities, and most recently, M&A and partnership strategy in emerging technology and the internet-of-things.

Education

• St. Olaf College A college that can change lives.

Tags

analyticspublic valuationvaluationstartupsstartup forecaststart-upsoftware servicessoftwarescenario analysissaas

Website

https://seekingalpha.com/author/colin-ferrian/articles#regular_articles

Social

Categories

• 

  Startup Financial Models

• 

  Software-as-a-Service (SaaS)

• 

  Raising Capital

• 

  Debt Schedule

• 

  Valuation Models

• 

  Discounted Cash Flow (DCF)

• 

  Scenario Analysis

• views 4.7k
• users 278
• reviews 20
• Downloadable Best Practices 3

• free

• 

  One Pager | An Easy to Use, Working Model for Startups

  Fastest model for building a forecast for your startup.

  startupsstart-upproformaworking modelone pager

  9522add_shopping_cart

  $20.00
• 

  DCF Model with Bear and Bull Scenarios in Excel

  A DCF model built for public equity valuations, with a bull and bear scenario analysis to evaluate upside/downside risk

  modelvaluationequitydcfdiscounted cash flow

  3,292Discussadd_shopping_cart

  $20.00
• 

  Analytics Software Platform Pro Forma Excel Model

  Detailed excel model for analytics software and service platform, including debt schedules and exit valuation

  debtfundraisingsaasanalyticssoftware

  4752add_shopping_cart

  free

Publish your own Best Practice

Best Practices Downloaded & Rated by Colin Ferrian

• 

  Merger Synergy Valuation Excel Model

  This Excel Model estimates the value of synergy in a merger.

  synergyvaluationmergersindependent firmscombined firm

  3,360Discussadd_shopping_cart

  free

  by Aswath Damodaran
• 

  Merger & LBO Model Valuation Excel

  This LBO model in excel analyzes the value of equity and the firm in a leveraged buyout operation.

  financemodelfirmmergersleveraged buyout

  10,473Discussadd_shopping_cart

  free

  by Aswath Damodaran
• 

  Leveraged Buyout LBO Model - DCF

  A comprehensive LBO model in Excel, of business acquisition

  acquisitionbusinessfinanceleveraged buyoutirr

  4,5504add_shopping_cart

  free

  by Amit Tandon
• 

  Early Stage SaaS Financial Model

  Get up to speed on a SaaS Financial Model with a template and its step by step instructions

  financefinancial modelentrepreneurshipstartupsearly-stage

  7,417Discussadd_shopping_cart

  free

  by Brandon Marker
• 

  Freemium Business Model

  Customize a ready-made financial model for your Freemium Web Services Business

  financemodelingfinancial modelstartupsventure capital

  4,409Discussadd_shopping_cart

  free

  by Giff Constable
• 

  Liquidation Model - Waterfall Analysis

  Educate employees, founders, and others in how liquidation preferences affect financial distribution in exit scenarios

  financestartupsventure capitalraising capitalliquidation preferences

  7,3071add_shopping_cart

  free

  by Michael Dempsey
• 

  SaaS Financial Plan

  A financial plan template for SaaS startups based on a model created for Zendesk

  roadmapsalesmarketingfinancemodel

  10,260Discussadd_shopping_cart

  free

  by Christoph Janz
• 

  LBO model - Leveraged Buyout Analysis

  A step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!

  financevaluationleveraged buyoutprivate equityinvestment banking

  24,1338add_shopping_cart

  $9.00

  by Patrik Johansson
• 

  SaaS Financial Model

  A simple 12-month SaaS financial model customisable to your startup precise conditions and needs.

  financefinancial modelstartupearly-stageraising capital

  3,7092add_shopping_cart

  free

  by Nicholas Petroski
• 

  S3 Cap Table Template

  A cap table file to help entrepreneurs structure and understand their financing rounds and increase their performance

  valuationfinancingstartupsventure capitalraising capital

  8,3351add_shopping_cart

  free

  by S3 Ventures
• 

  SaaS Model & KPIs

  A simple model to define and track your key metrics as a SaaS Startup

  business modelfinancial modelstartupsearly-stagelifetime value

  2,577Discussadd_shopping_cart

  free

  by Ryan Carson
• 

  Dummy Cap Table & Returns Analysis - Round B

  Example Pro Forma Cap Table for a Series B company (three tranches of A, plus warrants)

  financevaluationoptionsoption poolcap table

  1,639Discussadd_shopping_cart

  free

  by Lindsay Meyer
• 

  Leveraged Buyout LBO Model Template

  A full Leveraged Buyout LBO model template for a project to understand its different components and work with your own.

  financevaluationleveraged buyoutdcfwacc

  7,7252add_shopping_cart

  free

  by John P. Burns
• 

  Combination Model

  A 22 section excel model to assess the impact on the financials of the combination of companies

  combinationimpactfinancemergersm&a

  7,4134add_shopping_cart

  free

  by John P. Burns
• 

  Leveraged Buyout LBO Model

  A fully customizable excel LBO model to assess the debt level your firm can take in a deal & expected investor returns

  mergersleveraged buyoutprivate equitylbom&a

  4,682Discussadd_shopping_cart

  free

  by Firmex
• 

  Startup Excel Model

  A startup financial model that can be sent to a Venture Capital, Private Equity Firm or Hedge Fund.

  financecash flowprivate equityfinancial modelstartup

  38,3267add_shopping_cart

  free

  by Robert H. Hacker
• 

  Startup Financial Plan Template

  Ongoing document made to guide you in running your business, when in need of funding or financing.

  planinvestmentfinancialmodelstartup

  2,5002add_shopping_cart

  free

  by Serious Funding
• 

  Startup Pro-forma Profit and Loss statement (P&L) Template

  Made to help you construct a high level operation plan for your startup.

  cogsstatementexpensesstartuptemplate

  32,3591add_shopping_cart

  free

  by Charlie Tillett
• 

  Virtual World Freemium Business Model Template

  A business model excel spreadsheet to help companies make business decisions and understand how variables interact.

  business planstartupfreemiumrevenue modeltemplate

  1,753Discussadd_shopping_cart

  free

  by Matthew Warneford
• 

  Merger Model - Consolidation of Two Companies

  Financial Model for a business merger focussing on the consolidation of two companies.

  income statementmergersbalance sheetcashm&a

  1,404Discussadd_shopping_cart

  $5.00

  by Prof. Ed Bodmer
• 

  Income Statement and Balance Sheet Template

  A one year income statement and balance sheet suitable for both established and startup businesses.

  income statementfinancebalance sheetprofit and loss

  1,751Discussadd_shopping_cart

  free

  by Lift Fund
• 

  Balance Sheet and Income Statement

  Ronald Roy talks you through the two most commonly-used financial statements: the income statement and balance sheet.

  income statementfinancebalance sheetfinancial statementfinancial position

  1,062Discuss

  free

  by Ronald Moy
• 

  Powerful and Customizable Debt Module Excel Model

  Powerful, highly customization and free debt calculations module.

  debtinterestexcelspreadsheetprincipal

  2,234Discussadd_shopping_cart

  $19.00

  by Alex Martyanov
• 

  Simple Leveraged Buyout (LBO) Model Excel Template + Instructions

  Excel model tutorial for building a detailed Leveraged Buyout Analysis.

  leveraged buyoutdebt schedulelbohow tolbo analysis

  2,673Discussadd_shopping_cart

  free

  by Wall Street Prep
• 

  M&A Model - Accretion Dilution Excel Model Template + Instructions

  Excel training model for mergers and aquisiton and accretion/dilution analysis

  dilutionaccretiontarget companyacquiring companyexcel skills

  1,685Discussadd_shopping_cart

  free

  by Wall Street Prep
• 

  LBO (Leveraged Buyout) Excel Model

  Complete LBO (Leveraged Buyout) model for financial analysis of potential investments and acquisitions.

  investmentfinanceleveraged buyoutprivate equityinvesting

  2,365Discussadd_shopping_cart

  free

  by DW Financial Services

+ More Best Practices

Discuss with Colin Ferrian

Ask Colin Ferrian questions about their Best Practices. Go ahead!

Post Comment