The Appraisal Toolbox

Taking a course?
Preparing for an exam?
Brushing up before a state or designation exam?

Practice problems with the working shown — step-by-step solutions, HP-12c keystrokes, exhibits, and study tools. Built by a practicing appraiser who teaches these courses.

Plainly: the Appraisal Toolbox is not developed, approved, or endorsed by any appraisal organization, association, or course provider. It is not part of any course, and it is not a substitute for course material. Using it is entirely optional.

What the Toolbox is

A large set of appraisal practice problems that generate fresh numbers every time you open them, each one worked through in full.

Most appraisal study material has two gaps.

The first is between the problem and the answer. You are given both, and the route between them is where people get stuck. Every problem here shows that route: what you were given, which method applies, the arithmetic in order, and the calculator keystrokes that get you there.

The second is that it is one problem with one answer. Work it twice and you are working the same numbers, and the second time you are remembering rather than solving. Every problem here draws fresh figures each time you open it — the data changes, the wording moves, the answer is different. You end up learning how to solve the problem rather than what the answer was.

It was built by one person — a practicing appraiser who teaches these courses — and it is maintained continuously. It exists because the same questions come up in every class, and a worked example beats an explanation.

What it is not

  • Not developed, approved, or endorsed by any appraisal organization, association, or course provider.
  • Not part of any course, and not a substitute for course material.
  • Not required, and not a shortcut. It is practice.

What is inside a problem

Every problem draws new numbers each time, so you can work the same method until it sticks rather than memorizing one answer.

A fresh problem, every time

Press New problem and the figures change. The method stays; the arithmetic does not.

Example ↗
The same problem, two draws
Sale price$710,000
Term20 years
Seller rate4.75%
⇩ New problem
Sale price$460,000
Term15 years
Seller rate5.50%

The worked solution

Step by step, in order, with each figure shown as it is calculated — not just the answer.

Example ↗
Step 2 of 4
Step 2 — annualize the change
Δ × SFF = 0.15 × 0.066204
The change happens once, at the end. The sinking fund factor turns that one-time amount into its annual equivalent.
= 0.9931%

HP-12c keystrokes

The actual keys, in sequence, for every step that uses the calculator.

Example ↗
Solving for the payment
ClearfFIN
Term20n
Rate4.75i
Loan460,000CHSPV
SolvePMT→ 2,972.63

A flowchart

Four boxes showing the route through the problem, with your own numbers in them.

Example ↗
Four boxes, your numbers
1 · The spreadWhat comes in, less what goes out.
2 · Value itA level income that ends.
3 · How thinSpread over rent collected.
4 · Why the rateCompare to the leased fee.

Exhibits and charts

Where a diagram makes the relationship clearer than a paragraph.

Example ↗
Where the value comes from
INCOME68%REVERSION32%

Print it

Any problem prints as a clean worksheet, with or without the solution.

Example ↗
A clean worksheet
Cash Equivalency Price
Sale price$710,000
Loan$460,000
Answer__________
With the solution, or blank to work by hand.

Predict before you solve

Many problems ask you to say which way the answer will go before you work it — will the rate land above or below the yield, is the change positive or negative. Getting that wrong before you start is more useful than getting the arithmetic wrong at the end.

Sample problems

Six problems are open to anyone. No code, no sign-in — work them as they are.

They are ordinary problems from the course files, not demonstrations. Press New problem, reveal the solution, open the flowchart, look at the keystrokes.

The samples are the same build as everything else. If they are useful, the rest will be; if they are not, they are not.

Course files

Practice files are organized by course, and within a course by topic.

CourseWhat it covers
Basic Appraisal PrinciplesValue, the approaches, economic principles, property rights
Basic Appraisal ProceduresThe appraisal process, measurement, describing improvements
Cost ApproachDepreciation, site value, cost new, extraction
Sales ComparisonAdjustments, paired sales, cash equivalency, bracketing
Income Capitalization INOI, cap rates, band of investment, Ellwood, reversions
Income Capitalization IIDCF, yields, mortgage and equity positions, divided interests
Advanced Income CapitalizationWraparounds, participations, taxation, complex financing
StatisticsMeasures, distributions, regression
HP-12cSix functions, programming, cash flows
USPAPStandards and practice
Market AnalysisHighest and best use, market studies

