Exam 11: Loan Amortization, investment Analysis, and Asset Depreciation

The SLN function has ________ arguments.

Maturity is the interest rate the bond pays.

An alternative method to using the negative sign to make the result positive is to use the ABS function.

The ________ function indicates the profitability of an investment and is commonly used in business when choosing between investments.

An amortization table shows all of the following EXCEPT ________.

The ________ of an asset is the value of an asset at the end of its useful life.

The ________ function calculates the interest rate per period for an investment or loan,given that you know the present value of the loan,payment amount,and number of payment periods.

The ________ method of depreciation that the value of the asset loses the same amount of value each year of its life.

The ________ is the unpaid balance amount of the loan.

You could use ________ analysis to determine whether or not you could afford the payment for a specific mortgage amount,interest rate,and terms.

You would use the ________ function to find out how much money you would pay on a mortgage loan of $100,000 with a monthly rate of 5%.

You would use the ________ function to determine the amount of interest paid over a specific number of periods

The ________ function can be used to determine if it is better to take a lump sum payment or to withdraw smaller payments over a longer period of time.

The ________ is the value of an asset at the end of its useful life.

The ________ argument is used when you want to speculate about what the interest rate would be when using the RATE function.

Bonds are categorized as ________ securities because the company is indebted to the people who loan the company money through the purchase of bonds.

The XIRR function is generally used in capital budgeting to measure and compare how profitable a potential investment is.

As the total loan balance decreases,a(n)________ proportion is applied to interest and a greater proportion to principal.

The FV function has two optional arguments.These two arguments are ________ and ________.