Assignment Instructions

Below are directions how to complete the assignment. You will submit the assignment on the next page.

1. Download the file Sales Comparison Adjustments Excel Template Download Sales Comparison Adjustments Excel Template.Download Sales Comparison Adjustments Excel Templa This is the spreadsheet template you will use to complete and upload your assignment.
2. Carefully review Formulas & Mastery Tips for this Week's Sales Comparison Approach Excel Grid Assignment
3. Watch the following Step-by-Step Sales Comparison Adjustment Demonstration video. This video is 26 minutes and 23 seconds long and covers the following topics:
   • How to analyze elements of comparison in order to classify comps as "Superior," "Inferior," or "Similar"
   • How to determine whether comp adjustments should be upward (positive) or downward (negative) or no adjustment warranted based on comparison with the Subject property
   • How to calculate Adjusted Comparable Sales Prices, Net and Gross Adjustments and Percentage Net and Gross Adjustments
   • How to reconcile the value indicators into a single indicated value for a subject property based on the Gross Percentage Adjustments of the comps
4. Complete your downloaded Sales Comparison Adjustments Excel Template Download Sales Comparison Adjustments Excel Templateby adjusting each comparable by performing the following:
   • Analyze the elements of comparison for each comparable to determine whether comp adjustments are warranted.

1. • If a comp element of comparison adjustment is warranted, input the calculation into the corresponding cell formula to reflect upward (positive) or downward (negative) or no adjustment warranted based on comparison with the Subject property using the Market-Derived Adjustments provided
   • Input your cell formula calculations for Adjusted Comparable Sales Prices, Net and Gross Adjustments and Percentage Net and Gross Adjustments using cell formulas
   • Complete the two (2) "fill-in the blank questions" below the grid to (1) indicate which comp is the most reliable indicator of value and why and (2) indicate the final reconciled value for the subject property.
   • Complete the two (2) "fill-in the blank questions" below the grid to (1) indicate which comp is the most reliable indicator of value and why and (2) indicate the final reconciled value for the subject property. (Links to an external site.)

If you need a refresher on writing basic formulas in Excel, please refer to How to Create Cell Formulas in Excel (Links to an external site.).

Remember to include cell formulas in your spreadsheet.

AutoSava OFF OF AGE SUGA+= Sales Comparison Adjustments Excel Template Insert Draw Page Layout Formulas Data Home - Review View Acrobat Tell me Share Comments = Calibri (Body! v 11 ab Insert v AP A . General X [G Fi Conditional Formatting v Format as Teblev 280 1x Delete Peste BIU DA 90 Sensitivity = = Coll Styles Format v v Sart 4 Filter Find Select Analyze Data Create and Share Adobe PDF Yes No 0 P R 5 5 T w Derivea nic lagtchca Pairs Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A1 xv fx Sales Comparison Adjustment Template A c F G H M N 1 Sales Comparison Adjustment Template 2 3 Matched pairs were used to derive the following market ajustments 4 Traffic influence has a $10,000 impact on valus 5 Depreciated value of GLA Improvements is approximately $100 per square foot EAX Bath in this neighborhood is warth about $5,000 7 - Antra 1-Car Garage has a value of approximately $10,000 in this neighborhood 8 9 Input the required adjustments below using cell formulas 10! 11 12 Subject Comp 1 +$ Adjustment Comp 2 +(-) S Adjustment Comp3 + 1$ Adjustment Market-Derived Adjustments + (-1 13 Elements of Comparison 14 Isales Price N/A $ 540,000 $ 615,000 $ 575,000 15 Location Interior Tract Traffic $ 10.000 Interior Tract Interior Tract $10,000 for trafic influence 16 Condition Average Average werp Avere 17 Bedrooms 3 3 4 3 12 Baths 2.5 2.5 2 $ 5,000 3 $5,000 for 1/2 bath 19 Gruss Living Areas 2,000 SF 1,800 SE $ 20,000 2,200 SF 1 2,000 SF $100 per SF for GLA 20 Garage 2 Car 3 Car (10,000) 3 Car 2 Car $10,000 for garage space per car 22 Adjusted Comp Sales Price 22 Al Aljustments s S 30,000 23 Net Adjustment 24 Grow Adbustments $ 10,000 25 Gross Adjustment N 26 27 Remember that percentage Net or Grass Adjustments are always expressed as a "positive number" regardless of whether or not the actual nesargrass adjustments are positive or negative 28 Please insert commas into all dollar amounts over $1,000. 28 30 Fill in all blanks on the above grid and based only on the information given, answer the following questions 3. Which comparable is the most reliable indicator of the subject's value and explain why? 32 What is the Reconciled Value by Sales Comparison Approach? 33 34. 35 36 37 38 39 40 11 Sale Comparison Adjustments + Select destination and press ENTER or choose Paste ### + 100% AutoSava OFF OF AGE SUGA+= Sales Comparison Adjustments Excel Template Insert Draw Page Layout Formulas Data Home - Review View Acrobat Tell me Share Comments = Calibri (Body! v 11 ab Insert v AP A . General X [G Fi Conditional Formatting v Format as Teblev 280 1x Delete Peste BIU DA 90 Sensitivity = = Coll Styles Format v v Sart 4 Filter Find Select Analyze Data Create and Share Adobe PDF Yes No 0 P R 5 5 T w Derivea nic lagtchca Pairs Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A1 xv fx Sales Comparison Adjustment Template A c F G H M N 1 Sales Comparison Adjustment Template 2 3 Matched pairs were used to derive the following market ajustments 4 Traffic influence has a $10,000 impact on valus 5 Depreciated value of GLA Improvements is approximately $100 per square foot EAX Bath in this neighborhood is warth about $5,000 7 - Antra 1-Car Garage has a value of approximately $10,000 in this neighborhood 8 9 Input the required adjustments below using cell formulas 10! 11 12 Subject Comp 1 +$ Adjustment Comp 2 +(-) S Adjustment Comp3 + 1$ Adjustment Market-Derived Adjustments + (-1 13 Elements of Comparison 14 Isales Price N/A $ 540,000 $ 615,000 $ 575,000 15 Location Interior Tract Traffic $ 10.000 Interior Tract Interior Tract $10,000 for trafic influence 16 Condition Average Average werp Avere 17 Bedrooms 3 3 4 3 12 Baths 2.5 2.5 2 $ 5,000 3 $5,000 for 1/2 bath 19 Gruss Living Areas 2,000 SF 1,800 SE $ 20,000 2,200 SF 1 2,000 SF $100 per SF for GLA 20 Garage 2 Car 3 Car (10,000) 3 Car 2 Car $10,000 for garage space per car 22 Adjusted Comp Sales Price 22 Al Aljustments s S 30,000 23 Net Adjustment 24 Grow Adbustments $ 10,000 25 Gross Adjustment N 26 27 Remember that percentage Net or Grass Adjustments are always expressed as a "positive number" regardless of whether or not the actual nesargrass adjustments are positive or negative 28 Please insert commas into all dollar amounts over $1,000. 28 30 Fill in all blanks on the above grid and based only on the information given, answer the following questions 3. Which comparable is the most reliable indicator of the subject's value and explain why? 32 What is the Reconciled Value by Sales Comparison Approach? 33 34. 35 36 37 38 39 40 11 Sale Comparison Adjustments + Select destination and press ENTER or choose Paste ### + 100%