Course files open with a code for the course you are taking. The sample problems above are open to everyone.

DCF our way

Six positions, each with its own set of problems — and you decide how hard they are.

A discounted cash flow is one method applied to six different questions. Most material shows you one worked example of one of them. Here each has its own pages, at the difficulty you choose.

Solve for value

Property Value

The whole property — income, reversion, and the yield the market wants.

Six levels — single tenant to full multi-tenant
Solve for value

Mortgage Value

The lender’s position: payments plus a payoff, discounted at the market’s mortgage yield.

Six problems across three routes
Solve for value

Equity Value

What the equity actually receives after debt service, and what the equity keeps at sale.

Three levels — simple, loan and reversion, participation
Solve for the rate

Property Yield Rate

Price and cash flows known, the rate is not. What the property actually earns.

Two levels — level income and growing income
Solve for the rate

Mortgage Yield Rate

Advance the money, collect the payments, take the payoff — and see what the lender earned.

Five problems — straight note, balloon, points and fees
Solve for the rate

Equity Yield Rate

The leveraged return, and how far leverage magnifies every movement.

Five problems — level, changing, and three participations
The problem Sensitivity analysis Reveal what you need Excel formulas too Three ways to be shown Down to the equity

What makes them ours

1

You choose the difficulty

Simple and advanced levels for every position. On the multi-tenant problems you choose how many tenants, each with its own lease, expiry and rollover. Start where you are and move up when it stops being hard.

2

Sensitivity sliders on every input

Move a rate, a term, a rent, a vacancy factor — and watch the answer move with it. See what actually changes value, and by how much. The same for the yield rate: some inputs barely move it and some dominate it, and reading about that is not the same as watching it happen.

3

Fresh numbers every time

Every problem redraws. Work a position until the method is yours, not until you have memorized one answer.

4

The working, in whichever form helps

The step-by-step reasoning, the HP-12c keystrokes, and the arithmetic laid out — for the same problem, so you can see how the three line up.

Study tools

Reference material that sits outside any one course, open to anyone.

Symbols list

Every symbol the standard texts use without explaining — with its term, a plain-English note, and what people commonly get wrong. Sortable, and drillable as flashcards.

Example ↗
One entry
Rm
Mortgage cap rate (mortgage constant)
The annual mortgage payment as a percentage of the loan amount.

Math basics

The arithmetic the courses assume you already have.

Example ↗
Working with rates
A rate is a fraction wearing a percent sign.
8.25% = 8.25 ÷ 100 = 0.0825
Which is why the calculator wants 8.25, not 0.0825.

HP-12c help

Setup, the keys that matter, and the sequences that come up repeatedly.

Example ↗
Two conversions worth knowing
Years → monthsg12×
Annual → monthly rateg12÷
The blue key, then the key underneath it.

Quick Quiz — Concepts

Given the explanation, recall the symbol and the term. Reveal either side, one at a time or all at once.

Example ↗
One row of the concepts drill
The total annual payment to the mortgage (principal plus interest). Also written Im.
Show SymbolShow Term

Quick Quiz — Multiple Choice

Five questions at a time, drawn from a category you pick. Appraisal Principles, Procedures, Income, and more.

Example ↗
One question
Real estate transactions typically use two types of capital as part of the purchase:
Aequity and debt
Bdebt and loans
Ccash and stocks

Quick Quiz — Symbols

Given the symbol, recall the term and the explanation. Short answer, matching and flashcards too.

Example ↗
Two rows of the symbols drill
ETRHide Term
Effective tax rate
YLHShow Term

Open the study tools — no code needed.

My Stuff

A scratchpad that follows you around the site while you study.

As you work, you can add things to My Stuff: a definition you want to come back to, an explanation that finally made something land, a link to a problem you want to work again, or a note to yourself.

  • It is there on every page, and the count goes up as you add.
  • You can write your own notes into it — “ask about split rates on Thursday”.
  • You can download the whole thing at any time.

My Stuff is a scratchpad, not storage. It is cleared when your course ends, along with your access. It is not a record-keeping system and not a backup.

Download anything you want to keep, before your course ends. Once it is cleared there is no recovery and no archive.

The Toolbox Library

Written papers on the topics that take more than a worked problem to explain.

Some things do not fit inside a problem. When a concept needs several pages — the reasoning, the exceptions, the way it shows up in practice — it becomes a paper in the Toolbox Library, and the problems that touch on it link across to it.

The papers are written the same way the problems are: worked through, with the arithmetic shown and the calculator keystrokes where they apply.

The papers

41 papers, and the list grows. Five are open to anyone — the rest open for students with course access.

Cap Rates vs Yield Rates
Cap Rates vs Yield Rates
Open →
Extracting a Cap Rate
Extracting a Cap Rate
Open →
How a Four-Year-Old Sale Can Still Be the Best Comparable
How a Four-Year-Old Sale Can Still Be the Best Comparable
Open →
No Such Thing as an Update
No Such Thing as an Update
Open →
Overage Rent
Overage Rent
Open →
Appraisal Review
Appraisal Review
Available with course access
Appraisal vs Restricted Report
Appraisal vs Restricted Report
Available with course access
Appraiser Competence
Appraiser Competence
Available with course access
Band of Investment
Band of Investment
Available with course access
Bias and Impartiality
Bias and Impartiality
Available with course access
Cash Equivalency
Cash Equivalency
Available with course access
Conflict of Interest
Conflict of Interest
Available with course access
Consulting and USPAP
Consulting and USPAP
Available with course access
Cost vs Price vs Value
Cost vs Price vs Value
Available with course access
Definition of Market Value
Definition of Market Value
Available with course access
Effective Rent
Effective Rent
Available with course access
Entrepreneurial Incentive vs Profit
Entrepreneurial Incentive vs Profit
Available with course access
Four Methods of Depreciation
Four Methods of Depreciation
Available with course access
Highest and Best Use
Highest and Best Use
Available with course access
Highest and Best Use — As Improved
Highest and Best Use — As Improved
Available with course access
Highest and Best Use — As Vacant
Highest and Best Use — As Vacant
Available with course access
How NOI Is Determined
How NOI Is Determined
Available with course access
Identification of the Problem
Identification of the Problem
Available with course access
Leased Fee vs Fee Simple
Leased Fee vs Fee Simple
Available with course access
Level Equivalent Income
Level Equivalent Income
Available with course access
PV vs NPV
PV vs NPV
Available with course access
Property Models
Property Models
Available with course access
Real Estate vs Real Property
Real Estate vs Real Property
Available with course access
Sales Comparison — Apples to Apples
Sales Comparison — Apples to Apples
Available with course access
Scope of Work
Scope of Work
Available with course access
Special Value Sales — Legal Perspective
Special Value Sales — Legal Perspective
Available with course access
Special Value Sales — Valuation Perspective
Special Value Sales — Valuation Perspective
Available with course access
TVM — Overview
TVM — Overview
Available with course access
TVM 1 — Future Value of 1
TVM 1 — Future Value of 1
Available with course access
TVM 2 — Future Value of 1 per Period
TVM 2 — Future Value of 1 per Period
Available with course access
TVM 3 — Sinking Fund Factor
TVM 3 — Sinking Fund Factor
Available with course access
TVM 4 — Present Value of 1
TVM 4 — Present Value of 1
Available with course access
TVM 5 — Present Value of 1 per Period
TVM 5 — Present Value of 1 per Period
Available with course access
TVM 6 — Installment to Amortize 1
TVM 6 — Installment to Amortize 1
Available with course access
The Five Rules of USPAP
The Five Rules of USPAP
Available with course access
Three Forms of Depreciation
Three Forms of Depreciation
Available with course access

Library papers are not part of any course, and are not provided or approved by any appraisal organization, association, or course provider.

Getting access

The sample problems and the study tools are open to anyone. Course files need a code.

Open to anyone

The six sample problems and the study tools — symbols, math basics, HP-12c help, quizzes. No code, nothing to sign in to.

Course files

The practice files for a course open with a code. Access lasts for the length of the course and stops when it ends.

For more information

Students, instructors and course providers — email the Toolbox. Terms of access and anything else that applies to your situation are sent by reply.

Email TheAppraisalToolbox@gmail.com

One address for everything. All access questions go to TheAppraisalToolbox@gmail.com. If you are in one of my classes, please do not send access questions to my instructor email — they are handled here.