Converting R&D Expenses
  • Converting R&D Expenses
  • Converting R&D Expenses
  • Converting R&D Expenses
Originally published: 21/06/2016 10:02
Publication number: ELQ-51325-1
View all versions & Certificate

Converting R&D Expenses

Convert R&D expenses from operating to capital expenses.

This spreadsheet converts R&D expenses from operating to capital expenses. It makes the appropriate adjustments to operating income, net income, the book value of assets and the book value of equity. (It can also be used to convert other intangible assets, such as human capital, into capital invested.)

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, 1 ReadMe

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

download for free

Add to bookmarks


Further information

The objective of this model is to get the following outputs:

- Amortization table
- Value of Research Asset
- Expenditure on asset in current year
- Amortization of asset for current year

Without capitalizing / With capitalizing
- Operating income
- Operating income after taxes
- Net Income
- Book value of capital
- Return on capital
- Capital expenditures
- Depreciation & Amortization


  • No review yet!


More tools from Prof. Aswath Damodaran

See all

Any questions on Converting R&D Expenses?

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

please wait...