Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the return from opening the office building under the assumption that it is leased? A company is considering opening an office and is

image text in transcribed

What is the return from opening the office building under the assumption that it is leased?

A company is considering opening an office and is trying to decide if the new office should be owned or leased. The company will have to invest $2.5 million in office furniture, office equipment, and other up-front costs associated with opening the new office before considering the cost of owning or leasing the office space. This new office will allow the company to increase its annual sales by $2.5 million of which the cost of goods sold is expected to be 70% of sales and corporate overhead would increase by $300,000, not including the cost of cither acquiring or leasing the office space. Cash flows for owning versus leasing are estimated as follows. Assume that the cash flows from operations will remain the same level over a 15-year holding period. If purchased, the company will need $4.5 million as purchase price, where the company plans to invest $1.35 million in equity and finance the rest (70% LTV) with an interest-only loan at the rate of 4.5% that has a balloon payment due when the property is sold. The land value of the $4.5 million purchase price is $900,000 and the remainder is the building value which will be depreciated over 39 years. The company is in a 21% tax bracket. The company can lease it alternately for $450,000 per year for a period of 15 years, with the company paying all the operating expenses. Operating expenses are estimated to be 50% of the annual lease payments. Estimates are that the property value will increase to $5 million at the end of 15 years. The after-tax cash flow from sale of the property at the end of year 15 is expected to be $1,454,231. The own versus lease information can be summarized as below. Personal Property $2,500,000 $2,500,000 Own Lease $2,500,000 $1,000,000 $1,500,000 $2,500,000 $1,000,000 $1,500,000 $300,000 $225,000 Sales Cost of Goods Sold Gross Income Operating Expenses Business Real Estate Lease Payments Interest Depreciation Taxable Income Tax Income After Tax Plus: Depreciation After-tax Cash Flow $300,000 $225,000 $450,000 $141,750 $92,308 $740,942 $155,598 $585,344 $92,308 $677,652 $525,000 $110.250 $414,750 $414,750 Purchase Price Company's Investment Equity Sale Price in 15 Years ATCF Sale in Year 15 $4,500,000 $1,350,000 $5,000,000 $1,454,231 What is the return from opening the office building under the assumption that it is owned? (round your final answer to 2 decimals)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Structured Finance

Authors: Ann Rutledge, Sylvain Raynes

1st Edition

0195179986, 978-0195179989

More Books

Students also viewed these Finance questions