Excel - i RATE n A P F To find the compound interest rate i...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Most commonly used Excel functions in economic analysis: To find the present value P : PV( i %, n , A , F ) To find the future value F : FV( i %, n , A , P ) To find the equal, periodic value A : PMT( i %, n , P , F ) To find the number of periods n : NPER( i %, A , P , F ) To find the compound interest rate
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: i : RATE( n , A , P , F ) To find the compound interest rate i : IRR(first_cell:last_cell) To find the present value P of any series : NPV( i %, second_cell:last_cell) _ first_cell...
View Full Document

This note was uploaded on 10/18/2009 for the course NFNSN GES2302 taught by Professor Inkla during the Spring '09 term at École Normale Supérieure.

Ask a homework question - tutors are online