Concept explainers
An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,000 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,000 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,000 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense
stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI
adjustment that provides for the base rent to increase at half the increase in the CPI. The CPI is projected to increase by 3 percent per year. Estimated operating expenses for the next year include the following:
Property taxes $100,000
Insurance 10,000
Utilities 75,000
Janitorial 25,000
Maintenance 40,000
Total $250,000
All expenses are projected to increase by 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase by 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after the first leases expire, vacancy is estimated to be 10 percent of EGI for the last two years (years 4 and 5).
a. Project the effective gross income (EGI) for the next five years.
b. Project the expense reimbursements for the next five years.
c. Project the net operating income (NOI) for the next five years.
d. How much does the NOI increase (average compound rate) over the five years?
e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (“going-in” rate)?
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 6 images
- A lease agreement that qualifies as a finance lease calls for annual lease payments of $50,000 over a four-year lease term (also the asset's useful life), with the first payment on January 1, the beginning of the lease. The interest rate is 7%. The lessor's fiscal year is the calendar year. The lessor manufactured this asset at a cost of $144,000. Required: a. Determine the price at which the lessor is "selling" the asset (present value of the lease payments). b. Create a partial amortization table through the second payment on January 1, Year 2. c. What would be the increase in earnings that the lessor would report in its income statement for the first year ended December 31 (ignore taxes)? Note: Use tables, Excel, or a financial calculator. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Complete this question by entering your answers in the tabs below. Required A Required B Required C Determine the price at which the lessor is "selling" the asset (present value…arrow_forwardA store has 5 years remaining on its lease in a mall. Rent is $2,000 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to sell the property in a year and wants rent at that time to be high so that the property will appear more valuable. Therefore, the store has been offered a "great deal" (owner's words) on a new 5-year lease. The new lease calls for no rent for 9 months, then payments of $2,600 per month for the next 51 months. The lease cannot be broken, and the store's WACC is 12% (or 1% per month). Should the new lease be accepted? (Hint: Be sure to use 1% per month.) -Select-YesNoItem 1 If the store owner decided to bargain with the mall's owner over the new lease payment, what new lease payment would make the store owner indifferent between the new and old leases? (Hint: Find FV of the old lease's original cost at t = 9; then treat this as the PV of a 51-period annuity whose payments represent the rent during months 10 to 60.) Do not…arrow_forwardThe Sirap Co. leased equipment from the Xylo co. with a fair market value of $200,000. The lease contract has payments of $30,000 at the end of each year. The terms are 10 years at 10% interest rate. There is no bargain purchase agreement and the lessor will repossess the equipment. The equipment has a useful life of 15 years. Use the 5 criteria and determine if the lease qualifies as a financing lease.arrow_forward
- On 31 December 20X1, Lessee Ltd. entered into a lease agreement by which Lessee leased a jutling machine for six years. Annual lease payments are $20,000, payable at the beginning of each lease year (31 December). At the end of the lease, possession of the machine will revert to the lessor. The normal economic life for this type of machine is 8 to 10 years. At the time of the lease agreement, jutling machines could be purchased for approximately $90,000 cash. Equivalent financing for the machine could have been obtained from Lessee's bank at 14%. Lessee uses straight-line depreciation for its jutling machines. Required: 1. Prepare a lease liability amortization table for the lease. 2. Prepare all journal entries relating to the lease and the leased asset for 20X1, 20X2, and 20X3. 3. How would the amounts relating to the leased asset and lease liability be shown on Lessee's statement of financial position at 31 December 20X4?arrow_forwardA store has 5 years remaining on its lease in a mall. Rent is $2,000 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to sell the property in a year and wants rent at that time to be high so that the property will appear more valuable. Therefore, the store has been offered a "great deal" (owner's words) on a new 5-year lease. The new lease calls for no rent for 9 months, then payments of $2,750 per month for the next 51 months. The lease cannot be broken, and the store's WACC is 12% (or 1% per month). a. Should the new lease be accepted? (Hint: Be sure to use 1% per month.) No b. If the store owner decided to bargain with the mall's owner over the new lease payment, what new lease payment would make the store owner indifferent between the new and old leases? (Hint: Find FV of the old lease's original cost at t = 9; then treat this as the PV of a 51-period annuity whose payments represent the rent during months 10 to 60.) Do not round…arrow_forwardA six-year operating lease requires annual rent payments of $15,000 for years 1, 2, and 3, and annual rent payments of $10,000 for years 4, 5, and 6. The agreement also requires the lessor to pay a $2,800 annual insurance premium for the leased property. Which of the following amounts should be recognized as the rental revenue in year 1 by the lessor? O $10,000 O $16,800 $13,500 O $15,000arrow_forward
- Callaway Golf Co. leases telecommunications equipment from Sandhill Company. Assume the following data for equipment leased from Sandhill Company. The lease term is 5 years and requires equal rental payments of $30,380 at the beginning of each year. The equipment has a fair value at the commencement of the lease of $147,000, an estimated useful life of 8 years, and a guaranteed residual value at the end of the lease of $15,190. Sandhill set the annual rental to earn a rate of return of 6%, and this fact is known to Callaway. The lease does not transfer title or contain a bargain purchase option, and is not a specialized asset. How should Callaway classify this lease? ✓ Finance lease Operaing lease Sales-type leasearrow_forwardMasukharrow_forwardA local car dealer is advertising a standard 24-month lease of $900 per month for its new XT 3000 series sports car. The standard lease requires a down payment of $3,700, plus a $800 refundable initial deposit now. The first lease payment is due at the beginning of month 1. In addition, the company offers a 24-month lease plan that has a single up-front payment of $29,200, plus a refundable initial deposit of $800. Under both options, the initial deposit will be refunded at the end of month 24. Assume an interest rate of 6% compounded monthly. With the present-worth criterion, which option is preferred? The present worth of the standard lease option is $ (Round to the nearest dollar.)arrow_forward
- Sun company engaged in leasing a machine for quality control that requires payment of $2000 at the end of each month. The economic life of the machine is five years. sun company normally subject to 6% interest rate per year in business transactions assume lease period is 54 months provide the journal entry that must be made on the date. The lease contract is signed. arrow_forwardFor his business, Nicholas leased equipment valued at $19,000. The terms of the lease required payments of $1550 every month. If the first payment is due eighteen months after the lease was signed and interest is 5% compounded semi-annually, what is the term of the lease? State your answer in years and months (from 0 to 11 months).arrow_forwardYankee Construction agreed to lease payments of $762.79 on construction equipment to be made at the end of each month for six years. Financing is at 15% compounded monthly. a) What is the value of the original lease contract? b) If, due to delays, the first eight payments were deferred, how much money would be needed after nine months to bring the lease payments up to date? c) How much money would be required to pay off the lease after nine months?arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education