Question

In: Accounting

Appraiser Donna Dewgood of the firm of Dewgood & Excel is reviewing a faulty appraisal done...

Appraiser Donna Dewgood of the firm of Dewgood & Excel is reviewing a faulty appraisal done by appraiser Justin Goodenuf. The subject property is located on Modest Lane and is a 3 bedroom, 2 bath single family residence of 1,600 SF gross living area with a 2 car garage. Which of the following sales used by Mr. Goodenuf should the competent Ms. Dewgood REPLACE in her review appraisal of the subject property?

Sale 1 is a 3 bedroom, 2 bath single family residence, 1,800 SF, 2 car garage
Sale 2 is a 2 bedroom, 2 bath single family residence, 1,600 SF, 2 car garage
Sale 3 is a 3 bedroom, 1.5 bath single family residence, 1,375 SF, 1 car garage
Sale 4 is a 3 bedroom, 1 bath single family residence, 1,512 SF, 1 car garage

Solutions

Expert Solution

Of the given sales used by Mr.Goodneuf, Sale 3 and sale 4 should be replaced. Following are the reasons for considering or not considering the sales:

The method used for appraisal is the comparative market analysis (CMA) approach. In this approach, the recent sales of properties in the same area are compared and adjusted for differences and a price is determined for the property under consideration. The comparables should be similar to the property under consideration.

Sale 1: Both the properties have the same number of bedrooms and baths and also the same garage. However, the area is different and adjustment for the same can be easily made in the appraisal. (3 of the 4 comparables are same)

Sale 2: Both the properties have the same number of baths and also the same garage, however, there is a difference in the number of rooms. However, the area of both the properties is the same. Hence, this property can be considered. (3 of the four comparables are same)

Sale 3: The number of bedrooms is the same, however, the garage is a single car garage and the bath is only a 1.5 bath. Also, the overall area is lesser than the actual property. Hence, there is a substantial difference in the comparables i.e 3 out of the four comparables are different. And this property will have to be replaced.

Sale 4: The number of bedrooms is the same, while the number of baths, the area, and the garage type is different. Hence, there is a substantial difference in the comparables i.e 3 out of the four comparables are different. And this property will have to be replaced.


Related Solutions

NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An ARM for 100,000 is made at the...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An ARM for 100,000 is made at the time when the expected start rate is 5 percent. The Loan will be made with a teaser rate of 2 percent for the first year, after which the rate will be reset. The loan is fully amortizing, has a maturity of 25 years, and payments will be made monthly. a. What will be the payments during the first year? b. Assuming that the reset...
I have a philosophical question for you: How often should a formal performance appraisal be done...
I have a philosophical question for you: How often should a formal performance appraisal be done and why?" I think there are certain advantages and disadvantages to more or less often.
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An investor has $60,000 to invest in a...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An investor has $60,000 to invest in a 280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and second mortgage for $40,000 at 13 percent for 20 years. All loans require monthly payments and are fully amortizing a. Which alternative should the borrower choose, assuming he will own the property for the full loan term? b....
Use Excel to complete the following question. You must submit/attach all work done in Excel in...
Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....
This needs to be done in Excel and that is where I am having issues Healthy...
This needs to be done in Excel and that is where I am having issues Healthy Snacks Co. produces snack mixes. Recently, the company has decided to introduce a new snack mix that has peanuts, raisins, pretzels, dries cranberries, sunflower seeds and pistachios. Each bag of the new snack is designed in order to hold 250 grams of the snack. The company has decided to market the new product with a emphasis on its health benefits. After consulting nutritionists, Healthy...
To please be done in excel: It is November, 2001. ABC Ltd. is a company listed...
To please be done in excel: It is November, 2001. ABC Ltd. is a company listed on the Stock Exchange. The company was founded in the early 1980’s and management identified a market for small photocopier and fax machines and in later years, tablets. The company has in the past relied on importing equipment from the Far East, but the recent decline in the value of the Peso, combined with increased local competition, has resulted in a significant decrease in...
The Ratio Calculations should be done in a table in Excel and included with your submission....
The Ratio Calculations should be done in a table in Excel and included with your submission. The following ratios should be included for Pier 1 for 2 years: calculate these ratios below is a link to 10-K form Working Capital Current Ratio Total Debt to Total Equity Ratio Times Interest Earned RNOA ROCE Show calculations for pier 1 https://investors.pier1.com/financial-information/annual-reports
NEEDS TO BE DONE IN EXCEL. A price level adjusted mortage (PLAM) is made with the...
NEEDS TO BE DONE IN EXCEL. A price level adjusted mortage (PLAM) is made with the following terms: Amount=$95,000 Initial interest rate= 4 percent Term= 30 Years Points= 6 percent Payments to be reset at the beginning of each year. Assuming inflation is expected to increase at the rate of 6 percent per year for the next five years: a. Compute the payments at the beginning of each year (BOY) b. what is the loan balance at the end of...
This is to be done in excel (which I can do), but I am confused about...
This is to be done in excel (which I can do), but I am confused about which tail test to use and why to accept or reject H0- and the summary. According to research, holiday shoppers spent an average of $370 over a holiday weekend in 2008. The accompanying data show the amount spent by a random sample of holiday shoppers during the same weekend in 2009. Retailers were concerned that the economic downturn was affected holiday sales. Does this...
Show me how it is done in Excel if possible: A store has one counter. The...
Show me how it is done in Excel if possible: A store has one counter. The probability of inter-arrival time (in min) and service time (in min.) of customers are given in the following table. Distribution of time between Arrival Interarrival time(min) Probability Cumulative Probability Random Digit Assignment 1 0.13 2 0.15 3 0.03 4 0.17 5 0.06 6 0.14 7 0.15 8 0.09 9 0.19 10 0.08 Distribution of Service-Time Service Time(min) Probability Cumulative Probability Random Digit Assignment 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT