A+
Spreadsheets - C268 (Financal
Functions) 2025/2026 Exam Questions
and Correct Answers | New Update
what are the arguments for the FV function - 🧠ANSWER ✔✔the interest rate
charged or earned on the investment (rate), the number of payments to be paid or
earned (nper), and the payment amount (PMT).
which function is used to calculate the future value for a loan or investment after
all of the payments are made or earned. - 🧠ANSWER ✔✔"FV" function
what are the arguments for the PV function - 🧠ANSWER ✔✔the interest rate
charged or earned on the investment (rate), the number of payments to be paid or
earned (nper), and the payment amount (PMT)
which function is used to calculate the current value for a loan or investment. -
🧠ANSWER ✔✔"PV" function
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
what are the arguments for the PMT function - 🧠ANSWER ✔✔the interest rate
charged on the loan (rate), the number of payments made on the loan (PMT), and
the original loan amount (pv).
which function is used to calculate the payment amount for a loan - 🧠ANSWER
✔✔"PMT" function
what are the arguments for the NPER function - 🧠ANSWER ✔✔the interest rate
charged on a loan (rate), and payment amount (pmt), and the original loan amount
(pv).
which function is used to calculate the number of payments I will make on a loan
before it is paid off - 🧠ANSWER ✔✔"NPER" function
what are the arguments for the EFFECT function - 🧠ANSWER ✔✔the interest rate
quoted on the loan (nominal_rate) and the number of times per year that interest
will be charged (npery)
which function is used to calculate the real, or effective, interest rate paid on a loan
accounting for compounding interest - 🧠ANSWER ✔✔"EFFECT" function
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
Spreadsheets - C268 (Financal
Functions) 2025/2026 Exam Questions
and Correct Answers | New Update
what are the arguments for the FV function - 🧠ANSWER ✔✔the interest rate
charged or earned on the investment (rate), the number of payments to be paid or
earned (nper), and the payment amount (PMT).
which function is used to calculate the future value for a loan or investment after
all of the payments are made or earned. - 🧠ANSWER ✔✔"FV" function
what are the arguments for the PV function - 🧠ANSWER ✔✔the interest rate
charged or earned on the investment (rate), the number of payments to be paid or
earned (nper), and the payment amount (PMT)
which function is used to calculate the current value for a loan or investment. -
🧠ANSWER ✔✔"PV" function
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
what are the arguments for the PMT function - 🧠ANSWER ✔✔the interest rate
charged on the loan (rate), the number of payments made on the loan (PMT), and
the original loan amount (pv).
which function is used to calculate the payment amount for a loan - 🧠ANSWER
✔✔"PMT" function
what are the arguments for the NPER function - 🧠ANSWER ✔✔the interest rate
charged on a loan (rate), and payment amount (pmt), and the original loan amount
(pv).
which function is used to calculate the number of payments I will make on a loan
before it is paid off - 🧠ANSWER ✔✔"NPER" function
what are the arguments for the EFFECT function - 🧠ANSWER ✔✔the interest rate
quoted on the loan (nominal_rate) and the number of times per year that interest
will be charged (npery)
which function is used to calculate the real, or effective, interest rate paid on a loan
accounting for compounding interest - 🧠ANSWER ✔✔"EFFECT" function
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
