Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Effective RentThis project requires you to compute the effective rent per square foot for a seven - year lease of office space. Assume a discount
Effective RentThis project requires you to compute the effective rent per square foot for a sevenyear lease of office space. Assume a discount rate of percent. In your report, describe which rent type should be chosen to maximize the price per square foot and which should be chosen to minimize the price per square foot.A Gross Lease with Flat RentRent will be $ per rentable square foot each year. The lessor owner will be responsible for the payment of all operating expenses. Expenses are estimated to be $ during the first year and will increase by $ per year thereafter. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsB Gross Lease with Expense StopRent will be $ per rentable square foot per year with the lessor responsible for payment of recoverable operating expenses as identified in the lease, up to an expense stop of $ per square foot. Lessee pays all expenses in excess of $ per square foot. Expenses are estimated to be $ during the first year and will increase by $ per year thereafter. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsC Gross Lease with Year Rent FreeRent during the first year is free. Thereafter, rent will be $ per rentable square foot each year. The lessor owner will be responsible for the payment of all operating expenses. Expenses are estimated to be $ during the first year and will increase by $ per year thereafter. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsD Gross Lease with Months Rent Free and StepsRent will be $ per rentable square foot the first year and will increase by $ per year. Rent during the first months is free. The lessor owner will be responsible for the payment of all operating expenses. Expenses are estimated to be $ during the first year and will increase by $ per year thereafter. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsE Gross Lease with Step Up RentsRent will be $ per rentable square foot in year and will increase by $ per square foot each year thereafter. Operating expense will be $ per square foot in year and will increase by $ per year. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsF Gross Lease with Step Up Rents and Expense StopRents will be $ per square foot and will increase by $ per year. Operating expenses will be $ and will increase by $ per year. The tenant will pay the owner will recover all increases in operating expense above a $ expense stop. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsG Gross Lease with Expense Stop and CPI AdjustmentRent will be $ per rentable square foot the first year and will increase by the CPI after the first year with an expense stop at $ per square foot. The CPI is estimated to be each year. Operating expenses are assumed to be $ per square foot in year and will increase by $ per year thereafter. Apply the Excel NPV and PMT functions to calculate the present value and effective net rent per square foot, respectively. PointsNote: An expense stop implies that the owner will recover the amount above the expense stop. For example, if an expense stop of $ exists and the operating expense is $ then the recovery is $Formula: Net rent Gross rent Operating expenses Recoveries A Gross Lease with Flat Rent
Year
Gross Rent
Operating Expenses
Recoveries
Net Rent
Present Value
Effective Net Rent
B Gross Lease with Expense Stop
Year
Gross Rent
Operating Expenses
Recoveries
Net Rent
Present Value
Effective Net Rent
C Gross Lease with Year Rent Free
Year
Gross Rent
Operating Expenses
Recoveries
Net Rent
Present Value
Effective Net Rent
D Gross Lease with Months Rent Free and Steps
Year
Gross Rent
Operating Expenses
Recoveries
Net Rent
Present Value
Effective Net Rent
uuE Gross Lease with Step Up Rent
use Year
Gross Rent
Operating Expenses
Recoveries
Net Rent
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started