I’ve created a third Excel spreadsheet that can be used to value a company. All three are slightly different, though they all can be used to value a company as a venture capitalist might. All three use the classic VC method which uses the total market size, the company’s market share, and the operating margin at the time of exit to figure out first the terminal net income, then the terminal value and finally the present value…

In between power outages I’ve been working on improving my ability to use VBA in Excel…

With all my recent readings on Excel I figured I should make something that didn’t have anything to do with my hockey pool. So I decided to make an easy to use spreadsheet for valuing a company, determining how large of investment results in what percentage of ownership, shares to issue, share price, etc….

Last night I attended a guest speaker session at the Tsinghua School of Economics and Management. It was given by Xue Jun (薛军) of the Tsinghua Science Park…