Financial math's Solving Care

𝐓𝐨𝐩 𝐅𝐢𝐧𝐚𝐧𝐜𝐢𝐚𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
----------------------------------------------------------
 
Below are the top financial functions used in excel.

#1 Future Value (FV) Formula

 FV (Rate, Nper, [Pmt], PV, [Type])

#2 – Present Value (PV)

Present Value (PV) Formula

PV = (Rate, Nper, [Pmt], FV, [Type])

#3 – Net Present Value (NPV)

Net Present Value (NPV) Formula

NPV = (Rate, Value 1, [Value 2], [Value 3]…)

#4 – PMT

PMT Formula

PMT = (Rate, Nper, PV, [FV], [Type])

#5 – PPMT

PPMT Formula

PPMT = (Rate, Per, Nper, PV, [FV], [Type])

#6 – Internal Rate of Return (IRR)

Internal Rate of Return (IRR) Formula

IRR = (Values, [Guess])

#7 – Modified Internal Rate of Return (MIRR)

Modified Internal Rate of Return (MIRR) Formula

MIRR = (Values, Finance rate, Reinvestment rate)