Analysis Report of Homes Sold in the Fayettville Area

In: Other Topics

Submitted By krystal0715
Words 932
Pages 4
ANALYSIS REPORT OF HOMES SOLD
To develop a multiple linear regression model to help the firm identify the average resale value of homes in the Fayeetville area, we have collected information on a random sample of 50 homes sold in the Fayettville area over the first 8 months of 2011. This information was obtained from the Fayettville Multi-Listing Realty Service and thus, our sample only includes homes listed or sold by agents and companies that belong to the service.
We put collected data into SAS system to help us generate an automatic result. We use six independent variables to analyze the selling price of home, which are respectively the heated area of house, the age of house, the lot size of house, a dummy variable with a value of 1.0 for a house located in the Northeast quadrant of the city, located in the Northwest quadrant of the city, and located in the Southwest quadrant of the city. After running the SAS system, we get a following model:
Pricei = 65,829 + 66.98 sqfti – 591.65 agei + 34,178 lotszi – 19,024 dnei –1,169.3 dnwi + 460.35 dswi.
For example, we may interpret the independent variable SQFT like this: on the average, within the range of observed values, on each 1 square feet increase in the average heated area of house, the selling price of home increases by $66.980, controlling for agei, lotszi, dnei, dnwi, dswi, OTHC. Similarly, the other five variables can be interpreted in the same way.
The sample plan is to analyze the observed values and to learn how the project is going on through studying the results. The status of the project is very important to help us make a good business decision in the future.
To make an overall test of significance analysis, we could make two hypothesizes: one is that all of the six independent variables equal to zero, the other is one or more of the six independent variables is/are not equal to zero. As the…...

Similar Documents

Home Reading Report

...* | | | | Home Reading Report In EnglishSKIPPING CHRISTMASBy John Grisham  Settings: It was a holiday and the places were full of snow. The people are preparing for the upcoming Christmas Eve and it was very cold. Characters: Main Characters * Luther Krank * Nora Krank * Walt and Bev Scheel * Vic Frohmeyer * Blair Krank  Plot: The story focuses on how Luther Krank and his wife Nora tried to avoid doing the traditional Christmas frenzy. The plan was hatched by Luther himself after he and his wife took their daughter Blair to the airport for a yearlong mission to Peru with the Peace Corps. After calculating how much money they spent last Christmas, Luther decides to take a 10-day Caribbean Cruise with his wife this year instead of celebrating Christmas the usual way. No Christmas shopping, no Christmas trees, not even the traditional Christmas party they hosted. Nora reluctantly agreed at first but as the day of the cruise approaches she thinks it's a great idea as they all miss the crazy commotion people had to endure during the season. Or so they thought...... Blair suddenly calls on Christmas Eve to tell them that she's at the airport in Miami, FL and she's coming home with her fiance as a surprise for them. Blair also told them that her fiance hasn't been to the U.S.A. and would like to see how they spend Christmas, after Blair told him about the decorations, Music, snow and the Christmas party their family always......

Words: 606 - Pages: 3

Financial Analysis of a Company Report

...Table of Contents 1.0 Introduction 4 2.0 Methodology 4 3.0 Non-Financial Information 4 3.1 SWOT Analysis 5 3.2 Porter’s 5 forces model 5 3.2.1 Fig 1 Porter's five forces Model 6 3.3 Corporate Social Responsibility 7 4.0 Financial Information 7 4.1 Directors’ Report 9 4.2 Auditors’ Report 9 4.2.1 Understanding Unqualified and Qualified Phrases 10 4.3 Financial Notes 10 5.0 Balance Sheet 11 5.1 Assets 11 5.1.1 Cash and Cash Equivalent 11 5.1.2 Temporary Investments 12 5.1.3 Accounts Receivable 12 5.1.4 Inventory 12 5.1.5 Prepaid Expenses 13 5.1.6 Total Current Assets 13 5.1.7 Property, Plant and Equipment (PPE) 13 5.2 Liabilities 14 5.3 Stockholders’ Equity 14 6.0 Working Capital 14 6.1 Current Ratios 15 6.2 Financial Leverage 15 7.0 Income Statement 15 7.1 Profit Margins 16 8.0 Cash Flow Statement 17 8.1 Financial Ratio Analysis 18 8.1.1 Return on Capital Employed ROCE 18 8.1.2 Calculating ROCE 18 8.1.3 Return on Assets ROA & Return on Investments ROI 19 8.1.4 Calculating Return on Fixed Assets ROFA 19 9.0 Summary 20 References 24 1.0 Introduction. Abacus Accounts are seeking to outsource most of their Facilities Management operations to an external FM provider; these will include: maintenance, cleaning, catering, security and vehicle management. They are a large business which is seeking to identify a strategic partnership and will therefore, only be willing to deal with significant......

