Colin Ferrian
Co-Founder & CEO at deepgreen

• views 1.9k
• users 139
• reviews 13
• tools 3

•  
• free

Colin Ferrian

Co-Founder & CEO at deepgreen

Discuss with Colin Ferrian!

mailPrivate message

Follow 17

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.

Tags

analyticspublic valuationvaluationstartupsstartup forecaststart-upsoftware servicessoftwarescenario analysissaas

Website

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

Social

Categories

• 

  Startup Financial Models

• 

  Scenario Analysis

• 

  Software-as-a-Service (SaaS)

• 

  Raising Capital

• 

  Debt Schedule

• 

  Valuation Models

• 

  Discounted Cash Flow (DCF)

• views 1.9k
• users 139
• reviews 13
• tools 3

• free

• 

  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

  1,556Discuss

  $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

  2612

  free
• 

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

  Fastest model for building a forecast for your startup.

  startupsstart-upproformaworking modelone pager

  95Discuss

  free

Publish your own tool

People using these tools also downloaded

Business Tools Downloaded & Rated by Colin Ferrian

• 

  Merger Synergy Valuation Excel Model

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

  synergyvaluationmergersindependent firmscombined firm

  1,771Discuss

  free by Prof. 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

  7,350Discuss

  free by Prof. 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

  5,068Discuss

  free by Brandon Marker
• 

  Freemium Business Model

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

  financemodelingfinancial modelstartupsventure capital

  3,041Discuss

  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

  3,064Discuss

  free by Michael Dempsey
• 

  SaaS Financial Plan

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

  roadmapsalesmarketingfinancemodel

  7,612Discuss

  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

  15,8267

  free by Business-Valuation.net
• 

  SaaS Financial Model

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

  financefinancial modelstartupearly-stageraising capital

  2,4562

  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

  5,3491

  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

  1,933Discuss

  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

  12,3153

  free by Prof. Moana Vercoe
• 

  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,103Discuss

  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

  4,6644

  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

  27,1856

  free by Prof. 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

  1,3112

  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

  17,5561

  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

  860Discuss

  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

  390Discuss

  free 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

  919Discuss

  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

  138Discuss

  free by Ronald Moy
• 

  Powerful and Customizable Debt Module Excel Model

  Powerful, highly customization and free debt calculations module.

  debtinterestexcelspreadsheetprincipal

  485Discuss

  $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

  434Discuss

  free by Wall Street Prep

+ More business tools

Discuss with Colin Ferrian

Ask Colin Ferrian questions about their work or tools. Go ahead!

Post Comment