REFM Question and answers correctly solved 2024/2025

REFM
HLOOKUP() - correct answer ✔=HLOOKUP(lookup_value, table_array,
row_index_number, [range_lookup])


VLOOKUP() - correct answer ✔=VLOOKUP(lookup_value, table_array,
col_index_num, range_lookup)


COUNTIFS() - correct answer ✔=COUNTIFS(criteria_range1, criteria1,
criteria_range2, criteria2)


INDEX(MATCH()) - correct answer ✔=INDEX(array, MATCH(lookup_value,
lookup_array, match_type))


SUMPRODUCT() - correct answer ✔=SUMPRODUCT(array1, array2)


FV() - correct answer ✔=FV(rate, nper, pmt, pv, type)


XIRR() - correct answer ✔=XIRR(values, dates)


XNPV() - correct answer ✔=XNPV(rate, values, dates)


PPMT() - correct answer ✔=PPMT(rate, per, nper, pv, fv, type)


IPMT() - correct answer ✔=IPMT(rate, per, nper, pv, fv, type)


LTV - correct answer ✔=loan amount/(NOI/cap rate)

, PMT() - correct answer ✔=PMT(rate, nper, pv, fv, type)


operating expense ratio - correct answer ✔=total expenses/effective gross
revenue


EOMONTH() - correct answer ✔=EOMONTH(date, additional_months)


NNN ("triple net") lease - correct answer ✔a lease agreement on a property
whereby the tenant or lessee promises to pay all the expenses of the property


FSG ("full service gross") lease - correct answer ✔Landlord pays all
expenses


Going in cap rate - correct answer ✔=First year NOI/purchase price


unlevered IRR - correct answer ✔=XIRR(unlevered net cash flows, dates)


levered IRR - correct answer ✔=XIRR(levered net cash flows, dates)


unlevered equity multiple - correct answer ✔=SUM(unlevered net cash flows
from period 1)/-unlevered net cash flows from acquisition period


levered equity multiple - correct answer ✔=SUM(levered net cash flows from
period 1)/-levered net cash flows from acquisition period


going in debt yield - correct answer ✔=NOI/loan amount