I like the simplicity of the =LOOKUP function. You give it a lookup value and an range, and it returns a result. It doesn’t matter if the range is formatted vertically or horizontally, the function first looks vertically, and if it doesn’t find anything, it looks horizontally. So, in this way it’s simpler than […]
Here is Bruce Berkowitz talking about General Growth and the reorganizing process under bankruptcy
In the mortgage world, LTV refers to the Loan To Value ratio. This is a simple, straightforward calculation. If you borrow $300,000 to buy a home that is worth $400,000, then the LTV is 75%. In the world of Marketing, however, LTV refers to the Lifetime Value of a customer. Here the calculations are a […]
I think this is one of the most important lessons of the course. This chart is clickable. The starting base case is an asset that pays a 10% yield, that is purchased with 75% debt at 8%.
Yahoo’s CEO Marissa Mayer said last October that she would communicate back to shareholders by the next earnings release on Jan. 27 with the company’s plans for the rest of its Alibaba holding. Here’s a story that describes the current situation. Also, below is a very simple analysis of Yahoo. Start with the value of the company […]
AT&T sells the current iPhone for a subsidized price of about $300 ($199 + 40 + tax on $650 is about $300) if you sign up for a 24 month commitment at $80 per month for a 3GB plan. T-mobile sells essentially the same device for $700 ($650 plus tax). If you bring your own device, T-mobile […]
Google Spreadsheets is an interesting product and it is worth getting to know. Instead of doing a specific assignment, please explore the Google Spreadsheet interface and produce a page or two demonstrating a few interesting features of Google Spreadsheets does that Excel does not do natively.
Part of learning a language involves organizing and categorizing large numbers of vocabulary words. When I was a Middlebury Student, I remember using Excel to create lists of vocabulary words for my French class. Here’s a workbook that I put together, including the VBA code, that reaches out to the web and pulls down […]
Thanks for getting involved at the beginning stages of ‘Project Ecuador’. I know that this is your first software development project, but you’ll be in good company. There will be about 20 people which will be working on the project. Senior management has asked us for a project plan, and as project lead, I need […]
Visual Basic is a Microsoft product. So, it should come as no surprise that Google Sheets do not support Visual Basic. Instead, Google Sheets support JavaScript. If you’re interested in this area, you may want to check out this sample book, or buy the full book which offers examples of how to use JavaScript to write custom […]
Financial Modeling and Data Analysis 
Recent Comments