Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Case Analysis You find a place in Woodward, OK. The doctor will sign a new lease at closing (i.e. it is a sale leaseback). The

Case Analysis You find a place in Woodward, OK. The doctor will sign a new lease at closing (i.e. it is a sale leaseback). The lease will be for twenty years. It is listed at $3,300,000, but you haggle the price down to a 7.35% acquisition cap rate. In year one you will receive $242,400 in rent. You must front all the expenses below. However, the tenant will reimburse you for everything but 18,000 of the real estate taxes (i.e. for taxes, tenant is responsible for everything above 18,000). Expenses in year one are 4,500 for insurance, 2,500 for snow removal, 3,000 in repairs, and 37,000 in real estate taxes (use the rent and expenses to calculate NOI in order to figure out your purchase price). You project you will need 10,000 of capex every 5 years. Rent will increase by 2% and expenses at 3%. For financing, you will purchase at a 75% loan to value. The interest rate will be 6.5%. The loan will be amortized over 25 years. Acquisition closing costs will be 1.5% and disposition closing costs will be 5.5%. You will sell at the end of year 6 at an 8.10% cap rate. The property is 4,500 sq ft. What is the percentage difference between allequity and leveraged IRR? Please answer in Excel

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

The Analysis And Use Of Financial Statements

Authors: Gerald I. White, Ashwinpaul C. Sondhi, Haim D. Fried

3rd Edition

0471375942, 978-0471375944

More Books

Students also viewed these Finance questions