Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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

AR ADV SS UNIT 8

Arkansas Advanced Spreadsheets Unit 8-Developing a Financial Analysis

QuestionAnswer
Amortization schedule A file with details about each loan payment, specifying how much of the payment is devoted toward interest and how much toward repaying the principal
Balance sheet A file that shows what the company owns and how its assets are financed
Cash flow The movement of cash assets into or out of an account
Cash inflow Cash coming into a business from revenue
Cash outflow Cash paid out of a business
Cost of goods sold Any costs directly related to production of a tangible item
Declining balance depreciation Depreciation of an asset by a constant percentage each year rather than a constant amount
Dependent cell A cell whose value depends on the value of other cells
Depreciation The process of allocating the original cost of the investment over the years of use
Discount rate Time value of money, quoted as a percentage to indicate the value of future dollars
Error indicator A green triangle in the upper-left corner of a cell that contains an error or potential error
Extrapolate To calculate a series of values from a starting point without a defined ending point
FV function The financial function to calculate the future value of an investment or loan
Gross profit The difference between the company's sales revenue and the cost of goods sold
Growth trend When values change not by a constant percentage; when plotted, a growth trend appears as a curve with the greatest increases occurring near the end of the series
Income statement A file that shows how much money a business makes or losses over a specified period of time
Internal rate or return (IRR) The point at which the net present value of an investment equals zero
Interpolate To fill in missing values when you know the beginning and the ending values in a series and the series trend
Linear trend When values change by a constant amount; when plotted, a linear trend appears as a straight line
Negative cash flow The movement of cash assets out of an account
Net income Income after all expenses and taxes have been paid
Net present value The current value of all the cash inflows and outflows in an investment adjusted by the time value of money
NPER function The financial function to calculate the number of payment periods in an investment or loan
Payback period The length of time required for an investment to recover its initial cost
PMT function The financial function to calculate the amount paid into an investment or loan during each payment period
Positive cash flow The movement of cash assets into an account, also called cash inflow
Precedent cell A cell whose value is used to calculate the active cell's value
Profit and loss statement A file that shows how much money a business makes or losses over a specified period of time
PV function The financial function to calculate the present value of an investment or loan
Tangible asset A long lasting material asset not intended for sale, such as equipment, land, buildings and delivery trucks
RATE function The financial function to calculate the interest rate charged or received during each payment period
Rate of return The time value of money, also known as the discount rate
Risk The possibility that an entire transaction will fail, resulting in a loss of the initial investment
Time value of money The assumption that money received today is worth more than the same amount received later
Tracer arrow An arrow that provides visual clues to the relationship between two cells by pointing from the precedent cell to the dependent cell
Salvage value The value of an asset at the end of its useful life
Straight-Line Depreciation Depreciation of an asset by equal amounts each year of its lifetime until it reaches the salvage value
Created by: Jame Pearce
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards