Financial Functions
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| A higher discount rate means that future dollars are ___________ in comparison to current dollars. | show 🗑
|
||||
| A positive cash flow, or ____________________, occurs whenever money is flowing into the account. | show 🗑
|
||||
| A _______ cash flow occurs when cash is going to the investor | show 🗑
|
||||
| A(n) ____ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell | show 🗑
|
||||
| A(n) ____ shows how much money a business makes or loses over a specified period of time. | show 🗑
|
||||
| show | balance sheet
🗑
|
||||
| A(n) ____________________ cash flow occurs whenever money is flowing out of the account. | show 🗑
|
||||
| show | income statement
🗑
|
||||
| show | amortization schedule
🗑
|
||||
| show | button
🗑
|
||||
| _________ include equipment, land, and delivery trucks | show 🗑
|
||||
| show | amortization schedules
🗑
|
||||
| show | negative
🗑
|
||||
| At higher rates of return, the net present value of the investment goes ______ | show 🗑
|
||||
| show | negative
🗑
|
||||
| Both the NPV and the ______ functions assume the cash flows occur at evenly spaced intervals | show 🗑
|
||||
| ____ is the symbol Excel uses to easily indicate an error | show 🗑
|
||||
| show | #NAME?
🗑
|
||||
| These are the red tracer arrows that means there is an error in the value being received from the precedent cell or passed to the ____ cell. | show 🗑
|
||||
| _______ is concerned with the direction of the money as it moves in and out of the company. | show 🗑
|
||||
| Cash flow is the movement of cash assets ____ an account. | show 🗑
|
||||
| show | five
🗑
|
||||
| show | green triangles
🗑
|
||||
| _____ ____ is used to calculate the future value of a fund | show 🗑
|
||||
| Financial functions format calculated values as currency, with ____ ________ appearing in red font | show 🗑
|
||||
| If the NPER function returns the error value ________ a loan cannot be paid back in any length of time | show 🗑
|
||||
| show | months
🗑
|
||||
| If you don’t include an fv value, Excel assumes a future value of ____ | show 🗑
|
||||
| show | interpolation
🗑
|
||||
| If you plan to invest money for 18 months, the value of the _____ argument in the PMT function is 18 | show 🗑
|
||||
| In a(n) ____ trend, the values change by a constant amount. | show 🗑
|
||||
| In a(n) ____ trend, values change by a constant percentage and usually appear as a curve | show 🗑
|
||||
| show | absolute
🗑
|
||||
| In comparing two investments, a commonly used guideline is to accept the investment with the ____. | show 🗑
|
||||
| show | type
🗑
|
||||
| show | direction
🗑
|
||||
| show | NPV
🗑
|
||||
| The PMT value is also known as the ____ payment | show 🗑
|
||||
| show | PMT
🗑
|
||||
| The ____ function calculates the future value of an investment or loan. | show 🗑
|
||||
| The ____ function calculates the interest rate charged or received during each payment period. | show 🗑
|
||||
| show | NPER
🗑
|
||||
| The ____ function returns a variable declining depreciation for any specified period using any specified depreciation method. | show 🗑
|
||||
| show | IPMT
🗑
|
||||
| show | SYD
🗑
|
||||
| show | SLN
🗑
|
||||
| The ____ period is a quick method of projecting the value of an investment. | show 🗑
|
||||
| The ____________________ argument specifies whether payments are made at the end of each period or at the beginning. | show 🗑
|
||||
| The ____________________ function calculates the amount of a loan payment used to pay off the principal of the loan | show 🗑
|
||||
| show | NPER
🗑
|
||||
| show | Principal
🗑
|
||||
| The company’s income after all expenses and taxes have been paid is called the ____. | show 🗑
|
||||
| show | gross profit
🗑
|
||||
| show | cash flow
🗑
|
||||
| ____________________ is the difference between the present value of future cash flows and the current cost of the initial investment. | show 🗑
|
||||
| show | the only difference is the direction of the _______
🗑
|
||||
| show | IRR
🗑
|
||||
| show | 0
🗑
|
||||
| The possibility that the entire transaction will fail, resulting in a loss of the initial investment is called the _________ | show 🗑
|
||||
| The process of allocating the original cost of an investment over the years of use is known as ____. | show 🗑
|
||||
| To ____ a series, the cells between the first and last cells in the series must be blank | show 🗑
|
||||
| To calculate a series of values from a starting point without a defined ending point, you have to ____ the values. | show 🗑
|
||||
| show | VBD
🗑
|
||||
| To calculate an ________ multiply the value returned by the RATE function by the number of payments per year | show 🗑
|
||||
| To calculate the _________ of an asset, you need to know an asset’s original cost and its useful life. | show 🗑
|
||||
| show | irr
🗑
|
||||
| To choose between two or more investments, it’s a good idea to graph the ____ for each investment against different possible rates of return. | show 🗑
|
||||
| n To determine the interest rate needed to reach your savings goal, you can use the ____________________ function. | show 🗑
|
||||
| show | evaluate formula
🗑
|
||||
| show | 0 and 1
🗑
|
||||
| show | tracer arrows
🗑
|
||||
| show | unvevenly spaced intervals
🗑
|
||||
| When an investment requires the investor to make multiple future payments, rather than a single initial payment, ___ | show 🗑
|
||||
| When using the PMT function to calculate monthly loan payments, the interest rate and the number of payments should be based on the interest rate per _____ and the total months to pay off the loan. | show 🗑
|
||||
| When you borrow money, the money you receive represents a ____ cash flow. | show 🗑
|
||||
| When you extrapolate a series, the ____ value represents the amount that each value is increased or multiplied as the series is extended. | show 🗑
|
||||
| When you extrapolate a series, you do not have to specify a(n) _______ | show 🗑
|
||||
| show | straight-line
🗑
|
||||
| With the PMT function, the ____ argument is 0 when the payments are made at the end of each period. | show 🗑
|
||||
| show | cumulative
🗑
|
||||
| You can extrapolate a series of values from the _____ dialog box. | show 🗑
|
||||
| You can use the ____ function to estimate how much a dollar amount today is worth in future dollars. | show 🗑
|
||||
| You can use the ____________________ Window to view the impact of a changing value in one worksheet on the cell values in the other cells. | show 🗑
|
||||
| ____ depreciation depreciates an asset by a constant percentage each year rather than a constant amount | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
galvanl
Popular Computers sets