Valuation spreadsheet





Factor Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year n
Market size, units -- X X X X X X X X X X
Market share, percent -- X X X X X X X X X X
Market share, units -- X X X X X X X X X X
Unit price, $ -- X X X X X X X X X X
Unit cost, $ -- X X X X X X X X X X
Total annual sales, $ -- X X X X X X X X X X
Net annual sales, $ -- X X X X X X X X X X
Present value, $ X -- -- -- -- -- -- -- -- -- --
Inventors' share, $ X -- -- -- -- -- -- -- -- -- --