MG final

profileFredablyee
BusinessAnalyticsAssignment.xls
Home>Business & Finance homework help>Accounting homework help>MG final

Priv-Res SA

Value of Private Residential Construction Put in Place excluding rental, vacant, and seasonal residential improvements - Seasonally Adjusted Annual Rate
(Millions of Dollars)
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1993 194,150 194,689 190,185 198,296 198,835 203,175 208,760 212,238 214,446 214,778 227,235 235,648
1994 238,612 236,577 235,150 244,746 244,056 244,032 245,463 243,134 242,619 234,905 239,857 241,395
1995 241,184 234,257 228,013 225,488 222,062 218,972 224,113 226,045 228,688 227,589 231,913 235,572
1996 240,958 243,695 249,952 252,836 259,296 263,085 263,549 263,618 265,677 261,444 259,668 253,234
1997 255,365 258,595 264,566 257,490 264,581 262,299 261,593 263,951 270,511 272,980 272,786 269,192
1998 276,485 279,249 291,505 288,409 292,879 296,632 296,717 299,495 305,345 308,127 307,899 302,650
1999 305,968 307,914 316,822 316,111 320,326 322,905 320,854 326,779 334,947 342,423 348,035 346,989
2000 353,065 351,933 353,452 356,188 349,907 348,133 337,374 337,583 339,048 344,095 347,301 344,139
2001 348,279 353,629 350,029 361,991 360,534 365,905 366,500 369,000 368,809 370,957 375,803 376,279
2002 377,631 385,745 385,406 398,990 394,223 401,920 404,632 398,875 394,820 397,077 401,424 411,758
2003 417,788 417,500 413,303 420,510 421,143 430,929 448,917 453,031 458,676 469,855 485,245 503,356
2004 498,640 500,439 506,879 512,400 522,534 527,794 543,260 551,447 546,306 551,137 550,392 566,284
2005 575,650 588,435 591,580 598,335 603,707 616,958 628,750 633,710 647,374 658,590 665,376 670,522
2006 675,679 678,562 668,311 650,388 633,815 615,053 598,487 584,460 573,878 561,444 548,971 545,011
2007 537,571 531,641 527,865 523,666 514,131 505,936 495,976 480,974 465,709 447,819 431,878 416,486
2008 402,138 386,197 390,471 385,328 381,911 374,495 364,873 352,598 340,396 329,304 312,540 293,997
2009 283,870 267,938 254,645 243,958 237,188 237,343 244,141 250,768 254,135 254,942 255,941 255,801
2010 254,826 255,121 253,924 254,574 252,896 250,518 244,354 238,695 237,834 236,512 237,468 239,030
2011 240,548 240,062 241,586 244,598 245,449 247,520 249,770 251,877 250,152 252,821 247,279 247,983
2012 251,869 247,503 252,283 258,567 263,797 269,664 273,587 279,216 286,120 294,197 296,510 299,101
2013 303,792 309,078 312,083 316,537 321,706 324,770 328,388 335,690 339,977 346,273 353,317 360,754
2014 368,359 363,860 369,329 375,347 376,671 372,569 372,572 372,893 382,053 386,299 391,521 401,584
2015r 405,105 410,055 409,845 415,034 422,979 433,746 439,819 439,616 448,021 448,256 446,990 452,947
2016r 456,427 462,338 469,444 468,579 469,095 474,679 477,138 481,080 482,889 496,331 504,423 512,006
2017r 510,854 531,426 526,669 533,586 536,756 537,034 542,342 542,135 544,226 537,894 561,466 564,275
2018r 570,597 576,567 571,961 574,593 578,615 570,521 560,485 550,313 550,704 535,314 537,537 517,562
2019r 516,899 516,346 517,654 523,932 531,954 542,612 554,234 558,908 561,924 564,734 577,566 583,160
2020r 596,265 607,522 617,990 599,184 591,253 593,464 614,353 638,430 657,613 677,725 697,825 719,089
2021r 734,961 738,572 757,841 770,734 788,401 799,279 806,484 811,497 814,272 816,908 824,006 842,949
2022r 881,907 903,400 920,041 935,913 938,198
Instructions:
Business Analytics Course/Project 1. Given the available data above, build a model using excel tool/functions, including graphs, charts, pivot tables to determine or estimate the sales prices of single-family new homes in 2023. What will be cost of down payment at minimum rate of 20%? Should potential single-family homebuyers buy now or buy in 2023? Why and/or why not? 2. Prepare a report of not more than a page to explain your model/analysis.