Words: 6167 - Pages: 25

Home Dipot Financial Analysis

...1.The Home Improvement Industry consists of companies which sell goods and offer services that are used to improve the quality, value, and living situation of residential housing. 2.Revenue of the industry is 159 billion(US Dollar) 3.Annual growth for the period 2007-12 is -2.8%. 4.It came to existance post world war ii intensifying price competition and the continued dominance of the industry's top players keep profit down. 5.This industry includes stores that sell a broad range of home repair and maintenance goods like hardware, tools and electrical goods, as well as lumber and structural material for construction and renovations. Stores that focus on a specific area like flooring or wall coverings are excluded from this industry. Operators purchase goods from domestic and international manufacturers and wholesalers and sell them to end-users, such as do-it-yourself consumers and professional contractors. 6.Home improvement is the process of renovating or making additions to one's home. Often, a professional handyman is hired to perform the improvements but, typically, most improvements are done on an amateur DIY basis by the homeowner. 7.Several major retailers, such as Home Depot and Lowes, specialize in selling materials and tools for DIY home improvement. These stores even host classes to educate customers how to do the work themselves. 8.U.S. Census data show a boom in home repair and improvement between 1982 and 1992: a 115% increase, the largest of any...

Words: 814 - Pages: 4

Financial Analysis Report of Carrefour

...Financial report : Carrefour Yi LI Yuhuan CHEN FEI XU Matthieu GRACIEUX Nicolas CHAPACOU 1 Table of Contents 1) 2) 3) 4) 5) 6) 7) 8) Business Description .................................................................................................. 3 Market Summary ....................................................................................................... 5 Strategy and Competitive Positioning ......................................................................... 9 Risks ........................................................................................................................ 13 Financial analysis ..................................................................................................... 15 Forecast, Valuation and Recommendations .............................................................. 17 Appendix ................................................................................................................. 19 Sources .................................................................................................................... 22 2 1) Business Description - Carrefour SA operates hypermarkets, supermarkets, convenience stores, cash and carry stores, and hypercash stores worldwide. The company also operates food and non-food e-commerce Websites. Its hypermarkets offer food products; and non-food products comprising clothing products, electronic goods, household appliances, multimedia products,......

Words: 7288 - Pages: 30

Trade Area Analysis

...Trade Area Analysis: The Example of Best Buy in the Toronto Area Part A: Trade area delimitation for Best Buy stores 1. There are 10 Best Buy stores shown on the map. They are almost evenly distributed all over Toronto. However, those stores are a little more concentrated in the southwest part of Toronto city, where are more densely populated. Apparently, Best Buy aims to serve all customers in Toronto. Each store is relatively some distance away from another to avoid overlapping market and at the same time cover larger market area. 2. Possible new locations can be identified, by applying Thiessen polygon technique to Map One. In theory, the vertices of boundary lines are considered to be the best sites for new stores. These locations are identified as poorly served areas as people in these areas have to travel a relative long distance to reach a Best Buy store. Moreover, stores in such locations are less likely to compete with other Best Buy stores around it. Possible new stores are identified by little triangles. There are nine spots identified as possible new locations of Best Buy stores. Among all the locations, West Site location seems rather unrealistic. Although it falls right on the junction of boundaries, it is right where the Pearson International Airport is. People are sparsely populated in this area. If opening a new store there, the market area will be mainly occupied by the airport. It will not make much difference. Similarly, spot six falls on the......

Words: 1268 - Pages: 6

Case Analysis for Home Depot

