Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Pregrad Month 2

Total questions: 50

Worksheet time: 1hrs 27mins

Name
Class
Date
1.

Kavya is reviewing her company's financial health and needs to determine which financial statement will provide her with the best insight into the firm's liquidity position at a specific point in time.

a)

Income Statement

b)

Balance Sheet

c)

Cash Flow Statement

d)

Statement of Retained Earnings

2.

Aditi is analyzing her company's financial performance and decides to create a common-size income statement. She wants to express all items as a percentage of:

a)

Total assets

b)

Net income

c)

Sales revenue

d)

Equity

3.

In DuPont Analysis, a decrease in equity multiplier with constant ROA will result in:

a)

Higher ROE

b)

Lower ROE

c)

No impact on ROE

d)

Increase in profit margin

4.

In a recent financial analysis, Kabir, the CFO of a manufacturing company, is evaluating the firm's performance. He wants to determine which ratio best captures the firm's ability to generate profit from its core operations.

a)

Gross margin

b)

Operating margin

c)

Net profit margin

d)

Return on Assets

5.

Myra's company has been experiencing a consistently negative cash flow from investing activities. This situation usually indicates:

a)

Declining profitability

b)

Excessive dividend payouts

c)

Expansion and capital investments

d)

Inefficient cost control

6.

Myra's company has reported a positive operating cash flow for the year, but surprisingly, the net income is negative. The most likely reason for this discrepancy is:

a)

High depreciation expenses

b)

Increase in accounts receivable

c)

Rise in inventory levels

d)

Decline in gross margins

7.

Avyaan, a financial analyst at a leading investment firm, is tasked with integrating financial statements into valuation models. This process primarily supports:

a)

Corporate governance decisions

b)

Strategic forecasting and valuation

c)

Employee compensation planning

d)

Audit risk assessment

8.

Rohan is preparing a financial model for his startup and needs to project revenue growth. He knows that the assumptions he uses for this projection are generally classified as:

a)

Output variables

b)

Independent drivers

c)

Forecast errors

d)

Non-operating inputs

9.

A sensitivity analysis examines:

a)

Multiple variables changing simultaneously

b)

Impact of one variable on model output

c)

Model errors based on historical data

d)

Scenarios where assumptions remain constant

10.

In a business meeting, Tara is analyzing different sales strategies for the upcoming quarter. She needs to evaluate various scenarios to determine the best approach. Which Excel function is MOST commonly used for scenario analysis?

a)

OFFSET

b)

IF

c)

INDEX-MATCH

d)

CHOOSE

11.

A balanced financial model must satisfy which condition?

a)

Cash inflows = Cash outflows

b)

Total assets = Total liabilities + equity

c)

Net income = Cash flow from operations

d)

Retained earnings = Net income – dividends

12.

A major purpose of model validation is to:

a)

Ensure model includes all possible variables

b)

Confirm accuracy, logic, and linkage integrity

c)

Eliminate subjective assumptions

d)

Improve graphical output

13.

Aarav is building a financial model for his startup, and he notices that he has created a situation where certain calculations depend on each other in a circular manner. This issue primarily occurs due to:

a)

Revenue driver formulas

b)

Linked depreciation schedules

c)

Interest expense linked to ending debt balances

d)

Working capital calculations

14.

Divya is preparing a financial report for her company and needs to ensure that her revenue projections are realistic. She wants to choose the BEST technique to validate these projections against actual market conditions. What should she use?

a)

Goal Seek

b)

Trend analysis vs industry growth

c)

Scenario simulation

d)

Sensitivity testing

15.

Myra is analyzing her company's cash flows for the upcoming quarter. She realizes that changes in working capital, such as inventory levels and accounts receivable, usually affect:

a)

Investing cash flow

b)

Financing cash flow

c)

Operating cash flow

d)

Retained earnings

16.

In a DCF model, terminal value generally represents:

a)

5–10% of total firm value

b)

Future value of dividends

c)

Majority of the firm’s total value

d)

Value of tangible assets only

17.

Rohan is evaluating several companies in the technology sector to determine their market value. He knows that in Comparable Company Analysis (CCA), the most commonly used valuation multiple is:

a)

Price-to-book

b)

EV/EBITDA

c)

Dividend yield

d)

PEG ratio

18.

A key disadvantage of precedent transaction analysis is:

a)

It requires too little data

b)

Market conditions during past deals may differ

c)

It ignores control premiums

d)

It cannot be used for private companies

19.

