Course outline
Module 1
Module 1: Foundations of Financial Modeling
Foundations of Financial Modeling
Knowledge check
Q1. What is the primary purpose of a financial model?
- A. To record historical accounting transactions for tax filing
- B. To represent a company's financial performance and forecast future outcomes using numerical assumptions ✓
- C. To replace the need for audited financial statements
- D. To calculate employee payroll and benefits
Why: A financial model is a tool that uses assumptions and formulas to represent a business's financial performance and project future results, supporting decisions like investment, valuation, and planning.
Q2. In a well-structured financial model, where should key assumptions such as growth rates and tax rates be placed?
- A. Hard-coded directly inside each formula
- B. In a separate, clearly labeled input or assumptions section ✓
- C. In the footnotes of the final output page
- D. Only in the cover memo accompanying the model
Why: Keeping assumptions in a dedicated, labeled section makes the model easier to audit, update, and run scenarios on, and avoids scattering hard-coded numbers throughout formulas.
Q3. Which of the following best describes the three core financial statements typically linked in a financial model?
- A. Balance sheet, income statement, and cash flow statement ✓
- B. Payroll ledger, inventory log, and sales report
- C. Budget, invoice register, and tax return
- D. Market analysis, competitor review, and SWOT chart
Why: The integrated three-statement model links the income statement, balance sheet, and cash flow statement so that changes in one flow through and balance across the others.
Q4. What does it mean for a financial model to be 'dynamic'?
- A. It is updated by hand every quarter with new printed reports
- B. It automatically recalculates outputs when inputs or assumptions are changed ✓
- C. It only shows results in animated charts
- D. It includes multiple unrelated spreadsheets with no links
Why: A dynamic model is built with live formulas so that changing an assumption instantly updates all dependent calculations, enabling scenario and sensitivity analysis.
Q5. Why is it considered good practice to color-code cells in a financial model (e.g., blue for hard-coded inputs, black for formulas)?
- A. It makes the file size smaller
- B. It helps users quickly distinguish inputs from calculations, reducing errors ✓
- C. It is required by all tax authorities
- D. It automatically checks the model for mathematical accuracy
Why: Color-coding is a convention that visually separates hard-coded inputs from formulas and links, making the model easier to read, review, and audit for errors.
Module 2
Module 2: Time Value of Money
Time Value of Money
Knowledge check
Q1. What is the time value of money?
- A. Money is worth the same amount regardless of when it is received
- B. A dollar today is worth more than a dollar received in the future because it can be invested to earn returns ✓
- C. Inflation always makes future money worth more than present money
- D. Money loses all its value after one year
Why: The time value of money rests on the idea that money available now can be invested to earn interest or returns, so it is worth more than the same amount received later.
Q2. If you invest $1,000 at an annual interest rate of 5% (simple interest), how much will you have after 2 years?
- A. $1,050
- B. $1,100 ✓
- C. $1,102.50
- D. $1,200
Why: Simple interest is calculated only on the principal: $1,000 x 5% = $50 per year, so after 2 years you earn $100, giving $1,100.
Q3. What is the present value of $500 received one year from now, given a discount rate of 10%?
- A. $550
- B. $450
- C. $454.55 ✓
- D. $500
Why: Present value = future value / (1 + r) = $500 / 1.10 = approximately $454.55.
Q4. Which factor causes the future value of an investment to grow faster when compounding is used?
- A. Earning interest only on the original principal
- B. Earning interest on both the principal and previously accumulated interest ✓
- C. Reducing the investment amount each period
- D. Holding the money in cash with no interest
Why: Compound interest earns returns on prior interest as well as principal, so the balance grows at an increasing rate over time.
Q5. As the discount rate increases, what happens to the present value of a future cash flow?
- A. It increases
- B. It stays the same
- C. It decreases ✓
- D. It becomes negative
Why: A higher discount rate means future money is worth less today, so the present value of a given future cash flow falls as the discount rate rises.
Module 3
Module 3: Building Income Statements
Building Income Statements
Knowledge check
Q1. What is the first line item typically shown at the top of an income statement?
- A. Net Income
- B. Revenue (Sales) ✓
- C. Operating Expenses
- D. Gross Profit
Why: An income statement starts with revenue, the total money earned from selling goods or services. Every subsequent line subtracts costs or expenses from this top-line figure.
Q2. How is Gross Profit calculated?
- A. Revenue minus Operating Expenses
- B. Revenue minus Cost of Goods Sold ✓
- C. Revenue minus Taxes
- D. Net Income plus Interest Expense
Why: Gross Profit equals revenue minus Cost of Goods Sold (COGS), which captures the direct costs of producing the goods or services sold. It shows how efficiently a company turns sales into profit before overhead.
Q3. Which of the following is an example of an operating expense?
- A. Raw materials used in production
- B. Interest paid on a bank loan
- C. Rent for the corporate headquarters ✓
- D. Income tax payable to the government
Why: Operating expenses are costs of running the business that are not directly tied to producing goods, such as rent, salaries for administrative staff, and utilities. Raw materials are COGS, interest is a financing cost, and taxes come after pre-tax income.
Q4. What does EBIT stand for, and what does it measure?
- A. Earnings Before Interest and Taxes; operating profit before financing costs and taxes ✓
- B. Earnings Before Inventory and Transfers; cash held in warehouses
- C. Expenses Before Income and Tax; total costs prior to sales
- D. Equity Balance In Trust; shareholder ownership value
Why: EBIT, or Earnings Before Interest and Taxes, measures a company's operating profitability by showing income generated from core operations before interest payments and income taxes are deducted.
Q5. If a company has revenue of $500,000, COGS of $300,000, and operating expenses of $120,000, what is its operating income (EBIT)?
- A. $80,000 ✓
- B. $200,000
- C. $380,000
- D. $120,000
Why: Gross Profit is $500,000 minus $300,000, which equals $200,000. Subtracting operating expenses of $120,000 gives an operating income of $80,000.
Module 4
Module 4: Balance Sheets and Cash Flow
Balance Sheets and Cash Flow
Knowledge check
Q1. What are the three main sections of a balance sheet?
- A. Revenue, expenses, and net income
- B. Assets, liabilities, and shareholders' equity ✓
- C. Operating, investing, and financing activities
- D. Cash inflows, cash outflows, and ending cash balance
Why: A balance sheet reports what a company owns (assets), what it owes (liabilities), and the residual claim of owners (shareholders' equity). Revenue and expenses appear on the income statement, and operating, investing, and financing activities appear on the cash flow statement.
Q2. Which equation must always hold true on a balance sheet?
- A. Assets = Liabilities + Shareholders' Equity ✓
- B. Assets = Revenue - Expenses
- C. Cash = Net Income + Depreciation
- D. Liabilities = Assets + Shareholders' Equity
Why: The balance sheet is built on the accounting identity that total assets equal the sum of liabilities and shareholders' equity. This is why it is called a balance sheet: both sides must balance.
Q3. Under the indirect method, which adjustment is made to net income in the operating section of the cash flow statement?
- A. Adding back depreciation, which is a non-cash expense ✓
- B. Subtracting dividends paid to shareholders
- C. Adding proceeds from issuing new stock
- D. Subtracting the purchase of equipment
Why: Depreciation reduces net income but does not involve any cash leaving the business, so it is added back to convert net income into operating cash flow. Dividends and stock issuance are financing activities, and equipment purchases are investing activities.
Q4. A company buys a new delivery truck for $50,000 in cash. How does this transaction affect the cash flow statement?
- A. It is a cash outflow in operating activities
- B. It is a cash outflow in investing activities ✓
- C. It is a cash inflow in financing activities
- D. It does not appear on the cash flow statement
Why: Buying long-term assets such as trucks, equipment, or property is classified as an investing activity. Because cash leaves the company, it is recorded as a $50,000 outflow in the investing section.
Q5. Why can a profitable company still run out of cash?
- A. Profit is recorded on an accrual basis, so revenue may be booked before cash is collected ✓
- B. Profit is always equal to cash on hand
- C. Depreciation expenses reduce the cash balance each period
- D. Shareholders' equity must be paid out in cash each year
Why: Under accrual accounting, revenue is recognized when earned, not when cash is received. A company can show strong net income while customers have not yet paid, and it may also spend cash on inventory or equipment, so cash can run short even when the business is profitable.
Module 5
Module 5: Valuation Methods
Valuation Methods
Knowledge check
Q1. What does the Discounted Cash Flow (DCF) method primarily estimate?
- A. The company's book value based on historical cost of assets
- B. The present value of expected future cash flows
- C. The current market price of the company's stock
- D. The total revenue the company will earn next year
Q2. Why are future cash flows discounted when calculating present value?
- A. Because cash flows always decrease over time due to inflation only
- B. Because money received in the future is worth less than money received today due to time value of money and risk
- C. Because accounting rules require a fixed percentage reduction each year
- D. Because discounting removes taxes from the cash flow calculation
Q3. Which valuation method compares a company's value to similar companies using multiples such as Price-to-Earnings (P/E)?
- A. Liquidation valuation
- B. Discounted cash flow analysis
- C. Comparable company analysis
- D. Net asset value analysis
Q4. If a company's cash flow next year is expected to be $100 and the discount rate is 10%, what is the present value of that cash flow?
- A. $110.00
- B. $100.00
- C. $90.91
- D. $91.00
Q5. What does a higher discount rate do to the calculated present value of future cash flows?
- A. It increases the present value
- B. It has no effect on present value
- C. It decreases the present value
- D. It converts the cash flows into revenue
Module 6
Module 6: Scenario and Sensitivity Analysis
Scenario and Sensitivity Analysis
Knowledge check
Q1. What is the main purpose of scenario analysis in a financial model?
- A. To calculate the exact future value of a company's stock
- B. To evaluate how the model's outputs change under different sets of assumptions, such as best, base, and worst cases ✓
- C. To remove all uncertainty from the forecast
- D. To audit the accounting records of a company
Why: Scenario analysis tests how outputs like revenue, profit, or valuation change when several assumptions move together to represent coherent future states (e.g., optimistic, base, pessimistic).
Q2. In sensitivity analysis, what is typically changed to observe its effect on the model output?
- A. The model's formatting and cell colors
- B. One input variable at a time, holding others constant ✓
- C. All inputs randomly at the same moment without any record
- D. The historical financial statements of prior years
Why: Sensitivity analysis usually flexes a single input (such as sales growth or discount rate) while keeping others fixed, showing how sensitive the output is to that specific driver.
Q3. A sensitivity table shows that a 1% change in the discount rate causes a large change in valuation. What does this indicate?
- A. The valuation is insensitive to the discount rate
- B. The valuation is highly sensitive to the discount rate ✓
- C. The discount rate has no role in the model
- D. The model contains a formula error that must be fixed
Why: A large output change from a small input change means high sensitivity, signaling that the discount rate assumption deserves careful justification and scrutiny.
Q4. What is a two-way data table commonly used for in financial modeling?
- A. Recording historical transactions in two currencies
- B. Showing how the output changes when two input variables are varied simultaneously ✓
- C. Comparing two different companies' balance sheets
- D. Listing two separate income statements side by side
Why: A two-way data table varies two inputs at once (for example, growth rate and margin) and displays the resulting output in a grid, helping identify combined effects.
Q5. Why is it important to use scenario analysis rather than relying on a single forecast?
- A. Because a single forecast is always legally required to be wrong
- B. Because it reveals the range of possible outcomes and the risks associated with uncertain assumptions ✓
- C. Because scenarios eliminate the need for any assumptions
- D. Because single forecasts cannot be built in spreadsheet software
Why: Since future conditions are uncertain, showing a range of outcomes helps decision-makers understand downside risk and upside potential instead of trusting one point estimate.
Module 7
Module 7: Interpreting and Presenting Model Outputs
Interpreting and Presenting Model Outputs