C268 (Financal Functions) Spreadsheets
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 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 which function will return the interest rate that is paid on the loan or investment described by the arguments - Answer- "Rate" function "FV" function - Answer- calculates the future value of an investment given the interest rate, number of payments to be made, and the amount of the payment. "PV" function - Answer- calculates the current value (accounting for compounding interest) of an investment given the interest rate, number of payments to be made, and the amount of the payment. "PMT" functio
Document information
- Uploaded on
- March 28, 2023
- Number of pages
- 2
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers