The holt lunsford commercial case

Assignment Help Corporate Finance
Reference no: EM132184238

Case Study - The "Holt Lunsford Commercial" Case

Read the "Holt Lunsford" case study and answer the below questions.

You are required to write at least 3 pages (font: 12; line spacing: 2).

- 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 thatStaton 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 (COGS): 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%. Capital gains tax is 15%.
- 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.
- The operating expenses per SF are the same as for the lease option.
- 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 no 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. Assume no selling costs.

Case reference - holt lunsford commercial by Arthur I SEGEL and JOHN H. VOGEL

Attachment:- Case Study.rar

Verified Expert

This is a short assignment which requires an excel calculation of two aspect lease and rent to define the fact that how the NPV is being estimated. Purely an excel assignment which helps in understanding how calculations can be justified in excel format.

Reference no: EM132184238

Questions Cloud

What are the most important us foreign policy goals : What are the most important US foreign policy goals? Which of these do you believe is the most important one?
Explain how you identified the social change problem : Explain how you identified the social change problem. Describe how you decided on what problem(s) to be considered.
Determine how has your understanding changed : Compare your understanding of social change and public policy before you began this course with your current understanding. Has your understanding changed.
How exactly does this power relate to the usa : If we conceive of the EU as a power in international relations, how exactly does this power relate to the USA and to US power in the 21st century?
The holt lunsford commercial case : 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?
Explaining the significance of the selected category : Describe the selected content and explain the significance of the selected category across all of the religions studied. Show in what ways the category.
What does public service mean to you : What does public service mean to you? What role do you see yourself playing in public service? How will you measure your success?
Numbers and calculate the average : ry a program that prompt the user to enter five positive numbers and calculate the average. When a negative number is entered, program will be terminated.
Definition of assistive technology : Definition of Assistive Technology (AT) and how a student qualifies for AT (discuss the Assistive Technology Act);

Reviews

len2184238

12/3/2018 3:01:31 AM

Please note, I only need some corrections made to my spreadsheet. Please see the markups written in Red from my Professor. For example, adjustments made to Operations Expenses, Depreciation Formula, and WACC and Discounted Cash Flow for Buy vs. Lease Options to name a few. Since I only need those corrections, I have have reflected that in my expected cost. Also, please make any other adjustments necessary.

Write a Review

Corporate Finance Questions & Answers

  Identify a multi­category nominal variable

Perform a multiple regression analysis including a set of dummy variables built from a multi­category nominal variable - brief interpretation of the descriptive stat that you have obtained using Pivot Table and the frequency distribution.

  The machine has a book value

Xinhong Company is considering replacing one of its manufacturing machines. The machine has a book value of $ 45,000 and a remaining useful life of 5 years, at which time its salvage value will be zero.

  Questionthe medical centre tender selection panel have

questionthe medical centre tender selection panel have provided you with some estimated figures of the number of

  What is bond rating

What is bond rating and what is the current price of these bonds if required rate is 12 per cent per annum?

  Geocentric approaches to staffing

Explain the polycentric, ethnocentric, and geocentric approaches to staffing.

  Value for the hospitals investors

If interest rates rise over the next year, which bond will lose the most value and explain why the higher rated bond, Salt Lake City Revenue Bond, has a negative yield to maturity (YTM) - Discuss whether this project would add value for the hospital'..

  Corporate return

Corporate Return

  Find the investing amount

An individual who is 22 years old wins an amount of 5000$. He invests the money at 8% compounded quarterly for 43 years until he stop working. When he retires he invests the money at 7 percent compounded monthly.

  Find out on raytheon balance sheet

Find out on Raytheon Balance Sheet the total short term liabilities (short term debt) and long term liabilities and find out the numbers of shares outstanding, and the recent price per share

  What is the irr of the project

What is the IRR of the project and what is the NPV of the project, based on the required rate of return of 12%

  Multiple choice questions related to financial deregulation

Determine which of the following was not part of the financial deregulation of the 1970 and 1980?

  Determine the service-related variance for surgical volume

Determine the service-related variance for Surgical Volume. Determine service-related variance for Patient Days. Prepare a flexible budget estimate. Present side-by-side budget, flexible budget estimate, and the actual Surgical Revenues.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd