Search test library by skills or roles
⌘ K

Financial & Excel Modeling Test

The financial modeling test assesses a candidate's understanding of fundamental financial modeling concepts like historical ratios, income statement, working capital, depreciation schedule, amortization schedule, shareholder equity schedule, stock options, cash flow statements, time value of money, capital asset pricing model and asset valuation and their ability to create and maintain financial models using Excel.

Get started for free
Preview questions

Screen candidates with a 45 mins test

Test duration:  45 mins
Difficulty level:  Moderate
Availability:  Ready to use
Questions:
  • 8 Financial Modeling MCQs
  • 4 Finance MCQs
  • 4 Excel MCQs
Covered skills:
Financial analysis
Financial planning
Financial forecasting
Financial reporting
Valuation
Investment analysis
Risk management
Budgeting
Financial statements
Cash flow statement
Depreciation schedule
Historical ratios
Time Value of money
Net present value
Internal rate of return
Financial Analysis
Asset Valuation
Stock Valuation
Risk And Return
Rate of return
Capital Asset Pricing Model
Excel Macros
Excel modeling
Get started for free
Preview questions

Use Adaface tests trusted by recruitment teams globally

Adaface is used by 1500+ businesses in 80 countries.

Adaface skill assessments measure on-the-job skills of candidates, providing employers with an accurate tool for screening potential hires.

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte NCS Sokrati J&T Express Capegemini

Use the Financial & Excel Modeling Assessment Test to shortlist qualified candidates

The Financial & Excel Modeling Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

  • Ability to prepare detailed financial models
  • Strong understanding of financial analysis and forecasting
  • Capability to analyze and interpret financial statements
  • Proficiency in valuation techniques
  • Knowledge of investment analysis and risk management
  • Skill in budgeting and financial planning
  • Ability to create and analyze cash flow statements
  • Understanding of time value of money concepts
  • Proficiency in Excel modeling and macros
  • Capability to perform asset and stock valuation
  • Competence in using the Capital Asset Pricing Model
  • Ability to evaluate risk and return in financial decision making
Get started for free
Preview questions

Screen candidates with the highest quality questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

These are just a small sample from our library of 15,000+ questions. The actual questions on this Financial & Excel Modeling Test will be non-googleable.

🧐 Question

Medium

Compound Revenue Growth Rate
Projections
Income Statement
Solve
Given the following information for the company NotOpenAI:
 image
What is the projected Year 6 Revenue based on the historical compound annual growth rate (CAGR)?

Medium

Depreciation on new Capex
Depreciation Schedule
Projections
Solve
Our financial intern deleted the entries for the Depreciation from new CapEx by mistake. Can you help them calculate the total depreciation on new CapEx in Year 3?
 image

Medium

Projected Current Ratio
Projections
Balance Sheet
Solve
Given the following information for the company NotOpenAI:
 image
What is the projected Year 6 Current Ratio based on the historical average Current Ratio?

Medium

Earnings Per Share
Solve
Consider the following financial data for 3 companies (in millions) for the year 2022:
 image
Which company has the highest Earnings Per Share (EPS) if each company has 50 million outstanding shares?

Medium

Net cash receipt on issued bonds
Solve
Gajni Inc. issued 2000 $100 9% bonds on May 1 (year 1). These bonds are issued at 103 plus accrued interest. The bonds are dated Jan 1 (year 1) and mature on Jan 1 (year 5). Interest needs to be paid twice a year (Jan 1 and July 1). The cost of issuing the bonds, $5000 was paid by Gajni Inc. to the investment bank. What would be the net cash receipt realized by Gajni Inc. from the issuance of these bonds?

Medium

Return on Capital Employed
Solve
Consider the following financial data for five companies for the year 2022:
 image
Which company has the highest Return on Capital Employed (ROCE)?

Easy

Hedge risk using derivates
Solve
Phenomenal Pte. Ltd., a Singapore based company secured a new client in Germany for their SaaS business, and is expecting to receive a payment of EUR 1.3 million after 6 weeks. They want to be certain of the amount they receive and plan on using the derivates market to hedge the risk. What action would you recommend?

Medium

MATCH INDEX LOOKUP
Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
 image

