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

Companies that are planning to make a long-term investment,like the purchase of machinery,typically use ________ to evaluate whether the endeavor is worth pursuing.

The CUMIPMT requires six arguments.

The series of values for the XIRR function must contain at least one positive and one negative value.

Each loan payment in an amortized loan is made up of a principal amount and an interest amount.

The ________ argument in the DDB function is the rate at which the balance declines.

There are two methods for calculating depreciation.

A(n)________ is the ratio of the amount of money gained or lost from an investment relative to the initial amount invested.

Stocks are categorized as ________ securities because the company gives partial ownership of its equity,defined as total assets minus total liabilities,by selling stock in the company.

The statement of cash flows can aid in determining whether a company is able to collect payments from customers and pay its bills.

To report on a company's net book value on the annual tax return,a(n)________ must be maintained.

An amortization schedule is a table that calculates the interest and principal payments along with the remaining balance of the loan for each period.

The par value is how much the bondholder will receive at maturity.

The pv argument in the PMT function represents the ________ of the loan.

To calculate a loan payment for a mortgage loan with a monthly rate of 4%,you would enter .04 for the rate argument.

A(n)________ is a legal document that can be bought and sold and holds some financial value.

The ________ function calculates what an investment would be worth in today's dollars.

Identify the correct formula to calculate the cumulative interest paid on a mortgage loan for the second year of the loan (periods 13-24,where rate =9%,nper= 5,present value = $250,000.

________ is a reduction in the value of a fixed asset from its original cost.