Num Sum - web spreadsheet

Export spreadsheet as a HTML table

Here is the html code for spreadsheet: Startup Fundraising Math

Just copy and paste this to your favorite HTML page editor...

<TABLE cellspacing="0" cellpadding="0" width="1012" border="1" id="s1" style="left: 0pt; top: 0pt;" class="spreadsheet">
    <COLGROUP><COL width="154"/><COL width="87"/><COL width="89"/><COL width="82"/><COL width="100"/><COL width="100"/><COL width="100"/><COL width="100"/><COL width="100"/><COL width="100"/></COLGROUP>
    <THEAD></THEAD><TBODY>
    <TR><TD>&nbsp;</TD><TD style="text-decoration: underline;">Dollars</TD><TD style="text-decoration: underline;">Shares</TD><TD style="text-decoration: underline;">Percentage</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD style="text-decoration: underline;">Before financing</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Founder 1</TD><TD formula="=D3*B5" format="format:'pat',numType:'c',pat:'$#,##0'"><DIV class="spreadsheetCellFormatted">$500,000</DIV></TD><TD format="format:'pat',numType:'c',pat:'#,##0'" formula="=D3*C5"><DIV class="spreadsheetCellFormatted">5,000,000</DIV></TD><TD style="background-color: rgb(255, 255, 204); font-weight: bold;" format="format:'pat',numType:'p',pat:'0%'"><DIV class="spreadsheetCellFormatted">50%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Founder 2</TD><TD formula="=D4*B5" format="format:'pat',numType:'p',pat:'$#,##0'"><DIV class="spreadsheetCellFormatted">$500,000</DIV></TD><TD format="format:'pat',numType:'p',pat:'#,##0'" formula="=D4*C5"><DIV class="spreadsheetCellFormatted">5,000,000</DIV></TD><TD style="background-color: rgb(255, 255, 204); font-weight: bold;" format="format:'pat',numType:'p',pat:'0%'"><DIV class="spreadsheetCellFormatted">50%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Pre-money valuation</TD><TD style="background-color: rgb(255, 255, 204); font-weight: bold;" format="format:'pat',pat:'$#,##0'"><DIV class="spreadsheetCellFormatted">$1,000,000</DIV></TD><TD style="background-color: rgb(255, 255, 204); font-weight: bold;" format="format:'pat',pat:'#,##0'"><DIV class="spreadsheetCellFormatted">10,000,000</DIV></TD><TD formula="=D3+D4" format="format:'pat',numType:'p',pat:'0%'"><DIV class="spreadsheetCellFormatted">100%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Amount raised</TD><TD format="format:'pat',pat:'$#,##0'" style="background-color: rgb(255, 255, 204); font-weight: bold;"><DIV class="spreadsheetCellFormatted">$500,000</DIV></TD><TD format="format:'pat',pat:'#,##0'" formula="=B7*C5/B5"><DIV class="spreadsheetCellFormatted">5,000,000</DIV></TD><TD format="format:'pat',numType:'p',pat:'0%'" formula="=B7/B5"><DIV class="spreadsheetCellFormatted">50%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD style="text-decoration: underline;">After financing</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Post-money valuation</TD><TD format="format:'pat',pat:'$#,##0'" formula="=B5+B7"><DIV class="spreadsheetCellFormatted">$1,500,000</DIV></TD><TD format="format:'pat',pat:'#,##0'" formula="=C5+C7"><DIV class="spreadsheetCellFormatted">15,000,000</DIV></TD><TD format="format:'pat',numType:'p',pat:'0%'" formula="=D11+D12+D13"><DIV class="spreadsheetCellFormatted">100%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Founder 1</TD><TD format="format:'pat',pat:'$#,##0'" formula="=B3"><DIV class="spreadsheetCellFormatted">$500,000</DIV></TD><TD format="format:'pat',pat:'#,##0'" formula="=C3"><DIV class="spreadsheetCellFormatted">5,000,000</DIV></TD><TD format="format:'pat',numType:'p',pat:'0%'" formula="=C11/C10"><DIV class="spreadsheetCellFormatted">33%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Founder 2</TD><TD format="format:'pat',pat:'$#,##0'" formula="=B4"><DIV class="spreadsheetCellFormatted">$500,000</DIV></TD><TD format="format:'pat',pat:'#,##0'" formula="=C4"><DIV class="spreadsheetCellFormatted">5,000,000</DIV></TD><TD format="format:'pat',numType:'p',pat:'0%'" formula="=C12/C10"><DIV class="spreadsheetCellFormatted">33%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>Investors</TD><TD format="format:'pat',pat:'$#,##0'" formula="=B7"><DIV class="spreadsheetCellFormatted">$500,000</DIV></TD><TD format="format:'pat',pat:'#,##0'" formula="=C7"><DIV class="spreadsheetCellFormatted">5,000,000</DIV></TD><TD format="format:'pat',pat:'0%'" formula="=C13/C10"><DIV class="spreadsheetCellFormatted">33%</DIV></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    </TBODY>
   </TABLE>

Or, if you'd like to link to this spreadsheet published as a linkable web page, it's URL would be...

Go back to spreadsheet: Startup Fundraising Math.