Medium

Organization data
Data transformation
Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved:
 image
We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data?

A: Select the Organization ID and Country columns, and then click Keep Duplicates.
B: Select the Organization ID and Country columns, and then click Remove Duplicates.
C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation.
D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.

Medium

Student scores
Data formatting
Solve
Here’s a sample Excel data source:
 image
Here’s the expected data format: 
 image
Which of the following is the correct way to transform the data from the query editor to achieve the result?

A: Columns to Select: Student Only
B: Columns to Select: Student and Student ID
C: Columns to Select: Primary and Secondary
D: Command to Use: Pivot Column
E: Command to Use: Reverse Rows
F: Command to Use: Unpivot Columns

Medium

VLOOKUP blood donor
Solve
We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
 image
A: =VLOOKUP("O-", A1:E10, 3, TRUE)
B: =VLOOKUP("O-", A1:E10, 3, FALSE)
C: =VLOOKUP("O-", D1:D10, 4)
D: =VLOOKUP("O-", D1:D10, 3)
E: =VLOOKUP("O-", A1:E10, 4, TRUE)
F: =VLOOKUP("O-", A1:E10, 4, FALSE)
G: =VLOOKUP("Kane", A1:E10, 4)
🧐 Question🔧 Skill

Medium

Compound Revenue Growth Rate
Projections
Income Statement

3 mins

Financial Modeling
Solve

Medium

Depreciation on new Capex
Depreciation Schedule
Projections

3 mins

Financial Modeling
Solve

Medium

Projected Current Ratio
Projections
Balance Sheet

3 mins

Financial Modeling
Solve

Medium

Earnings Per Share

3 mins

Finance
Solve

Medium

Net cash receipt on issued bonds

3 mins

Finance
Solve

Medium

Return on Capital Employed

3 mins

Finance
Solve

Easy

Hedge risk using derivates

2 mins

Finance
Solve

Medium

MATCH INDEX LOOKUP

2 mins

Excel
Solve

Medium

Organization data
Data transformation

3 mins

Excel
Solve

Medium

Student scores
Data formatting

2 mins

Excel
Solve

Medium

VLOOKUP blood donor

2 mins

Excel
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Compound Revenue Growth Rate
Projections
Income Statement
Financial Modeling
Medium3 mins
Solve
Depreciation on new Capex
Depreciation Schedule
Projections
Financial Modeling
Medium3 mins
Solve
Projected Current Ratio
Projections
Balance Sheet
Financial Modeling
Medium3 mins
Solve
Earnings Per Share
Finance
Medium3 mins
Solve
Net cash receipt on issued bonds
Finance
Medium3 mins
Solve
Return on Capital Employed
Finance
Medium3 mins
Solve
Hedge risk using derivates
Finance
Easy2 mins
Solve
MATCH INDEX LOOKUP
Excel
Medium2 mins
Solve
Organization data
Data transformation
Excel
Medium3 mins
Solve
Student scores
Data formatting
Excel
Medium2 mins
Solve
VLOOKUP blood donor
Excel
Medium2 mins
Solve

Test candidates on core Financial & Excel Modeling Hiring Test topics

Financial Analysis: Financial analysis refers to the assessment of a company's financial performance, including the analysis of financial statements, ratios, and trends. It helps in evaluating the company's profitability, liquidity, and solvency, providing insights into its financial health and performance.

Financial Planning: Financial planning involves developing a comprehensive strategy to manage and allocate financial resources effectively. It includes creating budgets, setting financial goals, and formulating investment plans to achieve those goals. This skill is measured in the test to assess a candidate's ability to develop and execute financial plans.

Financial Forecasting: Financial forecasting is the process of predicting future financial outcomes based on historical data and market trends. It helps in estimating revenues, expenses, and cash flows, enabling businesses to make informed decisions and plans. This skill is measured in the test to evaluate a candidate's ability to forecast financial outcomes accurately.

Financial Reporting: Financial reporting involves preparing and presenting financial statements and reports to communicate relevant financial information to stakeholders. It includes the preparation of balance sheets, income statements, and cash flow statements. This skill is measured in the test to assess a candidate's proficiency in accurately preparing financial reports.

