Exam 9: Exploring Financial Tools and Functions

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the payment in each period required to pay off a loan or reach an investment goal

To _______ a series,the cells between the first and last cells in the series must be blank.

If the NPER function returns #NUM!,the loan cannot be repaid in any length of time.

-In an amortization schedule,use relative references to refer to the original loan conditions and use absolute references to refer to information about specific payment periods.

Skylar is studying for her midterm exam in her accounting class. Her study partner Lisa is her go-to person for help with calculating depreciation. -Which of the following functions does Lisa say is used to calculate a double-declining balance depreciation?

With the PMT function,the type argument is _______ when the payments are made at the end of each period.

The point at which the net present value of an investment equals _______ is the internal rate of return.

Cash flow is concerned with the direction of money as it moves in and out of a company.

The _______ function calculates the amount paid into an investment or loan during each payment period.

Excel supports _______ function(s)to calculate depreciation under different assumptions.

The ____________________ function calculates the number of payment periods in an investment or loan.

-The item marked 2 in the accompanying figure is the _______ value.

The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.

In the function =CUMIPMT(rate,nper,pv,start,end,type),it is _______ that defines whether the payments are made at the beginning or end of each period.

A(n) $\underline { \text { negative } }$ cash flow occurs when cash is going away from the investor._________________________

To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.

Skylar is studying for her midterm exam in her accounting class. Her study partner Lisa is her go-to person for help with calculating depreciation. -Which of the following functions does Lisa say is used to calculate a straight-line depreciation?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment used to pay off the interest

To evaluate a formula,you select the cell and then click the _______ button from the Formula Auditing group on the FORMULAS tab.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the per period interest rate required to pay off a loan or reach an investment goal