Exam 9: Exploring Financial Tools and Functions

A(n)____________________ cash flow occurs whenever money is flowing out of the account.

The ____________________ function calculates the amount of a loan payment used to pay off the principal of the loan.

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 declining balance depreciation?

To determine the interest rate needed to reach your savings goal,you can use the ____________________ function.

Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he turns to another co-worker, Seymour, for tips on how to trace errors in the sheet. -If Charles sees red tracer arrows that means there is an error in the value being received from the precedent cell or passed to the _______ cell.

Financial functions format calculated values as currency,with _______.

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is $\underline { 18. }$ _________________________

To calculate a declining balance depreciation,use the DVB function.

To calculate the internal rate of return,use the _______ function with the cost of the initial investment as the first cash flow value in a series.

The FV function calculates the $\underline {\text { full } }$ value of an investment or loan._________________________

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 depreciation if it is variable?

-As shown in the accompanying figure,later payment periods apply more of the payment toward the _______.

You can use the ____________________ Window to view the impact of a changing value in one worksheet on the cell values in the other cells.

-The DB function used to calculate the declining balance depreciation has the following syntax: _______.

One simple measure of the return from an investment is the ____________________ period,which is the length of time required for an investment to recover its initial cost.

The tracer arrow provides a visual clue to the source of the error.

Describe the steps to interpolate a series of values between starting and ending values.

The process of allocating the original cost of an investment over the years of use is known as _______.

After you select a cell with an error indicator,you can click the Error Checking _______ to display additional information about the possible error and determine if further action is needed.

A(n)_______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.