...Case Analysis for Home Depot In analyzing the Home Depot case I will cover the following; relevant stakeholder interests, ethical and social concerns, tradeoffs, and possible alternatives. Through analyzing case evidence along with the integration of key concepts, I will give a recommendation for Home Depots course of action. The organization is feeling external pressures to address a unique development that has affected many of their stores and local communities. Day laborers across the country have chosen to use Home Depot locations as a hub for soliciting work. With increasing public scrutiny and rising stakeholder concern, day laborers are making Home Depot’s reputation very fragile. The organization needs to address the ethical dilemma of day laborers. No two stakeholders are more important to the organization than the local governments and communities. Home Depot has avoided addressing the problem to prevent conflict that may arise from opposing stakeholders. This is why local government agencies are critical to Home Depot’s day laborer issues. Local government and officials have the ability to help remedy a positive outcome. Day laborers have put Home Depot and their stakeholders at the intersection of the political debate between illegal immigration and human rights. There is no other stakeholder who can proactively work with Home Depot to develop a solution for the day laborer problem. Proactively working with local government agencies that are......

Words: 1570 - Pages: 7

Report Analysis

...| Cordlife Analysis Report | Based on Cordlife Annual Report 2012 | | ACCY112 | | | Table of Contents Executive Summary 3 Introduction 3 Corporate Information 3 Registered Office 3 Auditors 3 Board of Directors 4 Consolidated Report 4 Cost of Sales for the Year 4 Profit before Tax 4 Income Tax Expense Amount 4 Net Accounts Receivable 5 Method used for bad debts 5 Property, Plant and Equipment (PPE) 6 Depreciation Method 6 Book Value 6 Depreciation Expense 7 Long-Term Liabilities 7 Contingent Liabilities 8 Issued Capital Amount 8 Liquidity of the Company 8 Current Ratio 9 Quick Ratio 9 Accounts Receivable Turnover Ratio 9 Inventory Turnover Ratio 10 References 10 Executive Summary This report will be about the company analysis report for Cordlife Group Limited’s annual report 2012 (Cordlife Annual Report 2012, Page 1). We will be going through the information of the company such as what the types of business undertake and the internal factors like the auditors of the company. The summary of the consolidated report will be mention on the company’s financial statement, how is the company doing in their financial strength. Introduction According to Cordlife, 2013, Cordlife Group Limited is a leading service provider of stem cell banking from cord blood and the umbilical cord, who currently owned and operates two stem cell banks with full processing and cryopreservation storage facilities in Singapore and...

Words: 2346 - Pages: 10

Analysis Report

...Analysis Report for Week 2 1. Poor planning- Going into business requires a lot of planning, for example, financial planning (Budget proposal) and market planning (Market Plan). At CanGo they were able to see some initial success without the formal planning in place, but now that they are introducing an online gaming segment that will put the entire company at risk if they do not initially put a plan in place. My recommendation would be to create a formal budget for each of the marketing segments that CanGo is in. The team needs to know what resources are available to them. This way they can focus their efforts on the areas where they can get the most bang for their buck. They will be able to utilize their funds in the best way possible in order to generate more revenue or at least keep up with demand. Some projects will need to be forgone to insure the funds are available to support operations. 2. Not having a business strategy set in place- At CanGo success was an accident. They did not go into business with a strategy in place for success, but none the less they were able to create a business that flourished. Although they did not start with a good plan in place there is still time to put a strategy in place and create some structure in the organization. My recommendation would be to perform a SWOT analysis. This self-assessment will be able to show CanGo what procedures and routines are working well and which ones need some improvement. It will also identify some......

Words: 952 - Pages: 4

Annual Report Analysis on Home Depot

