Question

In: Accounting

Please do not use excel or copy Estimate the present market value of a 10-unit apartment...

Please do not use excel or copy

Estimate the present market value of a 10-unit apartment house given the following information pertaining to the property.

Each apartment has 1000 square feet of living area, 3 bedrooms, and kitchen appliances. Tenants pay their own utilities. The value of the land is $250,000. The estimate replacement value is $100 per square foot for this type of construction. Total operating expenses insurance and property taxes for the year, $25,000. The rental income, $6000 month/allow 5% for vacancy and non-payment. Management fees are 6% of total rents collected. The building is 20 years old and has an estimate future useful life of 20 more years. A first mortgage is available at 6% for 75% of the purchase price. Equity will be used as the other 25% of the purchase price and the owner requires a return of 12% on the equity investment.

Compute the following:

A) Net income before capitalization

B) Capitalization rate adjusted for recapture

C) Estimated value of this property using the income approach

D) Estimated value using the replacement cost approach

Show all work.

Solutions

Expert Solution

A) Net Income before Capitalisation:

1. Rental INcome : @ $6000/Month for 10 Apartments for 1 year : $ 7,20,000

less vacancy allowance $36000

Balance: $6,84,000

less operating expenses - $25000

management fees 6% rent collected : $41040

Net Income: $617960 (A)

B) Capitalization rate adjusted for recapture

Mortgage Loan is available @6% for 75% price which works out to 4.5 % of the total investment.

income expected by the invester on his 25% equity is 12% which works out to be 3%. Therefore Total capitalisation can be at rate above 7.5%

C) Estimated value of this property using the income approach

for calculating capitalised value under income approach generally discounted cashflow method is abopted.

that is the present value of the future earnings shall be calculated. for this purpose discounting factor is to be known. In the question there is no discounting factor. So the same cannot be answered with provided data.

D) Estimated value using the replacement cost approach

The replacement cost given is $100/SQFT so each apartment may worth $100,000.

total cost of 10 apartment will be therefore $1,000,000. Adding land value of Rs. $250,000, total replacement cost will be $1,250,000

  


Related Solutions

19. PLEASE SHOW EXCEL WORK AND ANSWER ONLY B THANKS! Use future value and present value...
19. PLEASE SHOW EXCEL WORK AND ANSWER ONLY B THANKS! Use future value and present value calculations (Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C) to determine the following: a. The future value of a $600 savings deposit after eight years at an annual interest rate of 6 percent. (Round time value factor to 3 decimal places and final answer to 2 decimal places.)   Future value $   956.40 b. The future value of saving $1,800 a year for five years at an...
How do you calculate Profit Present Value in excel?
How do you calculate Profit Present Value in excel?
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test XYZ company is considering a new machine that costs $300,000 and would reduce pre-tax manufacturing costs by $108,000 annually. XYZ would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The net operating working capital...
PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company...
PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6-years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $350 [($2,100/6) = $350 per year]. If the old machine is not replaced, it can...
Copy the table to Excel then for each part using Excel formula to do the questions...
Copy the table to Excel then for each part using Excel formula to do the questions below and make sure to apply DCOVA, which stands for Define, Collect, Organize, Visualize, and Analyze. 1. Find the mean and standard deviation, 2. What did you observe and what that means in term of Cholesterol levels for a patient. 3. Find the five-number summary ( Minimum, Q1, Q2, Q3, and Maximum) 4. Interpret your result in term of cholesterol level 5. Find interquartile...
Explain why we can use the present value of a no-growth perpetuity to quickly estimate the...
Explain why we can use the present value of a no-growth perpetuity to quickly estimate the value of a relatively long-lived, no-growth financial asset. Make sure you provide a mathematical example.
Please do not use Excel to answer this. I need the computations as we are not...
Please do not use Excel to answer this. I need the computations as we are not allowed to use excel. Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $80,000 $312,000    $165,000    $78,500 $107,400 Square feet 1,500...
These numbers are in Lacs. Copy these numbers into excel and than divide all by 10...
These numbers are in Lacs. Copy these numbers into excel and than divide all by 10 to convert them into millions. Afterwards put copy them in your answer, please do not paste image but the numbers directly from excel so I can copy them again. Thanks              94,812.74            127,870.11              86,685.95            102,168.18                 1,243.98                 1,446.76                 1,616.11                 1,911.59                 6,369.91                 5,510.62                 4,340.45                 4,597.43              14,311.60              12,886.97                       33.07                       22.65                    254.66...
These numbers are in Lacs. Copy these numbers into excel and than divide all by 10...
These numbers are in Lacs. Copy these numbers into excel and than divide all by 10 to convert them into millions. Afterwards put copy them in your answer, please do not paste image but the numbers directly from excel so I can copy them again. Thanks 456080.96 457371.47 419888.65 13972.59 16600.31 15349.51 470053.55 473971.78 435238.16 100408.13 99986.42 91046.84 -506.09 -230.30 3119.72 90564.86 90540.82 81837.92 25778.70 22943.64 13305.03 23895.52 22217.86 22509.64 238302.21 231786.07 223482.74 478443.33 467244.51 435301.89 5315.95 48605.94 7247.23 -3073.83...
These numbers are in Lacs. Copy these numbers into excel and than divide all by 10...
These numbers are in Lacs. Copy these numbers into excel and than divide all by 10 to convert them into millions. Afterwards put copy them in your answer, please do not paste image but the numbers directly from excel so I can copy them again. Thanks                 6,662.76                 6,156.67                 6,003.54                 6,139.88              33,506.37              39,160.01              56,894.61              40,897.70              47,018.78              47,294.23              44,405.59              40,508.23              12,961.62              54,430.26              14,193.83              17,942.34                 9,005.52...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT