I nee help matching these items. Match the following lettered items with Questio

Question

I nee help matching these items.

Match the following lettered items with Questions A. Compound Interest E. IRR I PMT M. ROI B. CUMIPMT F. NPER J. PPMTN. Simple Interest C. FV G. NPV K PVO. SLN D. IPMT H. Payback Period L. RATE P Type 1 Function to calculate the value at the end of a financial transaction 2. Function to calculate the interest percentage per period of a financial transaction 3. Function to calculate the value at the beginning of a financial transaction 4· Function to calculate the number of compounding periods in a financial transaction 5. Function to calculate periodic payments into or out of a financial transaction

Explanation / Answer

[1] function to calculate the value at the end of a financial transaction
FV

[2] function to calculate the interest percentage per period of a financial transaction
RATE

[3] function to calculate the value at the beginning of a financial transaction
PV

[4] function to calculate the number of compounding periods in a financial transaction
NPER

[5] function to calculate periodic payments into or out of a financial transaction
PMT

[6] Use a 0 for this argument to indicate that interest will be paid at the end of each compounding period
TYPE

[7] This type of interest is calculated on original principal regardless of the previous interest earned
simple interest

[8] This type of interest is calculated based on principal and previous interest earned
compound interest

[9] function to calculate straight line depreciation based on the initial capital investment, number of years to be depreciated and salvage value
SLN

[10] function to calculate the cumulative interest paid between two periods
CUMPRINC

[11] function to calculate the amount of a periodic payment that is interest in a given period
IPMT

[12] function to calculate the amount of a specific periodic payment that is principal in a given function period
PPMT

[13] function to determine the value of a variable set of cash flows discounted to its present value
NPV

[14] function to determine the rate of return, where the net present value of the cash flow is 0
IRR

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.