...Annual Report Analysis On Home Depot, Inc. DeVry University Intermediate Accounting Introduction Home Depot, Inc., founded in 1978 by Bernie Marcus and Arthur Blank, decided to team up with investment banker Ken Langone and merchandising guru Pat Farah ultimately became the visionaries for the one-stop-shop do-it-yourself store which today has become a very lucrative business bring the vision to fruition. The Home Depot is the world’s largest home improvement retailer based upon reported $4.5billion in net sales for the fiscal year 2012. Home Depot has more than 2,200 locations throughout the United States and now has expanded across the globe with stores located in territories of the U.S. Virgin Island, Guam, Canada, Puerto Rico, Mexico and reaching as far as China. Stores averaging 105,000 square feet with approximately 23,000 additional square feet outside garden area; inventory consist up to 40,000 different kinds of building materials, home improvement supplies and equipment to also include appliances along with lawn and garden products and equipment for just about every imaginable project need. Home Depot offers competitive prices with a guarantee they can beat anyone’s advertised specials. Among other offers, Home Depot offers home services such as contractor services, home services, free “how-to-clinics” and a free children’s “how-to-clinic” offering ideas that can range from simple to complex ideas. Report I Reporting and Auditors Financial......

Words: 1307 - Pages: 6

Analysis Report

...PART TWO: ANALYSIS REPORT Education becomes more effective when there is a combination of theory and practical knowledge. Theoretical knowledge achieved perfection with the implication of practical knowledge. The internship program can combine theoretical knowledge with practical situation. A practical orientation program is really essential for a student as our educational system is mostly text based. Professional experience is very important to be established. In this situation I got a bit practical experience by analyzing financial performance of Medez – Galanto & Associates. A. SECTIONS IN THE MEDEZ- GALANTO & ASSOCIATES 1. Accounts Payable and Receivable The accounts payable section of an accounting department records goods and services that it receives and the payments it owes, such as inventory from a supplier or other expenses. The department records each accounts payable as a liability and accounts receivable as assets. Assets such as revenue and customers’ obligations pay for goods and services. 2. Payroll The payroll function of an accounting department ensures that the organization pays its employees accurately, including bonuses, commissions and benefits. The department monitors employees' time off, vacation and sick days. It pays the government taxes as well as union dues and other withholding from an employee's paycheck. The department reimburses employees for expenses and makes payments to vendor. 3. Inventory A company's......

Words: 5035 - Pages: 21

Home Depot Report Analysis

...Information Bernie Marcus and Author Blank founded Home Depot in Georgia in 1978. The first few stores were attached to Treasure Island stores and stocked around 25,000 products. What started out as a small neighborhood hardware store soon sprouted as the largest home improvement store in the nation. It wasn’t before long that Home Depot (HD) shares were being traded publicly on the New York Stock Exchange. Today, Home Depot is a member of the Dow Jones Industrial Average and is one of the “Top Ten Most Admired Companies” by Fortune magazine, which also ranked The Home Depot as “America’s Most Admired Specialty Retailer” for the seventh consecutive year. This company only goes up with increasing net sales and net profit. The main ingredient to Home Depot’s success is not only the number of stores there are, but the diverse types of customers they attract. Home Depot attracts contractors, other retail stores, the do it yourselfer, and the average John Doe shopper. Home Depot is also attracting more and more women by increasing and expanding their EXPO Design stores which focuses on wall paper and other types of remodeling. So, whether you’re a contractor looking for lumber to build a house or John Doe who just broke his door handle and is looking to buy a new one, the Home Depot is your one stop superstore. What makes the Home Depot such a pleasant place to shop is the 201,000 friendly and knowledgeable sales associates. Home Depot forces their employees through a......

Words: 2396 - Pages: 10

Home Depot Analysis

...Management Analysis The CEO and leader of Home Depot is Craig Menear. He has more than three decades of experience in the retail and hardware home improvement industry, more than half of which have been with the company. This makes me a smart choice to lead the best home retailor in the country. At age 57 he has a vast experience and knowledge of his craft which makes him the obvious choice to lead The Home Depot. He should be in this position for many years to come seeing how in 2013 under Craig’s leadership, HomeDepot.com sales grew 50 percent and accounted for $900 million of the company’s total sales growth of $5 billion. The Home Depot has a functional structure which maintains a CEO with a small corporate staff along with managers in organizational areas such as production, accounting, marketing, R&D, engineering and human resources. Separating the organizational areas of a company allows for specialization in each functional area. However, this separation can have a negative effect as it makes communication between these areas more difficult. The multidivisional structure consists of different divisions which represent separate businesses which corporate officers that dictate responsibilities to lower level personal. This allows officers to monitor each businesses performance more effectively. Officers can easily compare divisions and help improve the performance of a poorly performing division (Celinski, 2014). The Home Depot typically promotes from within the......

