WorksheetsPregrad Month 2
Total questions: 50
Worksheet time: 1hrs 27mins
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.
Income Statement
Balance Sheet
Cash Flow Statement
Statement of Retained Earnings
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:
Total assets
Net income
Sales revenue
Equity
In DuPont Analysis, a decrease in equity multiplier with constant ROA will result in:
Higher ROE
Lower ROE
No impact on ROE
Increase in profit margin
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.
Gross margin
Operating margin
Net profit margin
Return on Assets
Myra's company has been experiencing a consistently negative cash flow from investing activities. This situation usually indicates:
Declining profitability
Excessive dividend payouts
Expansion and capital investments
Inefficient cost control
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:
High depreciation expenses
Increase in accounts receivable
Rise in inventory levels
Decline in gross margins
Avyaan, a financial analyst at a leading investment firm, is tasked with integrating financial statements into valuation models. This process primarily supports:
Corporate governance decisions
Strategic forecasting and valuation
Employee compensation planning
Audit risk assessment
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:
Output variables
Independent drivers
Forecast errors
Non-operating inputs
A sensitivity analysis examines:
Multiple variables changing simultaneously
Impact of one variable on model output
Model errors based on historical data
Scenarios where assumptions remain constant
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?
OFFSET
IF
INDEX-MATCH
CHOOSE
A balanced financial model must satisfy which condition?
Cash inflows = Cash outflows
Total assets = Total liabilities + equity
Net income = Cash flow from operations
Retained earnings = Net income – dividends
A major purpose of model validation is to:
Ensure model includes all possible variables
Confirm accuracy, logic, and linkage integrity
Eliminate subjective assumptions
Improve graphical output
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:
Revenue driver formulas
Linked depreciation schedules
Interest expense linked to ending debt balances
Working capital calculations
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?
Goal Seek
Trend analysis vs industry growth
Scenario simulation
Sensitivity testing
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:
Investing cash flow
Financing cash flow
Operating cash flow
Retained earnings
In a DCF model, terminal value generally represents:
5–10% of total firm value
Future value of dividends
Majority of the firm’s total value
Value of tangible assets only
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:
Price-to-book
EV/EBITDA
Dividend yield
PEG ratio
A key disadvantage of precedent transaction analysis is:
It requires too little data
Market conditions during past deals may differ
It ignores control premiums
It cannot be used for private companies
When Tara's company is evaluating its financing options, she notices that the weighted average cost of capital (WACC) decreases when:
Equity becomes more expensive
Debt interest rates rise
The firm adds cheaper debt financing
The firm's beta increases
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?
Operating taxes
Depreciation
Net interest payments
Working capital requirements
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.
Lower future growth expectations
Higher risk and lower profitability
Better growth prospects or market premium
Declining market share
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?
Price-to-earnings
Dividend discount model
Market multiples
Scenario-based DCF or First Chicago Method
In investment analysis, the metric most closely aligned with value creation is:
Payback period
Internal rate of return (IRR)
Book value per share
Dividend payout ratio
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?
Conflicting decision rules
Incorrect cash flow forecast
Infeasible project
Project with no risk
In M&A, a control premium is paid primarily because:
Prisha wants access to financial statements
The target firm has declining revenues
Rohan gains decision-making authority and synergies
Sellers demand compensation for taxes
In a recent merger between two tech companies, Sanya and Avyaan, the synergies in their M&A deal are reflected in valuation mainly by:
Lower purchase price
Higher combined cash flows in future periods
Reduced working capital needs
Elimination of debt obligations
Siya is evaluating a potential merger with a competitor. A key step in the M&A valuation process is:
Estimating replacement cost of assets
Determining post-acquisition capital structure
Identifying comparable countries
Calculating marketing expenses
When valuing a leveraged buyout (LBO), the primary focus is on:
Dividends
Free cash flow to equity
Debt capacity and IRR for equity investors
Comparable transaction multiples
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.
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:
Correcting for market volatility
Uncovering off-balance-sheet liabilities
Harmonizing accounting software
Meeting regulatory filing requirements
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?
43.2%
51.8%
29.2%
36.5%
Eshaan's company has current assets of $500,000 and inventory of $150,000. Current ratio = 2.5. What is current liabilities?
$350,000
$200,000
$125,000
$50,000
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?
$125,000
$105,000
$130,000
$140,000
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.
$160,000
$210,000
$150,000
$135,000
A bond with annual coupon 6% (on par 1,000), required return 8%, maturity 5 years. What is its approximate value?
$920–$930
$960–$970
$1,040–$1,050
$880–$890
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?
$1,200,000
$2,000,000
$1,800,000
$1,000,000
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?
$1.5 million
$2.0 million
$2.5 million
$3.0 million
In an M&A deal, Ishaan, the acquirer, pays $15M for a target company with identifiable net assets worth $12.4M. What is goodwill?
$1.8M
$2.6M
$2.4M
$3.2M
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.
$18,000
$12,000
$5,000
$2,000
Kabir, a private equity investor, invests $5M and expects $12M exit value in 5 years. Find the IRR (approx).
15%
18%
20%
22%
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?
Increase in cash
Increase in accounts receivable
Increase in inventory
Decrease in current liabilities
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?
Tax rate
Market risk premium
Cost of equity
Cost of debt
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.
Operating expenses
Depreciation
Interest expense
Cost of goods sold
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?
To forecast future market trends
To determine the optimal capital structure
To validate the accuracy of historical data
To assess the impact of changes in key assumptions
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?
Return on investment
Debt-to-equity ratio
Current ratio
Market risk premium
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.
Payment of dividends
Sale of equipment
Purchase of inventory
Issuance of stock
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?
To determine the maximum profit potential
To identify the sales volume at which total revenues equal total costs
To evaluate the financial health of a company
To assess the impact of variable costs on profitability
Saisha is analyzing the financial performance of her company using the DuPont analysis. What does this analysis primarily decompose to evaluate?
Gross Profit, Operating Income, and Net Profit
Return on Assets, Return on Equity, and Profit Margin
Asset Turnover, Equity Multiplier, and Debt Ratio
Net Income, Total Revenue, and Operating Expenses
In the DuPont formula, which component is used to measure how efficiently a company uses its assets to generate sales?
Return on Equity
Equity Multiplier
Asset Turnover
Net Profit Margin
If Eesha's company has an increasing ROE due to a rising equity multiplier, what could this indicate about the company's financial leverage?
Increased profitability without leverage
Decreasing financial leverage
Increasing financial leverage
No change in financial leverage
