Investment Science: A list of useful excel sheets for computations

Tuesday, March 27, 2012


Has been planning to do this for sometime, but here is a list of excel sheet computations which I developed during my Investment Science course in Stanford, these may help you understand some investment related calculations (like mortgages, Net Present Value, Internal rate of return and so on), the one which may be of frequent use is the mortgage/loan payment schedule given the interest rate and the number of years, personally was of good use to me.

Note: Most of them may be in openoffice format, you may download openoffice software to use these.

1. Spreadsheet:Compound interest calculation

2. Spreadsheet:Calculating Net Present Value (NPV) and Internal rate of return (IRR)

No comments:


Copyright © 2016 Prasanna Seshadri, www.prasannatech.net, All Rights Reserved.
No part of the content or this site may be reproduced without prior written permission of the author.