Skip to content
Rob's 2700 Notes

🔎 Coffee Shop Spreadsheet

The goal of this spreadsheet is to illustrate all of the calculations in the Coffee Shop example.

In particular it illustrates all of the numbers in both of the following images:

Microsoft Excel Workbook
Coffee Shop Example - Full Breakdown
A table from Bruce's lecture that includes the market value and return on investment for debt, unlevered equity, and levered equity. A graph that illustrates the numbers from the previous table.