Money Multiplier Calculator Excel Template
Money Multiplier Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Calculate the money multiplier and total money supply with this editable Excel template. Includes generalized formula with excess reserves and currency drain.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Calculate the money multiplier and total money supply created through fractional reserve banking with this fully editable Excel template. Perfect for economics students, finance professionals, and anyone studying monetary policy.
What You Can Calculate
This template computes all key money multiplier outputs using the generalized formula that accounts for real-world banking behavior:
- Money Multiplier (m) - The factor by which deposits expand from an initial reserve injection
- Total Money Supply - The equilibrium money supply after the multiplier process completes
- New Money Created - Additional money generated beyond the initial deposit
- Total Deposits - Aggregate deposit balances in the banking system
- Total Reserves - Combined required and excess reserves held by banks
Required Inputs
Enter four parameters to model different monetary scenarios:
- Required Reserve Ratio (rr) - The fraction banks must hold as reserves (note: U.S. requirements are 0% since March 2020)
- Initial Deposit (D) - New reserves entering the banking system
- Excess Reserve Ratio (e) - Voluntary reserves banks hold beyond the requirement
- Currency Drain Ratio (c) - Cash held by the public relative to deposits
Methodology
The template uses the generalized money multiplier formula: m = (1 + c) / (rr + e + c). This accounts for excess reserves and currency drain that reduce the multiplier below the simple textbook value (1/rr). Set e and c to zero to reproduce the classic textbook model.
Assumptions & Limitations
- Calculates steady-state equilibrium values (round-by-round expansion table available in online calculator)
- Does not model interbank lending, Basel III capital requirements, or lending standards
- Assumes consistent bank and public behavior across all rounds
Frequently Asked Questions
No. The Excel template focuses on the steady-state multiplier and final money supply results. The round-by-round expansion table requires dynamic row generation that is better suited to the interactive online calculator. This template gives you the final equilibrium values with fully editable formulas.
Yes, but you must enter a positive value for excess reserve ratio (e) or currency drain (c). With all three ratios at zero, the formula is undefined. Since March 2020, U.S. reserve requirements are 0%, so using the generalized formula with leakage parameters is the realistic approach.
Copy the Calculator sheet and vary one input at a time. For example, create sheets with reserve ratios of 5%, 10%, 15%, 20% to see how the multiplier changes. All formulas reference the input cells, so copying the sheet preserves the calculation structure.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
