Excel - i : RATE( n , A , P , F ) To find the compound...

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

Ask a homework question - tutors are online