Valuation: Valuation refers to the process of determining the intrinsic value of an asset, such as a business, stock, or investment. It involves analyzing various factors and methodologies to estimate the fair value of the asset. This skill is measured in the test to evaluate a candidate's ability to assess the worth of different assets.

Investment Analysis: Investment analysis involves evaluating the potential risks and returns of different investment opportunities. It includes analyzing financial statements, market trends, and industry dynamics to make informed investment decisions. This skill is measured in the test to assess a candidate's ability to analyze and recommend suitable investment options.

Risk Management: Risk management is the process of identifying, assessing, and mitigating potential risks that may impact an organization's financial objectives. It includes developing risk avoidance and risk mitigation strategies to minimize potential losses. This skill is measured in the test to evaluate a candidate's understanding of risk management techniques.

Budgeting: Budgeting involves the process of planning and allocating financial resources to achieve organizational goals. It includes estimating expenses, setting financial targets, and monitoring actual spending against the budget. This skill is measured in the test to assess a candidate's ability to create and manage budgets effectively.

Financial Statements: Financial statements are formal records of a company's financial activities, including the balance sheet, income statement, and cash flow statement. These statements provide essential information about an organization's financial performance, position, and cash flows. This skill is measured in the test to evaluate a candidate's proficiency in analyzing and interpreting financial statements.

Cash Flow Statement: A cash flow statement is a financial statement that shows the inflows and outflows of cash during a specific period. It provides insights into a company’s liquidity, operating activities, and investing/financing decisions. This skill is measured in the test to assess a candidate's understanding of cash flow analysis and their ability to interpret cash flow statements.

Depreciation Schedule: A depreciation schedule is a document that outlines the depreciation expense of an asset over its useful life. It helps in allocating the cost of an asset over time and reflects the reduction in its value due to wear and tear or obsolescence. This skill is measured in the test to evaluate a candidate's ability to calculate and track depreciation expenses.

Historical Ratios: Historical ratios are financial metrics calculated based on historical financial data. They provide insights into a company's past financial performance and can be used to analyze trends and make comparisons. This skill is measured in the test to assess a candidate's proficiency in analyzing and interpreting historical financial ratios.

Time Value of Money: The time value of money is a concept that states that the value of money changes over time due to factors such as inflation, interest rates, and opportunity costs. It is important in financial analysis and investment decision-making as it helps in evaluating the worth of cash flows occurring at different times. This skill is measured in the test to evaluate a candidate's understanding of the time value of money and its application in financial calculations.

Net Present Value: Net present value (NPV) is a financial metric used to assess the profitability of an investment by discounting the future cash flows to their present value. Positive NPV indicates that the investment is expected to generate more value than the initial investment, while negative NPV implies a potential loss. This skill is measured in the test to assess a candidate's ability to calculate and interpret NPV.

Internal Rate of Return: Internal rate of return (IRR) is a financial metric used to assess the attractiveness of an investment by calculating the discount rate at which the net present value (NPV) of the investment becomes zero. It helps in determining the rate of return that an investment is expected to generate. This skill is measured in the test to evaluate a candidate's ability to calculate and interpret IRR.

Asset Valuation: Asset valuation refers to the process of determining the worth of an asset, such as property, equipment, or inventories. It involves analyzing factors such as market conditions, replacement costs, and income potential to estimate the fair value of the asset. This skill is measured in the test to assess a candidate's ability to value different types of assets.

Stock Valuation: Stock valuation is the process of determining the intrinsic value of a company's stock. It involves analyzing financial statements, market trends, and industry dynamics to estimate the fair value of the stock. This skill is measured in the test to evaluate a candidate's ability to analyze and value stocks.

Risk And Return: Risk and return are two essential concepts in finance that go hand in hand. Risk refers to the possibility of losing some or all of the invested capital, while return represents the gain or loss on the investment. Measuring a candidate's understanding of risk and return helps in assessing their ability to make informed investment decisions.

Rate of Return: Rate of return is a financial measure used to evaluate the profitability of an investment over a specific period. It represents the percentage gain or loss on an investment relative to its initial cost. Measuring a candidate's ability to calculate and interpret rates of return helps in assessing their analytical skills in investment analysis and performance evaluation.

