CORPORATE FINANCE EXAM 2025/2026 WITH
ACTUAL CORRECT QUESTIONS AND
VERIFIED DETAILED ANSWERS
|CURRENTLY TESTING QUESTIONS AND
SOLUTIONS|ALREADY GRADED
A+|NEWEST|BRAND NEW VERSION
!!|GUARANTEED PASS
Identify which of the following is not a goal of the variance dashboard.
A detailed written report
To find out the value of the assumptions that are needed to hit a certain budget target, you
would use ______; to optimize an output, you would use ______.
Goal seek, solver
Which of the following is NOT an advantage to link workbooks?
The links will update themselves when the file name changes
Please open the attached Excel file.
Budgeting & Forecasting Assessment-Questions.xlsx
Use simple linear regression to estimate the relationship between promotion and revenue for
ABC Company. What will the revenue be when the promotion cost is 150?
$1059.51
Use the same Excel data in the previous question and run a multiple regression to estimate the
relationship between promotion, advertising (independent variables) and revenue (dependent
variable). Calculate the revenue if the promotion cost is $150 and the advertising cost is $250.
1060.83
Inputs should be blue colored font and should have ________ only. Process and outputs should
be in black colored font and have _______ only.
hardcoded numbers only, formulas only
1|Page
,The annual accounts payable is 4,800; the annual revenue is 75,000, and the gross profit margin
is 40%. The payable days estimated from the data above is ______.
39
The annual accounts receivable is 3,000; the annual sales 40,000, and the gross profit margin is
40%.
The receivable days estimated from the data above is _____.
27.4
The opening balance of Company A is 25,000, and the repayment is scheduled for 1,000 per
month at an annual interest rate of 5%. Use the average debt balance to calculate the interest
payment.
The closing balance of debt at the end of the month is _____ and the interest payment is _____.
24,000; 102
To arrive at operating cash flows, you should start with _______, _______ non-cash items and
then adding or subtracting changes in working capital.
net income, adding
From the chart above, decision makers should pay most attention to the month:
Sep 2018
The PP&E gross book value at the start of the month is 60,000, and the CAPEX of the month is
12,000. The accumulated depreciation at the start of the month is 25,000; the depreciation
expense of the month is 750.The net book value of PP&E calculated from the data above is
_____.
46,250
Data validation works for setting a reasonable range for _______.
Inputs
The chart above is an example of a combination of a ________ chart and a ________ chart.
stacked column, line
Before protecting a worksheet to avoid people from editing the formulas, you must ________.
unlock the input cells
For a line graph, removing which of the following items would create the cleanest look?
2|Page
, Gridlines
Suppose you want to make a gauge chart on website traffic in the same format as in the
presentation.
This gauge chart was based on the following data:
What value should be outputted as in cell E69?
60
Suppose you want to make a gauge chart on website traffic in the same format as in the
presentation.
This gauge chart was based on the following data
What value should be outputted as in cell E71?
290
What do you set as the angle of the first slice in order to properly convert and format the above
gauge chart?
270°
As an alternative to CTRL + C and then CTRL + V to perform copy and paste, what combination
of keys (as outlined in the videos) will perform the same action?
CTRL + D
Building a heat map would be an appropriate way to visualize data in which of the following?
Sensitivity Analysis
Assuming a section of data is highlighted, which of the following Excel shortcuts opens
Recommended Charts?
ALT + N + R
Which of the following is NOT a pre-attentive attribute discussed in the course?
Comments
If the last data point in this chart is the accumulated total (1258), what will you do to set up the
chart properly?
Right click the last data point and select "Set as Total"
Under which tab in Excel would you be able to open the Page Break Preview?
3|Page
ACTUAL CORRECT QUESTIONS AND
VERIFIED DETAILED ANSWERS
|CURRENTLY TESTING QUESTIONS AND
SOLUTIONS|ALREADY GRADED
A+|NEWEST|BRAND NEW VERSION
!!|GUARANTEED PASS
Identify which of the following is not a goal of the variance dashboard.
A detailed written report
To find out the value of the assumptions that are needed to hit a certain budget target, you
would use ______; to optimize an output, you would use ______.
Goal seek, solver
Which of the following is NOT an advantage to link workbooks?
The links will update themselves when the file name changes
Please open the attached Excel file.
Budgeting & Forecasting Assessment-Questions.xlsx
Use simple linear regression to estimate the relationship between promotion and revenue for
ABC Company. What will the revenue be when the promotion cost is 150?
$1059.51
Use the same Excel data in the previous question and run a multiple regression to estimate the
relationship between promotion, advertising (independent variables) and revenue (dependent
variable). Calculate the revenue if the promotion cost is $150 and the advertising cost is $250.
1060.83
Inputs should be blue colored font and should have ________ only. Process and outputs should
be in black colored font and have _______ only.
hardcoded numbers only, formulas only
1|Page
,The annual accounts payable is 4,800; the annual revenue is 75,000, and the gross profit margin
is 40%. The payable days estimated from the data above is ______.
39
The annual accounts receivable is 3,000; the annual sales 40,000, and the gross profit margin is
40%.
The receivable days estimated from the data above is _____.
27.4
The opening balance of Company A is 25,000, and the repayment is scheduled for 1,000 per
month at an annual interest rate of 5%. Use the average debt balance to calculate the interest
payment.
The closing balance of debt at the end of the month is _____ and the interest payment is _____.
24,000; 102
To arrive at operating cash flows, you should start with _______, _______ non-cash items and
then adding or subtracting changes in working capital.
net income, adding
From the chart above, decision makers should pay most attention to the month:
Sep 2018
The PP&E gross book value at the start of the month is 60,000, and the CAPEX of the month is
12,000. The accumulated depreciation at the start of the month is 25,000; the depreciation
expense of the month is 750.The net book value of PP&E calculated from the data above is
_____.
46,250
Data validation works for setting a reasonable range for _______.
Inputs
The chart above is an example of a combination of a ________ chart and a ________ chart.
stacked column, line
Before protecting a worksheet to avoid people from editing the formulas, you must ________.
unlock the input cells
For a line graph, removing which of the following items would create the cleanest look?
2|Page
, Gridlines
Suppose you want to make a gauge chart on website traffic in the same format as in the
presentation.
This gauge chart was based on the following data:
What value should be outputted as in cell E69?
60
Suppose you want to make a gauge chart on website traffic in the same format as in the
presentation.
This gauge chart was based on the following data
What value should be outputted as in cell E71?
290
What do you set as the angle of the first slice in order to properly convert and format the above
gauge chart?
270°
As an alternative to CTRL + C and then CTRL + V to perform copy and paste, what combination
of keys (as outlined in the videos) will perform the same action?
CTRL + D
Building a heat map would be an appropriate way to visualize data in which of the following?
Sensitivity Analysis
Assuming a section of data is highlighted, which of the following Excel shortcuts opens
Recommended Charts?
ALT + N + R
Which of the following is NOT a pre-attentive attribute discussed in the course?
Comments
If the last data point in this chart is the accumulated total (1258), what will you do to set up the
chart properly?
Right click the last data point and select "Set as Total"
Under which tab in Excel would you be able to open the Page Break Preview?
3|Page
