Co-Founder & CEO at deepgreen

Discuss with Colin Ferrian!

mailPrivate message

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

analyticsdcfdebtdiscounted cash flowequityexit valuationfundraisingmodelpublic equitiespublic valuation

Website

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

Colin Ferrian's Channel: methods and tools

• 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 flowscenario analysispublic equitiespublic valuation

  341 remove_red_eyeDiscuss

  free
• 

  Analytics Software Platform Pro Forma Excel Model

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

  debtfundraisingsaasanalyticssoftwareexit valuationsoftware services

  139 remove_red_eye2 chat_bubble

  free

Publish your own tool

People using these tools also downloaded

Business Tools Downloaded & Rated by Colin Ferrian

• 

  Merger & LBO Model Valuation Excel

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

  financemodelfirmmergersleveraged buyoutlbolbo analysis

  4,564 remove_red_eyeDiscuss

  freeby 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-stageraising capitalbusiness modelingsaasseedseries a

  2,200 remove_red_eyeDiscuss

  freeby Brandon Marker
• 

  Freemium Business Model

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

  financemodelingfinancial modelstartupsventure capitalraising capitalfreemiumuser acquisitionuser activationentrepreneur

  2,424 remove_red_eyeDiscuss

  freeby Giff Constable
• 

  Liquidation Model - Waterfall Analysis

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

  financestartupsventure capitalraising capitalliquidation preferencesfinancial distributionventuresexitsliquidation modelwaterfall analysis

  2,068 remove_red_eyeDiscuss

  freeby Michael Dempsey
• 

  SaaS Financial Plan

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

  roadmapsalesmarketingfinancemodelstartupsraising capitalsaaschartsfinancial plan

  4,198 remove_red_eyeDiscuss

  freeby Christoph Janz
• 

  SaaS Financial Model

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

  financefinancial modelstartupearly-stageraising capitalsaasassumptionsmrrcacarr

  1,827 remove_red_eye2 chat_bubble

  freeby 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 capitalseries acap tableseries bownershipshareholders

  1,978 remove_red_eyeDiscuss

  freeby S3 Ventures
• 

  SaaS Model & KPIs

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

  business modelfinancial modelstartupsearly-stagelifetime valuecustomer acquisitionsaaskey metrics

  1,442 remove_red_eyeDiscuss

  freeby 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 capitalassumptionsentrepreneursingle roundunstaged investmentstaged investment

  6,722 remove_red_eyeDiscuss

  freeby 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 tablereturns analysisround bcommon stockpre-moneypost-money

  830 remove_red_eyeDiscuss

  freeby Lindsay Meyer
• 

  Startup Excel Model

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

  financecash flowprivate equityfinancial modelstartupfundraisingventure capitalassumptionscapexheadcount

  11,161 remove_red_eye4 chat_bubble

  freeby Robert H. Hacker
• 

  Startup Financial Plan Template

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

  planinvestmentfinancialmodelstartuptemplatefundingfinancial forecastongoingdocument

  822 remove_red_eye2 chat_bubble

  freeby 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.

  cogsstatementexpensesstartuptemplateexcelcashflowprice and loss

  7,299 remove_red_eye1 chat_bubble

  freeby 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 modeltemplateexcelspreadsheetfreedownloadvirtual worldgaming

  453 remove_red_eyeDiscuss

  freeby Matthew Warneford
• 

  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

  205 remove_red_eyeDiscuss

  freeby 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

  42 remove_red_eyeDiscuss

  freeby Ronald Moy

+ More business tools

Colin Ferrian's Community of Users

keyboard_arrow_downShow more

Discuss with Colin Ferrian

Ask Colin Ferrian questions about his/her work or tools. Go ahead!

Post Comment