ABC Financial Modeling & Forecasting 2

Question 1

In a three-statement financial model, which statement serves as the primary driver that feeds into both the balance sheet and cash flow statement?

Accepted Answer

Income statement

Answer

The income statement drives net income, which flows into retained earnings on the balance sheet and is the starting point for the cash flow statement.

Question 2

A company's Days Sales Outstanding (DSO) is 45 days. If annual revenue is $3.6 million, what is the approximate accounts receivable balance?

Accepted Answer

$444,000

Answer

DSO = (AR / Revenue) × 365, so AR = (45 / 365) × $3,600,000 ≈ $443,836.

Question 3

Which forecasting method assigns different weights to historical data points, giving more importance to recent periods?

Accepted Answer

Exponential smoothing

Answer

Exponential smoothing applies a smoothing factor that gives exponentially decreasing weight to older observations.

Question 4

When building a sensitivity analysis in a financial model, what is the primary purpose of a data table in Excel?

Accepted Answer

To show how output changes across multiple input variable combinations

Answer

A data table simultaneously calculates results for a range of one or two input variables, showing their combined impact on a key output.

Question 5

In financial modeling, 'hardcoding' refers to:

Accepted Answer

Entering a fixed numeric value directly into a formula cell

Answer

Hardcoding means embedding a literal number directly in a formula rather than referencing a designated input cell, making models harder to audit and update.

(ABC) Accredited Business Communicator Practice Test

(ABC) Accredited Business Communicator Practice Test

ABC Financial Modeling & Forecasting 2