Complete Real Exam Questions And Correct Answers (Verified
Answers) Already Graded A+ / Guaranteed Pass /Newest Exam /
Just Released!! CFI CBCA Core Course Assessments &
Quizzes
What would a low AR days number, compared to the
industry, mean for a
company? - ANSWER-Receivables are being collected
efficiently, and
customers are paying their debts
quickly.
Which of the following statements are true when completing a
horizontal analysis? - ANSWER-Horizontal analysis is usually
performed after vertical analysis.
This analysis can be used to better project future
performance and solvency.
Analysis can reveal things such as consistent records of
sales, or profitability
growth.
Which of the following statements are true when
completing a horizontal
analysis? Select ALL that apply. - ANSWER-Protect inputs by
locking input cells
,Complex financial models are all of the following EXCEPT: -
ANSWER-They are
easy to follow and
audit
Forecast the 2019 Cost of goods sold on the previous year's
number and the
assumptions
2018 Actual
Sales Growth 6%
Gross Margin 40%
Revenues 50,000
Cost of Goods Sold 30,000
2019
Estimate
Sales Growth
8%
Gross Margin 40% - ANSWER-=
32,400
Forecast the accounts receivable for Company XYZ using the
following annual information.
Receivable days assumption = 55 days
Payable days assumption = 69 days
Forecasted revenue = $263,500
Forecasted cost of goods sold = $114,780 - ANSWER-= 39,705 =
Receivable days assumption*Forecasted revenue/365 days
,What formula below can be used to forecast inventory? -
ANSWER-= Inventory
days * Cost of sales
/ 365
Which of the following items can be found in a published cash
flow statement under "operating activities"? Select ALL correct
answers. - ANSWER-Changes in operating assets and
liabilities, Depreciation
What is the total cash from operating activities based on the
information below?
Net income:
500
Depreciation:
80
Increase in
receivables: 100
Increase in
inventory: 50
Increase in payables: 60 - ANSWER-= 490 = Net income +
Depreciation -
Increase in receivables - Increase in inventory +
Increase in payables
Calculate the end of the year cash balance based on the
information below:
Beginning of the year cash balance: 2,000
, Net income: 300
Depreciation: 140
Increase in accounts payable: 60
Acquisitions of
PP&E: 580
Dividends paid in the current
year: 130
Increase in long-term debt: 200 -
ANSWER-= 1,990
Which Excel function or tool will you use to display the cells
that are referred to
by a formula in the selected cell? - ANSWER-Trace
Precedents
What is the forecasted value of property, plan and equipment
(PP&E) based on
the following
information:
Capital asset turnover
ratio: 2.5
Forecasted revenues:
$120
Forecasted costs of goods sold: $80 -
ANSWER-= 48
Capital asset turnover ration = Revenue / PP&E
(Average)