Capital Asset Pricing Model: The Capital Asset Pricing Model (CAPM) is a financial model used to estimate the expected return on an investment based on its risk relative to the overall market. It helps in determining the appropriate required rate of return for an investment. Measuring a candidate's understanding of CAPM helps in assessing their knowledge of asset pricing and risk management.

Excel Macros: Excel macros are automated sequences of commands and functions written in Visual Basic for Applications (VBA) programming language. They enable users to automate repetitive tasks, perform complex calculations, and interact with data in Excel. Measuring a candidate's proficiency in Excel macros helps in assessing their ability to optimize workflows and enhance productivity.

Excel Modeling: Excel modeling refers to the process of creating financial models using Excel to analyze and forecast financial data. It involves using formulas, functions, and data analysis techniques to build dynamic models that facilitate decision-making. Measuring a candidate's skill in Excel modeling helps in assessing their ability to effectively use Excel for financial analysis and forecasting.

Get started for free
Preview questions

Make informed decisions with actionable reports and benchmarks

View sample scorecard

Screen candidates in 3 easy steps

Pick a test from over 500+ tests

The Adaface test library features 500+ tests to enable you to test candidates on all popular skills- everything from programming languages, software frameworks, devops, logical reasoning, abstract reasoning, critical thinking, fluid intelligence, content marketing, talent acquisition, customer service, accounting, product management, sales and more.

Invite your candidates with 2-clicks

Make informed hiring decisions

Get started for free
Preview questions

Try the most advanced candidate assessment platform

ChatGPT Protection

Non-googleable Questions

Web Proctoring

IP Proctoring

Webcam Proctoring

MCQ Questions

Coding Questions

Typing Questions

Personality Questions

Custom Questions

Ready-to-use Tests

Custom Tests

Custom Branding

Bulk Invites

Public Links

ATS Integrations

Multiple Question Sets

Custom API integrations

Role-based Access

Priority Support

GDPR Compliance


Pick a plan based on your hiring needs

The most advanced candidate screening platform.
14-day free trial. No credit card required.

From
$15
per month (paid annually)
love bonito

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!

Brandon Lee, Head of People, Love, Bonito

Brandon
love bonito

It's very easy to share assessments with candidates and for candidates to use. We get good feedback from candidates about completing the tests. Adaface are very responsive and friendly to deal with.

Kirsty Wood, Human Resources, WillyWeather

Brandon
love bonito

We were able to close 106 positions in a record time of 45 days! Adaface enables us to conduct aptitude and psychometric assessments seamlessly. My hiring managers have never been happier with the quality of candidates shortlisted.

Amit Kataria, CHRO, Hanu

Brandon
love bonito

We evaluated several of their competitors and found Adaface to be the most compelling. Great library of questions that are designed to test for fit rather than memorization of algorithms.

Swayam Narain, CTO, Affable

Brandon

Have questions about the Financial & Excel Modeling Hiring Test?

How does pricing work?

You can check out our pricing plans.

Can I customize the test?

Yes, absolutely. Custom assessments are set up within 48 hours based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test. You can also customize a test by uploading your own questions.

Can I combine multiple skills into one test?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test.

What roles can I use the Financial & Excel Modeling Assessment Test for?

Here are few roles for which we recommend this test:

  • Financial Analyst
  • Business Analyst
  • Accountant
  • Finance Manager
  • Risk Analyst
  • Data Analyst
  • Management Consultant
Can I see a sample test, or do you have a free trial?

Yes!

The free trial includes one sample technical test (Java/ JavaScript) and one sample aptitude test that you will find in your dashboard when you sign up. You can use it to review the quality of questions and the candidate experience of giving a test on Adaface.

You can preview any of the 500+ tests and see the sample questions to decide if it would be a good fit for your requirements.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

customers across world
Join 1500+ companies in 80+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to use the Adaface Financial & Excel Modeling Test?
Ready to use the Adaface Financial & Excel Modeling Test?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
Terms Privacy Trust Guide
ada
Ada
● Online
Previous
Score: NA
Next
✖️