Colin Ferrian
Co-Founder & CEO at deepgreen

• views 1.8k
• users 135
• 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

• 

  Debt Schedule

• 

  Valuation Models

• 

  Discounted Cash Flow (DCF)

• 

  Scenario Analysis

• 

  Software-as-a-Service (SaaS)

• 

  Raising Capital

• views 1.8k
• users 135
• 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

  dcfdiscounted cash flowequitymodelpublic equities

  1,444Discuss

  $20.00
• 

  Analytics Software Platform Pro Forma Excel Model

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

  analyticsdebtexit valuationfundraisingsaas

  2412

  free
• 

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

  Fastest model for building a forecast for your startup.

  one pagerproformastart-upstartup forecaststartups

  84Discuss

  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.

  combined firmindependent firmsmergerssynergyvaluation

  1,638Discuss

  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.

  financefirmlbolbo analysisleveraged buyout

  6,770Discuss

  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

  business modelingearly-stageentrepreneurshipfinancefinancial model

  4,588Discuss

  free by Brandon Marker
• 

  Freemium Business Model

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

  entrepreneurfinancefinancial modelfreemiummodeling

  2,892Discuss

  free by Giff Constable
• 

  Liquidation Model - Waterfall Analysis

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

  exitsfinancefinancial distributionliquidation modelliquidation preferences

  2,788Discuss

  free by Michael Dempsey
• 

  SaaS Financial Plan

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

  chartsfinancefinancial planmarketingmodel

  6,896Discuss

  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!

  financeinvestment bankinglboleveraged buyoutm&a

  14,5407

  free by Business-Valuation.net
• 

  SaaS Financial Model

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

  arrassumptionscacearly-stagefinance

  2,2732

  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

  cap tablefinancingownershipraising capitalseries a

  4,6811

  free by S3 Ventures
• 

  SaaS Model & KPIs

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

  business modelcustomer acquisitionearly-stagefinancial modelkey metrics

  1,809Discuss

  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

  assumptionsentrepreneurfinancefinancinginvestment

  11,200Discuss

  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)

  cap tablecommon stockfinanceoption pooloptions

  1,054Discuss

  free by Lindsay Meyer
• 

  Combination Model

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

  acquisitionscombinationfinancefinancial statementsimpact

  4,1444

  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.

  assumptionscapexcash flowfinancefinancial model

  23,2596

  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.

  documentfinancialfinancial forecastfundinginvestment

  1,2072

  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.

  cashflowcogsexcelexpensesprice and loss

  16,0251

  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 plandownloadexcelfreefreemium

  763Discuss

  free by Matthew Warneford
• 

  Merger Model - Consolidation of Two Companies

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

  acquisitionsbalance sheetcashconsolidationfinancial assumptions

  336Discuss

  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.

  balance sheetfinanceincome statementprofit and loss

  812Discuss

  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.

  balance sheetfinancefinancial positionfinancial statementincome statement

  134Discuss

  free by Ronald Moy
• 

  Powerful and Customizable Debt Module Excel Model

  Powerful, highly customization and free debt calculations module.

  amortizationannuitydebtexcelgrace period

  420Discuss

  $19.00 by Alex Martyanov

+ More business tools

Discuss with Colin Ferrian

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

Post Comment