When Tara's company is evaluating its financing options, she notices that the weighted average cost of capital (WACC) decreases when:

a)

Equity becomes more expensive

b)

Debt interest rates rise

c)

The firm adds cheaper debt financing

d)

The firm's beta increases

20.

Siya is evaluating a company using DCF valuation. She wants to understand what components are included in the free cash flow to firm (FCFF). She realizes that FCFF excludes certain financial elements. Which of the following does FCFF exclude?

a)

Operating taxes

b)

Depreciation

c)

Net interest payments

d)

Working capital requirements

21.

Asher is analyzing a tech startup that has a high valuation multiple compared to its competitors. He wonders what this might indicate about the company's future.

a)

Lower future growth expectations

b)

Higher risk and lower profitability

c)

Better growth prospects or market premium

d)

Declining market share

22.

Imagine Anika is an investor looking to fund a promising early-stage startup that has not yet generated any revenue. She is trying to determine the best method to value this startup before making her investment decision. Which method is MOST appropriate for valuing early-stage, pre-revenue startups?

a)

Price-to-earnings

b)

Dividend discount model

c)

Market multiples

d)

Scenario-based DCF or First Chicago Method

23.

In investment analysis, the metric most closely aligned with value creation is:

a)

Payback period

b)

Internal rate of return (IRR)

c)

Book value per share

d)

Dividend payout ratio

24.

Aashi is evaluating a new project for her company. The project has a positive Net Present Value (NPV), but the Internal Rate of Return (IRR) is below the company's cost of capital. What does this indicate?

a)

Conflicting decision rules

b)

Incorrect cash flow forecast

c)

Infeasible project

d)

Project with no risk

25.

In M&A, a control premium is paid primarily because:

a)

Prisha wants access to financial statements

b)

The target firm has declining revenues

c)

Rohan gains decision-making authority and synergies

d)

Sellers demand compensation for taxes

26.

In a recent merger between two tech companies, Sanya and Avyaan, the synergies in their M&A deal are reflected in valuation mainly by:

a)

Lower purchase price

b)

Higher combined cash flows in future periods

c)

Reduced working capital needs

d)

Elimination of debt obligations

27.

Siya is evaluating a potential merger with a competitor. A key step in the M&A valuation process is:

a)

Estimating replacement cost of assets

b)

Determining post-acquisition capital structure

c)

Identifying comparable countries

d)

Calculating marketing expenses

28.

When valuing a leveraged buyout (LBO), the primary focus is on:

a)

Dividends

b)

Free cash flow to equity

c)

Debt capacity and IRR for equity investors

d)

Comparable transaction multiples

29.

In M&A transactions, goodwill is created when a company, such as Viaan Corp, acquires another company, like Aanya Industries, for a price that exceeds the fair market value of its identifiable assets. This excess payment reflects the value of intangible assets such as brand reputation, customer relationships, and employee expertise.

4 lines
30.

During the due diligence process of a merger between two companies, the financial team discovered several discrepancies in the financial statements. The MOST critical reason for valuation adjustments during this M&A due diligence is:

a)

Correcting for market volatility

b)

Uncovering off-balance-sheet liabilities

c)

Harmonizing accounting software

d)

Meeting regulatory filing requirements

31.

Krish runs a successful company with a Net Profit Margin of 12%. His company has an Asset Turnover of 1.8× and an Equity Multiplier of 2.4×. What is the Return on Equity (ROE) according to the DuPont analysis?

a)

43.2%

b)

51.8%

c)

29.2%

d)

36.5%

32.

Eshaan's company has current assets of $500,000 and inventory of $150,000. Current ratio = 2.5. What is current liabilities?

a)

$350,000

b)

$200,000

c)

$125,000

d)

$50,000

33.

Aanya runs a small business and wants to calculate her Operating Cash Flow. She knows that Operating Cash Flow = Net Income + Depreciation – Increase in Working Capital. Given: Net Income = $90,000, Depreciation = $40,000, and her Working Capital increases by $25,000. What is Aanya's Operating Cash Flow?

a)

$125,000

b)

$105,000

c)

$130,000

d)

$140,000

34.

Aashi's firm has EBIT = $300,000, tax rate = 30%, depreciation = $50,000, capex = $80,000, and increase in working capital = $20,000. Find FCFF.

a)

$160,000

b)

$210,000

c)

$150,000

d)

$135,000

35.

A bond with annual coupon 6% (on par 1,000), required return 8%, maturity 5 years. What is its approximate value?

