**# 📊 FINANCE RELATED FORMULAS

1️⃣ Present Value (PV)

Formula:

=PV(rate, nper, pmt, [fv], [type])

Example:

=PV(10%, 5, 0, -100000)

2️⃣ Future Value (FV)

Formula:

=FV(rate, nper, pmt, [pv], [type])

Example:

=FV(8%, 10, -5000, 0)

3️⃣ Net Present Value (NPV)

Formula:

=NPV(rate, value1:valueN)

Example:

=NPV(12%, B2:B6)

4️⃣ Internal Rate of Return (IRR)

Formula:

=IRR(values, [guess])

Example:

=IRR(B2:B6)

5️⃣ XIRR (Irregular Cash Flows)

Formula:

=XIRR(values, dates, [guess])

Example:

=XIRR(B2:B6, A2:A6)

6️⃣ EMI (PMT)

Formula:

=PMT(rate, nper, pv, [fv], [type])

Example:

=PMT(9%/12, 20*12, -5000000)

7️⃣ Interest Component (IPMT)

Formula:

=IPMT(rate, per, nper, pv, [fv], [type])

Example:

=IPMT(9%/12, 1, 20*12, -5000000)

8️⃣ Principal Component (PPMT)

Formula:

=PPMT(rate, per, nper, pv, [fv], [type])

Example:

=PPMT(9%/12, 1, 20*12, -5000000)

9️⃣ CAGR

Formula:

=(Ending_Value/Beginning_Value)^(1/Years)-1

Example:

=(B1/A1)^(1/C1)-1

🔟 Straight Line Depreciation

Formula:

=SLN(cost, salvage, life)

Example:

=SLN(1000000,100000,10)

📈 GENERAL & REPORTING FORMULAS

1️⃣1️⃣ VLOOKUP

Formula:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Example:

=VLOOKUP(A2, A10:C20, 2, FALSE)

1️⃣2️⃣ INDEX

Formula:

=INDEX(array, row_num, [column_num])

Example:

=INDEX(A1:C10, 5, 2)

1️⃣3️⃣ MATCH

Formula:

=MATCH(lookup_value, lookup_array, [match_type])

Example:

=MATCH(A2, A1:A100, 0)

1️⃣4️⃣ INDEX + MATCH

Formula:

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Example:

=INDEX(B1:B100, MATCH(A2, A1:A100, 0))

1️⃣5️⃣ XLOOKUP

Formula:

=XLOOKUP(lookup_value, lookup_array, return_array)

Example:

=XLOOKUP(A2, A10:A20, B10:B20)

1️⃣6️⃣ SUM

Formula:

=SUM(number1, [number2], ...)

Example:

=SUM(A1:A100)

1️⃣7️⃣ SUMIF

Formula:

=SUMIF(range, criteria, [sum_range])

Example:

=SUMIF(A1:A100, "Sales", B1:B100)

1️⃣8️⃣ SUMIFS

Formula:

=SUMIFS(sum_range, criteria_range1, criteria1)

Example:

=SUMIFS(B1:B100, A1:A100, "Sales")

1️⃣9️⃣ COUNT

Formula:

=COUNT(value1, [value2], ...)

Example:

=COUNT(A1:A100)

2️⃣0️⃣ COUNTA

Formula:

=COUNTA(value1, [value2], ...)

Example:

=COUNTA(A1:A100)

2️⃣1️⃣ COUNTIF

Formula:

=COUNTIF(range, criteria)

Example:

=COUNTIF(A1:A100, "Sales")

2️⃣2️⃣ COUNTIFS

Formula:

=COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2)

Example:

=COUNTIFS(A1:A100, "Sales", B1:B100, ">10000")

2️⃣3️⃣ IF

Formula:

=IF(logical_test, value_if_true, value_if_false)

Example:

=IF(A1>50000, "Achieved", "Not Achieved")

2️⃣4️⃣ IFERROR

Formula:

=IFERROR(value, value_if_error)

Example:

=IFERROR(VLOOKUP(A2, A10:C20, 2, FALSE), "Not Found")

2️⃣5️⃣ CONCAT

Formula:

=CONCAT(text1, text2, ...)

Example:

=CONCAT(A1, " ", B1)

---**