FIN301 Final Exam Study Guide — Calculation Big Picture
This guide is built from the calculation topics in the final-exam question bank and is arranged in the same chapter order used on the FIN301 course hub. Use it to learn the type of problem, the formula structure, what is usually given, what they usually ask, and what mistakes usually cost points.
This is not an answer sheet and does not repeat the real exam numbers. It is meant to help you learn how to recognize a problem quickly and set it up correctly.
How to use this guide
Before solving, first identify what chapter the problem belongs to. Then ask yourself: “What is the unknown? What formula family fits? What is the time line or cash-flow pattern?”
1) Name the problem type
- TVM?
- Ratio / statement link?
- Expected return / CAPM?
- Bond price / YTM / coupon?
- Stock price / dividend growth?
- WACC?
- NPV / IRR / payback?
2) Sort the inputs
- What is already given?
- Are rates annual, monthly, or semiannual?
- Is the dividend D0 or D1?
- Is the bond annual coupon or semiannual coupon?
- Is the initial outlay at time 0?
3) Check the common traps
- Mismatch between rate and number of periods.
- Using D0 when the formula needs D1.
- Forgetting after-tax cost of debt in WACC.
- Forgetting time 0 in NPV.
- Using market values vs book values incorrectly.
Chapter 5 — Time Value of Money
Big idea: move money across time correctly. Money today and money later are not the same.
What this chapter is really testing
- Can you move one amount forward or backward in time?
- Can you tell whether the unknown is value, rate, or number of periods?
- Can you match the rate unit to the time unit?
Main math structure
Excel functions and calculators
- FV: find a future value when today’s amount, rate, and time are known.
- PV: find today’s value of a future amount.
- RATE: solve for the interest rate when beginning value, ending value, and time are known.
- NPER: solve for the number of periods, especially for payoff questions.
- NPV: not the main Chapter 5 tool, but helpful when you begin thinking about discounting several future cash flows back to today.
- Detailed Excel style:
=ABS(FV(rate, nper, 0, -pv))=ABS(PV(rate, nper, 0, fv))=RATE(nper, 0, -pv, fv)=NPER(rate, pmt, -pv, 0)=NPV(rate, future cash flows only) + initial cash flow at time 0
- Try the calculators here: TVM Calculator and NFV Calculator.
What is usually given
- Present value and interest rate.
- Future value and number of years.
- APR with monthly compounding.
- A payment amount plus a borrowing balance.
What they may ask
- Future value of an investment.
- Present value of a future amount.
- Interest rate needed to grow one amount into another.
- How long it takes to pay off a balance.
- How much someone else must cover if your own investment grows first.
What to be careful about
- Do not mix annual rate with monthly periods.
- If compounding is monthly, convert both the rate and the number of periods.
- Read carefully whether the question is asking for the amount at the future date or the amount needed today.
- For payoff questions, often you first find how much one account becomes, then subtract from the target.
- Excel sign convention can make answers negative if cash-in and cash-out signs are inconsistent.
- Before using an Excel function, decide whether the unknown is FV, PV, RATE, or NPER.
- For many exam-style answers, use ABS(...) so the final answer shows as a positive number after Excel gives a signed cash-flow result.
- Common pattern: if money today is an outflow, enter it as negative; if the future amount is what you receive, let that side be positive.
- For NPV, remember Excel discounts only the future cash flows. Add the initial cash flow separately.
- If you want a quick check, use the Chapter 5 calculators after you set up the problem type correctly.
Chapters 3–4 — Financial Statements and Ratio Analysis
Big idea: know the hidden statement rules, know where each number comes from, and connect the statements before you calculate ratios or cash changes.
What this chapter is really testing
- Can you identify which statement the number comes from?
- Can you move from one statement to another without getting lost?
- Can you use the hidden accounting links before doing the ratio math?
- Can you tell whether an accounting change is a source of cash or a use of cash?
Main math structure
JUFinance statement tools
Use these pages to see where each item belongs before doing any calculation.
What is usually given
- A short balance-sheet table with cash, AR, inventory, fixed assets, liabilities, and equity items.
- Income-statement items such as sales, EBIT, interest expense, tax rate, net income, or dividend.
- Changes in AR, inventory, AP, long-term debt, common stock, or net fixed assets.
- Beginning-year and end-of-year current assets and current liabilities.
What they may ask
- ROE, ROA, or profit margin.
- Net income after interest and taxes.
- Change in net working capital.
- Cash from operation, investment, financing, or total change in cash.
- Which number belongs to which statement.
Fast setup idea
- First say: balance sheet, income statement, or cash flow statement?
- Then write the hidden rule before using the calculator or ratio formula.
- Then check whether the problem wants a level number, a ratio, or a change from last year to this year.
Hidden rules — Balance Sheet
Hidden idea: the balance sheet is a snapshot at one date. It must balance every time.
Hidden rules — Income Statement
Hidden idea: the income statement is for a period of time, not for one date.
Hidden rules — Cash Flow Statement
Hidden idea: many questions are really testing whether you know the signs of the changes.
What to be careful about
- For ROE, use total equity, not total assets.
- For ROA, use total assets, not equity.
- Do not confuse net income with cash flow.
- A decrease in accounts receivable is usually a source of cash.
- An increase in inventory usually uses cash.
- Dividend is not subtracted to get net income; it is used after net income when moving to retained earnings or financing cash flow.
- Before using a ratio, make sure the numerator and denominator come from the correct statement.
Chapter 6 — Risk and Return
Big idea: compute expected return from possible states, and compute required return from CAPM using beta.
What this chapter is really testing
- Can you compute a weighted average correctly?
- Can you separate risk-free rate, market return, and market risk premium?
- Can you find portfolio beta before finding portfolio return?
Main math structure
Excel functions and JUFinance tools
- SUMPRODUCT: use it for expected return and portfolio beta as a weighted average.
- Direct CAPM formula in Excel: =rf + beta*(rm-rf).
- JUFinance calculators: Expected Return Calculator, CAPM Calculator, Portfolio Calculator.
- Two-point CAPM idea: if two stocks' betas and required returns are given, use those two points to solve for the CAPM line first, then plug in the new beta.
What is usually given
- Several economic states with probabilities and returns.
- Betas for one stock or several stocks.
- Portfolio weights.
- Risk-free rate and market return.
What they may ask
- Expected return of one stock or one scenario table.
- Required return for a stock with a given beta.
- Portfolio beta.
- Portfolio required return using CAPM.
What to be careful about
- Probabilities must add to 1 or 100%.
- Do not just average returns; use weighted average.
- If market return is given, subtract the risk-free rate to get market risk premium.
- For portfolio return in CAPM style, first compute portfolio beta, then plug into CAPM.
- Keep decimals and percentages consistent during calculation.
Extra Chapter 6 note — CAPM from two known points
This is the same CAPM idea, but the problem gives you enough information to rebuild the line before solving the final answer.
Chapter 7 — Bond Valuation
Big idea: bonds are present-value problems. The key is recognizing whether you need coupon, price, or yield, and whether coupons are annual or semiannual.
What this chapter is really testing
- Can you set up bond inputs correctly?
- Can you convert annual terms into semiannual terms?
- Can you distinguish coupon rate from yield to maturity?
Main math structure
Excel functions and JUFinance tools
- RATE: solve YTM from price.
- PMT: solve coupon payment when price, YTM, and maturity are known.
- PV: solve bond price when discount rate and cash flows are known.
- Typical setup: annual bond uses yearly inputs; semiannual bond uses years*2 and rate/2.
- JUFinance calculator: Bond Calculator.
What is usually given
- Bond price.
- Years to maturity.
- Yield to maturity or coupon rate.
- Whether payments are annual or semiannual.
- For zero-coupon bond: no coupons, just price and maturity.
What they may ask
- Annual coupon amount.
- Yield to maturity.
- Periodic semiannual yield.
- Implied relationship between premium/discount and yield.
What to be careful about
- For semiannual bonds, divide the annual rate by 2 and multiply the years by 2.
- Zero-coupon bond has no coupon payment, but time periods still matter.
- If the bond price is above par, yield is below the coupon rate; if price is below par, yield is above the coupon rate.
- Read carefully whether they ask for the periodic yield or annual yield.
- Keep face value separate from market price.
Chapter 8 — Stock Valuation
Big idea: connect dividends, growth, required return, and stock price using the constant-growth model.
What this chapter is really testing
- Can you tell whether the dividend given is the last dividend or next dividend?
- Can you use the stock valuation formula in the correct direction?
- Can you connect total return = dividend yield + growth?
Main math structure
Excel functions and JUFinance tools
- There is usually no special built-in Excel function for the Gordon model; set it up directly with formulas.
- Typical Excel setup: =D1/(r-g), =D0*(1+g), =D1/P0+g.
- JUFinance calculator: Dividend Growth Model Calculator.
What is usually given
- D0 or D1.
- Growth rate.
- Required return.
- Stock price and dividend yield.
What they may ask
- Current stock price.
- Next dividend.
- Dividend growth rate.
- Dividend yield or implied expected return piece.
What to be careful about
- The formula uses D1, not D0.
- If D0 is given, first grow it one period to get D1.
- Make sure required return is greater than growth rate in the constant-growth model.
- Dividend yield uses next dividend over current price.
- When they ask for growth, rearrange the return identity carefully.
Chapter 9 — WACC
Big idea: combine the cost of debt and the cost of equity using capital weights, and remember the tax adjustment on debt.
What this chapter is really testing
- Can you find the capital weights correctly?
- Can you compute after-tax cost of debt?
- Can you compute cost of equity from the dividend-growth approach with flotation if needed?
- Can you put the parts together into WACC?
Main math structure
Excel functions and JUFinance tools
- RATE: often used first to find bond YTM for cost of debt.
- Direct Excel formulas: calculate weights, after-tax debt cost, equity cost, and then combine them into WACC.
- Typical setup: =wd*kd_after_tax + we*ke.
- JUFinance calculator: WACC Calculator.
What is usually given
- Total capital needed.
- Dollar amount from debt and from equity.
- Bond information to get debt cost.
- Dividend, growth rate, stock price, and flotation fee to get equity cost.
- Tax rate.
What they may ask
- Weight of debt.
- Weight of equity.
- After-tax cost of debt.
- Cost of equity.
- Overall WACC.
What to be careful about
- Weights should add to 1 or 100%.
- Use after-tax cost of debt, not before-tax cost of debt, in WACC.
- If flotation fee is present, use the net price received for equity.
- Debt cost may come from YTM, not just the coupon rate.
- Do each step separately before combining them.
Chapter 10 — Capital Budgeting
Big idea: compare the cost of a project with the value of its future cash flows. Different tools answer different questions.
What this chapter is really testing
- Can you read a time-0 outlay and later cash inflows correctly?
- Can you distinguish payback, NPV, and IRR?
- Can you make the right accept/reject decision from the result?
Main math structure
Excel functions and JUFinance tools
- NPV: use it for the present value of future cash flows only; then add time-0 cash flow separately.
- IRR: solve for the project rate directly from the full cash-flow stream.
- MIRR: possible in Excel, but only use it if your class has covered it.
- Payback: usually done manually from cumulative cash flows.
- JUFinance tools: Capital Budgeting Calculator and Capital Budgeting Excel Template.
What is usually given
- Initial project cost at time 0.
- A stream of yearly cash inflows.
- Required rate of return or cost of capital.
- Sometimes two projects for comparison.
What they may ask
- Payback period.
- Net present value.
- Internal rate of return.
- Accept or reject decision.
- Crossover rate for two projects.
What to be careful about
- Initial outlay is usually at time 0 and should not be placed inside Excel NPV function with later cash flows.
- Payback ignores the time value of money and any cash flows after the payback cutoff.
- NPV uses the discount rate given in the problem; IRR solves for the rate instead.
- For decision questions, connect the sign of NPV or the size of IRR to the rule before choosing the answer.
- For crossover-rate style questions, compare the difference in project cash flows, not each project in isolation.
Extra Chapter 10 note — one big future cash flow
Even if almost all years are zero, it is still a normal project-decision setup.
Final reminder
For the calculation part, the hardest step is often not the arithmetic — it is recognizing the chapter, choosing the correct setup, and avoiding the usual trap. Slow down for the first 10 seconds of each problem, name the type, and then calculate.