SmartHelping / Interest Rate Analysis / Excel
Interest Rate Swap Financial Model
Compare fixed and floating interest cash flows under your own rate assumptions. See payment timing, which side pays or receives, and how the net present value of each leg develops over time.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & workbook preview
See how the two sides compare.
Review the rate inputs, payment schedules, and valuation charts before entering your own assumptions.
Inputs you control
Set the terms and the expected rate path.
Explore how the starting rates, direction of future changes, and timing of those changes affect the projected cash flows.
Notional amount & fixed rate
Enter the notional amount used to calculate interest payments and the fixed interest rate for the comparison.
Payment timing & duration
Set the first payment date, payment schedule, and total number of years the swap lasts.
Starting floating rate
Choose the initial variable rate. The original model refers to this input as Starting LIBOR.
Rate changes & start period
Enter the expected percentage change per period, positive or negative, and the period when those changes begin.
The model's comparison
One notional amount. Two streams of interest cash flow.
The model compares fixed and variable interest cash flows over the same time horizon. It assumes a constant notional amount and matching payment dates for both sides.
Change your floating-rate assumptions to see how the projected payment amounts and present values respond. The results reflect the rate path you enter.
Cash flows & visual comparisons
Review payments and value over time.
See both the timing of cash movements and the cumulative effect of your assumptions.
Fixed and floating legs
Compare the two sets of interest cash flows using the same notional amount, payment schedule, and swap duration.
Accumulated present value
Use the NPV chart to compare the accumulated discounted value of the fixed and variable legs over time.
Undiscounted cash flows
Review the separate chart showing the non-discounted value of each leg over time alongside the present-value comparison.
Payments by period
The payment schedule and accompanying chart show when cash changes hands and whether the fixed or variable side pays or receives.
A straightforward scenario workflow
Change the rate path, then compare the results.
-
Establish the swap terms
Enter the notional amount, fixed rate, first payment date, payment schedule, and duration.
-
Define your floating-rate assumptions
Set the starting variable rate, expected change per period, and the period when the rate begins changing.
-
Review cash flows and present values
Compare payments, receipts, and charts. Adjust your assumptions to explore an alternative rate scenario.
Also available in bundles
Expand your financial analysis toolkit.
The Interest Rate Swap Financial Model is also included in these collections.
Valuation and DCF Analysis Bundle
Explore spreadsheets for business valuation, discounted cash flow, acquisition analysis, discount rates, and investment returns.
Explore the valuation bundle →Lending and Credit Models Bundle
Explore models for lending operations, loan portfolios, credit facilities, amortization, securitization, and investor returns.
Explore the lending bundle →Questions before you buy
A few useful details.
What does the model compare?
It compares fixed and floating interest cash flows over the same period using a constant notional amount and matching payment dates. Outputs include present values, undiscounted cash flows, and payments by period.
Can I change when the floating rate starts moving?
Yes. You can enter the starting floating rate, the expected percentage change per period, and the period when that change begins.
Does it show which side pays or receives?
Yes. The payment schedule and chart show the timing of payments and whether the fixed or variable side is paying or receiving.
Why does the original model refer to LIBOR?
The original model and walkthrough use LIBOR terminology for the floating-rate assumptions. LIBOR publication ended on September 30, 2024. This template is described here as a scenario model using your rate assumptions; review its rate and payment conventions before adapting it to another benchmark. See the FCA's LIBOR announcement.
What is the price and file format?
The one-time price is $45 USD for the Excel model. The download is available immediately after purchase.
Make the cash flows easier to see
Compare fixed and floating rate scenarios in Excel.
Get the Interest Rate Swap Financial Model. Have a question? Contact SmartHelping.
