Excel modeling library
These eight files use fictional course inputs. Blue cells are hardcoded assumptions and black cells contain formulas. There are no external workbook links. Instructor formula cells are protected against accidental edits; sheets can be unprotected without a password for study. This protection is not encryption or access control.
| Course | Student construction file | Completed solution |
|---|---|---|
| 1 — Harbor DCF ($000) | Learner workbook | Instructor workbook |
| 2 — Vanguard normalization (USD) | Learner workbook | Instructor workbook |
| 3 — Precision financing (USD) | Learner workbook | Instructor workbook |
| 4 — Apex negotiation (USD) | Learner workbook | Instructor workbook |
Start with the learner file, which contains source assumptions, labels and yellow blank analytical cells. The instructor file supplies those formulas. Do not paste an answer into a blank when the exercise requires a formula. The complete sheet/cell task map is in the repository's audit/workbook_manifest.json.
Course 1's scenario switch selects base or downside operations. Its WACC illustration is separately calculated; the packet's 20% DCF rate is an explicit case assumption. Course 3 supports a revenue shock and an optional reset to the stress rate after month 12, reamortizing the remaining balance over 108 months. Course 4's customer-loss fraction drives a selected scenario alongside the base/half/full comparisons. Course 2 permits direct changes to growth, recurring costs, debt and distributions.
The spreadsheets were generated with openpyxl, which does not calculate formulas. The formulas evaluator actually evaluates every instructor formula and the key results are compared against independent Python reference models. Numeric caches in the instructor files come from that evaluator. Excel and LibreOffice were not installed; native application recalculation and GUI rendering remain unverified. Recalculate when opening in your spreadsheet application and inspect Model checks. Formula changes require fresh recalculation; cached values alone are not proof of a current result.
The annual liquidity models do not invent monthly customer collections that the packet never supplies. Develop a monthly or 13-week forecast before underwriting actual operating cash minima. Policy statements are a dated educational snapshot, not a lender commitment.