Author Archives: jaschro

The Mathematics of Leverage

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%. Advertisements

On the Value of Yahoo!

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 […]

[HW 4.3d] Implied Loans

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 […]

[HW 4.3c] Google Spreadsheets

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.  

[HW 4.3b] Spreadsheets as translation engines

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 […]

[HW 4.3a] Creating a Basic Project Plan

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 […]

VBA for Google Spreadsheets: JavaScript

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 […]

Coding is not the new literacy…

This article is long, but I think it’s worth reading. It’s on the distinction between “coding” and “modeling”.  His thesis is that Modeling is the new literacy.   The author is a progammer who ran the VisualStudio IDE (integrated development environment) business for Microsoft.   http://www.chris-granger.com/2015/01/26/coding-is-not-the-new-literacy/

[HW 4.2a] A Trip to the Casino

A friend has approached you asking for help estimating the winning odds on a heavily modified variation of a popular dice game. His version of the game works as follows: • The player rolls 3 dice, each die has 6 sides • If the total rolled is 3,4,5,16,17 or 18 the player loses • If the […]

[HW 4.2d] Hybrid Cars 

Generally, hybrid cars cost more upfront than their conventional gasoline counterparts.  For example, the 2015 Honda Civic Hybrid lists for  [x] but the non-hybrid 2015 Honda Civic sells for [y].  Of course, the hybrid gets better gas mileage, so the added cost should pay for itself over time.  However, the success of this extra investment […]