{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["READ ME","Inputs","FA1","FA2","FA3","FA4","FA5","FA6","FA7","FA8","FA8Par2","FA8Par3","FA9","FA10","FA11","FA11A","FA12(1of2)","FA12(2of2)","FA12A","FA13(1of2)","FA13(2of2)","FA14","FA15","FA16","FA16Par2","FA16Par3","FA17","FA18(1of2)","FA18(2of2)","FA18A","FA19(1of2)","FA19(2of2)","FA20(1of2)","FA20(2of2)","FA21","FA22","FA22A","FA22B","FA22C","FA22D","Add'l Pages"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME","index":0,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":false,"merged":[[15,0,15,1],[14,0,14,1]]}
[]
["READ THE INSTRUCTIONS"]
["Be sure you have downloaded a copy onto your computer-"]
["do not start filling in the report on-line."]
["Begin by using the 'save as' command and save under a new name "]
[]
["The ALDOT appraisal form report is, by design, very repetitive in regard to certain information; this report format in Excel "]
["is intended to eliminate some of repetitive entry of the same data and do some of the calculations on several pages"]
["which should save time and eliminate errors. "]
["There are limitations to this -it is set up in land acres (not SF) and it is not set up to handle multiple Before or After parcels."]
["If the property appraised does not fit this format, the appraiser will have to the the Word Version of individual pages or"]
["one of the Word report packages.  If one is well versed in Excel, one can make modifications to this  Excel worksheet as"]
["needed (be careful with the formulas!)."]
[]
["This Excel file contains the body of the appraisal report, The Addenda cover page, some subject photo pages, and"]
["property plat page.  The rest of the Addenda and Master File, if one is used, is more easily created in Word"]
["since the number of pages needed (for sales, maps and additional photographs) is variable from tract to tract)."]
[]
["Note that this Excel report body has each page or the ROW form on a separate worksheet.  Try to stay within the space "]
["allocated or add additional pages for detailed analysis and explanation."]
["The allocated space is not expandable in this version, however, there is an additional page below the primary"]
["page (same worksheet).  If more room is needed, there is an additional page (below) in each worksheet which will print"]
["if you put anything on it.  the tract number, project number, etc. will not carry over to those pages and will have to "]
["be typed  in when used.  Or, you can make reference to the Addenda and include any additional information or "]
["attachments there as well.  BE SURE WHAT YOU TYPE ACTUALLY PRINTS IN ITS ENTIRITY (BECAUSE OF THE CHARACTER LIMIT.)"]
[]
["DON'T USE THE FORM LIMITATIONS AS AN EXCUSE TO NOT ADEQUATELY DOCUMENT & DISCUSS; ADD ADDITIONAL PAGES."]
[]
["Also note; the Subject Exhibit & Photograph pages (FA-21A, 21B, 21C & 21D) are moved to the Addenda to make the"]
[" process (hopefully) more efficient from a report development/production perspective."]
[]
["Most of the pages (worksheet) has been locked (protected) to only allow the user to enter information in certain cells; "]
["these cells are shaded /highlighted and will show on the screen display if the resolution is adjusted.   "]
["The pages not protected are the pages where photographs/images need to be inserted."]
["These pages include FA-21A, 21B, 21C & 21D.  These form pages will be included on the worksheet tabs after the "]
[]
["Addenda Cover Page; the appraiser can either use these (there will be a separate Print macro for them) or use the same "]
["form pages in the Word format (which may be easier to insert images into for some)."]
["Each worksheet can be un-protected if need be, but if you write-over a formula you will lose it (unless you can re-do it)."]
[]
["The next Tab, Inputs, (tab at the bottom of the screen) is where most of the reoccurring data for the forms can be "]
["entered.  This data will 'populate' the various worksheets (pages); for example, enter the tract number on the Inputs page "]
["and it shows up throughout the report as does all inputs on the inputs page.  If the acreage changes after you have put it in, "]
["change it on the Inputs page and it changes throughout the report and the values will recalculate as well (as long as the"]
["forumlas have not been altered; always check to be sure)."]
[]
["The values for the Transmittal cover letter (FA-2) and the Report Summary (FA-3) are all generated on other pages in the "]
["report.  You can fill in the Comment Section at the bottom of FA1 if needed and on FA2 & FA3 there are a few fill-in cells."]
[]
["Explanations of individual pages (tabs) can be found in A-18 Appraisal Form Instructions."]
[]
["FILL IN THE 'INPUTS' WORKSHEET FIRST"]
["Note; the Tan worksheet tabs are data providing and analytical discussion pages; the blue tabs are more related to Before"]
["value calculation/presentation; and the green worksheet tabs are After value calculation/presentation report pages."]
["The grey tabs are for additional land parcels; if used, these will have to be separately-they are not in the print macros."]
[]
["NOTE-STILL WORKING OUT SOME OF THE FORMULAS; CHECK YOUR RESULTS FOR ERRORS-THIS IS A WORKING MODEL"]

{"sheet":"Inputs","index":1,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[7,6,7,8],[7,10,7,12],[27,1,27,6],[44,4,47,7],[48,4,50,7],[41,3,55,3]]}
[null,null,null,"ALABAMA DEPARTMENT OF TRANSPORTATION"]
[null,null,null,"Before you begin, go to the Read Me Tab (bottom of screen) and read about this report format."]
[null,null,null,"INPUT INFORMATION IN THE GREY BOXES"]
[null,"Appraiser Name",null,"General or Residential",null,"License Number"]
[null,"Appr Address",null,"Appr-City, State, Zip"]
[]
[null,"Region/Area",null,"Region Engineer"]
[null,"Region Area Ofc Street Address",null,"Region Area -City, State, Zip"]
[]
[null,"Project Number"]
[null,"Tract Number"]
[null,"County",null,"City "]
[null,"CPMS Number"]
[null,"Property Owner"]
[null,"Address of Owner",null,"City, State, Zip"]
[null,"Property Address"]
[null,"Contact Person"]
[null,"Telephone Number"]
[null,"Date of Report",null,"Effective DOV"]
[null,"Date Owner was contacted on"]
[null,"A certified letter to owner sent",null,"(Enter date or N/A)"]
[]
[null,"If not owner who was contacted?",null,"(Name)"]
[null,"What date was rep. contacted?",null,"(Enter date s or N/A)"]
[null,"What date(s) was ppty inspected?",null,null,null,null,"(Enter whatever date[s] apply or leave add'l boxes blank)"]
[null,"Who inspected the property ",null,"(the owner or named rep)"]
[null,"A Master File was/was not created",null,"(was or was not)"]
[null,"The Before and After areas have to be entered in acres-make sure the calculated Acquired acres match the map and/or plat."]
[null,"Before Area (Acres)",null,"After Area (Acres)",null,"Acquired Area (Ac)",{"$f":"C29-E29","v":0},null,null,"Before Subject SF"]
[null,"Size of PDE(s)",null,"Size of TCE(s)",null,null,null,null,null,"After Subject SF"]
[null,null,null,null,"For 2 or 3 parcels enter 2 or 3 in the appropriate box below (do not fill in unnecessary boxes)"]
[null,"If a total taking? (Enter, 1, Otherwise, 0)",null,"2 Parcels in the Before?",null,"3 Parcels Before?"]
[null,null,null,"2 Parcels in the After?",null,"3 Parcels After?"]
[null,null,null,null,"Parcel boxes can also be used for multi-zoned land or primary & excess land, usable & floodway"]
[null,null,"Parcel-1 in Acres",null,"Parcel-2 in Acres",null,"Parcel-3 in Acres"]
[null,"If no multiple parcels, Par.-1 = Before Area "]
[null,"If no multiple parcels, Par.1 = After Area "]
[null,null,null,"AFTER FILLING IN THE GREY BOXES ABOVE, FINISH FILLING IN THE GREY AREAS ON THE FOLLOWING PAGES AS APPLICABLE"]
[null,null,null," (adjust screen resolution if necessary)"]
[null,null,null,"Before printing, you may need to 'enable' macros (look toward the top of the screen)."]
[null,null,null,"Then Click on the shape to print"]
[null,null,null,"PLEASE NOTE; THE ADDITIONAL LAND-GRID PAGES FOR MULTIPLE PARCELS MAY NOT PRINT WHEN USING THE PRINT BUTTONS TO THE LEFT (I'm working on it!); THE APPRAISER MAY HAVE TO PRINT THOSE SEPARATELY AND INSERT THEM. "]
[null,"To print total taking, Land Only"]
[]
[null,"To print partial taking, Land Only",null,null,"THIS EXCEL APPRAISAL REPORT INCLUDES PAGES FOR SOME SUBJECT PHOTOGRAPHS AND THE PROPERTY PLAT.  ALL OTHER ADDENDA CONTENT NEEDS TO BE DONE IN A WORD DOCUMENT, PRINTED SEPARATELY AND ATTACHED TO THE EXCEL REPORT."]
[]
[]
[null,"To print total taking, Residential"]
[null,null,null,null,"IT IS THE APPRAISERS RESPONSIBILITY TO ENSURE ALL NECESSARY REPORT PAGES AND EXHIBITS ARE INCLUDED."]
[null,"To print partial taking, Residential"]
[]
[]
[null,"To print total taking, Comm (Non-Res.)"]
[]
[null,"To print partial taking, Comm (Non-Res.)"]

{"sheet":"FA1","index":2,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[49,0,57,9],[27,2,27,3],[27,5,27,6],[45,0,45,9],[46,0,46,9],[47,0,47,9]]}
[null,null,null,null,null,null,null,null,null,"FA-1 (Rev. 10/20)"]
[]
[null,null,null,null,"REAL PROPERTY"," APPRAISAL REPORT"]
[null,null,null,null,null,"Prepared For"]
[null,null,null,null,null,"ALABAMA DEPARTMENT OF TRANSPORTATION"]
[null,null,null,null,null,"By"]
[]
[null,null,null,null,null,{"$f":"Inputs!C4","v":0}]
[null,null,null,null,null,{"$f":"Inputs!C5","v":0}]
[null,null,null,null,null,{"$f":"Inputs!E5","v":0}]
[null,null,"Region",null,{"$f":"Inputs!C7","v":0}]
[null,null,"Project Number",null,{"$f":"Inputs!C10","v":0}]
[null,null,"Tract Number",null,{"$f":"Inputs!C11","v":0}]
[null,null,"County",null,{"$f":"Inputs!C12","v":0}]
[null,null,"CPMS Number",null,{"$f":"Inputs!C13","v":0}]
[]
[null,"Property Owner",null,null,{"$f":"Inputs!C14","v":0}]
[]
[null,"Address of Owner(s)",null,null,{"$f":"Inputs!C15","v":0}]
[]
[null,"Property Address",null,null,{"$f":"Inputs!C16","v":0}]
[]
[null,"Contact Person",null,null,{"$f":"Inputs!C17","v":0}]
[]
[null,"Telephone Number",null,null,{"$f":"Inputs!C18","v":0}]
[]
[]
["Original Date ",null,{"$f":"Inputs!C19","v":"00:00:00"},null,"Revised Date ",null,null,"Effective Date",null,{"$f":"Inputs!E19","v":"00:00:00"}]
["of Report",null,null,null,"of Report",null,null,"of Appraisal"]
[null,null,null,null,null,"Please Note:"]
["This report is intended for use by the Alabama Department of Transportation and was developed with consideration of "]
["ALDOT’s assignment requirements.  This report is not intended for any other use or user not specifically described herein."]
["The Uniform Act (*) and Title 79, Code of Federal Regulations, Part 24 set the requirements for appraisal and appraisal "]
["review in support of Federal  and Federally-assisted acquisition(s) of real property for government projects.  This "]
["appraisal has been prepared in accordance with these requirements which are intended to be consistent with the "]
["Uniform Standards of Professional Appraisal Practice (USPAP).  In accordance with 49 CFR-§24.103(b); the appraiser, in "]
["developing the fair market value of a property before a proposed acquisition, is instructed to disregard any decrease or "]
["increase in the market value of the real property caused by the project for which the property is to be acquired, or by "]
["the likelihood that the property would be acquired for the project, other than that due to physical deterioration within "]
["the reasonable control of the owner.  Additionally, the appraiser is instructed to value any remainder property as if the "]
["planned project is complete as of the effective date of appraisal.  These instructions are legal requirements which can be "]
["construed to create hypothetical conditions as defined in USPAP Standards Rule 1-2(g) and are noted herein in "]
["accordance with USPAP Standards Rule 2-2(a)(xi).  These hypothetical conditions may affect the assignment results."]
[null,"(*) Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1970, as amended."]
[]
["Uniform Standards of Professional Appraisal Practice (USPAP)"]
["This written real property appraisal report was developed in substantial compliance with Standards Rule-1 of USPAP.  It"]
["is being reported as a \"Appraisal Report\" in accordance with Rule 2-2 of the USPAP."]
["Appraiser Comments:",null,"Any Appr. Comments (i.e. value is retrospective-for circuit court situations);"]