Words: 891 - Pages: 4

Home Depot Financial Analysis

...Home Depot Financial Analysis Introduction Home Depot is an American public corporation founded in 1978 (Homer, 2011). Home Depot’s shares are listed in the New York Securities Exchange with the abbreviation HD. The company retails construction and home improvement commodities and services. Home Depot runs stores of the big-box format across the United States, Mexico and Canada. Home Depot’s headquarters are in Cobb County, Atlanta. Home Depot is the largest retailer of home improvement products based on the revenue reports filled at the Securities Exchange Commission. This paper shall present a financial analysis of Home Depot. a) Current Ratio The current ratio is not only a liquidity ratio but also an efficiency ratio. It reflects a company’s ability to fulfill its short term financial obligations using its current assets. A healthy current ratio is above one while an unhealthy ratio is less than one. A current ratio that is greater than one means that the firm can meet its current liabilities with ease and without pressuring the liquid assets of the company. A very high current ratio is not ideal since it means that the company has tied too much of its resources on short term assets. However, a ratio that is less than one show that the company has problems in settling its short term financial obligations (Wang, 2008). Home Depot’s current ratio is 1.4 for both 2015 and 2014 financial years. The ratio of 1.4 is healthy since it is greater than one. The ratio shows...

Words: 2775 - Pages: 12

The Financial Analysis of Home Depot

...The Financial Analysis of The Home Depot By: The CPT Consulting Group 10-3-11 CPT Consulting Group Table of Contents I. Introduction II. Board of Directors and Corporate Governance III. WACC and Capital Structure IV. Degree of Operating leverage V. Dividends VI. Conclusions VII. Appendix I. Introduction The Home Depot was founded in 1978 by Bernie Marcus and Arthur Blank. The home depot Inc., collectively with its subsidiaries, operates as a home improvement retailer. The company sells a wide variety of building materials, home improvement products, and lawn and garden products for the do-it-your-self customer, the do-it-for-me customer, and the professional customer. Today The Home Depot provides installation options for: carpeting, tile flooring, cabinets, water heaters, furnaces, and central air systems to name a few. The founders’ originally had a vision of a one stop shopping store for the do-it–your- self customer, and later went on to expand the business into the do-it-for-me customer. Mr. Marcus and Mr. Blank opened the first Home Depot store on June 22, 1979 in Atlanta, Georgia. In 1981, the company went public on NASDAQ and moved to the New York Stock Exchange (NYSE:HD) in 1984. The Home Depot, Inc. is the world's largest home improvement specialty retailer and the fourth largest retailer in the United States with fiscal 2010 retail sales of $68.0 billion and earnings from continuing operations of $3.3 billion...

Words: 2931 - Pages: 12

Strategic Analysis of Home Depot

...A Strategic Analysis of Home Depot GM599 A Strategic Analysis of Home Depot Introduction The Home Depot (NYSE: HD) is a home improvement, construction products and services retailer operating over 2,000 big-box stores in the United States and abroad. The Home Depot was founded in 1978 by Bernie Marcus and Arthur Blank with the vision of one-stop shopping for do-it-yourself (DIY) customers, installation services for do-it-for-me (DIFM) customers and competitive products for the professional market. Their DIFM installation programs include products such as carpeting, flooring, cabinets, countertops, and water heaters. In addition, the company provides installation of various professional products like generators and HVAC systems. The Home Depot developed strategic product alliances directly with industry-leading manufacturers to deliver the most exclusive assortments to customers. Through a combination of national brands and proprietary products The Home Depot exclusively carries several major brands, including: BEHR Paint, G.E., Martha Stewart Living and Thomasville, which sets the standard for the do-it-yourselfer and the professional contractor. The Home Depot revolutionized the home improvement industry by bringing the know-how and the tools to the consumer and by saving them money. According to the founders, the customer has a bill of rights at The Home Depot, and this entitles the customer to the right assortment, quantities and price, along with trained......

Words: 3580 - Pages: 15