BUS 1350 MODULE 9 EXAM 3
QUESTIONS & ANSWERS PASSED
RATED 100% CORRECT
Business Intelligence (BI) - Correct Answer ✔✔ a broad category of applications,
technologies, and processes for gathering, storing, accessing, and analyzing data to
help business users make better decisions
cash flow - Correct Answer ✔✔ the DIRECTION in which money flows either to or from
the user
negative cash flow - Correct Answer ✔✔ money that is flowing FROM the user. excel
returns negative cash flow values for loan payments (in a function if the money is going
OUT you put it as -xxx )
positive cash flow - Correct Answer ✔✔ money that is flowing TOWARDS the
user/company. Excel returns positive cash flows for investments
present value - Correct Answer ✔✔ the current value of a loan or investment (what it is
worth now)
future value - Correct Answer ✔✔ the future value of a loan or investment. use a future
value of 0 for loans that will be completely repaid
in functions utilizing future value, what do you put in the function if the loan will be
completely repaid at the end of the term - Correct Answer ✔✔ 0
cost of sales - Correct Answer ✔✔ expenses which are directly related to
PRODUCTION
Tangible assets - Correct Answer ✔✔ NONCASH assets such as equipment, land,
buildings an vehicles
gross profit - Correct Answer ✔✔ the DIFFERENCE between the company's sales and
the cost of goods sold
compound interest - Correct Answer ✔✔ the ADDITION of interest to the principal sum
of a loan or deposit, or in other words, interest on interest. It is the result of reinvesting
the interest rather than paying it out, so that interest in the next period is then earned on
the principal plus previously accumulated interest.
, dividend - Correct Answer ✔✔ a sum of money paid REGULARLY by a company to its
shareholders out of its profits
financial functions are the excel functions used for analyzing these 3 things: - Correct
Answer ✔✔ loans
investments
financial metrics
money received is ___ cash flow - Correct Answer ✔✔ positive cash flow
if you borrow money by taking out a loan, the money you borrow is _____ cash flow to
you but a ____ to the lender. When you repay the loan, the repayments are ___ cash
flows to you. - Correct Answer ✔✔ positive,
negative,
negative
money you invest is a ____ cash flow because_____, but any returns on that
investment are ____ cash flow - Correct Answer ✔✔ negative
you are spending money
positive
in excel functions relating to cash flow a negative number represents - Correct Answer
✔✔ negative cash flow/money being paid out like in a loan payment or investment
in excel functions relating to cash flow, a positive number represents - Correct Answer
✔✔ positive cash flow or money coming in like from investment income, or money you
borrowed on a loan
present value - Correct Answer ✔✔ current value of a loan or investment
if you take out a loan for $50,000, its present value is $____ and if you repay the entire
loan, its future value is $____ - Correct Answer ✔✔ $50,000, (the PV is always what
your original loan or investment is
$0 (the future value of any loan that is fully paid at the end of the term is always 0
excels financial functions are used for analyzing:
a. loans
b investments
c financial metrics
d all - Correct Answer ✔✔ d all
many financial functions deal with ____ which is direction of money to and from an
individual or group - Correct Answer ✔✔ cash flow
QUESTIONS & ANSWERS PASSED
RATED 100% CORRECT
Business Intelligence (BI) - Correct Answer ✔✔ a broad category of applications,
technologies, and processes for gathering, storing, accessing, and analyzing data to
help business users make better decisions
cash flow - Correct Answer ✔✔ the DIRECTION in which money flows either to or from
the user
negative cash flow - Correct Answer ✔✔ money that is flowing FROM the user. excel
returns negative cash flow values for loan payments (in a function if the money is going
OUT you put it as -xxx )
positive cash flow - Correct Answer ✔✔ money that is flowing TOWARDS the
user/company. Excel returns positive cash flows for investments
present value - Correct Answer ✔✔ the current value of a loan or investment (what it is
worth now)
future value - Correct Answer ✔✔ the future value of a loan or investment. use a future
value of 0 for loans that will be completely repaid
in functions utilizing future value, what do you put in the function if the loan will be
completely repaid at the end of the term - Correct Answer ✔✔ 0
cost of sales - Correct Answer ✔✔ expenses which are directly related to
PRODUCTION
Tangible assets - Correct Answer ✔✔ NONCASH assets such as equipment, land,
buildings an vehicles
gross profit - Correct Answer ✔✔ the DIFFERENCE between the company's sales and
the cost of goods sold
compound interest - Correct Answer ✔✔ the ADDITION of interest to the principal sum
of a loan or deposit, or in other words, interest on interest. It is the result of reinvesting
the interest rather than paying it out, so that interest in the next period is then earned on
the principal plus previously accumulated interest.
, dividend - Correct Answer ✔✔ a sum of money paid REGULARLY by a company to its
shareholders out of its profits
financial functions are the excel functions used for analyzing these 3 things: - Correct
Answer ✔✔ loans
investments
financial metrics
money received is ___ cash flow - Correct Answer ✔✔ positive cash flow
if you borrow money by taking out a loan, the money you borrow is _____ cash flow to
you but a ____ to the lender. When you repay the loan, the repayments are ___ cash
flows to you. - Correct Answer ✔✔ positive,
negative,
negative
money you invest is a ____ cash flow because_____, but any returns on that
investment are ____ cash flow - Correct Answer ✔✔ negative
you are spending money
positive
in excel functions relating to cash flow a negative number represents - Correct Answer
✔✔ negative cash flow/money being paid out like in a loan payment or investment
in excel functions relating to cash flow, a positive number represents - Correct Answer
✔✔ positive cash flow or money coming in like from investment income, or money you
borrowed on a loan
present value - Correct Answer ✔✔ current value of a loan or investment
if you take out a loan for $50,000, its present value is $____ and if you repay the entire
loan, its future value is $____ - Correct Answer ✔✔ $50,000, (the PV is always what
your original loan or investment is
$0 (the future value of any loan that is fully paid at the end of the term is always 0
excels financial functions are used for analyzing:
a. loans
b investments
c financial metrics
d all - Correct Answer ✔✔ d all
many financial functions deal with ____ which is direction of money to and from an
individual or group - Correct Answer ✔✔ cash flow
