# Templates

### CAC / LTV Templates

* [Customer Lifetime Value](https://docs.google.com/spreadsheets/d/1YBDqAUNSp2BRw2az6Bif-XhjqVZ_trVz7aFidnXJM-Q/edit#gid=448972285)
* [How to (Actually) Calculate CAC](https://docs.google.com/spreadsheets/d/1k42ndFybND75kjbviKwecrpVXrKolKA0Gdp2xgFeKtU/edit#gid=0)
* [LTV Calculator for Annual Data](https://docs.google.com/spreadsheets/d/12ZjwrhRLBY-pwXP2rtyifaaDhJJWtRXidsCkbOzBPIE/edit#gid=495123181)

### Market Sizing

* [Market Sizing, TAM & Sensitivity Analysis](https://docs.google.com/spreadsheets/d/1mlz8jW240caD9tUGjCUJctsmoOAiOkXUVoWED794Ct4/edit?submissionGuid=8e355115-9210-4ef7-8b3b-ffc539107#gid=0)
* [Total Addressable Market Example](https://www.toptal.com/finance/market-sizing/total-addressable-market-example)

### Market Mapping

* [Market Mapping Template](https://docs.google.com/spreadsheets/d/1uYXSLW7Q9dzvv-gsrPrA94D7eC9e0LdQvTwoRmlqBsg/edit#gid=0)
* [Industry Market Mapping Analysis](https://www.cbinsights.com/research/industry-market-map-landscape/)

### Marketplace Template

* [Two-sided Marketplace Growth Model](https://docs.google.com/spreadsheets/d/1PrCPDPmm269MEUSmExrJtWR0XNxym-LWnJkCrGtzsEs/edit#gid=0)
* [Marketplace KPI Spreadsheet](https://docs.google.com/spreadsheets/d/1K5E1Nzjq4KEvGVv6EysGswTuQm5u21Sa2ugSZewrZqE/edit#gid=1569059121)

### Cap Table & Waterfall Analysis

* [Captable Template](https://docs.google.com/spreadsheets/d/143dck864473cFql4z26h4BBVKQC3Pln6MC8JiRTQOA4/edit#gid=805338951)
* [Waterfall Analysis - 1X Liquidation Preference](https://docs.google.com/spreadsheets/d/17uV4XElVYsGl36_GR44rFeyj1Pe2Qo8dirN6hW2QQ_Y/edit#gid=1233516235)
* [AngelList Rolling Fund Model](https://docs.google.com/spreadsheets/d/1C0GU9w7AlysllFMGnup1XLgiA5QhVqlWrMv6brcmA_U/edit#gid=0)

### SAAS Templates

* [SaaS Metrics Dashboard](https://docs.google.com/spreadsheets/d/18zxx7qzhoPzNf0ZB_PKhfUr4lIljY-EVt4I7-p0Bi3c/edit#gid=0)
* [B2B SaaS Financial Model](https://docs.google.com/spreadsheets/d/1-MBYKQf4j52ND-A2_kkMGb39gZaymReKpJiPUKn8u2k/edit#gid=1617551010)
* [Cohort Analysis Template for early stage SaaS Startups](https://docs.google.com/spreadsheets/d/1Pgg1jMa0BgVFwVgy60CxkJRH4RXpZMGNODOQbXu8PpE/edit#gid=1930402253)
* [SaaS Metrics MRR Dashboard](https://docs.google.com/spreadsheets/d/1MVI8toAkrlmpVEFX2___L8f7R2OLcmFOe43h4F47mLU/edit#gid=224933931)
* [Software Company Operating & Valuation Model Template](https://docs.google.com/spreadsheets/d/1B6XN_0MNrIy9Mw0bYs1Q7ZxhUnT4RGAp_oUHCqUX5tU/edit?inf_contact_key=7daa614a82cbb136bde0534b0cd017e309c74070ac2bf3cfa7869e3cfd4ff832#gid=958837325)
* [SaaS Financial Model](https://docs.google.com/spreadsheets/d/1nj0LtyG6Q9HhXk-iaj9-3taT9gwWpF8XnxYahpn--to/edit#gid=268326096)
* [Operating SaaS Model](https://my.causal.app/models/1378)

### Valuation Methodology

* [Venture Capital Method](https://docs.google.com/spreadsheets/d/1B-ivgVc5VtXjlbrmA_Fn3r4a8JLidtS6CKCnwQGUnAs/edit#gid=35)
* [Venture Capital Method with Sensitivity Analysis](https://docs.google.com/spreadsheets/d/1yZdI_LIAisn55FTm_pZyUBxvoEBJuVR62oETVlOtczM/edit#gid=0)
* [Venture Capital Method with Dilution](https://docs.google.com/spreadsheets/d/1_rRmZqlknUQcfexT4iDraq4ryi8jT7UnKfX6tHdIIZ0/edit#gid=0)
* [Venture Capital Method with Multiple Rounds](https://docs.google.com/spreadsheets/d/1tz6Otk71OiYDoOm48J1UdRh2ew_MLlqn9gSgip24cJ0/edit#gid=0)
* [Berkus Method](https://docs.google.com/spreadsheets/d/1l4-VFMwcT-IwYwEUs9iittiARPlIBVVqa1HAGmB1l6o/edit#gid=744097724)
* [Scorecard Method](https://docs.google.com/spreadsheets/d/1eSOcs_jqtotcIk_V22TA5o5H9NXrBilh259I4gHllfU/edit#gid=582948892)
* [Equity Valuation Spreadsheets](http://people.stern.nyu.edu/adamodar/New_Home_Page/eqspread.htm)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://vc.shibin.co/vc/modeling-templates-and-resources.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.