EXCEL FINANCE MODELING CERTIFICATION TEST - (90 QUESTIONS) UP-TO-DATE
ACTUAL EXAM QUESTIONS AND 100% ACCURATE SOLUTIONS | VERIFIED ANSWERS -
INSTANT PDF DOWNLOAD
Candidate Name: ____________________________
Candidate ID: ________________________________
Date: _______________________________________
Examination Centre: __________________________
Time Allowed: 180 Minutes
Total Questions: 90
Instructions: Answer all questions. Use Excel-based logic and financial modeling principles
where applicable.
Core Competency Areas Assessed:
Financial Statement Modeling
Discounted Cash Flow (DCF) Analysis
, Sensitivity & Scenario Analysis
Excel Functions & Formula Optimization
Valuation Techniques
Forecasting & Assumptions Building
Error Checking & Model Auditing
_ Introduction _
This assessment evaluates a candidate’s ability to build, analyze, and interpret financial
models using spreadsheet tools, primarily Excel. The test focuses on applied corporate
finance, valuation methods, and best practices in structuring dynamic and scalable
financial models. Candidates are expected to demonstrate strong analytical thinking,
logical structuring of formulas, and the ability to translate financial assumptions into
accurate outputs.
_ Candidate Instructions _
You are required to complete 90 questions within 180 minutes. Each question is designed
to test applied knowledge in Excel-based financial modeling. Choose the most
appropriate answer for each scenario. Calculations should follow standard financial
,modeling practices. Avoid assumptions not supported by the question. Ensure accuracy
and efficiency in interpreting financial data and formulas.
Disclaimer: This is an original simulated examination designed for educational and
preparation purposes. It is not affiliated with or taken from any official certification body.
Q1. You are building a three-statement financial model. Revenue is projected to grow at
10% annually, and accounts receivable is modeled as 20% of revenue. Which Excel formula
correctly calculates accounts receivable for Year 2 if Year 1 revenue is in cell B2? hard and
difficult level
A. =B21.10.2
B. =B20.2
C. =(B21.1)^0.2
D. =B2*(1.1+0.2)
Correct Answer: 🔴 A. =B21.10.2
Explanation: 🟡 Accounts receivable depends on next year's revenue. Year 2 revenue is B2 ×
1.1, then multiplied by 20%. Option B ignores growth, C misuses exponentiation, and D
incorrectly adds percentages.
, Q2. In a DCF model, which discount rate is most appropriate for unlevered free cash flow?
hard and difficult level
A. Cost of Equity
B. WACC
C. Cost of Debt
D. Dividend Yield
Correct Answer: 🔴 B. WACC
Explanation: 🟡 Unlevered free cash flow is discounted using Weighted Average Cost of
Capital (WACC). Cost of equity applies to levered cash flows. Debt cost alone ignores equity
component, and dividend yield is irrelevant.
Q3. Which Excel function is most appropriate for calculating NPV when cash flows are
unevenly spaced? hard and difficult level
A. NPV
B. IRR
C. XNPV
D. PMT
Correct Answer: 🔴 C. XNPV
Explanation: 🟡 XNPV accounts for actual dates, unlike NPV which assumes equal spacing.
IRR calculates return, not value. PMT is for annuities.
ACTUAL EXAM QUESTIONS AND 100% ACCURATE SOLUTIONS | VERIFIED ANSWERS -
INSTANT PDF DOWNLOAD
Candidate Name: ____________________________
Candidate ID: ________________________________
Date: _______________________________________
Examination Centre: __________________________
Time Allowed: 180 Minutes
Total Questions: 90
Instructions: Answer all questions. Use Excel-based logic and financial modeling principles
where applicable.
Core Competency Areas Assessed:
Financial Statement Modeling
Discounted Cash Flow (DCF) Analysis
, Sensitivity & Scenario Analysis
Excel Functions & Formula Optimization
Valuation Techniques
Forecasting & Assumptions Building
Error Checking & Model Auditing
_ Introduction _
This assessment evaluates a candidate’s ability to build, analyze, and interpret financial
models using spreadsheet tools, primarily Excel. The test focuses on applied corporate
finance, valuation methods, and best practices in structuring dynamic and scalable
financial models. Candidates are expected to demonstrate strong analytical thinking,
logical structuring of formulas, and the ability to translate financial assumptions into
accurate outputs.
_ Candidate Instructions _
You are required to complete 90 questions within 180 minutes. Each question is designed
to test applied knowledge in Excel-based financial modeling. Choose the most
appropriate answer for each scenario. Calculations should follow standard financial
,modeling practices. Avoid assumptions not supported by the question. Ensure accuracy
and efficiency in interpreting financial data and formulas.
Disclaimer: This is an original simulated examination designed for educational and
preparation purposes. It is not affiliated with or taken from any official certification body.
Q1. You are building a three-statement financial model. Revenue is projected to grow at
10% annually, and accounts receivable is modeled as 20% of revenue. Which Excel formula
correctly calculates accounts receivable for Year 2 if Year 1 revenue is in cell B2? hard and
difficult level
A. =B21.10.2
B. =B20.2
C. =(B21.1)^0.2
D. =B2*(1.1+0.2)
Correct Answer: 🔴 A. =B21.10.2
Explanation: 🟡 Accounts receivable depends on next year's revenue. Year 2 revenue is B2 ×
1.1, then multiplied by 20%. Option B ignores growth, C misuses exponentiation, and D
incorrectly adds percentages.
, Q2. In a DCF model, which discount rate is most appropriate for unlevered free cash flow?
hard and difficult level
A. Cost of Equity
B. WACC
C. Cost of Debt
D. Dividend Yield
Correct Answer: 🔴 B. WACC
Explanation: 🟡 Unlevered free cash flow is discounted using Weighted Average Cost of
Capital (WACC). Cost of equity applies to levered cash flows. Debt cost alone ignores equity
component, and dividend yield is irrelevant.
Q3. Which Excel function is most appropriate for calculating NPV when cash flows are
unevenly spaced? hard and difficult level
A. NPV
B. IRR
C. XNPV
D. PMT
Correct Answer: 🔴 C. XNPV
Explanation: 🟡 XNPV accounts for actual dates, unlike NPV which assumes equal spacing.
IRR calculates return, not value. PMT is for annuities.
