Colin Ferrian
Co-Founder & CEO at deepgreen Follow 21

• views 3.8k
• users 264
• reviews 20
• Downloadable Best Practices 3

•  
• free

Colin Ferrian

Co-Founder & CEO at deepgreen

Discuss with Colin Ferrian!

mailPrivate message

Follow 21

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

• 

  Raising Capital

• 

  Debt Schedule

• 

  Valuation Models

• 

  Discounted Cash Flow (DCF)

• 

  Scenario Analysis

• 

  Software-as-a-Service (SaaS)

• views 3.8k
• users 264
• 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

  6722add_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

  2,676Discussadd_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

  4212add_shopping_cart

  free

Publish your own Best Practice

People using these Best Practices also downloaded

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

  2,955Discussadd_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,092Discussadd_shopping_cart

  free

  by Aswath Damodaran
• 

  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,154Discussadd_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,078Discussadd_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

  6,143Discussadd_shopping_cart

  free

  by Michael Dempsey
• 

  SaaS Financial Plan

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

  roadmapsalesmarketingfinancemodel

  9,966Discussadd_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

  22,8127add_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,4902add_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,0401add_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,475Discussadd_shopping_cart

  free

  by Ryan Carson
• 

  Venture Capital Method (Single Round Financing)

  A full model enabling an entrepreneur to understand assumptions of both sides of the table in a single round financing

  investmentfinancevaluationfinancingventure capital

  15,2824add_shopping_cart

  free

  by Richard L. Smith
• 

  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,463Discussadd_shopping_cart

  free

  by Lindsay Meyer
• 

  Combination Model

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

  combinationimpactfinancemergersm&a

  7,0214add_shopping_cart

  free

  by John P. Burns
• 

  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

  37,6687add_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,2672add_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

  29,6521add_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,564Discussadd_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,199Discussadd_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,522Discussadd_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,018Discuss

  free

  by Ronald Moy
• 

  Powerful and Customizable Debt Module Excel Model

  Powerful, highly customization and free debt calculations module.

  debtinterestexcelspreadsheetprincipal

  1,713Discussadd_shopping_cart

  $19.00

  by Alex Martyanov
• 

  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,343Discussadd_shopping_cart

  free

  by Wall Street Prep

+ More Best Practices

Discuss with Colin Ferrian

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

Post Comment