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
- Find a machine's straight-line depreciation per year
- Find a delivery van's annual depreciation
- Find a credit card's true annual rate from its monthly-compounded APR
- Find the true annual yield on a savings account compounded daily
- Convert a bond's true annual yield back to its quoted nominal rate
The exercises
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.
| A | B | |
|---|---|---|
| 1 | Cost | 60000 |
| 2 | Salvage value | 8000 |
| 3 | Useful life (years) | 8 |
| 4 | Annual 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.
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.
| A | B | |
|---|---|---|
| 1 | Vehicle ID | VAN-204 |
| 2 | Cost | 32000 |
| 3 | Salvage value | 4000 |
| 4 | Useful life (years) | 5 |
| 5 | Annual 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.
A credit card advertises an 18% nominal annual rate, compounded monthly. Find the true effective annual rate a cardholder actually pays.
| A | B | |
|---|---|---|
| 1 | Nominal annual rate | 0.18 |
| 2 | Compounding periods per year | 12 |
| 3 | Effective 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.
A savings account advertises a 4% nominal annual rate, compounded daily (365 times a year). Find the true effective annual yield.
| A | B | |
|---|---|---|
| 1 | Account | High-Yield Savings |
| 2 | Nominal annual rate | 0.04 |
| 3 | Compounding periods per year | 365 |
| 4 | Effective 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.
A bond's true effective annual yield is 8.16%, compounded quarterly. Find the nominal annual rate it would be quoted at.
| A | B | |
|---|---|---|
| 1 | Effective annual rate | 0.0816 |
| 2 | Compounding periods per year | 4 |
| 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 →