ing could be purchased for sole use by the corporation at a total price of $4.5 million, of which $900,000 of the purchase price would represent land value, and $3.6 million would represent building value. The cost of the building would be de

Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter13: Capital Budgeting: Estimating Cash Flows And Analyzing Risk
Section: Chapter Questions
Problem 1P: Talbot Industries is considering launching a new product. The new manufacturing equipment will cost...
icon
Related questions
Question

The ABC Corporation is considering opening an office in a new market area that would allow it to increase its annual sales by $2.5 million. The cost of goods sold is estimated to be 40 percent of sales, and corporate overhead would increase by $300,000, not including the cost of either acquiring or leasing office space. The corporation 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 costs of owning or leasing the office space.

 

A small office building could be purchased for sole use by the corporation at a total price of $4.5 million, of which $900,000 of the purchase price would represent land value, and $3.6 million would represent building value. The cost of the building would be depreciated over 39 years. The corporation is in a 21 percent tax bracket. An investor is willing to purchase the same building and lease it to the corporation for $450,000 per year for a term of 15 years, with the corporation paying all real estate operating expenses (absolute net lease). Real estate operating expenses are estimated to be 50 percent of the lease payments. Estimates are that the property value will increase over the 15-year lease term for a sale price of $5.0 million at the end of the 15 years. If the property is purchased, it would be financed with an interest-only mortgage for $3,150,000 at an interest rate of 4.5 percent with a balloon payment due after 15 years.

b. What is the return from opening the office building under the assumption that it is owned?

c. What is the return on the incremental cash flow from owning versus leasing?

clear explanation of problem and use of excel will be very appreciated 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
New Line profitability analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College