Interest rate calculation

D

donaldo

Is there a way to calculate interest with irregular
payments or specified payments.
 
M

Myrna Larson

Have you looked at the XIRR function? It's in the Analysis Tool Pack. It will
give you an APR given a list of cash flows and the corresponding dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Turning off automatic calculation 0
Variable interest rate loan calculations- PLEASE HELP!!! 1
Amortization w/ variable interest rate 1
Calculate Interest Rate 2
Interest and Payment Calculations 6
XIRR vs. IRR Function 11
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge 3

Top