You are required to value a new business, West Pentire Apartments Ltd, which involves the acquisition...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are required to value a new business, West Pentire Apartments Ltd, which involves the acquisition of a new complex of residential apartments to let. You must forecast the annual financial statements over a 6-year horizon, and perform a discounted cash flow valuation of the business. Further information about the business is provided below. Non-Current Assets: • Land and improvements: £6,820,000 • Buildings and improvements: £11,100,000 Furnishings and equipment: £214,000 - Furnishing and Equipment has a useful life 6 years Furnishing and equipment has no residual values The straight-line depreciation method is used Equity and Long-Term Debt: • Long-term loan: £7,500,000 Income . Number of years: 25 years (repaid in equal installments) Interest rate: 6.0% per annum Equity (capital contributed by the owners): £11,500,000 Number of shares outstanding: 12,000 Expected return on equity: 10.5% per annum Apartment units: Two-Bedroom apartment: 55 units - One-Bedroom apartment: 150 units - Studio apartment: 85 units Monthly rents for the first year: Two-Bedroom apartment: £1800 per month One-Bedroom apartment: £945 per month Studio apartment: £650 per month The expected vacancy rates are shown below: Year 1 5.0% Estimated vacancy rates for each year Year 5 Year 2 4.5% 4.0% Year 3 Year 4 3.5% 3.5 % Monthly rents are expected to increase each year as shown below: Estimated increase in rents for each year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 n/a 4.0% 4.0% 3.0% 2.0% 2.0% Expenses • The operating expenses for the first year are shown below: Expense Management fees Salary expense Utilities Insurance Supplies Advertising Maintenance and repairs Property taxes Year 1 5.0% of EGI £55,000 £35,000 Year 6 3.5% £10,000 £10,000 £15,000 £105,000 £155,000 Expenses . . n/a Other Information • • 4.0% 4.0% 3.0% • Management fees are equal to 5.0% of Effective Gross Income (EGI). EGI is defined in the financial statement structure provided in Appendix C . The operating expenses for the first year are shown below: Expense • Property taxes are expected to increase to £205,000 for Year 5 onwards. . Management fees Salary expense Utilities 2.0% Insurance Supplies Advertising Maintenance and repairs Property taxes Year 1 5.0% of EGI £55,000 £35,000 £10,000 £10,000 £15,000 £105,000 £155,000 2.0% • The tenant deposit amounts for each year are shown below: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 £112,860 £117,992 £123,354 £127,717 £130,271 £132,876 E132,876 All other operating expenses (i.e. excluding management fees and property taxes) are expected to increase each year at 2.0% per annum. All long-term debt and equity will be issued by the end of Year 0. All capital expenditures will be made by the end of Year 0. Each year, the closing receivables balance is 5.0% of EGI, and the closing payables balance is 5.0% of operating expenses excluding depreciation. Corporation tax is equal to 20% of income before tax. The business only pays corporation tax if it is making a profit. The company's weighted average cost of capital (WACC) should be calculated using book values for Year 0. Assume that the company's WACC is constant each year. After Year 6, the free cash flow of the business will grow at the perpetuity growth rate of 2.0% per annum. 6 Expenses . . n/a Other Information • • 4.0% 4.0% 3.0% • Management fees are equal to 5.0% of Effective Gross Income (EGI). EGI is defined in the financial statement structure provided in Appendix C . The operating expenses for the first year are shown below: Expense • Property taxes are expected to increase to £205,000 for Year 5 onwards. . Management fees Salary expense Utilities 2.0% Insurance Supplies Advertising Maintenance and repairs Property taxes Year 1 5.0% of EGI £55,000 £35,000 £10,000 £10,000 £15,000 £105,000 £155,000 2.0% • The tenant deposit amounts for each year are shown below: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 £112,860 £117,992 £123,354 £127,717 £130,271 £132,876 E132,876 All other operating expenses (i.e. excluding management fees and property taxes) are expected to increase each year at 2.0% per annum. All long-term debt and equity will be issued by the end of Year 0. All capital expenditures will be made by the end of Year 0. Each year, the closing receivables balance is 5.0% of EGI, and the closing payables balance is 5.0% of operating expenses excluding depreciation. Corporation tax is equal to 20% of income before tax. The business only pays corporation tax if it is making a profit. The company's weighted average cost of capital (WACC) should be calculated using book values for Year 0. Assume that the company's WACC is constant each year. After Year 6, the free cash flow of the business will grow at the perpetuity growth rate of 2.0% per annum. 6 4. The business is considering charging tenants for parking in addition to rent. Parking cost/unit is £2,500 per year. Create a new worksheet named "Parking" and calculate the annual net income figures, with parking included. Provide a suitable chart to compare net income with and without parking. 9/12 ... ... You are required to value a new business, West Pentire Apartments Ltd, which involves the acquisition of a new complex of residential apartments to let. You must forecast the annual financial statements over a 6-year horizon, and perform a discounted cash flow valuation of the business. Further information about the business is provided below. Non-Current Assets: • Land and improvements: £6,820,000 • Buildings and improvements: £11,100,000 Furnishings and equipment: £214,000 - Furnishing and Equipment has a useful life 6 years Furnishing and equipment has no residual values The straight-line depreciation method is used Equity and Long-Term Debt: • Long-term loan: £7,500,000 Income . Number of years: 25 years (repaid in equal installments) Interest rate: 6.0% per annum Equity (capital contributed by the owners): £11,500,000 Number of shares outstanding: 12,000 Expected return on equity: 10.5% per annum Apartment units: Two-Bedroom apartment: 55 units - One-Bedroom apartment: 150 units - Studio apartment: 85 units Monthly rents for the first year: Two-Bedroom apartment: £1800 per month One-Bedroom apartment: £945 per month Studio apartment: £650 per month The expected vacancy rates are shown below: Year 1 5.0% Estimated vacancy rates for each year Year 5 Year 2 4.5% 4.0% Year 3 Year 4 3.5% 3.5 % Monthly rents are expected to increase each year as shown below: Estimated increase in rents for each year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 n/a 4.0% 4.0% 3.0% 2.0% 2.0% Expenses • The operating expenses for the first year are shown below: Expense Management fees Salary expense Utilities Insurance Supplies Advertising Maintenance and repairs Property taxes Year 1 5.0% of EGI £55,000 £35,000 Year 6 3.5% £10,000 £10,000 £15,000 £105,000 £155,000 Expenses . . n/a Other Information • • 4.0% 4.0% 3.0% • Management fees are equal to 5.0% of Effective Gross Income (EGI). EGI is defined in the financial statement structure provided in Appendix C . The operating expenses for the first year are shown below: Expense • Property taxes are expected to increase to £205,000 for Year 5 onwards. . Management fees Salary expense Utilities 2.0% Insurance Supplies Advertising Maintenance and repairs Property taxes Year 1 5.0% of EGI £55,000 £35,000 £10,000 £10,000 £15,000 £105,000 £155,000 2.0% • The tenant deposit amounts for each year are shown below: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 £112,860 £117,992 £123,354 £127,717 £130,271 £132,876 E132,876 All other operating expenses (i.e. excluding management fees and property taxes) are expected to increase each year at 2.0% per annum. All long-term debt and equity will be issued by the end of Year 0. All capital expenditures will be made by the end of Year 0. Each year, the closing receivables balance is 5.0% of EGI, and the closing payables balance is 5.0% of operating expenses excluding depreciation. Corporation tax is equal to 20% of income before tax. The business only pays corporation tax if it is making a profit. The company's weighted average cost of capital (WACC) should be calculated using book values for Year 0. Assume that the company's WACC is constant each year. After Year 6, the free cash flow of the business will grow at the perpetuity growth rate of 2.0% per annum. 6 Expenses . . n/a Other Information • • 4.0% 4.0% 3.0% • Management fees are equal to 5.0% of Effective Gross Income (EGI). EGI is defined in the financial statement structure provided in Appendix C . The operating expenses for the first year are shown below: Expense • Property taxes are expected to increase to £205,000 for Year 5 onwards. . Management fees Salary expense Utilities 2.0% Insurance Supplies Advertising Maintenance and repairs Property taxes Year 1 5.0% of EGI £55,000 £35,000 £10,000 £10,000 £15,000 £105,000 £155,000 2.0% • The tenant deposit amounts for each year are shown below: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 £112,860 £117,992 £123,354 £127,717 £130,271 £132,876 E132,876 All other operating expenses (i.e. excluding management fees and property taxes) are expected to increase each year at 2.0% per annum. All long-term debt and equity will be issued by the end of Year 0. All capital expenditures will be made by the end of Year 0. Each year, the closing receivables balance is 5.0% of EGI, and the closing payables balance is 5.0% of operating expenses excluding depreciation. Corporation tax is equal to 20% of income before tax. The business only pays corporation tax if it is making a profit. The company's weighted average cost of capital (WACC) should be calculated using book values for Year 0. Assume that the company's WACC is constant each year. After Year 6, the free cash flow of the business will grow at the perpetuity growth rate of 2.0% per annum. 6 4. The business is considering charging tenants for parking in addition to rent. Parking cost/unit is £2,500 per year. Create a new worksheet named "Parking" and calculate the annual net income figures, with parking included. Provide a suitable chart to compare net income with and without parking. 9/12 ... ...
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these organizational behavior questions
-
You are required to produce an Illustrated report demonstrating your understanding of plant biology. Your report must cover the areas outlined below. SECTION ONE Explain the differences between...
-
You are required to discuss two 2 different CCA classes and give examples Discuss whether you believe the amount allowed as a deduction is an advantage or disadvantage for the taxpayer and why
-
You are required to prepare two written responses: 1) tax file memorandum and 2) client letter. For the tax memorandum file, use exhibit 2.9 on page 2-27 for an example
-
(1) How Does Strategy Respond to Environmental Factors Imprima Corporation is based in the United States and is examining the prospects for expanding into international markets with its main product,...
-
1. How is training at Jack B. Kelley related to its organizational needs? 2. If you were involved in preparing JBKs safety training program, how would you assess employees readiness for training? In...
-
Revise BST in Listing 25.5, using a generic parameter and a Comparator for comparing objects. Define a new constructor with a Comparator as its argument as follows:BST(Comparator comparator) Listing...
-
Can the environmental impacts of one EIA centre be linked to the environmental impacts of another EIA centre? Provide an example to confirm your view? Do any control or responsibility problems arise?...
-
Pettit Company reports net income of $90,000 in 2014. However, ending inventory was understated $7,000. What is the correct net income for 2014? What effect, if any, will this error have on total...
-
How does Twitter's performance stack up with Facebook and Snap? Is there a clear winner based on the analysis?Explain
-
Suppose a firm runs a tournament compensation scheme for two workers where each worker gets base pay a and the worker who produces more output gets a prize S . Output for each worker i is Q i =dE i +...
-
ASSIGNMENT Jay, Kay and Ray share profits and losses in the ratio 2:2:1 respectively. On 31 March 2021, their Statement of Financial Position was as follows: Statement of Financial Position at 31...
-
Which of the following is an example of a corporate governance responsibility that AMCs board of directors has failed to meet? A. Ensure that the board adequately monitors and oversees the companys...
-
All of the following indicate Zeros boards lack of independence except: A. personal relationships. B. service of the outside counsel as a board member. C. lack of interlocking directorships. Jane...
-
Shirley Shea has evaluated an investment proposal and found that its payback period is one year, it has a negative NPV, and it has a positive IRR. Is this combination of results possible? A. Yes. B....
-
The after-tax operating cash flows in euros for the Fontenot Company are: A. 50 in both years. B. 70 in both years. C. 85 in both years. Linda Pyle is head of analyst recruiting for PPA Securities....
-
Erin Chou is reviewing a profitable investment project that has a conventional cash flow pattern. If the cash flows for the project, initial outlay, and future after-tax cash flows all double, Chou...
-
When collectibility of lease payments is not probable, ASC 842 requires Multiple select question. a lessor to recognize a lease deposit liability for cash payments received from the lessee. a lessor...
-
H.J. Heinzs annual dividends were as follows: 1990 ..............$0.540 1991.............. 0.620 1992 .............. 0.700 1993.............. 0.780 1994 .............. 0.860 1995 .............. 0.940...
-
Jerry made the following contributions during 2012: His synagogue (by check).....................................................$680 The Democratic Party (by check)...
-
In 2012, Michael has net short-term capital losses of $2,000, a net long-term capital loss of $45,000, and other ordinary taxable income of $45,000. a. Calculate the amount of Michael's deduction for...
-
Skyler is covered by his company's health insurance plan. The health insurance costs his company $3,500 a year. During the year, Skyler is diagnosed with a serious illness and the health insurance...
-
If X is a binomial random variable with n trials and success probability p, the standard deviation of X is X = __________________ . In Exercises 57, fill in each blank with the appropriate word or...
-
Refer to Problem 5. Find the standard deviation of the number of pets. Problem 5 The following table presents a probability distribution for the number of pets each family has in a certain...
-
Following is the probability distribution for the age of a student at a certain public high school. a. Find the variance of the ages. b. Find the standard deviation of the ages. x 13 14 15 16 17 18...
Study smarter with the SolutionInn App