Excel practice · Finance Functions

SLN, EFFECT & NOMINAL practice exercises

5 graded problems with realistic data, all medium.

SLN spreads an asset's cost evenly over its useful life; EFFECT and NOMINAL convert between a stated annual rate and the real rate once compounding is taken into account. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.

New to the function? Read the SLN, EFFECT & NOMINAL guide first: syntax, a worked example and the mistakes people make.

In this set

  1. Find a machine's straight-line depreciation per year
  2. Find a delivery van's annual depreciation
  3. Find a credit card's true annual rate from its monthly-compounded APR
  4. Find the true annual yield on a savings account compounded daily
  5. Convert a bond's true annual yield back to its quoted nominal rate

The exercises

1. Find a machine's straight-line depreciation per year Medium

A factory machine cost $60,000, is expected to be worth $8,000 in salvage value after its useful life, and will be used for 8 years. Find the straight-line depreciation charged each year.

AB
1Cost60000
2Salvage value8000
3Useful life (years)8
4Annual depreciation?

Enter a formula in B4.

Show a hint

SLN(cost, salvage, life) spreads the same depreciation amount evenly over every year of use: =SLN(B1,B2,B3).

Straight-line is the simplest, most common depreciation method in accounting: the same dollar amount every year until the asset reaches its salvage value.

2. Find a delivery van's annual depreciation Medium

A delivery van cost $32,000, will be sold for an estimated $4,000 after 5 years of service. Find its straight-line annual depreciation.

AB
1Vehicle IDVAN-204
2Cost32000
3Salvage value4000
4Useful life (years)5
5Annual depreciation?

Enter a formula in B5.

Show a hint

Same formula as any other SLN problem: =SLN(B2,B3,B4).

Fleet and equipment accounting runs on this calculation constantly; it is the baseline every other depreciation method (declining balance, sum-of-years) gets compared against.

3. Find a credit card's true annual rate from its monthly-compounded APR Medium

A credit card advertises an 18% nominal annual rate, compounded monthly. Find the true effective annual rate a cardholder actually pays.

AB
1Nominal annual rate0.18
2Compounding periods per year12
3Effective annual rate?

Enter a formula in B3.

Show a hint

EFFECT(nominal_rate, npery) converts a stated nominal rate into the real rate compounding actually produces: =EFFECT(B1,B2).

A card's advertised rate always understates what you actually pay once compounding is included: EFFECT is how to see the real number.

4. Find the true annual yield on a savings account compounded daily Medium

A savings account advertises a 4% nominal annual rate, compounded daily (365 times a year). Find the true effective annual yield.

AB
1AccountHigh-Yield Savings
2Nominal annual rate0.04
3Compounding periods per year365
4Effective annual yield?

Enter a formula in B4.

Show a hint

More frequent compounding pushes the effective rate a little higher than the nominal rate: =EFFECT(B2,B3).

This is the same math as the credit-card problem, just working in the saver's favor instead of the borrower's: more frequent compounding always helps whoever is earning the interest.

5. Convert a bond's true annual yield back to its quoted nominal rate Medium

A bond's true effective annual yield is 8.16%, compounded quarterly. Find the nominal annual rate it would be quoted at.

AB
1Effective annual rate0.0816
2Compounding periods per year4
3?

Enter a formula in A3.

Show a hint

NOMINAL(effect_rate, npery) is EFFECT run in reverse, converting a true annual rate back to the quoted nominal one: =NOMINAL(B1,B2).

Bonds and loans are usually quoted at their nominal rate, not their effective one: NOMINAL is how to go from a known real return back to the number that would actually be advertised.

Solve these in a real grid

Type your formula, get graded instantly. Your first 10 exercises are free, no signup.

Start the SLN, EFFECT & NOMINAL exercises →

More finance functions practice

All Excel practice exercises · Excel test prep