{"sheet":"FA2","index":3,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,2,4,3],[51,1,57,9],[16,9,16,10],[17,9,17,10],[18,6,18,10],[20,5,20,10],[30,0,30,1],[19,6,19,7]]}
[null,null,null,null,null,null,null,null,null,null,"FA-2 (Rev. 10/20)"]
[]
[]
[{"$f":"Inputs!E7","v":0}]
["Region Engineer,",null,{"$f":"Inputs!C7","v":0},null,"Area"]
["Alabama Department of Transportation"]
[{"$f":"Inputs!E8","v":0}]
[]
[null,null,null,null,null,null,null,"RE:","Project No.",{"$f":"Inputs!C10","v":0}]
[null,null,null,null,null,null,null,null,"Tract No.",{"$f":"Inputs!C11","v":0}]
[null,null,null,null,null,null,null,null,"County",{"$f":"Inputs!C12","v":0}]
[]
["In compliance with you request for an appraisal of the subject Right-of-Way tract, I have made a personal "]
["inspection of the property and a search of the market for comparable market data.  Contact with the owner "]
["was by the following (indicated) option."]
[]
["The owner was contacted / given the opportunity to inspect the property on:",null,null,null,null,null,null,null,null,{"$f":"Inputs!$C$20","v":"00:00:00"}]
["The owner designated a representative to meet me; that person was contacted on :",null,null,null,null,null,null,null,null,{"$f":"Inputs!$C$24","v":0}]
["The owner's representative was identified as:",null,null,null,null,null,{"$f":"Inputs!$C$23","v":0}]
["The property was inspected on:",null,null,null,null,null,{"$f":"Inputs!$C$25","v":"00:00:00"},null,{"$f":"Inputs!$D$25","v":"00:00:00"},{"$f":"Inputs!$E$25","v":"00:00:00"},{"$f":"Inputs!$F$25","v":"00:00:00"}]
["Those inspecting the property with me were:",null,null,null,null,{"$f":"Inputs!$C$26","v":0}]
[]
["I was unable to contact the owner; a certified/return receipt requested letter was sent to the last known address "]
["of the owner.  Two (2) weeks from the date of the certified letter were allowed for a reply before the valuation of the"]
["property."]
[]
["Attached is my report containing supporting market and site data or referencing a Master File for the market data"]
["content."]
[]
["My opinion of the fair market value of the referenced tract is stated below as of:"]
[{"$f":"Inputs!E19","v":"00:00:00"},null,"."]
[null,null,null,null,null,null,null,null,"Total Acquisition","Partial Acquisition"]
[null,null,"Fair Market Value Before the Acquisition:",null,null,null,null,null,{"$f":"IF(Inputs!$B$32=1,'FA14'!L5,\" \")","v":" "},{"$f":"IF(Inputs!C32=0,'FA20(1of2)'!#REF!,\" \")","v":{"$error":"#REF!"}}]
[null,null,"Fair Market Value After the Acquisition: ",null,null,null,null,null,{"$f":"IF(Inputs!$B$32=1,'FA14'!L6,\" \")","v":" "},{"$f":"IF(Inputs!C32=0,'FA20(1of2)'!#REF!,\" \")","v":{"$error":"#REF!"}}]
[null,null,"Fair Market Value of the Acquisition:",null,null,null,null,null,{"$f":"IF(Inputs!$B$32=1,'FA14'!L7,\" \")","v":" "},{"$f":"IF(Inputs!C32=0,'FA20(1of2)'!#REF!,\" \")","v":{"$error":"#REF!"}}]
[]
[]
["A Project Master File ",null,null,{"$f":"Inputs!C27","v":0},"used to incorporate, by reference, data common to other tracts."]
["A Master File is considered a part of the Addenda of each report making reference to it."]
[]
[]
[]
[null,null,null,null,null,null,null,"Respectively submitted,"]
[]
[null," "]
[]
[null,null,null,null,null,null,null,{"$f":"Inputs!C4","v":0}]
[null,null,null,null,null,"State Certified",null,{"$f":"Inputs!E4","v":0},"Real Property Appraiser"]
[null,null,null,null,null,null,null,"Alabama License Number",{"$f":"Inputs!G4","v":0}]
[]
[null,"Enclosures"]

