Muschamp Rd

Posts about Microsoft Excel

CFA® Level 1 Problem Set

Thursday, May 8th, 2008

When I was a younger more naive CFA Candidate I created a bunch of study materials for my study group…

Read on McDuff »

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 »

Excel Tips & Tricks

Saturday, November 4th, 2006

I’m pretty much self taught as far as Excel goes. I learned how to use Microsoft Word and PowerPoint better in my technical writing class at UVIC. I was surprised just how weak some people are at using Microsoft Word during my MBA program…

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.