Design debt (by looking at sensitivity to macro variables)

Allows you to estimate the duration of a firm's assets and its sensitivity to other macro economic variables

assetscash flowsdesign debtdurationfinancemacrosensitivityvariables

We are trying to estimate how the cash flows of a firm, and its value change as a function of the changes in macroeconomic variables. This will help us in the design of debt.

Inputs needed: You will need to input operating income, market value of equity and total debt
outstanding each year for the periods, starting with the latest one. If your firm has been listed
for 3 years or less, skip this spreadsheet.

Note: this model is being shared with the authorization of Professor Aswath Damodaran from NYU Stern Business School (

This business tool includes
1 Excel Model File

Prof. Aswath Damodaran offers you this business tool for free!

Download for free

Ask a question

Further information

The objective of this model is to get the following output values, based on Firm Value or based on Operating Income:
- Slope of regression vs Interest rate change
- Duration of the firm's assets
- Cyclicality of firm's assets
- Sensitivity to Inflation
- Sensitivity to Dollar movements

It may be useful in the design of debt.


  • No review yet!

Any questions on Design Debt (by Looking At Sensitivity To Macro Variables)?

The user community and author are here to help. Go ahead!

please wait...