Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 6 formulas in Financial
FV
=FV(0.05/12, 60, -200, 0)Calculating the future value of an investment with regular payments
View formula detailsIRR
=IRR({-10000, 2500, 3000, 3500, 4000, 4500})Calculating the internal rate of return for a series of cash flows
View formula detailsNPV
=NPV(0.1, 10000, 15000, 20000, 25000, 30000)Calculating the net present value of an investment based on a series of cash flows
View formula detailsPMT
=PMT(0.05/12, 360, 200000)Calculating the payment for a loan based on constant payments and interest rate
View formula detailsPV
=PV(0.05/12, 360, -1000)Calculating the present value of an investment based on future payments
View formula detailsRATE
=RATE(360, -1000, 200000)Calculating the interest rate for a loan or investment
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.