CFI CBCA Exam Study Verified Multiple Choice and
Conceptual Actual Exam Questions With Reviewed 100%
Correct Detailed Answers
Guaranteed Pass!!Current Update
1. Which ratio would you use to determine how much profit a company makes
after paying off its cost of goods sold? - ANSWER Gross Profit Margin
Ratio
2. What actions could a company take to reduce its working capital funding
gap? - ANSWER Negotiate the contract with suppliers to be able to
delay the payments
3. What could be the yield to maturity for a 3 year bond with a 8% annual
coupon if the bond is trading at discount? - ANSWER 9% (discount -
YTM > Coupon)
4. Which of the following best describes the efficiency ratios? - ANSWER
These ratios measure how efficiently a company is utilizing its assets and
resources
5. The keyboard shortcuts Ctrl + 1 (PC) or Command + 1 (MAC) performs
which of the following actions? - ANSWER Open the format cells
window
,6. What is the present value of a cash inflow of $2,000 five years from now if
the required rate of return is 6%? - ANSWER 1494.52 (2000/(1.06^5)
7. Based on the company's budget and actual figures, the company is facing
___? - ANSWER Unfavorable sales price and unfavorable total variable
costs (actual sales price lower and total variable costs higher)
8. What is the discount factor for a semi-annual coupon that will be received
in 12 months if the quoted annual yield is 8% - ANSWER =
1/1*(1+Discount rate)^n = 0.92 (0.93 rounded)
9. What's the forecasted EBIT based on the information below? (8100, 4900,
1500, 400, 150, 390) - ANSWER 1300
10.The net profit margin ratio can mathematically be broken down as: -
ANSWER Tax impact x Capital structure impact x EBIT / Sales
11.How to add the months from the raw data as labels in the following bar
chart? - ANSWER right click the chart - select data - select D45:O45 as
axis label range
12.To optimize an output, you would use ___; to find out the value of an
assumption that is needed to hit a certain budget target, you would use
___. - ANSWER Solver; Goal Seek
, 13.You would use scenario analysis when: - ANSWER Comparing different
business cases about the future with multiple variables changed
14.Which of the following best describes the top-down analysis to forecast
revenue? - ANSWER Start with the total addressable market and
forecast the revenue based on market share and segments. ***(not sure)
15.What's the forecasted capital expenditure based on the information below?
(4,200, 6,800, 900) - ANSWER 3500 (end - beginning) + depreciation
16.When performing a sensitivity analysis, which of the following
tools/functions in Excel is NOT commonly used? - ANSWER Index Match
Match
17.What is the total cash from operating activities based on the information
below? (620, 240, 210, 90, 160) - ANSWER 720; Net Income +
Depreciation - Increase in receivables - Increase in Inventory + Increase in
payables
18.What formula below is commonly used to forecast accounts payable? -
ANSWER Accounts Payable = Cost of Sales x Payable Days / 365
19.A firm generated annual revenue of 75,000 and has accounts payable of
3,260. The gross profit margin is 23.3%. The payable days estimated from
the data above is closest to ___ - ANSWER 21; get gross profit and then
calculate COGS, the do AP Days = AP/COGS x 365
Conceptual Actual Exam Questions With Reviewed 100%
Correct Detailed Answers
Guaranteed Pass!!Current Update
1. Which ratio would you use to determine how much profit a company makes
after paying off its cost of goods sold? - ANSWER Gross Profit Margin
Ratio
2. What actions could a company take to reduce its working capital funding
gap? - ANSWER Negotiate the contract with suppliers to be able to
delay the payments
3. What could be the yield to maturity for a 3 year bond with a 8% annual
coupon if the bond is trading at discount? - ANSWER 9% (discount -
YTM > Coupon)
4. Which of the following best describes the efficiency ratios? - ANSWER
These ratios measure how efficiently a company is utilizing its assets and
resources
5. The keyboard shortcuts Ctrl + 1 (PC) or Command + 1 (MAC) performs
which of the following actions? - ANSWER Open the format cells
window
,6. What is the present value of a cash inflow of $2,000 five years from now if
the required rate of return is 6%? - ANSWER 1494.52 (2000/(1.06^5)
7. Based on the company's budget and actual figures, the company is facing
___? - ANSWER Unfavorable sales price and unfavorable total variable
costs (actual sales price lower and total variable costs higher)
8. What is the discount factor for a semi-annual coupon that will be received
in 12 months if the quoted annual yield is 8% - ANSWER =
1/1*(1+Discount rate)^n = 0.92 (0.93 rounded)
9. What's the forecasted EBIT based on the information below? (8100, 4900,
1500, 400, 150, 390) - ANSWER 1300
10.The net profit margin ratio can mathematically be broken down as: -
ANSWER Tax impact x Capital structure impact x EBIT / Sales
11.How to add the months from the raw data as labels in the following bar
chart? - ANSWER right click the chart - select data - select D45:O45 as
axis label range
12.To optimize an output, you would use ___; to find out the value of an
assumption that is needed to hit a certain budget target, you would use
___. - ANSWER Solver; Goal Seek
, 13.You would use scenario analysis when: - ANSWER Comparing different
business cases about the future with multiple variables changed
14.Which of the following best describes the top-down analysis to forecast
revenue? - ANSWER Start with the total addressable market and
forecast the revenue based on market share and segments. ***(not sure)
15.What's the forecasted capital expenditure based on the information below?
(4,200, 6,800, 900) - ANSWER 3500 (end - beginning) + depreciation
16.When performing a sensitivity analysis, which of the following
tools/functions in Excel is NOT commonly used? - ANSWER Index Match
Match
17.What is the total cash from operating activities based on the information
below? (620, 240, 210, 90, 160) - ANSWER 720; Net Income +
Depreciation - Increase in receivables - Increase in Inventory + Increase in
payables
18.What formula below is commonly used to forecast accounts payable? -
ANSWER Accounts Payable = Cost of Sales x Payable Days / 365
19.A firm generated annual revenue of 75,000 and has accounts payable of
3,260. The gross profit margin is 23.3%. The payable days estimated from
the data above is closest to ___ - ANSWER 21; get gross profit and then
calculate COGS, the do AP Days = AP/COGS x 365
