# Question

Match the information below

A. Compound Interest

E. IRR

I. PMT

M. ROI

B. CUMIPMT

F. NPER

J. PPMT

N. Simple Interest

C. FV

G. NPV

K. PV

O. SLN

D. IPMT

H. Payback Period

L. RATE

P. Type

1. Function to calculate value of 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 in or out of a financial transaction

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

7. This type of interest is calculated based on original principal regardless of the previous interest earned

8. This type of interest is calculated based on principal and previous interest earned

9. Function to calculate straight line depreciation based on the initial capital investment, number of years to be depreciated, and salvage value

10. Function to calculate the cumulative interest paid between two periods

11. Function to calculate the amount of a periodic payment that is interest in a given period

12. Function to calculate the amount of a specific periodic payment that is principal in a given period

13. Function that determines the value of a variable set of cash flows discounted to its present value

14. Function that determines the rate of return where the net present value of the cash flows is 0

A. Compound Interest

E. IRR

I. PMT

M. ROI

B. CUMIPMT

F. NPER

J. PPMT

N. Simple Interest

C. FV

G. NPV

K. PV

O. SLN

D. IPMT

H. Payback Period

L. RATE

P. Type

1. Function to calculate value of 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 in or out of a financial transaction

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

7. This type of interest is calculated based on original principal regardless of the previous interest earned

8. This type of interest is calculated based on principal and previous interest earned

9. Function to calculate straight line depreciation based on the initial capital investment, number of years to be depreciated, and salvage value

10. Function to calculate the cumulative interest paid between two periods

11. Function to calculate the amount of a periodic payment that is interest in a given period

12. Function to calculate the amount of a specific periodic payment that is principal in a given period

13. Function that determines the value of a variable set of cash flows discounted to its present value

14. Function that determines the rate of return where the net present value of the cash flows is 0

## Answer to relevant Questions

List and describe the steps you would take to create a structured list of data from a text file that contains values stored on separate lines. What are the advantages and disadvantages of using the Subtotal tool to analyze data? How does a data table help you perform what-if analysis? Describe the steps for saving a Solver model. What is the advantage of saving a Solver model? What are false positives and false negatives, and which are harder to detect in worksheets?Post your question

0