1
Spreadsheets - C268 (Financal Functions)
Questions and Answers (100% Correct
Answers) Already Graded A+
what are the arguments for the FV functionAns: 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).
© 2026 Assignment Expert
which function is used to calculate the future value for a loan or
investment after all of the payments are made or earned.Ans: "FV"
function
Guru01 - Stuvia
what are the arguments for the PV functionAns: 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.Ans: "PV" function
what are the arguments for the PMT functionAns: 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 loanAns:
"PMT" function
what are the arguments for the NPER functionAns: the interest rate
charged on a loan (rate), and payment amount (pmt), and the original
loan amount (pv).