Please help me complete this sale comparison approach. I am stuck on the last step to finish my assignment.

Using the following information and provided price list, complete the Excel spreadsheet. Make adjustments where appropriate and determine an indicated value for the subject property completing the analysis as of today's date. Assume your 3 comps will have equal weights in this approach (meaning it would be acceptable to use an average for reconciliation in this circumstanc The subject property is located at 1926 Lookout Lane. in the Overlook Subdivision. It is a two-story home, located on a Q.16 acre lot and was built in 2001. Total square footage is 3,062. The upper level is 1066 square feet, the main floor is 998 square feet and the home has an 988 square foot basement that is 25% finished. The property has 5 bedrooms, 2 full bathrooms, a half bathroom and a bathroom, a three- car attached garage, one fireplace, brand new hardwood flooring on the main floor, a backyard pergola and hot tub, sprinkler system, and fenced yard. The property is listed for $420,000. Properties in the area have appreciated approximately 2% over the past year u have identified the following four properties as possible comparables- based on the informatio provided in class on comparable selection criteria, choose the three "best" comps for use in your analysis Property #14239 Applegate Ct This home is located in The Gates at Woodridge Subdivision, approximately 0.1 miles from the subject. It is a two-story home, located on a 0.19 acre lot and was built in 2001. The upper level is 643 square feet, the main floor is 1,900 square feet and the home has a 1,873 square foot basement that is unfinished. The property has 3 bedrooms, 2.5 bathrooms, a three car attached garage, one fireplace, a covered patio, and sprinkler system. The property was listed for $527,900 and sold April 10, 2018 for $520,000 with Seller paid closing costs of $5,000 Property #2 2008 Lookout Lane This property is in the Overlook Subdivision and is approximately 0.01 miles from the subject. The home was listed for $433,900 and s Concessions in the amount of $2,000). The two story home, built in 2001, has 3 bedrooms and 2.5 bathrooms. This home features hardwood floors, a patio and a sprinkler system. Square footage is as follows: main floor- 1047 square feet, upper level-984 square feet and basement-854 unfinished square feet. 3 car attached garage and 016 acre lot old on March 18,2019 for $433,900 (Sales Price includes Seller Property #3 4108 Center Gate Ct. Located in the The Gates Subdivision, approximately 0.01 miles from subject, featuring two-stories, fi bedrooms, three full bathrooms, and one bath. The home has a finished basement,and offers a $5,000 carpet allowance. One fireplace, large fenced yard with patio and deck. The house was built in 2000 and lot size is 0.17 acres. Total quare footage is 3,025. Main level is 1,115 square feet, upper level square footage is 830, and basement square footage is 1080. The property features hardwood flooring, granite counters and a fenced backyard with patio. Three car attached garage. This home was listed for $440,000 and sold for $440,000, with no seller concessions, on January 16,2019. Sales price includes a pool membership valued at $2,500 ive Property #41951 Silvergate Rd This property is in the Overlook Subdivision and is approximately 0.15 miles from the subject. The home was listed for $427,900 and sold for $424,000 on March 16, 2019. The two story home, built in 1995 has 4 bedrooms, 2 full bathrooms, one % bathroom and one lt bathroom and an unfinished basement. This home features, hardwood floors, and a backyard deck with pergola in the privacy fenced backyard. Square footage is as follows: combined main and upper levels are 1,906 square feet and basement-524 square feet. 2 car attached garage, one fireplace, and 015 acre lot. Price List 8 Item 9 Fireplace 0 Granite countertops 1 Stainless Kitchen appliances 2 Hardwood Flooring 3 Laminate Flooring 4 New or newer carpet (per level) 5 6 foot privacy fence 6 Patio 7 Updated Kitchen 8 Deck 9 Storage Shed 0 Central AC 1 Sprinkler System 2 Bedroom 3 Bathroom-half 4 Bathroom-3/4 5 Bathroom-full 6 Updated bathrooms (price per b 7 Finished Basement (100%) 8 Garage Space (Attached) 9 Garage Space (Detached) Price $1,000 $3,000 $2,000 $1,000 $4,000 $1,000 $6,000 $2,000 $3,000 $3,000 $5,000 $4,000 $2,000 $20,000 $4,000 Subject Adjustments Adjustments Adjustments 2 Address 3 Sales Price 4 Sale Date 5 Proximi 1926 Lookout Lane 420,000 Two-story home 8 Lot Size ( 9 GLA 10 Upper SF 11 Main SF 12 Basement SF 13 %Finished 14 Gar 15 Gar 16 Fireplace 17 Year Built 18 Interior Features 9 hardwood flooring 0.16 1066 25%-$5,000 ATT-$7,500 2001 $2,500 $3,000 5 x55,000- $25,000 2 x $4.000-$8,000 $1,500 21 bedrooms 22 full bath 23 halfbathroom 24 3/4 bathroom 25 26 27 28 Exterior Features hot tub fence 31 32 $4,000 35 Indicated Value Using the following information and provided price list, complete the Excel spreadsheet. Make adjustments where appropriate and determine an indicated value for the subject property completing the analysis as of today's date. Assume your 3 comps will have equal weights in this approach (meaning it would be acceptable to use an average for reconciliation in this circumstanc The subject property is located at 1926 Lookout Lane. in the Overlook Subdivision. It is a two-story home, located on a Q.16 acre lot and was built in 2001. Total square footage is 3,062. The upper level is 1066 square feet, the main floor is 998 square feet and the home has an 988 square foot basement that is 25% finished. The property has 5 bedrooms, 2 full bathrooms, a half bathroom and a bathroom, a three- car attached garage, one fireplace, brand new hardwood flooring on the main floor, a backyard pergola and hot tub, sprinkler system, and fenced yard. The property is listed for $420,000. Properties in the area have appreciated approximately 2% over the past year u have identified the following four properties as possible comparables- based on the informatio provided in class on comparable selection criteria, choose the three "best" comps for use in your analysis Property #14239 Applegate Ct This home is located in The Gates at Woodridge Subdivision, approximately 0.1 miles from the subject. It is a two-story home, located on a 0.19 acre lot and was built in 2001. The upper level is 643 square feet, the main floor is 1,900 square feet and the home has a 1,873 square foot basement that is unfinished. The property has 3 bedrooms, 2.5 bathrooms, a three car attached garage, one fireplace, a covered patio, and sprinkler system. The property was listed for $527,900 and sold April 10, 2018 for $520,000 with Seller paid closing costs of $5,000 Property #2 2008 Lookout Lane This property is in the Overlook Subdivision and is approximately 0.01 miles from the subject. The home was listed for $433,900 and s Concessions in the amount of $2,000). The two story home, built in 2001, has 3 bedrooms and 2.5 bathrooms. This home features hardwood floors, a patio and a sprinkler system. Square footage is as follows: main floor- 1047 square feet, upper level-984 square feet and basement-854 unfinished square feet. 3 car attached garage and 016 acre lot old on March 18,2019 for $433,900 (Sales Price includes Seller Property #3 4108 Center Gate Ct. Located in the The Gates Subdivision, approximately 0.01 miles from subject, featuring two-stories, fi bedrooms, three full bathrooms, and one bath. The home has a finished basement,and offers a $5,000 carpet allowance. One fireplace, large fenced yard with patio and deck. The house was built in 2000 and lot size is 0.17 acres. Total quare footage is 3,025. Main level is 1,115 square feet, upper level square footage is 830, and basement square footage is 1080. The property features hardwood flooring, granite counters and a fenced backyard with patio. Three car attached garage. This home was listed for $440,000 and sold for $440,000, with no seller concessions, on January 16,2019. Sales price includes a pool membership valued at $2,500 ive Property #41951 Silvergate Rd This property is in the Overlook Subdivision and is approximately 0.15 miles from the subject. The home was listed for $427,900 and sold for $424,000 on March 16, 2019. The two story home, built in 1995 has 4 bedrooms, 2 full bathrooms, one % bathroom and one lt bathroom and an unfinished basement. This home features, hardwood floors, and a backyard deck with pergola in the privacy fenced backyard. Square footage is as follows: combined main and upper levels are 1,906 square feet and basement-524 square feet. 2 car attached garage, one fireplace, and 015 acre lot. Price List 8 Item 9 Fireplace 0 Granite countertops 1 Stainless Kitchen appliances 2 Hardwood Flooring 3 Laminate Flooring 4 New or newer carpet (per level) 5 6 foot privacy fence 6 Patio 7 Updated Kitchen 8 Deck 9 Storage Shed 0 Central AC 1 Sprinkler System 2 Bedroom 3 Bathroom-half 4 Bathroom-3/4 5 Bathroom-full 6 Updated bathrooms (price per b 7 Finished Basement (100%) 8 Garage Space (Attached) 9 Garage Space (Detached) Price $1,000 $3,000 $2,000 $1,000 $4,000 $1,000 $6,000 $2,000 $3,000 $3,000 $5,000 $4,000 $2,000 $20,000 $4,000 Subject Adjustments Adjustments Adjustments 2 Address 3 Sales Price 4 Sale Date 5 Proximi 1926 Lookout Lane 420,000 Two-story home 8 Lot Size ( 9 GLA 10 Upper SF 11 Main SF 12 Basement SF 13 %Finished 14 Gar 15 Gar 16 Fireplace 17 Year Built 18 Interior Features 9 hardwood flooring 0.16 1066 25%-$5,000 ATT-$7,500 2001 $2,500 $3,000 5 x55,000- $25,000 2 x $4.000-$8,000 $1,500 21 bedrooms 22 full bath 23 halfbathroom 24 3/4 bathroom 25 26 27 28 Exterior Features hot tub fence 31 32 $4,000 35 Indicated Value