BUS 1350 – Module 9 Exam 3, 2026 – Study guide and practice material
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 eitehr 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
a ___ cash flow, or cash inflow, represents money that is coming to an individual (cash received)
A ___ cash flow, or cash outflow, represents money that is leaving the individual (cash spent) -
correct answer ✔✔ positive, negative
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 eitehr 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
a ___ cash flow, or cash inflow, represents money that is coming to an individual (cash received)
A ___ cash flow, or cash outflow, represents money that is leaving the individual (cash spent) -
correct answer ✔✔ positive, negative