{"sheet":"FA3","index":4,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[47,6,47,7],[42,8,42,9],[40,2,40,7],[41,2,41,7],[33,8,33,9],[34,8,34,9],[35,2,35,7],[35,8,35,9],[33,2,33,7],[8,1,8,2],[8,4,8,5],[8,7,8,8],[36,8,36,9],[39,8,39,9],[39,2,39,7],[23,2,23,7],[24,2,24,7],[27,8,27,9],[28,8,28,9],[25,8,25,9],[26,8,26,9],[34,2,34,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[50,1,58,10],[11,3,11,4],[11,8,11,9],[12,3,12,4],[12,8,12,9],[13,3,13,4],[13,8,13,9],[15,9,15,10],[19,5,19,9],[20,5,20,9],[23,8,23,9],[24,8,24,9],[40,8,40,9],[41,8,41,9],[32,8,32,9],[32,5,32,6]]}
[null,null,null,null,null,null,null,null,null,null,"FA-3: (Rev. 10/20)"]
[null,null,null,null,"APPRAISAL REPORT SUMMARY"]
[null,"Owner",{"$f":"Inputs!C14","v":0},null,null,null,null,"Project No.",{"$f":"Inputs!C10","v":0}]
[null,"Address",{"$f":"Inputs!C16","v":0},null,null,null,null,"County",{"$f":"Inputs!C12","v":0}]
[null,"City, State, Zip",{"$f":"Inputs!E15","v":0},null,null,null,null,"Tract No.",{"$f":"Inputs!C11","v":0}]
[]
[null,null,"APPRAISED AREA BEFORE",null,null,"APPRAISED AREA AFTER",null,null,"AREA TO BE ACQUIRED"]
[null,null,{"$f":"Inputs!C29","v":0},"Ac.",null,{"$f":"Inputs!$E$29","v":0},"Ac.",null,{"$f":"Inputs!$G$29","v":0},"Ac."]
[null,{"$f":"C8*43560","v":0},null,"SF",{"$f":"F8*43560","v":0},null,"SF",{"$f":"I8*43560","v":0},null,"SF"]
[]
[null,null,"VALUE BEFORE THE TAKING",null,null,null,null,"VALUE AFTER THE TAKING"]
[null,null,"Land Value =",{"$f":"'FA8'!K59+FA8Par2!J60+FA8Par3!K60","v":0},null,null,null,"Land Value =",{"$f":"'FA16'!K58-'FA20(1of2)'!L49+FA16Par2!K58+FA16Par3!K58","v":0}]
[null,null,"Improvement Value =",{"$f":"('FA14'!L17)-('FA8'!K59)","v":0},null,null,null,"Improvement Value =",{"$f":"'FA20(1of2)'!L43-'FA16'!K58-FA16Par2!K58-FA16Par3!K58","v":0}]
[null,null,"Total Value =",{"$f":"D12+D13","v":0},null,null,null,"Total Value =",{"$f":"I12+I13","v":0}]
[]
[null,null,null,null,null,null,"DIFFERENCE BETWEEN BEFORE AND AFTER VALUES",null,null,{"$f":"D14-I14","v":0}]
[]
[]
[null,null,null,null,null,"VALUATION DETAILS OF PORTION TO BE ACQUIRED"]
[null,"1. Land","Acquired",{"$f":"Inputs!G29","v":0},"Ac. @",{"$f":"IF(D20,K20/D20,\" \")","v":" "},null,null,null,null,{"$f":"IF((Inputs!C32>0),('FA14'!L31),('FA20(1of2)'!#REF!))","v":{"$error":"#REF!"}}]
[null,null,"P.D.E.",{"$f":"Inputs!C30","v":0},"Ac. @",null,null,null,null,null,{"$f":"'FA20(1of2)'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"2. Improvements on Land to be Acquired (Consistent with FA-20)"]
[null,1,null,null,null,null,null,null,0]
[null,2,null,null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,0]
[null,5,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I24:I28)","v":0}]
[null,null,null,null,null,null,null,"TOTAL VALUE OF IMPROVEMENTS TO BE ACQUIRED",null,null,{"$f":"IF(OR('FA14'!L32=I29,('FA20(1of2)'!#REF!=I29)),I29,\"Error\")","v":{"$error":"#REF!"}}]
[]
[null,"3. Temporary Construction Easement(s) & Damages to Remaining Property"]
[null,null,"T.C.E Area",null,"Ac @ $",null,null,"Per Acre=",0]
[null,1,null,null,null,null,null,null,0]
[null,2,null,null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"Total Damages",{"$f":"SUM(I34:I36)","v":0}]
[]
[null,"4. Estimated Specific Benefits to Remaining Property"]
[null,1,null,null,null,null,null,null,0]
[null,2,null,null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"Total Specific Benefits",{"$f":"SUM(I40:I42)","v":0}]
[]
[null,"5. Damages Less Benefits",null,null,null,null,null,null,null,"Net to Remainder",{"$f":"I37+I43","v":0}]
[]
[null,"6. Sum of Values"]
[null,null,null,"TOTAL VALUE OF PORTION TO BE ACQUIRED",null,null,{"$f":"K20+K21+K30+K45","v":{"$error":"#REF!"}},null,"As of (Eff. Date)",null,{"$f":"Inputs!E19","v":"00:00:00"}]
[null,"7. Remarks: "]
[null,"(Extraordinary Assumptions and/or Hypothetical Conditions that affect the analysis, opinions and conclusions found in this report.)"]

{"sheet":"FA4","index":5,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,4,53,5],[51,8,51,9],[52,8,52,9],[33,10,33,11],[33,8,33,9],[33,3,33,4],[48,6,48,7],[48,8,48,11],[33,1,33,2],[51,4,51,5],[0,7,0,8],[1,7,1,8],[54,4,54,11],[20,1,25,11],[35,8,35,9],[35,10,35,11],[35,1,35,2],[35,3,35,4],[34,1,34,2],[36,10,36,11],[37,3,37,4],[37,8,37,9],[37,10,37,11],[45,4,45,6],[56,1,58,11],[39,1,42,11],[34,3,34,4],[34,8,34,9],[34,10,34,11],[36,3,36,4],[36,8,36,9],[46,9,46,11],[47,9,47,11],[36,1,36,2],[37,1,37,2],[46,4,46,6],[45,9,45,11],[48,2,48,5],[47,4,47,6],[52,4,52,5]]}
[null,null,null,null,"ASSIGNMENT DETAILS AND",null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-4: (Rev. 10/20)"]
[null,null,null,null,"TRACT SPECIFIC DATA",null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,"Purpose of Appraisal:",null,"The purpose of the appraisal is to form an opinion of fair market value of the subject property "]
[null,"both before and after the acquisition of, all or a portion of, property by the Alabama Department of Transportation "]
[null,"for State highway use, taking into consideration the legally compensable damages and/or enhancement resulting "]
[null,"from the taking as determined by the laws of the State of Alabama."]
[]
[null,"Scope of Work:  (To be developed jointly by ALDOT and appraiser.)"]
[null,"General Scope Statement: In properly preparing this 'provided' form appraisal report, the appraiser is expected to: 1) Develop a  "]
[null,"working knowledge of the subject market area and to be familiar with current property values based on a review and analysis of"]
[null,"recent comparable sales activity which is to be documented in this report or in his/her Master File.  2) Personally inspect the"]
[null,"appraised property, the highway map, and construction plans depicting the proposed acquisition.  3) Provide an adequate Appraiser"]
[null,"scope of work statement which explains the assignment, addresse the extent of the inspection, the extent of the neighborhood &"]
[null,"proposed project area analysis, the extente of the property inspection, and the leve of detail of the description of the physical"]
[null,"characterisitcs of the property being appraised as well as the remaining property.  4) Report his/her analysis, opinions, and "]
[null,"conclusions in the most current ALDOT form appraisal report.  The proper preparation of this form will satisfy the definition of"]
[null,"\"appraisal\" in the specific rule requirements in §24.103(a)2 and §24.103(b).  The Tract Specific Scope Statement from the WAO is"]
[null,"included here by reference as the basis for the report's approaches and methodologies.  Any additional comments may be included"]
[null,"here (changes in the WAO schope requires written approval from the Central Office)."]
[null,"Appraiser Scope Statement"]
[null,"_Enter Scope here or refer to Addenda"]
[]
[]
[]
[]
[]
[null,"Property Rights Appraised:  Fee Interest (All leases and other encumbrances should be noted in the report)"]
[]
[null,"Definition of Fair Market Value:  The price the property would bring when offered for sale by a willing seller"]
[null,"who is not forced to sell and which is sought by a willing buyer who is not required to buy, after due "]
[null,"consideration of all elements affecting value.  (Code of Alabama §18-1A-172)"]
[]
[null,"Five Year Delineation of Title:"]
[null,"Grantor",null,"Grantee",null,"Date","Book ","Page","Consideration",null,"Verification"]
[]
[]
[]
[]
[null,"Analyze (understand and explain) any sales noted above or; current listings, recent offers, etc., or say None"]
[]
[]
[]
[]
[]
[null,"Tax Assessment Data:"]
[null,"County Tax Parcel ID No.",null,null,null,null,null,null,"Annual Taxes"]
[null,"County Tax Parcel ID No.",null,null,null,null,null,null,"Annual Taxes"]
[null,"County Appraised Value",null,null,null,null,null,null,"Assessed Value"]
[null,"Zoning:",null,null,null,null,"Flood Hazard:"]
[]
[null,"Utilities ","Available  Connected",null,null,null,"Available  Connected",null,null,null,"Available  Connected"]
[null,"Electricity:",null,null,"Public Sewer:",null,null,null,"Public Water:"]
[null,"Natural Gas:",null,null,"Septic System:",null,null,null,"Well Water:"]
[null,"Telephone:",null,null,"Cable:"]
[null,"Other"]
[null,"Describe any on-site water or septic system(s): (Capacities, areas, depths, equipment, piping, adequacies, etc.)"]

{"sheet":"FA5","index":6,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,1,16,11],[18,1,30,11],[32,1,44,11],[47,1,59,11],[0,7,0,8],[1,7,1,8]]}
[null,null,null,null,"MARKET AREA ANALYSIS",null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-5: (Rev. 10/20)"]
[null,null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,null,null,null,null,null,"(Provide current analysis, continue any of the sections in the Addenda or reference a Master File)"]
[]
[null,"COUNTY DATA:",null,null,{"$f":"Inputs!C12","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CITY DATA:",null,null,{"$f":"Inputs!E12","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NEIGHBORHOOD DATA:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SITE DATA:"]
[null,"(Incl. marketability factors i.e. access, frontage, depth, shape, topo., soils, use, improvements, easements, encroachments)"]

{"sheet":"FA6","index":7,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[38,1,38,2],[20,1,20,12],[23,1,23,2],[37,8,37,10],[28,11,28,12],[28,2,28,7],[36,8,36,10],[0,7,0,8],[1,7,1,8],[0,1,0,5],[1,1,1,5],[40,1,43,12],[14,1,19,12],[21,11,21,12],[3,1,6,12],[29,8,29,10],[30,8,30,10],[31,8,31,10],[32,8,32,10],[28,8,28,10],[33,8,33,10],[34,8,34,10],[35,8,35,10]]}
[null,"PRESENT USE, ACQUISITION DESCRIPTION,",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,null,"FA-6: (Rev. 10/20)"]
[null,"AND RELOCATION MEETING DETAILS",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,"Present Use: (Brief description of how the site is presently used to benefit the owner)"]
[]
[]
[]
[]
[]
[null,"Description of Proposed Acquisition: [Not the legal description of the acqusition.  Explain how it was explained to the"]
[null,"owner/representative including physical onsite indicators identifying the location of the acquisition (i.e. ROW stakes,"]
[null,"linear measurement from edge of pavement), state what was shown depicting the acquisition & describe the "]
[null,"proposed acqusition generally (i.e. state what is being acquired but not as detailed as in the valuation approaches,"]
[null,"FA-3 & FA-20), along with any noted encumbrances (easements, leases, etc.) observed by the appraiser or brought"]
[null,"to the attention of the appraiser.]"]
[]
[]
[]
[]
[]
[]
[null,"On-Site Meetings with ALDOT Relocation Person(s) Are Required When Structures Are Being Acquired*"]
[null,"Date(s) of Required Meeting(s):"]
[]
[null,"Attendees:"]
[null,"Personal Property / Specialty Items: Note those Acquired or Damaged by Proposed Acquisition:  (list & identify all items"]
[null,"of personal property and specialty items such as merchantable timber, crops, minerals, etc. acquired or damaged only.)"]
[]
[null,"Items of Personal/Specialty Property:"]
[null,"Item","Brief Description",null,null,null,null,null,"Owner of Item",null,null,"Acq'd/Damaged"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appraiser Comments:"]
[]
[]
[]
[]
[null,"*Final rule issued on January 4, 2005 (effective 2/3/05) revising title 49 CFR Part 24 [§ 24.103(a)–rule and Appendix A].  The appraiser must now "]
[null,"identify items in the appraisal report considered to be “real property” as well as those considered to be “personal property.”   "]
[]
[null,"Alabama Code Section 18-1A-3; defines Personal Property as: “Any property other than real property which is affixed or directly related to the real "]
[null,"property proposed to be acquired.”"]
[]
[null,"It is the intent of the Department for each tract assignment involving structures to be acquired, the appraiser will be required to"]
[null,"inform Region/Area Relocation personnel of when the on-site inspection for the appraisal is scheduled.   The appropriate "]
[null,"Department (Region/Area) relocation staff personnel will attend the appraiser’s inspection in order to accommodate this"]
[null," requirement.  If Region/Area Relocation Personnel are unavailable to accompany the Appraiser on the inspection, they will provide"]
[null,"the Appraiser their determination of any items necessary to be included in this report section (in writing) within 5 business days "]
[null,"from the appraiser’s date of inspection.  The results of these meetings are to be included in the appraisal report(s) and will serve as "]
[null,"guides in this area for the balance of the acquisition process.  If needed, legal counsel is to be consulted when there are questions "]
[null,"as to the status of a given item."]
[]
[null,"If Department (Region/Area) personnel determine such required meeting is not necessary; this will be noted in the Tract by Tract Scope of Work "]
[null,"section (page-2) of the Work Authorization Order when submitted for approval.  "]

{"sheet":"FA7","index":8,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[34,5,34,6],[45,1,48,11],[49,4,49,8],[34,1,34,3],[35,1,38,11],[39,5,39,6],[40,1,43,11],[44,5,44,6],[0,7,0,8],[1,7,1,8],[50,1,53,11],[54,4,54,8],[55,1,60,11],[6,1,6,2],[6,5,6,6],[7,1,10,11],[11,5,11,6],[12,1,15,11],[16,5,16,6],[17,1,20,11],[21,4,21,8],[22,1,25,11],[27,1,32,11],[26,4,26,8]]}
[null,null,null,null,"HIGHEST AND BEST USE ANALYSIS",null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-7: (Rev. 10/20)"]
[null,null,null,null,"BEFORE",null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,"(More than a statement of the appraiser's opinion: Considering supply & demand factores, describe in the depth and detail required by its "]
[null,"significance to the appraisal assignment.  The conclusion(s) should address the use, the timing of the use, and the most likely user(s). "]
[null,"The appropriate handling of the Principle of Consistent Use is of paramount importance.)  Additional pages may be attached as necessary."]
[]
[null,"As (As If) Vacant",null,null,null,"Physically Possible"]
[]
[]
[]
[]
[null,null,null,null,null,"Legally Permissible"]
[]
[]
[]
[]
[null,null,null,null,null,"Financially Feasible"]
[]
[]
[]
[]
[null,null,null,null,"Maximally Productive"]
[]
[]
[]
[]
[null,null,null,null,"Reasonably Probable Conclusion"]
[]
[]
[]
[]
[]
[]
[]
[null,"As Improved (If Applicable)",null,null,null,"Physically Possible"]
[]
[]
[]
[]
[null,null,null,null,null,"Legally Permissible"]
[]
[]
[]
[]
[null,null,null,null,null,"Financially Feasible"]
[]
[]
[]
[]
[null,null,null,null,"Maximally Productive"]
[]
[]
[]
[]
[null,null,null,null,"Reasonably Probable Conclusion"]

{"sheet":"FA8","index":9,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[49,1,50,3],[51,1,52,3],[53,1,54,3],[55,0,55,3],[34,1,36,3],[37,1,39,3],[40,1,42,3],[43,1,45,3],[46,1,48,3],[11,2,11,5],[21,1,21,5],[28,1,30,3],[31,1,33,3],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[28,4,30,11],[0,1,0,6],[1,1,1,6],[31,4,33,11],[34,4,36,11],[58,10,58,11],[53,4,54,11],[55,4,57,11],[37,4,39,11],[40,4,42,11],[43,4,45,11],[46,4,48,11],[49,4,50,11],[51,4,52,11],[18,4,18,5],[19,4,19,5],[20,4,20,5]]}
[null,"LAND SALES APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-8: (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (Acres)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER AC",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},"0","0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject Ac.s)",{"$f":"Inputs!$C$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Topography:"]
[]
[]
[null,"Shape:"]
[]
[]
[null,"Utility:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"Before Land Value Conclusion:",null,null,null,null,{"$f":"Inputs!$C$29","v":0},"Ac  @     $",0,"Per Acre=",{"$f":"G59*I59","v":0}]

{"sheet":"FA8Par2","index":10,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,10,58,11],[51,4,52,11],[53,1,54,3],[53,4,54,11],[55,0,55,3],[55,4,57,11],[51,1,52,3],[20,4,20,5],[21,1,21,5],[28,1,30,3],[28,4,30,11],[31,1,33,3],[31,4,33,11],[8,1,8,5],[9,1,9,5],[11,2,11,5],[18,4,18,5],[19,4,19,5],[0,1,0,6],[1,1,1,6],[5,1,5,5],[6,1,6,5],[7,1,7,5],[34,1,36,3],[34,4,36,11],[37,1,39,3],[37,4,39,11],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[46,4,48,11],[49,1,50,3],[49,4,50,11]]}
[null,"LAND SALES APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-8: (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (Acres)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER AC",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},"0","0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject Ac.s)",{"$f":"Inputs!$C$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Topography:"]
[]
[]
[null,"Shape:"]
[]
[]
[null,"Utility:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"Before Land Value Conclusion:",null,null,null,null,{"$f":"Inputs!$C$29","v":0},"Ac  @     $",0,"Per Acre=",{"$f":"G59*I59","v":0}]

{"sheet":"FA8Par3","index":11,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[55,0,55,3],[55,4,57,11],[58,10,58,11],[49,4,50,11],[51,1,52,3],[51,4,52,11],[53,1,54,3],[53,4,54,11],[49,1,50,3],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[46,4,48,11],[34,1,36,3],[34,4,36,11],[37,1,39,3],[37,4,39,11],[8,1,8,5],[9,1,9,5],[11,2,11,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,1,21,5],[28,1,30,3],[28,4,30,11],[31,1,33,3],[31,4,33,11],[0,1,0,6],[1,1,1,6],[5,1,5,5],[6,1,6,5],[7,1,7,5]]}
[null,"LAND SALES APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-8: (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (Acres)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER AC",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},"0","0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject Ac.s)",{"$f":"Inputs!$C$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Topography:"]
[]
[]
[null,"Shape:"]
[]
[]
[null,"Utility:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"Before Land Value Conclusion:",null,null,null,null,{"$f":"Inputs!$C$29","v":0},"Ac  @     $",0,"Per Acre=",{"$f":"G59*I59","v":0}]

{"sheet":"FA9","index":12,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,1,59,11],[58,1,58,11],[0,1,0,5],[1,1,1,5],[32,9,32,11],[5,3,5,5],[6,4,6,11],[10,3,10,7],[10,10,10,11],[27,3,27,4],[21,3,21,11],[25,3,25,4],[26,3,26,4],[24,4,24,11],[14,3,14,11],[17,3,17,11],[18,3,18,11],[19,3,19,8],[20,3,20,8],[11,3,11,7],[11,10,11,11],[12,3,12,7],[12,10,12,11],[13,3,13,11],[33,9,33,11],[44,1,46,11],[28,3,28,4],[49,3,49,11],[50,3,50,11],[51,3,51,11],[52,3,52,11],[53,3,53,11],[55,3,55,11],[56,3,56,11]]}
[null,"DESCRIPTION OF",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-9: (Rev. 10/20)"]
[null,"RESIDENTIAL IMPROVEMENT(S)",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,null,null,null,null,null,"All information is as of the Date Of Inspection (or Date Of Condemnation)"]
[null,"Structure #:",null,"Address:",null,null,null,null,null,null,"Zip Code:"]
[null,"Building Type:",null,null,null,null,null,"No. of Floors:",null,null,"No. of Units:"]
[null,"Occupant(s) & Rental Data:"]
[null,"Actual Rent:",null,null,null,null,"Economic (Market Rent) (REQUIRED):"]
[]
[null,"Exterior Description"]
[null,"Construction:",null,null,null,null,null,null,null,"Quality:"]
[null,"Foundation:",null,null,null,null,null,null,null,"Exterior Walls:"]
[null,"Roof Type:",null,null,null,null,null,null,null,"Roof Cover:"]
[null,"Porches/Patios:"]
[null,"Other Details:"]
[]
[null,"Interior Description"]
[null,"Walls/Wall Cover:"]
[null,"Floors/Floor Cover:"]
[null,"Ceilings:",null,null,null,null,null,null,null,null,"Base Ceiling Height:"]
[null,"Description of Baths:",null,null,null,null,null,null,null,null,"Number of Baths:"]
[null,"Bath Features:"]
[null,"Kitchen Built-ins:",null,"Oven-",null,null,"Dishwasher-",null,null,"Compactor-"]
[null,null,null,"Vent Hood-",null,null,"Range-",null,null,"Microwave-"]
[null,"Other Kitchen Features:"]
[null,"Heating:",null,null,null,"Comments:"]
[null,"Cooling:",null,null,null,"Comments:"]
[null,"Water Heater:",null,null,null,"Comments:"]
[null,"Fireplace(s):",null,null,null,"Comments:"]
[null,"Other Systems:",null,null,null,"Comments:"]
[]
[null,"Room Count"]
[null,"Total:",null,"Bedrooms",null,null,"Full Baths:",null,"Other"]
[null,null,null,"Utility Rm.",null,null,"Half Baths:",null,"Other"]
[]
[null,"Area Totals (SF)",null,"THE IMPROVEMENTS HAVE TO BE MEASURED BY THE APPRAISER TO ENSURE ACCURACY"]
[null,null,"Living Area:",0,null,"Front Porch:",0,null,"Garage:",0]
[null,null,"Fin.Basement:",0,null,"Rear Porch:",0,null,"Carport:",0]
[null,null,"UnFin/Bsmnt:",0,null,"Side Porch:",0,null,"Patio:",0]
[null,null,"Storage:",0,null,"Deck:",0,null,"Other:",0]
[]
[null,"Age/Condition"]
[null,"Year Built",null,null,"Actual Age",null,null,"Effective Age",null,null,"Remaining Eco. Life"]
[null,"Remodeling/Additions (Dates/Comments)"]
[]
[]
[]
[]
[null,"Extra Features & Remarks"]
[null,"Security Features:"]
[null,"Additional Insulation:"]
[null,"Site Improvements:"]
[null,"Landscaping:"]
[null,"Other/Comments:"]
[null,"Noted Non Real Estate Items:"]
[null,"Walls/Wall Cover:"]
[null,"Floors/Floor Cover:"]
[]
[null,"NOTE: ALL IMPROVEMENTS SHALL BE PHOTOGRAPHED AND INCLUDED IN THE ADDENDA EVEN IF THEY HAVE NO VALUE "]
[null,"OR IF THE VALUATION IS NOT INCLUDED AS PER THE SCOPE"]

{"sheet":"FA10","index":13,"n_rows":61,"n_cols":24,"rows_kept":61,"cut":false,"hidden":false,"merged":[[56,15,56,23],[58,15,58,23],[60,13,60,23],[60,1,60,11],[56,3,56,11],[58,3,58,11],[0,13,0,17],[1,13,1,17],[5,15,5,17],[6,16,6,23],[10,15,10,19],[10,22,10,23],[12,15,12,19],[12,22,12,23],[13,15,13,19],[13,22,13,23],[17,15,17,23],[20,15,20,23],[21,15,21,23],[22,15,22,20],[54,3,54,11],[55,3,55,11],[35,9,35,11],[36,9,36,11],[47,1,49,11],[52,3,52,11],[53,3,53,11],[27,4,27,11],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[21,3,21,11],[13,3,13,7],[13,10,13,11],[17,3,17,11],[20,3,20,11],[0,1,0,5],[1,1,1,5],[10,3,10,7],[10,10,10,11],[12,3,12,7],[12,10,12,11],[5,3,5,5],[6,4,6,11],[24,3,24,11],[22,3,22,8],[23,3,23,8],[23,15,23,20],[24,15,24,23],[27,16,27,23],[28,15,28,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[54,15,54,23],[55,15,55,23],[35,21,35,23],[36,21,36,23],[47,13,49,23],[52,15,52,23],[53,15,53,23]]}
[null,"DESCRIPTION OF",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-10: (Rev. 10/20)",null,"DESCRIPTION OF",null,null,null,null,null,"Project No.:",{"$f":"Inputs!O10","v":0},null,null,"FA-10: (Rev. 10/20)"]
[null,"RESIDENTIAL IMPROVEMENT(S)",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0},null,null,null,null,"RESIDENTIAL IMPROVEMENT(S)",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!O11","v":0}]
[]
[null,null,null,null,null,null,"All information is as of the Date Of Inspection (or Date Of Condemnation)",null,null,null,null,null,null,null,null,null,null,null,"All information is as of the Date Of Inspection (or Date Of Condemnation)"]
[null,"Structure #:",null,"Address:",null,null,null,null,null,null,"Zip Code:",null,null,"Structure #:",null,"Address:",null,null,null,null,null,null,"Zip Code:"]
[null,"Building Type:",null,null,null,null,null,"No. of Floors:",null,null,"No. of Units:",null,null,"Building Type:",null,null,null,null,null,"No. of Floors:",null,null,"No. of Units:"]
[null,"Occupant(s) & Rental Data:",null,null,null,null,null,null,null,null,null,null,null,"Occupant(s) & Rental Data:"]
[null,"Actual Rent:",null,null,null,null,"Economic (Market Rent) (REQUIRED):",null,null,null,null,null,null,"Actual Rent:",null,null,null,null,"Economic (Market Rent) (REQUIRED):"]
[]
[null,"Exterior Description",null,null,null,null,null,null,null,null,null,null,null,"Exterior Description"]
[null,"Construction:",null,null,null,null,null,null,null,"Quality:",null,null,null,"Construction:",null,null,null,null,null,null,null,"Quality:"]
[null,"No. of Stories:",null,null,"Avg. Story Height:",null,null,"Mezzanine:",null,"Basement:",null,null,null,"No. of Stories:",null,null,"Avg. Story Height:",null,null,"Mezzanine:",null,"Basement:"]
[null,"Foundation:",null,null,null,null,null,null,null,"Dock Level Floor:",null,null,null,"Foundation:",null,null,null,null,null,null,null,"Dock Level Floor:"]
[null,"Exterior Walls:",null,null,null,null,null,null,null,"Truck Well:",null,null,null,"Exterior Walls:",null,null,null,null,null,null,null,"Truck Well:"]
[null,"Doors & Windows:",null,null,null,null,null,null,null,"Porch/Canopy/Balcony:",null,null,null,"Doors & Windows:",null,null,null,null,null,null,null,"Porch/Canopy/Balcony:"]
[null,"Roof Type:",null,null,null,null,null,null,null,"Roof Cover/Age:",null,null,null,"Roof Type:",null,null,null,null,null,null,null,"Roof Cover/Age:"]
[null,"Store Front:",null,null,null,null,null,null,null,null,null,null,null,"Store Front:"]
[null,"Other Details:",null,"Area Type",null,null,null,null,null,null,null,null,null,"Other Details:",null,"Area Type"]
[]
[null,"Interior Description",null,null,null,null,null,null,null,null,null,null,null,"Interior Description"]
[null,"Walls/Wall Cover:",null,null,null,null,null,null,null,null,null,null,null,"Walls/Wall Cover:"]
[null,"Floors/Floor Cover:",null,null,null,null,null,null,null,null,null,null,null,"Floors/Floor Cover:"]
[null,"Ceilings:",null,null,null,null,null,null,null,null,"Base Ceiling Height:",null,null,"Ceilings:",null,null,null,null,null,null,null,null,"Base Ceiling Height:"]
[null,"Restroom(s) Descr.:",null,null,null,null,null,null,null,null,"Number of Restrooms:",null,null,"Restroom(s) Descr.:",null,null,null,null,null,null,null,null,"Number of Restrooms:"]
[null,"Bath Features:",null,null,null,null,null,null,null,null,null,null,null,"Bath Features:"]
[null,"Break Area Built-Ins:",null,"Oven-",null,null,"Dishwasher-",null,null,"Compactor-",null,null,null,"Break Area Built-Ins:",null,"Oven-",null,null,"Dishwasher-",null,null,"Compactor-"]
[null,null,null,"Vent Hood-",null,null,"Range-",null,null,"Microwave-",null,null,null,null,null,"Vent Hood-",null,null,"Range-",null,null,"Microwave-"]
[null,"Mechanical Systems",null,null,null,null,null,null,null,null,null,null,null,"Mechanical Systems"]
[null,"Heating:",null,null,null,"Comments:",null,null,null,null,null,null,null,"Heating:",null,null,null,"Comments:"]
[null,"Cooling:",null,null,null,"Comments:",null,null,null,null,null,null,null,"Cooling:",null,null,null,"Comments:"]
[null,"Plumbing:",null,null,null,"Comments:",null,null,null,null,null,null,null,"Plumbing:",null,null,null,"Comments:"]
[null,"Fire Protection:",null,null,null,"Comments:",null,null,null,null,null,null,null,"Fire Protection:",null,null,null,"Comments:"]
[null,"Other Systems:",null,null,null,"Comments:",null,null,null,null,null,null,null,"Other Systems:",null,null,null,"Comments:"]
[]
[null,"Room Count",null,null,null,null,null,null,null,null,null,null,null,"Room Count"]
[null,"Total:",null,"Bedrooms",null,null,"Full Baths:",null,"Other",null,null,null,null,"Total:",null,"Bedrooms",null,null,"Full Baths:",null,"Other"]
[null,null,null,"Utility Rm.",null,null,"Half Baths:",null,"Other",null,null,null,null,null,null,"Utility Rm.",null,null,"Half Baths:",null,"Other"]
[]
[null,"Area Totals (SF)",null,"THE IMPROVEMENTS HAVE TO BE MEASURED BY THE APPRAISER TO ENSURE ACCURACY",null,null,null,null,null,null,null,null,null,"Area Totals (SF)",null,"THE IMPROVEMENTS HAVE TO BE MEASURED BY THE APPRAISER TO ENSURE ACCURACY"]
[null,null,"Gross Bldg. Area:",0,null,"Office Area:",0,null,"Area Type:",0,null,null,null,null,"Gross Bldg. Area:",0,null,"Office Area:",0,null,"Area Type:",0]
[null,null,"Net Lease Area:",0,null,"Warehouse:",0,null,"Area Type:",0,null,null,null,null,"Net Lease Area:",0,null,"Warehouse:",0,null,"Area Type:",0]
[null,null,"Heated/Cooled:",0,null,"Mezzanine:",0,null,"Area Type:",0,null,null,null,null,"Heated/Cooled:",0,null,"Mezzanine:",0,null,"Area Type:",0]
[null,null,null,"Interior Description/Comments:",null,null,null,null,null,null,null,null,null,null,null,"Interior Description/Comments:"]
[]
[null,"Age/Condition",null,null,null,null,null,null,null,null,null,null,null,"Age/Condition"]
[null,"Year Built",null,null,"Actual Age",null,null,"Effective Age",null,null,"Remaining Eco. Life",null,null,"Year Built",null,null,"Actual Age",null,null,"Effective Age",null,null,"Remaining Eco. Life"]
[null,"Remodeling/Additions (Dates/Comments)",null,null,null,null,null,null,null,null,null,null,null,"Remodeling/Additions (Dates/Comments)"]
[]
[]
[]
[]
[null,"Extra Features & Remarks",null,null,null,null,null,null,null,null,null,null,null,"Extra Features & Remarks"]
[null,"On-Site Parking:",null,null,null,null,null,null,null,null,null,null,null,"On-Site Parking:"]
[null,"Security Features:",null,null,null,null,null,null,null,null,null,null,null,"Security Features:"]
[null,"Fencing/Gates:",null,null,null,null,null,null,null,null,null,null,null,"Fencing/Gates:"]
[null,"Site Improvements:",null,null,null,null,null,null,null,null,null,null,null,"Site Improvements:"]
[null,"Landscaping:",null,null,null,null,null,null,null,null,null,null,null,"Landscaping:"]
[null,"Noted Non Real Estate Items:",null,null,null,null,null,null,null,null,null,null,null,"Noted Non Real Estate Items:"]
[null,"Other/Comments:",null,null,null,null,null,null,null,null,null,null,null,"Other/Comments:"]
[]
[null,"NOTE: ALL IMPROVEMENTS SHALL BE PHOTOGRAPHED EVEN IF NO VALUE OR VALUATION INCLUDED IN THE SCOPE",null,null,null,null,null,null,null,null,null,null,null,"NOTE: ALL IMPROVEMENTS SHALL BE PHOTOGRAPHED EVEN IF NO VALUE OR VALUATION INCLUDED IN THE SCOPE"]

{"sheet":"FA11","index":14,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[55,0,55,3],[55,4,57,11],[49,1,50,3],[49,4,50,11],[51,1,52,3],[51,4,52,11],[53,1,54,3],[53,4,54,11],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[46,4,48,11],[31,4,33,11],[34,1,36,3],[34,4,36,11],[37,1,39,3],[37,4,39,11],[58,10,58,11],[0,1,0,6],[1,1,1,6],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[11,2,11,5],[20,4,20,5],[21,1,21,5],[28,1,30,3],[28,4,30,11],[18,4,18,5],[19,4,19,5],[31,1,33,3]]}
[null,"IMPROVED MARKET APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-11: (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (SF)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER SF",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},{"$f":"IF(H11,H11/H12,\"0\")","v":"0"},"0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject SF)",{"$f":"Inputs!$K$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Age:"]
[]
[]
[null,"Quality/ Condition:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"Before  Value Conclusion:",null,null,null,null,{"$f":"Inputs!$K$29","v":0},"SF  @     $",0,"Per SF =",{"$f":"G59*I59","v":0}]

{"sheet":"FA11A","index":15,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[4,1,4,11],[5,0,5,1],[20,9,20,11],[13,2,19,9]]}
[null,"MARKET (INCOME BASED) APPROACH",null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,null,"FA-11A: (Rev. 10/20)"]
[null,"BEFORE",null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[]
[null,"GROSS RENT MULTIPLIER (GRM) METHOD"]
["Structure #",null,0]
[null,null,"Comp. Sale","#"]
[null,"Sales Price",null,null,0,0,0,0,0,0]
[null,"Gross Annual Rent",null,null,0,0,0,0,0,0]
[null,"Indicated GRM",null,null,{"$f":"IF(E8,E8/E9,\"0\")","v":"0"},"0","0","0","0","0"]
[null,"Subject Market Rent",null,null,0,0,0,0,0,0]
[null,"Value Indications",null,null,{"$f":"E10*$E$11","v":0},0,0,0,0,0]
[null,"Correlation/Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Selected GRM",null,null,null,null,null,null,"Market Value Conclusion Via GRM Method",{"$f":"E11*E21","v":0}]

{"sheet":"FA12(1of2)","index":16,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[6,0,6,1],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[2,0,2,11],[4,7,4,8],[6,3,6,10],[54,10,54,11],[20,4,20,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[31,4,31,5],[32,4,32,5],[47,10,47,11],[25,4,25,5]]}
[null,"INCOME APPROACH",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-12 (1 of 2): (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
["Direct Capitalization Method"]
[]
[null,null,"Economic Rent/Mo.",0,null,null,"Actual Rent/Mo.",0,null,null,"Annual Rent",{"$f":"D5*12","v":0}]
[]
["Structure #",null,0,"Market Rent",null,null,null,null,null,null,null,{"$f":"L5","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Expense Reimbursements",0]
[null,null,null,null,null,null,null,null,null,null,"Potential Gross Income (PGI)",{"$f":"SUM(L7:L9)","v":0}]
[null,null,null,null,null,null,null,null,"Vacancy and Collection Loss",10,"%     V & CL",{"$f":"(L10*J11)/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Effective Gross Income (EGI)",{"$f":"L10-L11","v":0}]
[null,null,null,null,null,null,"(Note; Expenses can be entered, in the gray areas, as either a % or as a $ amount)"]
[null,null,"Fixed Expenses:",null,null,"Based on %","%EGI",null,"Based on $","%EGI"]
[null,null,null,"Management",{"$f":"$L$12*G15","v":0},null,0,null,0,{"$f":"IF($L$12,I15/$L$12,\" \")","v":" "}]
[null,null,null,"Insurance",{"$f":"$L$12*G16","v":0},null,0,"OR",0,{"$f":"IF($L$12,I16/$L$12,\" \")","v":" "}]
[null,null,null,"Property Taxes",{"$f":"$L$12*G17","v":0},null,0,null,0,{"$f":"IF($L$12,I17/$L$12,\" \")","v":" "}]
[null,null,null,"Total Fixed Expenses",{"$f":"SUM(E15:E17)","v":0},null,null,"+",{"$f":"SUM(I15:I17)","v":0},"=",null,{"$f":"E18+I18","v":0}]
[]
[null,null,"Variable Expenses:",null,null,"Based on %","%EGI",null,"Based on $","%EGI"]
[null,null,null,"Utilities-Electric",{"$f":"$L$12*G21","v":0},null,0,null,0,{"$f":"IF($L$12,I21/$L$12,\" \")","v":" "}]
[null,null,null,"-Water",0,null,0,"OR",0," "]
[null,null,null,"-Gas",0,null,0,null,0," "]
[null,null,null,"-Other",0,null,0,null,0," "]
[null,null,null,"Repairs & Maintenance",0,null,0,null,0," "]
[null,null,null,null,0,null,0,"OR",0," "]
[null,null,null,null,0,null,0,null,0," "]
[null,null,null,null,0,null,0,null,0," "]
[null,null,null,"Total Variable Expenses",{"$f":"SUM(E21:E28)","v":0},null,null,"+",{"$f":"SUM(I21:I28)","v":0},"=",null,{"$f":"E29+I29","v":0}]
[]
[null,null,null,null,null,"Based on %","%EGI",null,"Based on $","%EGI"]
[null,null,null,"Reserves for Replacement",{"$f":"$L$12*G32","v":0},null,0,"OR",0,{"$f":"IF($L$12,I32/$L$12,\" \")","v":" "}]
[null,null,null,"Total Reserves",{"$f":"SUM(E25:E32)","v":0},null,null,"+",{"$f":"SUM(I25:I32)","v":0},"=",null,{"$f":"E33+I33","v":0}]
["Exp.%"]
[{"$f":"L35/L12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Total Expenses (EXP)",{"$f":"L18+L29+L33","v":0}]
[null,null,null,null,null,null,null,"Net Operating Income",null,null," (NOI)",{"$f":"L12-L35","v":0}]
[null,null,null,null,null,"(Market-derived rate should be entered here)→",null,null,"Capitalization Rate:",0.1,"(Ro)"]
[null,null,null,null,null,null,null,"Direct Cap. Conclusion",null,null,"(NOI/Ro)",{"$f":"L36/J37","v":0}]
[null,null,null,null,null,null,null,null,null,"Excess Land and/or Other Improvments (if Other  improvements contribute value)",null,0]
[null,null,null,null,null,null,null,null,null,"Concluded Value",null,{"$f":"SUM(L38:L39)","v":0}]
[]
[]
[null,null,null,null,null,null,"Discounted Cash Flow (DCF) Analysis Method"]
["This income method can be applicable when a long-term lease is in place or where the property has multiple tenants with different terms,"]
["etc.  The analysis involves a set of income streams, a reversion (net resale price) at the end of the investment holding period, a yeile rate"]
["rate and a terminal cap rate.  Reasonable market oriented forecasting is crucial to reliable results using this methodology.  If computer "]
["software developed to produce DCF (such as Argus) is used, all input assumptions/printouts shall be included as Addendum support."]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Subdivision (Sellout) Analysis Method"]
["This income method can be applicable when the sellout of multiple parcels is required over time.  This is also a discounted cash flow "]
["analysis and key aspects of this include an absorption rate, projecting gross income and expenses when they are expected to occur "]
["with the net sales income discounted to a present value indication for the land.  All supporting data as well as the analysis itself shall "]
["be presented either in the body of the report or in the Addenda"]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"FA12(2of2)","index":17,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[50,1,58,11],[0,1,0,3],[1,1,1,3],[17,1,17,11],[4,1,16,11],[33,1,47,11],[19,1,30,11]]}
[null,"INCOME APPROACH SUPPORT",null,null,null,null,"Project No.:",{"$f":"Inputs!D10","v":0},null,null,null,"FA-12 (2 of 2): (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,"Tract No.:",{"$f":"Inputs!D11","v":0}]
[]
[null,"Explanation of Difference between Economic (Market) Rent and Actual (Contract) Rent:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Support Data (Attach Market Comparable Data as Needed or Include in Master File)"]
[null,"Expenses Support:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate(s) Support:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other comments about the Income Approach:"]

{"sheet":"FA12A","index":18,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[40,0,40,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,4,46,5],[42,6,42,7],[43,6,43,7],[44,6,44,7],[46,6,46,7],[45,6,45,7],[50,0,54,9],[38,0,38,9],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[42,4,42,5],[43,4,43,5],[44,4,44,5],[46,8,46,9],[45,4,45,5],[21,0,25,9],[32,0,36,9],[0,0,0,3],[1,0,1,3],[2,0,2,9],[6,0,6,9],[7,0,7,9],[27,2,27,3],[28,2,28,3],[4,0,4,9]]}
["INCOME APPROACH (RESIDENTIAL)",null,null,null,null,"Project No.:",{"$f":"Inputs!D10","v":0},null,null,"FA-12A: (Rev. 10/20)"]
["BEFORE",null,null,null,null,"Tract No.:",{"$f":"Inputs!D11","v":0}]
["(Appraiser can select preferred method below.)"]
[]
["Rent Multiplier Method (1)"]
[null,null,null,null,null,"(Note: may also be calculated on annual rents [GRM] if local market dictates)"]
["GRMM Method (Subject Gross Monthly Income x GRMM Multiple - "]
["derived from market sales tabulated/correlated below and details included in the Report or Master File"]
[]
[null,null,null,null,null,"Market Support"]
[null,null,"Sale#","Sales Price","÷","Rent (Mth/Ann)","=","Multiplier"]
[null,null,null,0,"÷",0,"=",{"$f":"IF(D12,D12/F12,\" \")","v":" "}]
[null,null,null,0,"÷",0,"=",{"$f":"IF(D13,D13/F13,\" \")","v":" "}]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[]
[null,null,"Subject Market Rent",null,null,{"$f":"'FA9'!J8","v":0},"(aka Economic Rent)"]
["Correlation Comments:"]
[]
[]
[]
[]
[]
[]
[null,"Gross Monthly Income",null,null,"x",null,"GRMM","=GRMM Concluded Value",null,{"$f":"IF(C28,C28*F28,\"\")","v":""}]
[null,"Gross Annual Income",null,null,"x",null,"GRM","=GRM Concluded Value",null,{"$f":"IF(C29,C29*F29,\"\")","v":""}]
[null,null,null,null,null,null,null,"Market Value Conclusion"]
[]
["Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Rent Multiplier Method (2)"]
["Commercial",null,"Sale-1",null,"Sale -2",null,"Sale - 3",null,"Sale - 4"]
["Sales Price $",null,0,null,0,null,0,null,0]
["Gross Ann. Rent $",null,0,null,0,null,0,null,0]
["Sale's GRM",null,{"$f":"IF(C43,C43/C44,\"\")","v":""},null,{"$f":"IF(E43,E43/E44,\"\")","v":""},null,{"$f":"IF(G43,G43/G44,\"\")","v":""},null,{"$f":"IF(I43,I43/I44,\"\")","v":""}]
["Subj.'s Eco Rent $",null,{"$f":"'FA10'!$K$8","v":0}]
["Indicated Value $",null,{"$f":"IF(C43,C45*$C$46,\"\")","v":""},null,{"$f":"IF(E43,E45*$C$46,\"\")","v":""},null,{"$f":"IF(G43,G45*$C$46,\"\")","v":""},null,{"$f":"IF(I43,I45*$C$46,\"\")","v":""}]
[null,null,null,null,null,null,null,"Market Value Conclusion"]
[]
["Correlation Comments:"]

{"sheet":"FA13(1of2)","index":19,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[56,2,59,11],[5,3,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[46,2,46,8],[41,2,41,8],[42,2,42,8],[43,2,43,8],[44,2,44,8],[45,2,45,8],[47,2,47,8],[35,9,35,10],[0,1,0,5],[1,1,1,5],[37,9,37,10],[40,2,40,8]]}
[null,"COST APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-13 (1 of 2):  (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,null,null,null,null,null,null,"IMPORTANT NOTE; THE HIGHLIGHTED PARTS OF PAGE 2of2 NEEDS TO BE COMPLETED FIRST"]
[null,null,null,null,null,null,null,"FOR THE FORMULAS ON THIS PAGE TO AUTOMATICALLY CALCULATE THE AMOUNTS"]
[null,"#",null,null,null,null,null,"Replacement Cost New Method"]
[null,1,"Main Bldg.:",null,null,null,"SF @",{"$f":"'FA13(2of2)'!L8","v":0},"Per","SF","=",{"$f":"F6*H6","v":0}]
[null,2,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L10","v":0},"Per","SF","=",0]
[null,3,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L12","v":0},"Per","SF","=",{"$f":"F8*H8","v":0}]
[null,4,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L14","v":0},"Per","SF","=",0]
[null,5,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L16","v":0},"Per","SF","=",0]
[null,6,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L18","v":0},"Per","SF","=",0]
[null,7,null,null,null,null,null,{"$f":"'FA13(2of2)'!L20","v":0},"Per",null,"=",0]
[null,8,null,null,null,null,null,{"$f":"'FA13(2of2)'!L22","v":0},"Per",null,"=",0]
[null,9,null,null,null,null,null,{"$f":"'FA13(2of2)'!L24","v":0},"Per",null,"=",0]
[null,10,null,null,null,null,null,{"$f":"'FA13(2of2)'!L26","v":0},"Per",null,"=",0]
[null,null,null,null,null,null,null,null,null,"R.C.N. TOTAL","=",{"$f":"SUM(L6:L15)","v":0}]
[null,null,null,null,null,"Depreciation",null,null,"% of RCN",null,"$"]
[null,null,null,null,null,null,null,"Physical Curable:"," ",null,0]
[null,null,null,null,null,null,null,"Physical Incurable:",null,null,0]
[null,null,null,null,null,null,null,"Functional Curable:",null,null,0]
[null,null,null,null,null,null,null,"Functional Incurable:",null,null,0]
[null,null,null,null,null,null,null,"Economic Obsolescence:",null,null,0]
[null,null,null,null,null,null,null,"Accrued Depreciation (Total)",{"$f":"IF(L23 >0, (L23/L16),0)","v":0},null,null,{"$f":"SUM(K18:K22)","v":0}]
[]
[null,null,"Depreciated Building(s) Cost",null,null,null,null,null,null,null,null,{"$f":"L16-L23","v":0}]
[]
[null,null,"Appurtenances To Above Structure(s)",null,null,null,null,null,"Units","Cost New","% Deprec.","Deprec. Cost"]
[null,null,"Walks & Drives:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L28*I28","v":0},null,{"$f":"((J28-(J28*K28)))","v":0}]
[null,null,"Fencing:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L30*I29","v":0},null,0]
[null,null,"Landscaping:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L32*I30","v":0},null,0]
[null,null,"Water Well:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L34*I31","v":0},null,0]
[null,null,"Septic System:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L36","v":0},null,0]
[null,null,"Other:",null,null,null,null,null,null,0,null,0]
[null,null,"Other:",null,null,null,null,null,null,0,null,{"$f":"((J34-(J34*K34)))","v":0}]
[null,null,"Other:",null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,"Total Deprec. Costs of Appurtenant Improvements:",{"$f":"SUM(L28:L35)","v":0}]
[]
[null,null,"Depreciated Cost of Structure(s) & Appurtenances",null,null,null,null,null,null,{"$f":"L25+J36","v":0}]
[null,null,null,null,"Other Improvements"]
[null,null,"Description",null,null,null,null,null,null,"Cost New","% Deprec.","Deprec. Cost"]
[null,"A",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L43","v":0},null,{"$f":"((J41-(J41*K41)))","v":0}]
[null,"B",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L44","v":0},null,0]
[null,"C",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L45","v":0},null,0]
[null,"D",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L46","v":0},null,0]
[null,"E",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L47","v":0},null,0]
[null,"F",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L48","v":0},null,0]
[null,"G",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L49","v":0},null,0]
[null,"H",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L50","v":0},null,0]
[null,null,"Total Depreciated Cost of All Improvements",null,null,null,null,null,null,null,null,{"$f":"L25+SUM(L28:L35)+SUM(L41:L48)","v":0}]
[null,null,"Concluded Land Value (from FA-8)",null,null,null,null,null,null,null,null,{"$f":"'FA8'!$K$59+FA8Par2!$K$60+FA8Par3!$K$60","v":0}]
[null,null,"APPRAISER'S COST APPROACH VALUE CONCLUSION:",null,null,null,null,null,null,null,null,{"$f":"L49+L50","v":0}]
[null,null,null,null,null,null,null,"COST SOURCES"]
[null,null,"Note:  If the Cost Approach is not relied on or not given more emphasis than the Improved Market Approach or Income "]
[null,null,"Approach, provide a general and brief summary of the source(s) below.  If the Cost Approach is relied on, or given more emphasis,"]
[null,null,"or used to arrive at adjustments in the Improved Market Approach or Income Approach; complete the detailed Cost Source Form  "]
[null,null,"FA-13A, which includes market extracted depreciation support, and include it in the report."]

{"sheet":"FA13(2of2)","index":20,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,1,3,11],[4,1,4,11],[2,1,2,11],[0,1,0,4],[1,1,1,4],[0,6,0,8],[1,6,1,8],[51,1,60,11],[30,2,31,7],[32,2,33,7],[34,2,35,7],[36,2,37,7],[38,2,39,7],[40,2,41,7],[42,2,42,10],[43,2,43,10],[44,2,44,10],[45,2,45,10],[46,2,46,10],[47,2,47,10],[48,2,48,10],[49,2,49,10],[28,2,29,7],[6,2,7,7],[8,2,9,7],[10,2,11,7],[12,2,13,7],[14,2,15,7],[16,2,17,7],[18,2,19,7],[20,2,21,7],[22,2,23,7],[24,2,25,7],[26,2,27,7]]}
[null,"COST APPROACH",null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,null,"FA-13 (2 of 2):  (Rev. 10/20)"]
[null,"BEFORE",null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,"COSTS SOURCES"]
[null,"Note: Provide the complete reference; if Marshall and Swift is used, provide the Section, page, description, multipliers,"]
[null,"etc.; if local or other source, provide a contact number or other way reviewer can verify the information."]
[null,"#",null,null,null,null,null,null,"Sub. Ttl.","CCM","LCM","Adj. Cost"]
[null,1]
[null,null,null,null,null,null,null,null,0,0,0,{"$f":"I8*J8*K8","v":0}]
[null,2]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I10*J10*K10","v":0}]
[null,3]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I12*J12*K12","v":0}]
[null,4]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I14*J14*K14","v":0}]
[null,5]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I16*J16*K16","v":0}]
[null,6]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I18*J18*K18","v":0}]
[null,7]
[]
[null,8]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I22*J22*K22","v":0}]
[null,9]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I24*J24*K24","v":0}]
[null,10]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I26*J26*K26","v":0}]
[null,"Walks & "]
[null,"Drives:",null,null,null,null,null,null,null,null,null,{"$f":"I28*J28*K28","v":0}]
[null,"Fencing:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I30*J30*K30","v":0}]
[null,"Land-"]
[null,"scaping:",null,null,null,null,null,null,null,null,null,{"$f":"I32*J32*K32","v":0}]
[null,"Water "]
[null,"Well:",null,null,null,null,null,null,null,null,null,{"$f":"I34*J34*K34","v":0}]
[null,"Septic "]
[null,"System:",null,null,null,null,null,null,null,null,null,{"$f":"I36*J36*K36","v":0}]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I38*J38*K38","v":0}]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I40*J40*K40","v":0}]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I42*J42*K42","v":0}]
[null,"A",null,null,null,null,null,null,null,null,null,0]
[null,"B",null,null,null,null,null,null,null,null,null,0]
[null,"C",null,null,null,null,null,null,null,null,null,0]
[null,"D",null,null,null,null,null,null,null,null,null,0]
[null,"E",null,null,null,null,null,null,null,null,null,0]
[null,"F",null,null,null,null,null,null,null,null,null,0]
[null,"G",null,null,null,null,null,null,null,null,null,0]
[null,"H",null,null,null,null,null,null,null,null,null,0]
[null,"Explanation & Support for Depreciation:"]

{"sheet":"FA14","index":21,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[19,1,19,11],[8,1,10,11],[35,1,60,11],[11,1,14,11],[30,3,30,9],[31,3,31,9],[32,3,32,9]]}
[null,"CORRELATION OF VALUES",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-14: (Rev. 10/20)"]
[null,"BEFORE",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[]
[null,"MARKET APPROACH",null,null,null,null,"(Value Indication)",null,null,null,null,{"$f":"'FA13(1of2)'!L51","v":0}]
[null,"INCOME APPROACH",null,null,null,null,"(Value Indication)",null,null,null,null,{"$f":"IF('FA12(1of2)'!L40=0,FA12A!J30,'FA12(1of2)'!L40)","v":0}]
[null,"COST APPROACH",null,null,null,null,"(Value Indication)",null,null,null,null,{"$f":"'FA11'!K59","v":0}]
[]
[null,"Reconciliation/Remarks: (If an approach is included in the scope, it is to be included in the report, unless a change in scope has been approved.  If an approach is at the discretion of the appraiser and is not considered applicable, the appraiser shall state why.)"]
[]
[]
[]
[]
[]
[]
[]
[null,"BEFORE VALUE CONCLUSION:",null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,"(Complete the following if ONLY if there is no remainder; i.e. a Total Taking)"]
[]
[null,"Value of the Acquisition"]
[]
[]
[null,"Fair Market Value Before the Acquisition",null,null,null,null,null,null,null,null,null,{"$f":"L17","v":0}]
[null,"Fair Market Value After the Acquisition",null,null,null,null,null,null,null,null,null,0]
[null,"Fair Market Value of the Acquisition",null,null,null,null,null,null,null,null,null,{"$f":"L25-L26","v":0}]
[]
[]
[null,"Breakdown of the Acquisition:"]
[null,"Land:",null,null,null,null,null,null,null,null,null,0]
[null,"Improvements:",null,null,null,null,null,null,null,null,null,0]
[null,"Specialty Items:",null,null,null,null,null,null,null,null,null,0]
[]
[null,"Additional Comments",null,null,null,null,null,null,null,null,"Total. Ck",{"$f":"SUM(L31:L33)","v":0}]

{"sheet":"FA15","index":22,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[2,1,7,11],[58,1,60,11],[20,1,22,11],[24,1,26,11],[28,1,30,11],[32,1,34,11],[36,1,38,11],[50,1,52,11],[49,6,49,8],[53,6,53,8],[57,5,57,8],[54,1,56,11],[9,1,11,11],[12,1,16,11],[42,1,44,11],[46,1,48,11],[19,6,19,8],[23,6,23,8],[27,6,27,8],[31,6,31,8],[35,5,35,8],[41,6,41,8],[45,6,45,8],[39,1,40,11]]}
[null,"DESCRIPTION & HIGHEST AND BEST USE",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-15: (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,"Note; this is a separate appraisal analysis from the Before based on the Hypothetical Condition that the project is complete and in place.  This is an important concept to remember; the Remainder is to be analyzed based on its marketability to a typical buyer, not  based on what is taken from the current owner.  A partial taking appraisal is not an appraisal of the part taken; it is two appraisals with the difference between two analyses being the compensation for the part taken.  Proper methodology is to analyze the After without recognition of what was Before and the appraiser then identifies the components of the value difference between the Before and After. "]
[]
[]
[]
[]
[]
[null,"Description of the Property After the Project:",null,null,null,null,"(Physical & Location Characteristics)"]
[]
[]
[]
[null,"Highest and Best Use of the Property After the Project: (More than a statement of the appraiser’s opinion: Considering supply & demand factors; describe in the depth and detail required by its significance to the appraisal assignment.  The conclusion(s) should address the use, the timing of the use and the most likely user(s).  The appropriate handling of the Principle of Consistent Use is of paramount importance).  Additional pages may be attached as necessary."]
[]
[]
[]
[]
[]
[null,"As (As If) Vacant (If it differs from the present use/zoning, address the timing of the change in use.)"]
[null,null,null,null,null,null,"Physically Possible"]
[]
[]
[]
[null,null,null,null,null,null,"Legally Permissible"]
[]
[]
[]
[null,null,null,null,null,null,"Financially Feasible"]
[]
[]
[]
[null,null,null,null,null,null,"Maximally Productive"]
[]
[]
[]
[null,null,null,null,null,"Reasonably Probable Conclusion"]
[]
[]
[]
[null,"As Improved - If Applicable (If present improvments are not consistent with the HBU conclusion, the principle of consistent use has to be part of the analysis.)"]
[]
[null,null,null,null,null,null,"Physically Possible"]
[]
[]
[]
[null,null,null,null,null,null,"Legally Permissible"]
[]
[]
[]
[null,null,null,null,null,null,"Financially Feasible"]
[]
[]
[]
[null,null,null,null,null,null,"Maximally Productive"]
[]
[]
[]
[null,null,null,null,null,"Reasonably Probable Conclusion"]

{"sheet":"FA16","index":23,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[18,4,18,5],[19,4,19,5],[28,4,30,11],[31,1,33,3],[34,1,36,3],[34,4,36,11],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[31,4,33,11],[9,1,9,5],[11,2,11,5],[20,4,20,5],[21,1,21,5],[28,1,30,3],[37,1,39,3],[37,4,39,11],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[49,1,50,3],[49,4,50,11],[51,1,52,3],[51,4,52,11],[46,4,48,11],[53,1,54,3],[53,4,54,11],[55,0,55,3],[55,4,57,11],[58,10,58,11]]}
[null,"LAND SALES APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-16: (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (Acres)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER AC",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},"0","0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject Ac.s)",{"$f":"Inputs!$C$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Topography:"]
[]
[]
[null,"Shape:"]
[]
[]
[null,"Utility:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"After Land Value Conclusion:",null,null,null,null,{"$f":"Inputs!$C$29","v":0},"Ac  @     $",0,"Per Acre=",{"$f":"G59*I59","v":0}]

{"sheet":"FA16Par2","index":24,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[18,4,18,5],[19,4,19,5],[28,4,30,11],[46,4,48,11],[34,4,36,11],[37,4,39,11],[60,4,60,6],[31,4,33,11],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[49,1,50,3],[49,4,50,11],[51,1,52,3],[51,4,52,11],[53,1,54,3],[53,4,54,11],[55,0,55,3],[55,4,57,11],[58,10,58,11],[0,1,0,6],[1,1,1,6],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[11,2,11,5],[20,4,20,5],[21,1,21,5],[28,1,30,3],[31,1,33,3],[34,1,36,3],[37,1,39,3]]}
[null,"LAND SALES APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-16: (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (Acres)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER AC",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},"0","0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject Ac.s)",{"$f":"Inputs!$C$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Topography:"]
[]
[]
[null,"Shape:"]
[]
[]
[null,"Utility:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"After Land Value Conclusion:",null,null,null,null,{"$f":"Inputs!$C$29","v":0},"Ac  @     $",0,"Per Acre=",{"$f":"G59*I59","v":0}]

{"sheet":"FA16Par3","index":25,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[11,2,11,5],[20,4,20,5],[21,1,21,5],[18,4,18,5],[19,4,19,5],[28,1,30,3],[31,1,33,3],[34,1,36,3],[34,4,36,11],[37,1,39,3],[37,4,39,11],[31,4,33,11],[28,4,30,11],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[46,4,48,11],[55,0,55,3],[55,4,57,11],[58,10,58,11],[49,1,50,3],[49,4,50,11],[51,1,52,3],[51,4,52,11],[53,1,54,3],[53,4,54,11]]}
[null,"LAND SALES APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-16: (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (Acres)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER AC",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},"0","0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject Ac.s)",{"$f":"Inputs!$C$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Topography:"]
[]
[]
[null,"Shape:"]
[]
[]
[null,"Utility:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"After Land Value Conclusion:",null,null,null,null,{"$f":"Inputs!$C$29","v":0},"Ac  @     $",0,"Per Acre=",{"$f":"G59*I59","v":0}]

{"sheet":"FA17","index":26,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[34,1,36,3],[34,4,36,11],[37,1,39,3],[37,4,39,11],[20,4,20,5],[21,1,21,5],[28,1,30,3],[28,4,30,11],[31,1,33,3],[31,4,33,11],[0,1,0,6],[1,1,1,6],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[11,2,11,5],[18,4,18,5],[19,4,19,5],[40,1,42,3],[40,4,42,11],[43,1,45,3],[43,4,45,11],[46,1,48,3],[46,4,48,11],[55,0,55,3],[55,4,57,11],[58,10,58,11],[49,1,50,3],[49,4,50,11],[51,1,52,3],[51,4,52,11],[53,1,54,3],[53,4,54,11]]}
[null,"IMPROVED MARKET APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-17: (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"COMPARABLE SALES",null,null,null,"#"]
[null,null,null,null,null,"Date of Sale"]
[null,"SALE PRICE",null,null,null,null,0,0,0,0,0,0]
[null,"PROPERTY RIGHTS CONVEYED",null,null,null,null,0,0,0,0,0,0]
[null,"A-Typical Financing Terms",null,null,null,null,0,0,0,0,0,0]
[null,"Special Conditions of Sale",null,null,null,null,0,0,0,0,0,0]
[null,"Market Conditions",null,null,null,null,0,0,0,0,0,0]
[null,"ADJUSTED SALES PRICE",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0]
[null,null,"Size of Sale (SF)",null,null,null,0,0,0,0,0,0]
[null,"SALE PRICE PER SF",null,null,null,null,{"$f":"IF(G11,G11/G12,\"0\")","v":"0"},{"$f":"IF(H11,H11/H12,\"0\")","v":"0"},"0","0","0","0"]
[null,null,"Adjustments:",null,null,"Location",0,0,0,0,0,0]
[null,null,null,null,null,"Topography",0,0,0,0,0,0]
[null,null,null,null,null,"Shape",0,0,0,0,0,0]
[null,null,null,null,null,"Utility",0,0,0,0,0,0]
[null,null,null,"(Subject SF)",{"$f":"Inputs!$K$29","v":0},"Size",0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,null,"Other-",null,null,null,0,0,0,0,0,0]
[null,"Net Adjustment",null,null,null,null,{"$f":"SUM(G14:G21)","v":0},0,0,0,0,0]
[]
[null,"ADJ PER ACRE VALUE",null,null,null,null,{"$f":"G13+(G13*G22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,"(The adjustments to the sales price in the upper part of the grid have to be entered as dollar amounts."]
[null,"Enter the adjustments to the unit prices in percentages; to enter a minus adjustment enter a minus sign first.) "]
[]
[null,null,null,null,null,null,null,"EXPLANATION OF ADJUSTMENTS"]
[null,"Conditions of Sale:"]
[]
[]
[null,"Market Conditions:"]
[]
[]
[null,"Location:"]
[]
[]
[null,"Age:"]
[]
[]
[null,"Quality/ Condition:"]
[]
[]
[null,"Size:"]
[]
[]
[null,"Other:"]
[]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
[null,"Other:"]
[]
["Correlation:"]
[]
[]
[null,"After  Value Conclusion:",null,null,null,null,{"$f":"Inputs!$K$29","v":0},"SF  @     $",0,"Per SF =",{"$f":"G59*I59","v":0}]

{"sheet":"FA18(1of2)","index":27,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[2,0,2,11],[24,4,24,5],[25,4,25,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[22,4,22,5],[20,4,20,5],[21,4,21,5],[4,7,4,8],[6,0,6,1],[6,3,6,10],[14,4,14,5],[23,4,23,5],[31,4,31,5],[32,4,32,5],[47,10,47,11],[54,10,54,11],[26,4,26,5],[27,4,27,5],[28,4,28,5]]}
[null,"INCOME APPROACH",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-18 (1 of 2): (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
["Direct Capitalization Method"]
[]
[null,null,"Economic Rent/Mo.",0,null,null,"Actual Rent/Mo.",0,null,null,"Annual Rent",{"$f":"D5*12","v":0}]
[]
["Structure #",null,0,"Market Rent",null,null,null,null,null,null,null,{"$f":"L5","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Expense Reimbursements",0]
[null,null,null,null,null,null,null,null,null,null,"Potential Gross Income (PGI)",{"$f":"SUM(L7:L9)","v":0}]
[null,null,null,null,null,null,null,null,"Vacancy and Collection Loss",10,"%    V & CL",{"$f":"(L10*J11)/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Effective Gross Income (EGI)",{"$f":"L10-L11","v":0}]
[null,null,null,null,null,null,"(Note; Expenses can be entered, in the gray areas, as either a % or as a $ amount)"]
[null,null,"Fixed Expenses:",null,null,"Based on %","%EGI",null,"Based on $","%EGI"]
[null,null,null,"Management",{"$f":"$L$12*G15","v":0},null,0,null,0,{"$f":"IF($L$12,I15/$L$12,\" \")","v":" "}]
[null,null,null,"Insurance",{"$f":"$L$12*G16","v":0},null,0,"OR",0,{"$f":"IF($L$12,I16/$L$12,\" \")","v":" "}]
[null,null,null,"Property Taxes",{"$f":"$L$12*G17","v":0},null,0,null,0,{"$f":"IF($L$12,I17/$L$12,\" \")","v":" "}]
[null,null,null,"Total Fixed Expenses",{"$f":"SUM(E15:E17)","v":0},null,null,"+",{"$f":"SUM(I15:I17)","v":0},"=",null,{"$f":"E18+I18","v":0}]
[]
[null,null,"Variable Expenses:",null,null,"Based on %","%EGI",null,"Based on $","%EGI"]
[null,null,null,"Utilities-Electric",{"$f":"$L$12*G21","v":0},null,0,null,0,{"$f":"IF($L$12,I21/$L$12,\" \")","v":" "}]
[null,null,null,"-Water",0,null,0,"OR",0," "]
[null,null,null,"-Gas",0,null,0,null,0," "]
[null,null,null,"-Other",0,null,0,null,0," "]
[null,null,null,"Repairs & Maintenance",0,null,0,null,0," "]
[null,null,null,null,0,null,0,"OR",0," "]
[null,null,null,null,0,null,0,null,0," "]
[null,null,null,null,0,null,0,null,0," "]
[null,null,null,"Total Variable Expenses",{"$f":"SUM(E21:E28)","v":0},null,null,"+",{"$f":"SUM(I21:I28)","v":0},"=",null,{"$f":"E29+I29","v":0}]
[]
[null,null,null,null,null,"Based on %","%EGI",null,"Based on $","%EGI"]
[null,null,null,"Reserves for Replacement",{"$f":"$L$12*G32","v":0},null,0,"OR",0,{"$f":"IF($L$12,I32/$L$12,\" \")","v":" "}]
[null,null,null,"Total Reserves",{"$f":"SUM(E25:E32)","v":0},null,null,"+",{"$f":"SUM(I25:I32)","v":0},"=",null,{"$f":"E33+I33","v":0}]
["Exp.%"]
[{"$f":"L35/L12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Total Expenses (EXP)",{"$f":"L18+L29+L33","v":0}]
[null,null,null,null,null,null,null,"Net Operating Income",null,null," (NOI)",{"$f":"L12-L35","v":0}]
[null,null,null,null,null,"(Market-derived rate should be entered here)→",null,null,"Capitalization Rate:",0.1,"(Ro)"]
[null,null,null,null,null,null,null,"Direct Cap. Conclusion",null,null,"(NOI/Ro)",{"$f":"L36/J37","v":0}]
[null,null,null,null,null,null,null,null,null,"Excess Land and/or Other Improvments (if Other  improvements contribute value)",null,0]
[null,null,null,null,null,null,null,null,null,"Concluded Value",null,{"$f":"SUM(L38:L39)","v":0}]
[]
[]
[null,null,null,null,null,null,"Discounted Cash Flow (DCF) Analysis Method"]
["This income method can be applicable when a long-term lease is in place or where the property has multiple tenants with different terms,"]
["etc.  The analysis involves a set of income streams, a reversion (net resale price) at the end of the investment holding period, a yeile rate"]
["rate and a terminal cap rate.  Reasonable market oriented forecasting is crucial to reliable results using this methodology.  If computer "]
["software developed to produce DCF (such as Argus) is used, all input assumptions/printouts shall be included as Addendum support."]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Subdivision (Sellout) Analysis Method"]
["This income method can be applicable when the sellout of multiple parcels is required over time.  This is also a discounted cash flow "]
["analysis and key aspects of this include an absorption rate, projecting gross income and expenses when they are expected to occur "]
["with the net sales income discounted to a present value indication for the land.  All supporting data as well as the analysis itself shall "]
["be presented either in the body of the report or in the Addenda"]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"FA18(2of2)","index":28,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[33,1,47,11],[50,1,58,11],[0,1,0,3],[1,1,1,3],[4,1,16,11],[17,1,17,11],[19,1,30,11]]}
[null,"INCOME APPROACH SUPPORT",null,null,null,null,"Project No.:",{"$f":"Inputs!D10","v":0},null,null,null,"FA-18 (2 of 2): (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,"Tract No.:",{"$f":"Inputs!D11","v":0}]
[]
[null,"Explanation of Difference between Economic (Market) Rent and Actual (Contract) Rent:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Support Data (Attach Market Comparable Data as Needed or Include in Master File)"]
[null,"Expenses Support:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate(s) Support:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other comments about the Income Approach:"]

{"sheet":"FA18A","index":29,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[7,0,7,9],[21,0,25,9],[27,2,27,3],[28,2,28,3],[32,0,36,9],[0,0,0,3],[1,0,1,3],[2,0,2,9],[4,0,4,9],[6,0,6,9],[38,0,38,9],[40,0,40,9],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[50,0,54,9]]}
["INCOME APPROACH (RESIDENTIAL)",null,null,null,null,"Project No.:",{"$f":"Inputs!D10","v":0},null,null,"FA-18A: (Rev. 10/20)"]
["AFTER",null,null,null,null,"Tract No.:",{"$f":"Inputs!D11","v":0}]
["(Appraiser can select preferred method below.)"]
[]
["Rent Multiplier Method (1)"]
[null,null,null,null,null,"(Note: may also be calculated on annual rents [GRM] if local market dictates)"]
["GRMM Method (Subject Gross Monthly Income x GRMM Multiple - "]
["derived from market sales tabulated/correlated below and details included in the Report or Master File"]
[]
[null,null,null,null,null,"Market Support"]
[null,null,"Sale#","Sales Price","÷","Rent (Mth/Ann)","=","Multiplier"]
[null,null,null,0,"÷",0,"=",{"$f":"IF(D12,D12/F12,\" \")","v":" "}]
[null,null,null,0,"÷",0,"=",{"$f":"IF(D13,D13/F13,\" \")","v":" "}]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[null,null,null,0,"÷",0,"="," "]
[]
[null,null,"Subject Market Rent",null,null,{"$f":"'FA9'!J8","v":0},"(aka Economic Rent)"]
["Correlation Comments:"]
[]
[]
[]
[]
[]
[]
[null,"Gross Monthly Income",null,null,"x",null,"GRMM","=GRMM Concluded Value",null,{"$f":"IF(C28,C28*F28,\"\")","v":""}]
[null,"Gross Annual Income",null,null,"x",null,"GRM","=GRM Concluded Value",null,{"$f":"IF(C29,C29*F29,\"\")","v":""}]
[null,null,null,null,null,null,null,"Market Value Conclusion"]
[]
["Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Rent Multiplier Method (2)"]
["Commercial",null,"Sale-1",null,"Sale -2",null,"Sale - 3",null,"Sale - 4"]
["Sales Price $",null,0,null,0,null,0,null,0]
["Gross Ann. Rent $",null,0,null,0,null,0,null,0]
["Sale's GRM",null,{"$f":"IF(C43,C43/C44,\"\")","v":""},null,{"$f":"IF(E43,E43/E44,\"\")","v":""},null,{"$f":"IF(G43,G43/G44,\"\")","v":""},null,{"$f":"IF(I43,I43/I44,\"\")","v":""}]
["Subj.'s Eco Rent $",null,{"$f":"'FA10'!$K$8","v":0}]
["Indicated Value $",null,{"$f":"IF(C43,C45*$C$46,\"\")","v":""},null,{"$f":"IF(E43,E45*$C$46,\"\")","v":""},null,{"$f":"IF(G43,G45*$C$46,\"\")","v":""},null,{"$f":"IF(I43,I45*$C$46,\"\")","v":""}]
[null,null,null,null,null,null,null,"Market Value Conclusion"]
[]
["Correlation Comments:"]

{"sheet":"FA19(1of2)","index":30,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[35,9,35,10],[40,2,40,8],[10,2,10,4],[46,2,46,8],[41,2,41,8],[42,2,42,8],[43,2,43,8],[44,2,44,8],[45,2,45,8],[37,9,37,10],[47,2,47,8],[56,2,59,11],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[0,1,0,5],[1,1,1,5],[5,3,5,4]]}
[null,"COST APPROACH",null,null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,"FA-19 (1 of 2):  (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[null,null,null,null,null,null,null,"IMPORTANT NOTE; THE HIGHLIGHTED PARTS OF PAGE 2of2 NEEDS TO BE COMPLETED FIRST"]
[null,null,null,null,null,null,null,"FOR THE FORMULAS ON THIS PAGE TO AUTOMATICALLY CALCULATE THE AMOUNTS"]
[null,"#",null,null,null,null,null,"Replacement Cost New Method"]
[null,1,"Main Bldg.:",null,null,null,"SF @",{"$f":"'FA13(2of2)'!L8","v":0},"Per","SF","=",{"$f":"F6*H6","v":0}]
[null,2,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L10","v":0},"Per","SF","=",0]
[null,3,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L12","v":0},"Per","SF","=",{"$f":"F8*H8","v":0}]
[null,4,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L14","v":0},"Per","SF","=",0]
[null,5,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L16","v":0},"Per","SF","=",0]
[null,6,null,null,null,null,"SF @",{"$f":"'FA13(2of2)'!L18","v":0},"Per","SF","=",0]
[null,7,null,null,null,null,null,{"$f":"'FA13(2of2)'!L20","v":0},"Per",null,"=",0]
[null,8,null,null,null,null,null,{"$f":"'FA13(2of2)'!L22","v":0},"Per",null,"=",0]
[null,9,null,null,null,null,null,{"$f":"'FA13(2of2)'!L24","v":0},"Per",null,"=",0]
[null,10,null,null,null,null,null,{"$f":"'FA13(2of2)'!L26","v":0},"Per",null,"=",0]
[null,null,null,null,null,null,null,null,null,"R.C.N. TOTAL","=",{"$f":"SUM(L6:L15)","v":0}]
[null,null,null,null,null,"Depreciation",null,null,"% of RCN",null,"$"]
[null,null,null,null,null,null,null,"Physical Curable:"," ",null,0]
[null,null,null,null,null,null,null,"Physical Incurable:",null,null,0]
[null,null,null,null,null,null,null,"Functional Curable:",null,null,0]
[null,null,null,null,null,null,null,"Functional Incurable:",null,null,0]
[null,null,null,null,null,null,null,"Economic Obsolescence:",null,null,0]
[null,null,null,null,null,null,null,"Accrued Depreciation (Total)",{"$f":"IF(L23 >0, (L23/L16),0)","v":0},null,null,{"$f":"SUM(K18:K22)","v":0}]
[]
[null,null,"Depreciated Building(s) Cost",null,null,null,null,null,null,null,null,{"$f":"L16-L23","v":0}]
[]
[null,null,"Appurtenances To Above Structure(s)",null,null,null,null,null,"Units","Cost New","% Deprec.","Deprec. Cost"]
[null,null,"Walks & Drives:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L28*I28","v":0},null,{"$f":"((J28-(J28*K28)))","v":0}]
[null,null,"Fencing:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L30*I29","v":0},null,0]
[null,null,"Landscaping:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L32*I30","v":0},null,0]
[null,null,"Water Well:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L34*I31","v":0},null,0]
[null,null,"Septic System:",null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L36","v":0},null,0]
[null,null,"Other:",null,null,null,null,null,null,0,null,0]
[null,null,"Other:",null,null,null,null,null,null,0,null,0]
[null,null,"Other:",null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,"Total Deprec. Costs of Appurtenant Improvements:",{"$f":"SUM(L28:L35)","v":0}]
[]
[null,null,"Depreciated Cost of Structure(s) & Appurtenances",null,null,null,null,null,null,{"$f":"L25+J36","v":0}]
[null,null,null,null,"Other Improvements"]
[null,null,"Description",null,null,null,null,null,null,"Cost New","% Deprec.","Deprec. Cost"]
[null,"A",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L43","v":0},null,{"$f":"((J41-(J41*K41)))","v":0}]
[null,"B",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L44","v":0},null,0]
[null,"C",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L45","v":0},null,0]
[null,"D",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L46","v":0},null,0]
[null,"E",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L47","v":0},null,0]
[null,"F",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L48","v":0},null,0]
[null,"G",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L49","v":0},null,0]
[null,"H",null,null,null,null,null,null,null,{"$f":"'FA13(2of2)'!L50","v":0},null,0]
[null,null,"Total Depreciated Cost of All Improvements",null,null,null,null,null,null,null,null,{"$f":"L25+SUM(L28:L35)+SUM(L41:L48)","v":0}]
[null,null,"Concluded Land Value (from FA-8)",null,null,null,null,null,null,null,null,{"$f":"'FA8'!$K$59+FA8Par2!$K$60+FA8Par3!$K$60","v":0}]
[null,null,"APPRAISER'S COST APPROACH VALUE CONCLUSION:",null,null,null,null,null,null,null,null,{"$f":"L49+L50","v":0}]
[null,null,null,null,null,null,null,"COST SOURCES"]
[null,null,"Note:  If the Cost Approach is not relied on or not given more emphasis than the Improved Market Approach or Income Approach,"]
[null,null," provide a general and brief summary of the source(s) below.  If the Cost Approach is relied on, or given more emphasis, or used "]
[null,null,"to arrive at adjustments in the Improved Market Approach or Income Approach; complete the detailed Cost Source Form  "]
[null,null,"FA-13A, which includes market extracted depreciation support, and include it in the report."]

{"sheet":"FA19(2of2)","index":31,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,1,7,6],[8,1,9,6],[10,1,11,6],[12,1,13,6],[14,1,15,6],[26,1,27,6],[45,1,45,9],[46,1,46,9],[47,1,47,9],[42,1,42,9],[43,1,43,9],[44,1,44,9],[0,5,0,7],[1,0,1,3],[1,5,1,7],[2,0,2,10],[3,0,3,10],[0,0,0,3],[4,0,4,10],[40,1,41,6],[48,1,48,9],[49,1,49,9],[51,0,60,10],[28,1,29,6],[30,1,31,6],[32,1,33,6],[34,1,35,6],[36,1,37,6],[38,1,39,6],[16,1,17,6],[18,1,19,6],[20,1,21,6],[22,1,23,6],[24,1,25,6]]}
["COST APPROACH",null,null,null,"Project No.:",{"$f":"Inputs!B10","v":"Project Number"},null,null,null,null,"FA-19 (2 of 2):  (Rev. 10/20)"]
["AFTER",null,null,null,"Tract No.:",{"$f":"Inputs!B11","v":"Tract Number"}]
["COSTS SOURCES"]
["Note: Provide the complete reference; if Marshall and Swift is used, provide the Section, page, description, multipliers,"]
["etc.; if local or other source, provide a contact number or other way reviewer can verify the information."]
["#",null,null,null,null,null,null,"Sub. Ttl.","CCM","LCM","Adj. Cost"]
[1]
[null,null,null,null,null,null,null,0,0,0,{"$f":"H8*I8*J8","v":0}]
[2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H10*I10*J10","v":0}]
[3]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H12*I12*J12","v":0}]
[4]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H14*I14*J14","v":0}]
[5]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H16*I16*J16","v":0}]
[6]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H18*I18*J18","v":0}]
[7]
[]
[8]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H22*I22*J22","v":0}]
[9]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H24*I24*J24","v":0}]
[10]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H26*I26*J26","v":0}]
["Walks & "]
["Drives:",null,null,null,null,null,null,null,null,null,{"$f":"H28*I28*J28","v":0}]
["Fencing:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H30*I30*J30","v":0}]
["Land-"]
["scaping:",null,null,null,null,null,null,null,null,null,{"$f":"H32*I32*J32","v":0}]
["Water "]
["Well:",null,null,null,null,null,null,null,null,null,{"$f":"H34*I34*J34","v":0}]
["Septic "]
["System:",null,null,null,null,null,null,null,null,null,{"$f":"H36*I36*J36","v":0}]
["Other:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H38*I38*J38","v":0}]
["Other:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H40*I40*J40","v":0}]
["Other:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H42*I42*J42","v":0}]
["A",null,null,null,null,null,null,null,null,null,0]
["B",null,null,null,null,null,null,null,null,null,0]
["C",null,null,null,null,null,null,null,null,null,0]
["D",null,null,null,null,null,null,null,null,null,0]
["E",null,null,null,null,null,null,null,null,null,0]
["F",null,null,null,null,null,null,null,null,null,0]
["G",null,null,null,null,null,null,null,null,null,0]
["H",null,null,null,null,null,null,null,null,null,0]
["Explanation & Support for Depreciation:"]

{"sheet":"FA20(1of2)","index":32,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[7,1,9,11],[59,3,59,5],[57,1,58,11],[10,1,13,11],[18,1,39,11]]}
[null,"CORRELATION OF VALUES",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-20 (1of2): (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[null,"MARKET APPROACH",null,null,null,null,"(Value Indication)",null,null,null,null,{"$f":"'FA13(1of2)'!L51","v":0}]
[null,"INCOME APPROACH",null,null,null,null,"(Value Indication)",null,null,null,null,{"$f":"IF('FA12(1of2)'!L40=0,FA12A!J30,'FA12(1of2)'!L40)","v":0}]
[null,"COST APPROACH",null,null,null,null,"(Value Indication)",null,null,null,null,{"$f":"'FA11'!K59","v":0}]
[]
[null,"Remarks/Correlation of Value: (If an approach is included in the scope, it is to be included in the report, unless improvements are acquired eliminating the need for the approach.)"]
[]
[]
[]
[]
[]
[]
[]
[null,"PRELIMINARY AFTER VALUE CONCLUSION:",null,null,null,null,null,null,null,null,null,0]
[]
[null,"Cost-to-Cure Damages"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PRELIMINARY AFTER VALUE CONCLUSION:",null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,"Value of Temporary Easement(s) (When there is a Before and After, use the After Value)"]
[null,"Annual Rent/Ac.",null,0,null,null,"Number of years for TCE",null,"@",null,null,"% per year"]
[]
[null,"Size of Easement(s)",null,{"$f":"Inputs!E30","v":0},null,null,"PVIF",null,null,null,"Value of Easement(s)",0]
[null,null,null,null,null,null,"(To get PVIF using the HP-12C, enter g-Beg, 1 CHS PMT, (selected rate)-¡, (# years)-n, Solve-pv)"]
[null,null,null,null,null,null,"Using this formula, with a 3 year TCE, 10% interest and $1 payment the calculated PVIF is 2.7355 which is then x's Ann. Rent x's Size of Esmnt=Value"]
[]
[]
[]
[]
[null,"FINAL AFTER VALUE CONCLUSION(Preliminary Less TCE):",null,null,null,null,null,null,null,null,null,{"$f":"L43-L49","v":0}]

{"sheet":"FA20(2of2)","index":33,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[13,3,14,9],[15,3,16,9],[34,1,48,11],[17,3,18,9],[19,3,21,9],[22,3,23,9],[24,3,26,9],[27,3,28,9],[33,1,33,6]]}
[null,"CORRELATION OF VALUES",null,null,null,null,"Project No.:",{"$f":"Inputs!C10","v":0},null,null,null,"FA-20(2of2): (Rev. 10/20)"]
[null,"AFTER",null,null,null,null,"Tract No.:",{"$f":"Inputs!C11","v":0}]
[]
[]
[null,"VALUE FOR ACQUISITION"]
[null,"Fair Market Value Before the Acquisition",null,null,null,null,null,null,null,null,null,{"$f":"'FA14'!L17","v":0}]
[]
[null,"Fair Market Value After the Acquisition",null,null,null,null,null,null,null,null,null,{"$f":"'FA20(1of2)'!L56","v":0}]
[]
[null,"Fair Market Value of the Acquisition",null,null,null,null,null,null,null,null,null,{"$f":"L6-L8","v":0}]
[]
[]
[null,null,null,null,null,"Breakdown of the Acquisition:"]
[null,"Land:"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Ttl. Permanent "]
[null,"Esmnt(s):",{"$f":"Inputs!C30","v":0},null,null,null,null,null,null,null,null,{"$f":"'FA16'!K56","v":0}]
[null,"Ttl. Temp. Const."]
[null,"Esmnt(s):",{"$f":"Inputs!E30","v":0},null,null,null,null,null,null,null,null,{"$f":"'FA20(1of2)'!L49","v":0}]
[null,"Improvements:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Specialty Items:"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Damages:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Less Enhancement(s):"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Ttl Check",null,null,{"$f":"L15+L17+L19+L22+L24+L27+L29","v":0}]
[]
[]
[null,"EFFECT OF THE ACQUISITION: (Describe all factors impacting on marketability which are considered to be"]
[null,"attributable to the acquisition."]

{"sheet":"FA21","index":34,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[59,2,59,4],[52,0,52,1],[55,8,55,9],[49,0,49,3],[0,0,0,5],[1,0,1,5],[57,8,57,9],[56,8,56,9],[54,8,54,9]]}
["CERTIFICATE OF",null,null,null,null,null,"Project No.:",{"$f":"Inputs!B10","v":"Project Number"},null,null,"FA-21: (Rev. 10/20)"]
["REAL PROPERTY APPRAISER",null,null,null,null,null,"Tract No.:",{"$f":"Inputs!B11","v":"Tract Number"}]
[]
["State of Alabama",null,null,null,null,null,null,null,"County Of:",{"$f":"Inputs!$C$12","v":0}]
[null,"I hereby certify:"]
[" •To the best of my knowledge and belief, the statements of fact contained in this appraisal are true and correct."]
[]
["•The reported analyses, opinions and conclusions are limited only by the reported assumptions, limiting"]
["   conditions & legal instructions; & are my personal, unbiased professional analysis, opinions and conclusions."]
[]
["•I understand my appraisal may be used in connection with the acquisition of right-of-way for a project to be"]
[" constructed by the State of Alabama with the assistance of Federal-aid highway funds or other Federal funds."]
[]
["•The appraisal and the report to which this certification is attached has been prepared in conformity with;"]
[" -the appropriate State laws, regulations, policies and procedures applicable to the appraisal of right-of-way"]
[" -the appropriate and applicable Federal laws, regulations, policies and procedures including the Uniform Standards for "]
["  Professional Appraisal Practice (USPAP) (with Jurisdictional Exceptions noted in the Scope of Work Section of the report)."]
[]
["• To the best of my knowledge, no portion of the value assigned to the appraised property is for non-"]
["   compensable items under the established law of the State of Alabama:"]
[]
["•Neither my employment nor compensation for this appraisal is in any way contingent on the value(s) reported."]
[]
["•I have no direct or indirect, present or contemplated future personal interest in the property appraised nor in any "]
["  benefit from the partial or whole acquisition of the property appraised."]
[]
["•I have performed no (or specified) other services, as an appraiser or in any other capacity, regarding the property"]
["  that is the subject of this report within the 3-years immediately preceding acceptance of this assignment."]
[]
["•I have not revealed the findings and results of this appraisal to anyone other than the proper officials of the "]
["  acquiring agency of Alabama or officials of the Federal Highway Administration and I will not do so until so  "]
["  authorized by said officials; or until I am required to do so by due process of law; or until I am released from this "]
["  obligation by having publically testified as to such findings."]
[]
["•I have personally inspected the appraised property and that I have also made a personal field inspection of the"]
["  comparable sales relied on in the appraisal of the subject property.  The subject and comparable sales relied on "]
["  in this appraisal are as represented in this report or the master file and/or supplemental report.  "]
[]
["•The owner or their representative was given the opportunity to accompany me (the signor of this certification)"]
["  during my inspection of the subject property of the appraisal report to which this certification is attached.  "]
["  the public improvement for which the property is acquired or caused by the likelihood that the property would"]
[" be acquired other than a decrease due to physical deterioration within reasonable control of the owner, was"]
["disregarded in determining the compensation for the property acquired."]
[]
["•In compliance with Alabama Code, Sec.34-27A-3 (applicable for Certified Appraisers): This assignment was made "]
["  subject to regulations of the Alabama Real Estate Appraisers Board.  The undersigned state licensed real estate "]
["   appraiser has met the requirements of the board that allow this report to be regarded as a ‘certified appraisal’."]
[]
["•No one provided significant professional assistance unless  named below and their qualifications are included."]
[]
[]
["•My opinion of the fair market value, just compensation, for the acquisition as of ",null,null,null,null,null,null,null,null,{"$f":"Inputs!$E$19","v":"00:00:00"},"is"]
[{"$f":"'FA20(1of2)'!$L$56","v":0},null,null,"based on my independent appraisal and the exercise of my professional judgment."]
[]
[null,null,null,null,null,null,"Signature"]
[null,null,null,null,"Date",null,"Name in Print",null,{"$f":"Inputs!$C$4","v":0}]
[null,null,null,null,null,null,"State Certified",null,"Alabama"]
[null,null,null,null,null,null,"Alabama License Number",null,{"$f":"Inputs!$G$4","v":0}]

{"sheet":"FA22","index":35,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,2,47,9],[41,2,41,9],[42,2,42,9],[43,2,43,9],[44,2,44,9],[45,2,45,9],[46,2,46,9],[0,0,0,4],[1,0,1,4],[0,5,0,6],[1,5,1,6],[40,2,40,9],[38,2,38,9],[39,2,39,9]]}
["Adenda",null,null,null,null,"Project No.:",null,{"$f":"Inputs!B10","v":"Project Number"},null,null,"FA-22: (Rev. 10/20)"]
[null,null,null,null,null,"Tract No.:",null,{"$f":"Inputs!B11","v":"Tract Number"}]
[]
[]
[]
[]
[null,null,null,null,null,"ADDENDA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Attachments (R= Required):"]
[null,"R","Photographs of Subject, Area To Be Acquired, & Location, Form FA-22A"]
[null,"R","Photographs of Improvements (Exterior & Interior), Form FA-22B"]
[null,"R","Improvement Sketch, Form FA-22C"]
[null,"R","Total Property Sketch/Plat, Form FA-22D (*)"]
[null,"R","Comparable Sales (Attached or in a Master File)"]
[null,"R","Sales (& Subject) Location Map(s)"]
[null,"R","Rent Comparables and Location Map"]
[null,"R","Income and Expense Comparables"]
[null,"R","State Certification License  (Attached or in a Master File)"]
[null,"R","Qualifications of Appraiser  (Attached or in a Master File)"]
[null,null,"General Assumptions & Limiting Conditions (Note; any areas of conflict with ALDOT, State, "]
[null,null,"and/or Federal Regulations/guidelines are notwithstanding and have no force and affect)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"* To be furnished by the State"]

{"sheet":"FA22A","index":36,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[60,3,60,4],[60,14,60,15],[57,4,57,7],[58,5,58,10],[19,15,19,18],[20,16,20,21],[38,15,38,18],[39,16,39,21],[57,15,57,18],[58,16,58,21],[21,13,37,21],[40,13,56,21],[21,2,37,10],[40,2,56,10],[19,4,19,7],[20,5,20,10],[38,4,38,7],[39,5,39,10],[0,1,0,5],[0,6,0,7],[1,1,1,5],[1,6,1,7],[2,13,18,21],[0,12,0,16],[0,17,0,18],[1,12,1,16],[1,17,1,18],[2,2,18,10]]}
[null,"PHOTOGRAPHS OF",null,null,null,null,"Project No.:",null,{"$f":"Inputs!$B$10","v":"Project Number"},null,null,"FA-22A: (Rev. 10/20)","PHOTOGRAPHS OF",null,null,null,null,"Project No.:",null,{"$f":"Inputs!$B$10","v":"Project Number"},null,null,"FA-22A: (Rev. 10/20)"]
[null,"SUBJECT",null,null,null,null,"Tract No.:",null,{"$f":"Inputs!$B$11","v":"Tract Number"},null,null,null,"SUBJECT",null,null,null,null,"Tract No.:",null,{"$f":"Inputs!$B$11","v":"Tract Number"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Photographer:",null,null,null,null,null,"Photograph Date:",null,null,null,null,"Photographer:",null,null,null,null,null,"Photograph Date:"]
[null,null,"Description & Camera Position:",null,null,null,null,null,null,null,null,null,null,"Description & Camera Position:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Photographer:",null,null,null,null,null,"Photograph Date:",null,null,null,null,"Photographer:",null,null,null,null,null,"Photograph Date:"]
[null,null,"Description & Camera Position:",null,null,null,null,null,null,null,null,null,null,"Description & Camera Position:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Photographer:",null,null,null,null,null,"Photograph Date:",null,null,null,null,"Photographer:",null,null,null,null,null,"Photograph Date:"]
[null,null,"Description & Camera Position:",null,null,null,null,null,null,null,null,null,null,"Description & Camera Position:"]

{"sheet":"FA22B","index":37,"n_rows":59,"n_cols":25,"rows_kept":59,"cut":false,"hidden":false,"merged":[[60,16,60,17],[60,3,60,4],[57,4,57,7],[58,5,58,10],[19,17,19,20],[20,18,20,23],[38,17,38,20],[39,18,39,23],[57,17,57,20],[58,18,58,23],[40,2,56,10],[19,4,19,7],[20,5,20,10],[38,4,38,7],[39,5,39,10],[40,15,56,23],[2,2,18,10],[21,2,37,10],[2,15,18,23],[21,15,37,23],[0,0,0,4],[0,5,0,6],[1,0,1,4],[1,5,1,6],[0,13,0,17],[0,18,0,19],[1,13,1,17],[1,18,1,19]]}
["PHOTOGRAPHS OF",null,null,null,null,"Project No.:",null,{"$f":"Inputs!$B$10","v":"Project Number"},null,null,null,null,"FA-22B: (Rev. 10/20)","PHOTOGRAPHS OF",null,null,null,null,"Project No.:",null,{"$f":"Inputs!$B$10","v":"Project Number"},null,null,null,"FA-22B: (Rev. 10/20)"]
["SUBJECT IMPROVEMENTS",null,null,null,null,"Tract No.:",null,{"$f":"Inputs!$B$11","v":"Tract Number"},null,null,null,null,null,"SUBJECT IMPROVEMENTS",null,null,null,null,"Tract No.:",null,{"$f":"Inputs!$B$11","v":"Tract Number"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Photographer:",null,null,null,null,null,"Photograph Date:",null,null,null,null,null,null,"Photographer:",null,null,null,null,null,"Photograph Date:"]
[null,null,"Description & Camera Position:",null,null,null,null,null,null,null,null,null,null,null,null,"Description & Camera Position:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Photographer:",null,null,null,null,null,"Photograph Date:",null,null,null,null,null,null,"Photographer:",null,null,null,null,null,"Photograph Date:"]
[null,null,"Description & Camera Position:",null,null,null,null,null,null,null,null,null,null,null,null,"Description & Camera Position:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Photographer:",null,null,null,null,null,"Photograph Date:",null,null,null,null,null,null,"Photographer:",null,null,null,null,null,"Photograph Date:"]
[null,null,"Description & Camera Position:",null,null,null,null,null,null,null,null,null,null,null,null,"Description & Camera Position:"]

{"sheet":"FA22C","index":38,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,1,57,11],[58,3,58,4],[0,2,0,6],[0,7,0,8],[1,2,1,6],[1,7,1,8]]}
[null,null,"BLDG DIMENSIONAL",null,null,null,null,"Project No.:",null,{"$f":"Inputs!$B$10","v":"Project Number"},null,null,"FA-22C: (Rev. 10/20)"]
[null,null,"SKETCH AND LAYOUT",null,null,null,null,"Tract No.:",null,{"$f":"Inputs!$B$11","v":"Tract Number"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"ALABAMA DEPARTMENT OF TRANSPORTATION"]

{"sheet":"FA22D","index":39,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[[2,1,59,11],[60,3,60,4],[0,2,0,6],[0,7,0,8],[1,2,1,6],[1,7,1,8]]}
[null,null,null,null,null,null,null,"Project No.:",null,{"$f":"Inputs!$B$10","v":"Project Number"},null,"FA-22D: (Rev. 10/20)"]
[null,null,"PROPERTY PLAT (OR SKETCH LAYOUT)",null,null,null,null,"Tract No.:",null,{"$f":"Inputs!$B$11","v":"Tract Number"}]

{"sheet":"Add'l Pages","index":40,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}