Limited Time Offer - Get Up To 30% OFF

Spreadsheet outlines pricing sheet setup, bootstrapping, conditionality, IRS pricer functions, and related teaching notes.

Step-by-Step Guide to Bootstrapping and
Interest Rates Swaps

This is how analysts on the desks are trained

Join the Market Wizardry ranks at:

Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'
Citibank logo with stylized red arc above the text.'HSBC logo with red and white hexagon symbol.'Two red dice showing a roll of six and one.'Nomura logo in red and black text.'

Get Ahead of Your Competition Today

The spreadsheet guide really helped me understand the theories I had memorized in Business School. I always learnt better by looking through EXCEL formulas and pressing F2 on different cells. What a lifesaver!

**** Wang

Verified Buyer

I was thoroughly impressed with the step-by-step approach this course provided through Excel, vastly improving my understanding of bootstrapping. It was a breath of fresh air versus my dry coursework that I will always appreciate. Thank you MarketWizardry!

**** Sullivan

Verified Buyer

Just ended by internship at a BB, and looking back, I am very grateful for the nuggets of insights this guide has provided me. From knowing what careless mistakes to avoid, to having this in my pocket to impress my team, I am confident of getting a return offer

**** Gupta

Verified Buyer

EXCEL Guide to Bootstrapping & Interest Rates Swaps

WHY IT'S INVALUABLE:

Demystify John Hull and understand the concepts through EXCEL formulas

Bootstrap a real yield curve and build upon it

Learn how to build an Interest Rate Swaps pricing tool from scratch

Contains invaluable teaching notes that tell you what mistakes to avoid and tips to impress

Get ahead of other candidates vying for a permanent role on the trading floor

Microsoft Excel logo in black and white, showing a stylized 'X' and spreadsheet.

EXCEL Driven

Black square, no visible content.

Demystify Textbooks

Unlock Your Mind

Black clock icon showing minute and hour hands in a circular frame.

Start NOW

Concentric black circles on a white background.

Aim to Impress

A square black image.
Money Back Guarantee
EXCEL Guide: Bootstrapping & Interest Rates Swaps

Setup. How an analyst should setup a pricing sheet on EXCEL, includes important formulas for daycounts, date adjustments etc.

Bootstrapping. Fundamentals and formulas for bootstrapping - textbook formulas translated into EXCEL magic

Conditionality. Impress your associate with the ability to toggle within spreadsheets

IRS Pricer. The Holy Grail, includes a solver function

Data. Market based data for a realistic simulation

Pricing

Start your Preparation Today - No Time to Waste

Frequently Asked Questions

Whether you have inquiries about financial modeling or our EXCEL Guides, our team at Market Wizardry is here to assist you with timely and precise responses. Email the MD at wiz @marketwizardry.com anytime.

Here are some helpful FAQs:

How is this different from my textbook or coursework?

What is included in the EXCEL Guide?

What formats are available for materials?

Will I receive personalized feedback from instructors?

Is there a risk-free trial available?

What Our Customers Are Saying

What Our Students Are Saying

The Best Investment I've Ever Made!

"I have aspired to sharpen my financial modelling skills through Market Wizardry for years, and I finally bought this EXCEL Guide! I was very pleasantly surprised when I opened the guide that it was intuitive. It was the best investment I ever made. 10/10 would recommend!"

**** Finch

Relieved

"I always struggled in lectures when concepts are taught through mathematical formulas and notation. However, I know that I am an intuitive learner and I understand these concepts at a high level. Was extremely relieved that Market Wizardry offers EXCEL guides for me to learn it my preferred way. Thank you!"

Alice *****

A Step Ahead

"Very grateful to the guide that I was a step ahead of other summer interns. Basic knowledge of formatting and spreadsheet structure goes a long way to impress my bosses. I even improved some of their spreadsheets in 10 weeks!"

**** Ollie

Spreadsheet outlines pricing sheet setup, bootstrapping, conditionality, IRS pricer functions, and related teaching notes.

Step-by-Step Guide to Bootstrapping and
Interest Rates Swaps

This is how analysts on the desks are trained