Exam 9: Working With Financial Tools and Functions

Case-Based Critical Thinking Questions Case 9-2 Mackenzie is studying for her midterm exam in her accounting class.Her study partner Libby is her go-to person for help with calculating depreciation. -Which of the following functions does Libby say is used to calculate a sum-of-years' digit depreciation?

The FV function calculates the full value of an investment or loan._________________________

The ____ period is a quick method of projecting the value of an investment.

To project a trend that decreases rather than increases,use a step value between ____ for a growth trend.

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

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

To choose between two or more investments,it's a good idea to graph the ____ for each investment against different possible rates of return.

A(n)____ shows how much money a business makes or loses over a specified period of time.

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

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.

As shown in the accompanying figure,when plotted,a(n)____ trend displays the greatest increases near the end of the series.

To calculate a variable deprecation,use the ____ function.

A(n)____________________ provides details about each loan payment,specifying how much of the payment is devoted toward interest and how much toward repaying the principal.

Case-Based Critical Thinking Questions Case 9-2 Mackenzie is studying for her midterm exam in her accounting class.Her study partner Libby is her go-to person for help with calculating depreciation. -Which of the following functions does Libby say is used to calculate a double-declining balance depreciation?

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

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

Error values will propagate throughout a workbook.

-The item marked 1 in the accompanying figure represents the ____ trend.

Both the NPV and the IRR functions assume the cash flows occur at evenly spaced intervals.

To properly use financial functions,always place argument values directly into a financial formula.