Category: Tutorials

Importance of Including Sales Price Trend Graph in Appraisal Reports 2

Importance of Graphing Sales

Scatter graph can help you “visualize” the trend of sale prices over a time period… Appraisers, I’ve been including ‘comparable’ price trend graphs in my reports (using Excel) since 2008. The graphs are based on a chart of MLS sales in the subject’s neighborhood, and can be from 1 to 5 years prior to the report Effective Date – based on housing density and number of sales. (I work in urban, suburban and rural areas.) A Scatter Graph can help you “visualize” the trend of sale prices over a time period. It can also show questionable outlier sales that you...

Lender Contributions FNMA Policy Adding Fuel to the Confusion... 6

Concession Reporting Confusion

…how are these "lender contributions" identified… Appraisers are ‘required’ to report comparable sales or financing concessions that benefit a borrower in the GSE form appraisal report, on the second line in the comparison grid (as a negative adjustment). Secondly, for subject properties, appraisers are ‘required’ to report any concession benefiting the borrower on page 1 of the report form. Subject concession amount is NOT entered on the Comparable grid. Well now, FNMA has issued a modification to their Selling Guide (which takes effect as of 4/03/18) – SEL–2018-03 – (I have added type face enhancements): Lender Contributions With this update we are...

Extraordinary Assumption & Hypothetical Condition Definition Changes 12

EA & HA Definition Changes

Appraisers, effective with the 2018-19 USPAP, definitions for Extraordinary Assumption and Hypothetical Condition have changed. Below is a one page PDF sheet you can print & post at your office, and you may distribute this to others if you like. According to the Appraisal Standards Board, the Extraordinary Assumption change was done to clarify the term and its applicability. It seems the same rationale was used for the Hypothetical Condition definition change, although that was not mentioned in their Summary of Actions document issued on Feb. 23, 2017. Underlined words are the changes made. I also include the prior definitions below...

Mobile Sketch User Guide - Total for Mobile Sketch 6

Mobile Sketch Guide

Just getting my big toe in the mobile ocean… Appraisers, For those of you interested to learn how to ‘sketch’ using a la mode’s Total for Mobile Sketch (T4M) on a tablet or phone, the attached PDF might be of interest to you. I’m a greenhorn, just getting my big toe in the mobile ocean and could not find a user guide for T4M Sketch, except as ‘single pages’ on the a la mode web site. I turned in a Support Request asking if such a guide was available. Turns out they don’t have a self-contained guide. So the support tech got...

Suburban Inside Urban City Limits 20

Suburban Inside Urban City Limits – Really?

Pre-filled template with ‘Suburban’ already checked… Appraisers, Another appraisal report was delivered by a homing pigeon to my windowsill the other day. After leaving a ‘deposit’ on the sill that kind of matches the goop I observed in the report, off it went. The subject property is within a built-up neighborhood area within the largest city in this particular area; it is within city limits. The neighborhood was developed in the 1950’s and 60’s. It is fully built out (i.e., all subdivided lots are developed) and has a couple of neighborhood parks. Population density is similar to other areas within...

Rounding of Adjustments Because We Are Just Not That Good 16

Adjustment Question

Rounding of adjustments is perfectly acceptable. Would someone kindly, and logically, explain to me why the ‘Site’ is adjusted precisely at $0.20 per square foot, down to the nearest dollar, but all other adjustments are rounded to $50? Are ‘we’ appraisers really that good, where we can divine buyer motivations or values (i.e., adjustments) as accurately as that?  In other words: “Well, I believe it’s worth exactly that much.” Usually I see this kind of adjustment practice to the nearest dollar when applied to the Gross Living Area and below grade areas, which is also screwy (IMHO).  This is the...

Pendings Can Reveal Market Trends - Use of Graphs in Appraisal Reports 5

Graphing Using Spreadsheet – Including Pendings

Pendings can reveal market trends, turns and current activity… Appraisers, How many of you use visual graphs in your reports to demonstrate sales (and Pending) trend data? This can be a very important tool to convince your clients that you really have a good understanding of current valuation issues. I am indebted to David Braun, Patrick Egger, Steve Smith, George Dell, Anthony Young and Joe Lynch (among others) for their presentations about this key feature we can utilize. Frankly, using spreadsheets and their built-in graphing functions is something every appraiser should learn. I bring this up because an appraiser peer was...

Cost Approach Booklet & Instructions 5

Cost Approach Booklet & Instructions

FREE Cost Approach calculation worksheet… Appraisers, Many use Building-Cost.net as a source for completing residential Cost Approach details in appraisal reports. Craftsman Book Company is the owner of this service, and the web site offers a FREE Cost Approach calculation worksheet, which can be printed to PDF and included in reports, and also a printed hardcopy for the workfile if desired. I began using and promoting this web site years ago. Not long ago, the web site above was updated, to provide more specific reporting items, which in turn enables a more accurate and professional looking Cost Approach to be...

UAD Rating Absolute vs Relative 39

UAD Rating Absolute vs. Relative

Where did those rating words come from? Why is it so many appraisers have trouble with UAD and the CU (Collateral Underwriter), and how to apply the Quality and Condition rating between the Subject and Comps? Not long after the UAD was implemented/mandated by FNMA (in 2011), and then the CU evaluation system came along, FNMA began discovering that many appraisers were improperly Rating the comps Quality and Condition AGAINST the Subject in the grid. And they began telling appraisers what they were finding. FNMA also discovered, and revealed, that many appraisers were using the same Comps over and over...

GLA Adjustment & Pizza Slices – They Do correlate! 17

GLA Adjustments & Pizza Slices – They Do Correlate!

Determining the GLA Adjustment in Appraisal Reports I promised in a previous post I’d send out my method for determining the GLA adjustment in appraisal reports. Goodness! Appraisers actually found that statement buried in the prior post, and have ‘rung my chimes’ requesting this info! OK, but first, the pizza analogy. I often tell clients and other appraisers that appraising (residential) real estate is far more complex than grabbing a store-bought pre-boxed pizza (that has exactly the same ingredients from box to box no matter which store you shop in) at a grocery and then applying 425 degrees of love...

xml sitemap