a)

$920–$930

b)

$960–$970

c)

$1,040–$1,050

d)

$880–$890

36.

Avyaan is evaluating a company that has a Free Cash Flow to the Firm (FCFF) projected at $120,000 for the next year, which is expected to grow at a rate of 4% indefinitely. The company's Weighted Average Cost of Capital (WACC) is 10%. What is the estimated value of the firm using the perpetuity with growth formula?

a)

$1,200,000

b)

$2,000,000

c)

$1,800,000

d)

$1,000,000

37.

Asher is evaluating a potential acquisition using Comparable Company Analysis. He finds that the Peer EV/EBITDA ratio is 8×. The target company's EBITDA is $250,000. What is the Enterprise Value of the target company?

a)

$1.5 million

b)

$2.0 million

c)

$2.5 million

d)

$3.0 million

38.

In an M&A deal, Ishaan, the acquirer, pays $15M for a target company with identifiable net assets worth $12.4M. What is goodwill?

a)

$1.8M

b)

$2.6M

c)

$2.4M

d)

$3.2M

39.

Aashi is considering a new project for her company, which has a WACC of 9%. The projected cash flows for the project over the next 3 years are: Year 1: 50,000, Year 2: 60,000, Year 3: 80,000. The initial investment required for the project is 140,000. Aashi wants to find the NPV of the project.

a)

$18,000

b)

$12,000

c)

$5,000

d)

$2,000

40.

Kabir, a private equity investor, invests $5M and expects $12M exit value in 5 years. Find the IRR (approx).

a)

15%

b)

18%

c)

20%

d)

22%

41.

Case: Liquidity Assessment A company’s current ratio improved from 1.4 to 2.0, but its quick ratio remained unchanged at 0.9. What is the MOST likely reason?

a)

Increase in cash

b)

Increase in accounts receivable

c)

Increase in inventory

d)

Decrease in current liabilities

42.

Tara is evaluating a new investment project for her company and needs to determine the weighted average cost of capital (WACC) to assess its viability. She knows that several factors play a role in this calculation. Which of the following factors is NOT typically considered when calculating the WACC?

a)

Tax rate

b)

Market risk premium

c)

Cost of equity

d)

Cost of debt

43.

Divya is preparing a financial model for her startup. She needs to identify which of the following expenses is most likely to be a non-cash expense.

a)

Operating expenses

b)

Depreciation

c)

Interest expense

d)

Cost of goods sold

44.

Dhruv is working on a financial model for his startup and wants to understand how different factors might affect his projections. What is the primary purpose of conducting a sensitivity analysis in financial modeling?

a)

To forecast future market trends

b)

To determine the optimal capital structure

c)

To validate the accuracy of historical data

d)

To assess the impact of changes in key assumptions

45.

Divya is evaluating her investment in a tech startup and wants to understand the factors that influence the company's cost of equity. Which of the following is a key factor in determining a company's cost of equity?

a)

Return on investment

b)

Debt-to-equity ratio

c)

Current ratio

d)

Market risk premium

46.

In financial modeling, Ishaan is analyzing the cash flows of his startup. He needs to identify which of the following is typically considered a cash flow from financing activities.

a)

Payment of dividends

b)

Sale of equipment

c)

Purchase of inventory

d)

Issuance of stock

47.

Eesha is planning to launch a new coffee shop and wants to understand the financial aspects of her business. What is the primary purpose of conducting a break-even analysis?

a)

To determine the maximum profit potential

b)

To identify the sales volume at which total revenues equal total costs

c)

To evaluate the financial health of a company

d)

To assess the impact of variable costs on profitability

48.

Saisha is analyzing the financial performance of her company using the DuPont analysis. What does this analysis primarily decompose to evaluate?

a)

Gross Profit, Operating Income, and Net Profit

b)

Return on Assets, Return on Equity, and Profit Margin

c)

Asset Turnover, Equity Multiplier, and Debt Ratio

d)

Net Income, Total Revenue, and Operating Expenses

49.

In the DuPont formula, which component is used to measure how efficiently a company uses its assets to generate sales?

a)

Return on Equity

b)

Equity Multiplier

c)

Asset Turnover

d)

Net Profit Margin

50.

If Eesha's company has an increasing ROE due to a rising equity multiplier, what could this indicate about the company's financial leverage?

a)

Increased profitability without leverage

b)

Decreasing financial leverage

c)

Increasing financial leverage

d)

No change in financial leverage