Project #158585 - Real Estate Case Study

Business Tutors

Subject Business
Due By (Pacific Time) 12/06/2016 12:00 am

I need a 3 page essay double spaced and an excel file using the case attached with the instructions below:  PLEASE REVIEW CAREFuLLY BEFORE BIDDING.   THE LAST SCHOLAR CANCELLED ON THE DUE DATE.

 

·       Based on the information provided in the case study, do you recommend Staton Tees to remain in the Welch building, irrespective of financing method, or relocate to a newly built facility in a different location? Discuss your rationale based on considerations, for example, with regard to the long-term strategy, operational needs of the firm and property market conditions.

·       Assuming that Staton Tees decides to remain in the Welch building, which financing method should they choose? To make your recommendations, discuss

1)                   Strategic considerations with regard to the financing options.

 

2)                   Financial considerations by conducting a DCF for each financing option.

 

·       For the DCF, use the information provided in the case study and conduct a lease vs. buy analysis on a after-tax basis and using the Income Statement approach. Please feel free to make assumptions if needed (e.g. regarding the roof replacement).

 

Business Assumptions:

 

·       Sales: In 2012, Staton’s sales were $223million. Over the next 5 years, sales are expected to increase by 5% per year and then increase by 3% for the next 5 years.

·       Cost of Goods Sold (CGS): Cost of goods sold are expected to remain at 40% of total sales for the next 10 years.

·       Business expenses: Non-real estate business expenses are expected to be 11.5% of total sales for the next 10 years.

·       Income tax: The corporate income tax for Staton is 35%.

 

·       Discount rate: Staton requires a return of 15% (after tax).

 

 

 

Lease option:

 

·       Assume a 10-year NNN lease with occupancy cost of $4.5 per SF ($3/SF rent; operating expenses of $1.5/SF) and a 3% inflation adjustment every 3 years.

 Buy option:

 ·       Assume a purchase price of $4,048,300. The building value represents 80% of the purchase price and a straight-line depreciation over 39 years should be used.

·       Assume that Staton is not interested in full recourse short-term debt financing option and decides to finance the acquisition with a 75% LTV mortgage at 5% for 25 years (monthly compounding, fully amortizing). Assume 2% closing costs.

 

·       The firm expects to sell the building in year 10. The sales price for the building is expected to be $5,985,000 in year 10 and Staton will have to pay 2% in closing costs.

TutorRating
pallavi

out of 1971 reviews
amosmm

out of 766 reviews
PhyzKyd

out of 1164 reviews
rajdeep77

out of 721 reviews
sctys

out of 1600 reviews
sharadgreen

out of 770 reviews
topnotcher

out of 766 reviews
XXXIAO

out of 680 reviews