Question

Write down examples for any two financial functions you know with their proper syntax.

Answer 1

Here are two Excel financial functions with their proper syntax and a concrete example for each.

1. ACCRINT: returns the accrued interest for a security that pays periodic interest.
   Syntax: ACCRINT(issue, first_interest, settlement, rate, par, frequency, basis, calc_method)
   Example: =ACCRINT (DATE (2024, 1, 1), DATE (2024, 7, 1), DATE (2024, 12, 31), 0.06, 1000, 2, 0, TRUE)
   Calculates accrued interest on a security with a 6% annual coupon, par 1000, semiannual payments (frequency = 2), using the 30/360 day count (basis = 0).
2. CUMIPMT: returns the cumulative interest paid between two periods for a loan.
   Syntax: CUMIPMT (rate, nper, pv, start_period, end_period, type)
   Example: = CUMIPMT(0.05/12, 60, 20000, 1, 12, 0)
   Returns the total interest paid on a $20,000 loan at 5% annual interest (monthly payments) during periods 1–12 (the first year). Results are typically negative because payments are cash outflows.

If you want examples for other financial functions (PMT, PV, FV, NPV, IRR, etc.) I can show syntax and worked examples for any you pick.