Question: How would I go about computing this lease expiration schedule? please show work and formulas for excel if possible Tenant Rent Schedule Tenants Total SF

How would I go about computing this lease expiration schedule? please show work and formulas for excel if possible

How would I go about computing this lease

Tenant Rent Schedule Tenants Total SF Accel USA, Inc 75.000 Rocky Mountain Health 10,000 Forum Medicine 7,500 Eisenhower Foundation 10,000 Custom Pharmacy 2,500 Premier Health 5,000 Jane Gutenberg, MD 2,500 Gonzaga Pharma 17,500 Concord College 15,000 Alamo Research 15,000 Vacant 40,000 Totals/Avgs 200,000 Percent of Building SF 37.5% 5.0% 3.8% 5.0% 1.3% 2.5% 1.3% 8.8% 7.5% 7.5% 20.0% 100.0% Annual Rent $1,125,000 $240,000 $206,250 $250,000 $75,000 $137,500 $82,500 $315,000 $300,000 $337,500 $0 $3,068,750 Expiration Year 2025 2026 2024 2021 2022 2023 2022 2028 2026 2023 N/A Using the data from Tenant Rent Schedule above, complete the Lease Expiration Schedule below. Then, calculate the average Rent PSF for the building weighted to Total SF: Year of Expiration Accel USA, Inc Rocky Mountain Health Forum Medicine Eisenhower Foundation Custom Pharmacy Premier Health Jane Gutenberg, MD Gonzaga Pharma Concord College Alamo Research Vacant Totals: Averages: Calendar Year 2025 2026 2024 2021 2022 2023 2022 2028 2026 2023 N/A Total SF 75,000 10,000 7,500 10,000 2,500 5,000 2,500 17,500 15,000 15,000 40,000 200,000 18,182 Lease Expiration Schedule Percent of Building # of Tenants 37.5% 1 5.0% 1 3.8% 1 5.0% 1 1.3% 1 2.5% 1 1.3% 1 8.8% 1 7.5% 1 7.5% 1 20.0% 1. 100% 11 9.1% 1 Annual Rent $1,125,000 $240,000 $206,250 $250,000 $75,000 $137,500 $82,500 $315,000 $300,000 $337,500 $0 $3,068,750 $278,977 Rent PSF $15.00 $24.00 $27.50 $25.00 $30.00 $27.50 $33.00 $18.00 $20.00 $22.50 $0.00 $242.50 $22.05 % of Total Rent 36.7% 7.8% 6.7% 8.1% 2.4% 4.5% 2.7% 10.3% 9.8% 11.0% 0.0% 100% 9.1%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I need an expert for this. please check info for details. For exclusive use Florida International University, 2015 REVISED SEPTEMBER 6, 2013 CRAIG FURFINE KEL757 The Return of the Loan: Commercial...

Create an Excel and show formulas that answer the questions below given the case study. This is all the information given, please work with what is there Case Study: Transaction Summary You are the...

PLEASE DO IN EXCEL IF POSSIBLE. WHATEVER IS EASIER BUT INCLUDE NUMBERS AND POSSIBLY GENERIC FORMULAS FOR HOW IT WAS FOUND. Anything helps Sweats Galore, Inc. 1 The Business Situation After graduating...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

IN REGARDS TO THE TWO CASES PROVIDED BELOW, For this assignment, please draft on the following topic: UNAUTHORIZED PRACTICE OF LAW ( UPL) and the practical applications of UPL in the real world The...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

You have purchased land and a building shell (fire gutted). The property is located at 850 East 55 th Street, New York, New York, and you plan to demolish the existing building and construct a new...

-- create database and tables create database expandedbookbiz go use expandedbookbiz go create ta... -- create database and tables create database expandedbookbiz go use expandedbookbiz go create...

SQL Exercise Using the given query below and write queries (with subqueries) to answer the following questions. 1. Which publishers haven't published a cook book? 2. Which publisher has the highest...

-- create database and tables create database expandedbookbiz go use expandedbookbiz go create table authors ( au_id char(11) not null primary key, au_lname varchar(40) not null, au_fname varchar(20)...

The following trial balance was drawn from the records of Havel Company as of October 1, 2010. Required a. Divide the class into groups, each with four or five students. Organize the groups into...

. Prove that each of the following operations is associative. (a) The intersection operation on the power set P(X) of a set X. (Hint: You need to prove (An B) nC = An (BNC) for all A, B, C = P(X)....

I need the correct answer to this general accounting problem using the standard accounting approach. Hamilton Industries Inc.'s year-end 2024 balance sheet lists the following: Current assets:...

Central Banks are responsible for setting interest rates not the value of the domestic currency.The Bank of Canada doesn't try to set the dollar's exchange rate. "We let markets set its value....