Question 1

-The item marked ____________________ in the accompanying figure is the initial cash inflow.

Accepted Answer

The answer of  
-The item marked ____________________ in the...

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Return rate for a series of future cash flows that will result in a net present value of zero

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function

Question 3

The functions used to work with loans are the same ones you used to work with investments;the only difference is the direction of the cash flow.

Accepted Answer

A) True 
 B)False

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the amount of a loan payment applied to the principal

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function

Question 5

You should reference worksheet cells in which the values are entered so the values are easily visible.

Accepted Answer

A) True 
 B)False

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the future value of a loan or an investment

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the present value of a loan or an investment

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function

Question 8

At higher rates of return,the net present value of the investment goes up._________________________

Accepted Answer

A) True 
 B)False

Question 9

-The item marked ____________________ in the accompanying figure is the number of quarterly payments.

Accepted Answer

The answer of  
-The item marked ____________________ in the...

Question 10

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

Accepted Answer

A)  periodic 
B)  growth 
C)  orthogonal 
D)  linear 
A)  periodic 
B)  growth 
C)  orthogonal 
D)  linear

Question 11

Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.

Accepted Answer

The financial definition of net present

Question 12

With ____ depreciation,the asset depreciates by equal amounts each year of its lifetime until it reaches the salvage value.

Accepted Answer

A)  straight-line 
B)  double-declining 
C)  declining 
D)  sum of years' digit 
A)  straight-line 
B)  double-declining 
C)  declining 
D)  sum of years' digit

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the internal rate of return for a series of unevenly spaced payments

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) NPV function
F)RATE function
G)PMT function
H)XIRR function
I)NPV
J)NPER function
K)FV function
L)PV function

Question 14

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 1.5._________________________

Accepted Answer

A) True 
 B)False

Question 15

The financial functions automatically format calculated values as currency with negative cash flow appearing in a green font._________________________

Accepted Answer

A) True 
 B)False

Question 16

The NPER function returns the number of payment periods,not necessarily the number of years.

Accepted Answer

A) True 
 B)False

Question 17

The major advantage of the payback period is that it takes into account the time value of money.

Accepted Answer

A) True 
 B)False

Question 18

-The item marked ____________________ in the accompanying figure is the interest rate per quarter.

Accepted Answer

The answer of  
-The item marked ____________________ in the...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

All of the following are examples of tangible assets except ____.

Accepted Answer

A)  equipment 
B)  land 
C)  delivery trucks 
D)  production parts 
A)  equipment 
B)  land 
C)  delivery trucks 
D)  production parts

-The item marked ____________________ in the accompanying figure is the initial cash inflow.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Return rate for a series of future cash flows that will result in a net present value of zero

The functions used to work with loans are the same ones you used to work with investments;the only difference is the direction of the cash flow.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment applied to the principal

You should reference worksheet cells in which the values are entered so the values are easily visible.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the future value of a loan or an investment

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the present value of a loan or an investment

At higher rates of return,the net present value of the investment goes up._________________________

-The item marked ____________________ in the accompanying figure is the number of quarterly payments.

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

Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.

With ____ depreciation,the asset depreciates by equal amounts each year of its lifetime until it reaches the salvage value.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the internal rate of return for a series of unevenly spaced payments

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 1.5._________________________

The financial functions automatically format calculated values as currency with negative cash flow appearing in a green font._________________________

The NPER function returns the number of payment periods,not necessarily the number of years.

The major advantage of the payback period is that it takes into account the time value of money.

-The item marked ____________________ in the accompanying figure is the interest rate per quarter.

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

All of the following are examples of tangible assets except ____.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 9: Working With Financial Tools and Functions

-The item marked ____________________ in the accompanying figure is the initial cash inflow.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Return rate for a series of future cash flows that will result in a net present value of zero

The functions used to work with loans are the same ones you used to work with investments;the only difference is the direction of the cash flow.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment applied to the principal

You should reference worksheet cells in which the values are entered so the values are easily visible.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the future value of a loan or an investment

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the present value of a loan or an investment

At higher rates of return,the net present value of the investment goes up._________________________

-The item marked ____________________ in the accompanying figure is the number of quarterly payments.

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

Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.

With ____ depreciation,the asset depreciates by equal amounts each year of its lifetime until it reaches the salvage value.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the internal rate of return for a series of unevenly spaced payments

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 1.5._________________________

The financial functions automatically format calculated values as currency with negative cash flow appearing in a green font._________________________

The NPER function returns the number of payment periods,not necessarily the number of years.

The major advantage of the payback period is that it takes into account the time value of money.

-The item marked ____________________ in the accompanying figure is the interest rate per quarter.

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

All of the following are examples of tangible assets except ____.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters