4.Appraisal_ExampleFullSolution.xlsx

    Done

    Table 1: Table of Comparison
    Elements of Comparison Subject Comp 1 Comp 2 Comp 3
    Sale price of comparable $ 510,000.00 $ 525,000.00 $ 499,000.00
    Transaction Characteristics
    Property rights conveyed Fee simple Same Same Same
    Adjusted price
    Financing terms Conventional Same Same Same
    Adjusted price
    Conditions of sale Arm's length Same Same Same
    Adjusted price
    Expenditure immed. after purchase None 3,000 None
    Adjusted price
    Market condition Today 3 months ago: 6 months ago: 6 months ago: Note: All the comparables are recently sold properties. Percentage change is given in the example.
    (add 2% total) (add 4% total) (add 4% total)
    Property characteristics
    Location Huntington Huntington Kensington Millhoper
    Physical characteristics (subtract 3% total) (subtract 3% total)
    Site/lot size (sg.ft) 6,662 6,700 6,800 6,600
    Construction quality Typical Typical Typical Typical
    Condition Average Average Average Average
    Age (years) 5.5 7 8 10
    Living area (sq.ft) 3473 3920 3985 3835
    Number of baths 3 3.5 3 2
    Garage Space (# of car space) 2 2 2 1
    Porch. Patio, deck Cov. Porch/wood deck Cov.Porch Cov. Porch Cov. Porch
    Fence, pool, etc. None None Pool Pool
    Economics characteristics N.A N.A N.A N.A
    Use Single-family Single-family Single-family Single-family
    Non-realty Components None None None None
    Table 2: Table of Adjustments
    Elements of Comparison Subject Comp 1 Comp 2 Comp 3
    Sale price of comparable $ 510,000.00 $ 525,000.00 $ 499,000.00
    Transaction Characteristics
    Property rights conveyed Fee simple There is no adjustments on these three since they are the same for each property.
    Adjusted price
    Financing terms Conventional
    Adjusted price
    Conditions of sale Arm's length
    Adjusted price
    Expenditure immed. after purchase $ 3,000.00
    Adjusted price
    Market condition Today $ 10,200.00 $ 21,120.00 $ 19,960.00 Refer to row D 16 for the percentage adjustment information. Subject property sells at higher price because market appreciates.
    Adjusted price $ 520,200.00 $ 549,120.00 $ 518,960.00
    Property characteristics
    Location Huntington $ (16,473.60) $ (15,568.80) As Huntington are less desirable than Kensington and Millhoper, subject should sell at 3% less than comparable 2 and 3. 3% is given in the example.
    Physical characteristics
    Site/lot size 6,662 sq. ft $ (760.00) $ (2,760.00) $ 1,240.00 An incremental square foot of lot size is worth about $20 per square foot, given in example. Smaller property sells at lower price.
    Construction quality Typical $ – 0
    Condition Average $ – 0
    Effective age 5.5 years $ 4,500.00 $ 7,500.00 $ 13,500.00 Each year of effective age reduces the value of properties in this market by about $3,000 per year. Younger property sells at a higher price.
    Living area 3,473 sq. ft $ (35,760.00) $ (40,960.00) $ (28,960.00) An incremental square foot of living area is worth about $80 per square foot, given in example. Smaller property sells at lower price.
    Number of baths 3 $ (500.00) $ – 0 $ 1,000.00 Each additional half-bath is worth $500; each additional full bath $1,000. given in example
    Garage Space 2-car $ – 0 $ – 0 $ 8,000.00 Additional garage space is worth $8000. given in example
    Porch. Patio, deck Cov. Porch/wood deck $ 1,000.00 $ 1,000.00 $ 1,000.00 Additional wood deck is worth $1000. given in example
    Fence, pool, etc. None $ – 0 $ (12,000.00) $ (12,000.00) Additional pool is worth $12,000. given in example
    Economics characteristics N.A $ – 0 $ – 0 $ – 0
    Use Single-family $ – 0 $ – 0 $ – 0
    Non-realty Components None $ – 0 $ – 0 $ – 0
    Indication of Subject Value $ 488,680.00 $ 485,426.40 $ 487,171.20
    Weight 50% 25% 25% You could decide what weight to assign to each property and need to justify your assignments in the report.
    Final Consolidation Value $ 487,489.40

    Demo

    Elements of Comparison Subject Comp 1 Comp 2 Comp 3
    Sale price of comparable $ 510,000.00 $ 525,000.00 $ 499,000.00
    Transaction Characteristics
    Property rights conveyed Fee simple
    Adjusted price
    Financing terms Conventional
    Adjusted price
    Conditions of sale Arm's length
    Adjusted price
    Expenditure immed. after purchase
    Adjusted price
    Market condition Today
    Adjusted price
    Property characteristics
    Location Huntington
    Physical characteristics
    Site/lot size 6,662 sq. ft
    Construction quality Typical
    Condition Average
    Effective age 5.5 years
    Living area 3,473 sq. ft
    Number of baths 3
    Garage Space 2-car
    Porch. Patio, deck Cov. Porch/wood deck
    Fence, pool, etc. None
    Economics characteristics N.A
    Use Single-family
    Non-realty Components None
    Indication of Subject Value

    Sheet3

                                                                                                                                      Order Now