1|Page
CFI CBCA CORE FINAL EXAM LATEST 2025/2026 ACTUAL EXAM
WITH COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS
(100% VERIFIED ANSWERS) |ALREADY GRADED A+| ||PROFESSOR
VERIFIED|| ||BRANDNEW!!!||
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
,2|Page
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
,3|Page
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
, 4|Page
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:
CFI CBCA CORE FINAL EXAM LATEST 2025/2026 ACTUAL EXAM
WITH COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS
(100% VERIFIED ANSWERS) |ALREADY GRADED A+| ||PROFESSOR
VERIFIED|| ||BRANDNEW!!!||
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
,2|Page
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
,3|Page
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
, 4|Page
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:
