Exp22_Excel_Ch08_CumulativeAssessment_Variation - Real Estate Valuation

profileSolutions Aplus
afrhuj_Exp22_Excel_Ch08_CumulativeAssessment_Variation_Valuationq.xlsx
Home>Computer Science homework help>Exp22_Excel_Ch08_CumulativeAssessment_Variation - Real Estate Valuation

Sales Data

Home Valuation Worksheet
Purchase Date Sqft Purchase Price Current Value Sqft Frequency BIN Frequency Standard Deviation
3/1/21 984 $ 71,252.00 $ 90,125.00 500
5/26/21 959 $ 76,050.00 $ 95,357.00 1000
11/1/21 586 $ 68,972.00 $ 80,114.00 1500 Variance
5/4/22 1101 $ 80,885.00 $ 90,789.00 2000
5/25/22 3026 $ 275,863.00 $ 337,800.00 2500
6/11/22 2400 $ 221,400.00 $ 351,000.00 3000 Covariance
9/2/22 3729 $ 303,951.00 $ 375,956.00 3500
9/16/22 3340 $ 281,753.00 $ 325,444.00 4000
10/28/22 800 $ 72,304.00 $ 90,005.00 Correlation
12/9/22 2372 $ 215,764.00 $ 285,647.00
2/20/23 3281 $ 265,741.00 $ 298,633.00
5/13/23 3370 $ 281,987.00 $ 325,744.00
5/16/23 1735 $ 150,789.00 $ 210,456.00
6/19/23 623 $ 69,258.00 $ 87,500.00
8/19/23 3458 $ 289,963.00 $ 325,665.00
11/2/23 2187 $ 200,741.00 $ 235,456.00
12/7/23 3704 $ 301,741.00 $ 315,478.00
1/31/24 683 $ 69,753.00 $ 92,357.00
5/10/24 2990 $ 247,753.00 $ 251,756.00
10/19/24 3693 $ 300,015.00 $ 303,124.00
12/9/24 1008 $ 80,250.00 $ 82,459.00
4/28/25 1300 $ 92,759.00 $ 105,478.00
5/14/25 2716 $ 235,741.00 $ 240,145.00
9/21/25 3596 $ 295,753.00 $ 305,741.00
12/1/25 3449 $ 289,987.00 $ 310,459.00
12/16/25 3993 $ 320,668.00 $ 330,000.00
12/18/25 3959 $ 315,452.00 $ 317,789.00

Subdivisions

SQFT Gatewood Cooper Point Eagle Creek
900 146,928.00 350,198.00 289,710.00
950 122,560.00 310,928.00 375,325.00
1000 134,547.00 445,709.00 346,279.00
1050 144,425.00 380,624.00 360,791.00
1100 145,608.00 427,847.00 317,780.00
1150 145,240.00 455,445.00 423,339.00
1200 127,547.00 384,802.00 437,737.00
1250 149,113.00 307,869.00 307,040.00
1300 115,547.00 298,280.00 314,884.00
1350 135,531.00 417,476.00 461,954.00
1400 102,026.00 285,571.00 400,801.00
1450 101,832.00 401,967.00 334,618.00
1500 227,720.00 382,944.00 498,130.00
1550 265,272.00 379,957.00 441,067.00
1600 224,611.00 431,285.00 486,998.00
1650 257,625.00 430,821.00 285,591.00
1700 231,889.00 430,666.00 464,692.00
1750 217,072.00 333,644.00 354,709.00
1800 243,835.00 399,806.00 418,578.00
1850 259,639.00 281,825.00 298,731.00
1900 249,958.00 429,591.00 319,557.00
1950 220,978.00 312,855.00 349,667.00
2000 450,536.00 339,722.00 303,693.00
2050 342,649.00 471,916.00 339,221.00
2100 327,389.00 330,069.00 288,960.00
2150 473,456.00 285,655.00 393,103.00
2200 378,260.00 490,318.00 419,127.00
2250 418,567.00 285,836.00 452,202.00
2300 339,908.00 451,369.00 380,206.00
2350 437,626.00 419,323.00 318,920.00
2400 437,523.00 289,054.00 438,146.00
2450 438,320.00 390,346.00 293,407.00
2500 483,215.00 464,488.00 414,822.00
2550 442,827.00 402,768.00 364,514.00
2600 288,029.00 489,213.00 388,064.00
2650 454,657.00 320,586.00 407,494.00
2700 450,453.00 487,869.00 436,469.00
2750 371,346.00 340,490.00 331,261.00
2800 496,580.00 379,786.00 442,866.00
2850 284,819.00 384,121.00 300,520.00
2900 304,310.00 419,650.00 389,481.00
2950 351,039.00 459,137.00 385,912.00
3000 418,331.00 464,687.00 285,497.00

Forecast

Sqft Purchase Price Intercept Slope RSQ Standard Error
586 $ 68,972.00
623 $ 69,258.00
683 $ 69,753.00 Sqft Forecast High Low
799 $ 71,252.00 4500
800 $ 72,304.00
959 $ 76,050.00
1008 $ 80,250.00
1101 $ 80,885.00
1300 $ 92,759.00
1735 $ 150,789.00
2187 $ 200,741.00
2372 $ 215,764.00
2400 $ 221,400.00
2716 $ 235,741.00
2990 $ 247,753.00
3026 $ 275,863.00
3281 $ 265,741.00
3340 $ 281,753.00
3370 $ 281,987.00
3449 $ 289,987.00
3458 $ 289,963.00
3596 $ 295,753.00
3693 $ 300,015.00
3704 $ 301,741.00
3729 $ 303,951.00
3942 $ 315,452.00
3993 $ 320,668.00