Muschamp Rd

Posts about Finance

Break-even Analysis in a Growing Market

Thursday, December 7th, 2006

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…

Read on McDuff »

Break-even Analysis using VBA

Friday, November 17th, 2006

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

Read on McDuff »

Venture Capital Calculations

Thursday, November 9th, 2006

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

Read on McDuff »

Venture Capital In China: Challenge and Opportunity

Friday, October 28th, 2005

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…

Read on McDuff »

Posts on Muskblog © Andrew "Muskie" McKay.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Muskblog. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.