12. Discounting and Depreciation Formulas

  1. John Walkenbach

Published Online: 1 NOV 2011

DOI: 10.1002/9781118257630.ch12

Excel® 2010 Formulas

Excel® 2010 Formulas

How to Cite

Walkenbach, J. (2010) Discounting and Depreciation Formulas, in Excel® 2010 Formulas, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257630.ch12

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 10 MAY 2010

ISBN Information

Print ISBN: 9780470475362

Online ISBN: 9781118257630

SEARCH

Keywords:

  • discounting;
  • depreciation;
  • formulas;
  • Excel;
  • cash flows

Summary

This Chapter contains sections titled:

  • Using the NPV Function

  • Using the IRR Function

  • Multiple Rates of IRR and the MIRR Function

  • Irregular Cash Flows

  • Using the FVSCHEDULE Function

  • Depreciation Calculations