23 I have a 5,200 square foot tenant space that I am trying to lease at...
Fantastic news! We've Found the answer you've been seeking!
Question:
![23 I have a 5,200 square foot tenant space that I am trying to lease at one of our centers. Three tenants](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/659bd94309da5_1704712511503.jpg)
Transcribed Image Text:
23 I have a 5,200 square foot tenant space that I am trying to lease at one of our centers. Three tenants have expressed an interest in leasing the space. Two of the tenants require some upfront money from us to move in, while the third tenant does not. This third tenant, however, will not pay as much in rent as the other two. Details on the projected rents from the tenants and the amounts we are to invest upfront are shown below. Using any one of the 3 primary capital budgeting analysis methods (NPV, IRR and/or MIRR) you feel is best and most appropriate, evaluate the three tenants and tell me which of the three tenants I should pursue. My cost of capital is 9.0%. Be sure to show me how you arrived at your conclusion using the tools of Excel. You can use this spreadsheet to set up your calculations if you so desire. As a second part to this for 10 points, describe what you would have needed to do to determine the best Tenant if one tenant was goiing to lease the space for only four 4 years and the other two were going to lease for 7 years? 5 Cost of Capital: 9.0% 8 Tenant 1-Fivebucks Coffee and Tea H86879 9 nitial upfront cost ($100,000) Year 1 rents: $80,000 Year 2 rents: $95,000 Year 3 rents: $100,000 Year 4 rents: $105,000 Year 5 rents: $120,000 10 11 12 13 14 15 16 17 Tenant 2-CheeseBurger King 18 nitial upfront cost ($40,000) Year 1 rents: $75,000 $75,000 $75,000 Year 2 rents: Year 3 rents: Year 4 rents: Year 5 rents: $75,000 $75,000 2288823 19 20 21 PROBLEM - CAPITAL BUDGETING (30 POINTS) 24 25 26 Tenant 3-Old McDonalds 27 nitial upfront cost 28 Year 1 rents 29 30 31 32 33 Year 2 rents: Year 3 rents: Year 4 rents Year 5 rents $0 $65,000 $70,000 $75,000 $80,000 $85,000 23 I have a 5,200 square foot tenant space that I am trying to lease at one of our centers. Three tenants have expressed an interest in leasing the space. Two of the tenants require some upfront money from us to move in, while the third tenant does not. This third tenant, however, will not pay as much in rent as the other two. Details on the projected rents from the tenants and the amounts we are to invest upfront are shown below. Using any one of the 3 primary capital budgeting analysis methods (NPV, IRR and/or MIRR) you feel is best and most appropriate, evaluate the three tenants and tell me which of the three tenants I should pursue. My cost of capital is 9.0%. Be sure to show me how you arrived at your conclusion using the tools of Excel. You can use this spreadsheet to set up your calculations if you so desire. As a second part to this for 10 points, describe what you would have needed to do to determine the best Tenant if one tenant was goiing to lease the space for only four 4 years and the other two were going to lease for 7 years? 5 Cost of Capital: 9.0% 8 Tenant 1-Fivebucks Coffee and Tea H86879 9 nitial upfront cost ($100,000) Year 1 rents: $80,000 Year 2 rents: $95,000 Year 3 rents: $100,000 Year 4 rents: $105,000 Year 5 rents: $120,000 10 11 12 13 14 15 16 17 Tenant 2-CheeseBurger King 18 nitial upfront cost ($40,000) Year 1 rents: $75,000 $75,000 $75,000 Year 2 rents: Year 3 rents: Year 4 rents: Year 5 rents: $75,000 $75,000 2288823 19 20 21 PROBLEM - CAPITAL BUDGETING (30 POINTS) 24 25 26 Tenant 3-Old McDonalds 27 nitial upfront cost 28 Year 1 rents 29 30 31 32 33 Year 2 rents: Year 3 rents: Year 4 rents Year 5 rents $0 $65,000 $70,000 $75,000 $80,000 $85,000
Expert Answer:
Answer rating: 100% (QA)
To evaluate the three tenants and determine which one to pursue we can use the Net Present Value NPV ... View the full answer
Related Book For
Business Law Text and Cases
ISBN: 978-1285185248
13th edition
Authors: Kenneth Clarkson, Roger LeRoy Miller, Frank Cross
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
During the fiscal year ended June 3 0 , 2 0 X 3 , West City Council authorized construction of a new city hall building and the sale of serial bonds to finance the construction. The following...
-
Tasty Foods Corporation is a food conglomerate with major product lines of cereals, frozen dinners, and canned sodas and fruit juices. The firm was founded in 1965 by Henry Abercrombie, an ambitious...
-
In Exercises 7582, express the given function h as a composition of two functions f and g so that h(x) = (f g)(x). h(x) = x-9
-
Carreker, Inc., has a number of divisions, including the Alamosa Division, producer of surgical blades, and the Tavaris Division, a manufacturer of medical instruments. Alamosa Division produces a...
-
Use inductive reasoning to predict the next three numbers or figures in the pattern. 6, 3, 3/2, 3/4 , . . .
-
Explain the primary difference between a commercial bank and a thrift as depository institutions.
-
Peter and Tanya Rothing operated Diamond R Stables near Belgrade, Montana, where they bred, trained, and sold horses. Arnold Kallestad owned a ranch in Gallatin County, Montana, where he grew hay and...
-
Please answer! Thanks! What is the risk-return trade-off? Comment on "Investment of high risk will generate high return
-
1. How many minutes, on average, does it takes for a first-edition patron to get the requested book from time of entry into the library? (State all assumptions and show the calculations.) 2. How many...
-
Alpha Corporation issued 60,000 shares of $5 par value common stock for cash $375,000. In doing the entry what would you credit to Paid in Capital in Excess of Par - Common Stock?
-
A company which manufactures microwaves advertises that 90% of their microwaves are flawless, requiring no adjustments. Their quality control department tests this percentage on a regular basis. On...
-
A new retail store is being planned for a site that contains 40 ft of soft clay (c 0.075 ft2/day, y = 100 pcf). The clay layer is overlain by 15 ft of sand (y = 112 pcf) and is underlain by dense...
-
Perez Bags (PB) is a designer of high-quality backpacks and purses. Each design is made in small batches. Each spring, PB comes out with new designs for the backpack and for the purse. The company...
-
Find a recent (within the last 12 months) article or economic blog related to price fixing, provide an executive summary of the information. Include an APA reference and/or link. How does the fact...
-
A rectangular block of a material with a modulus of rigidity G=90 ksi is bonded to two rigid horizontal plates. The lower plate is fixed, while the upper plate is subjected to a horizontal force P....
-
10. Problem 5.18 (Uneven Cash Flow Stream) eBook Problem Walk-Through a. Find the present values of the following cash flow streams at a 9% discount rate. Do not round intermediate calculations....
-
For the following exercises, rewrite the sum as a product of two functions or the product as a sum of two functions. Give your answer in terms of sines and cosines. Then evaluate the final answer...
-
THE ECONOMIC DIMENSION Should debtors with older vehicles be allowed to take an additional deduction for operating expenses? Explain. THE CULTURAL DIMENSION What argument might be made in favor of...
-
WHAT IF THE FACTS WERE DIFFERENT? Suppose that the name Pyramid Title, LLC, had not been included on the face of the check. Would Peoples have been personally liable for payment of the check in that...
-
* * * * Kelley Mala is a citizen of the United States Virgin Islands. * * * He went for a cruise in his powerboat near St. Thomas, Virgin Islands. When his boat ran low on gas, he entered Crown Bay...
-
Most smartphones are made in China. If you have a smartphone, and you have it with you all the time, and you think it makes your life wonderful, are you perhaps less concerned about Chinas progress?...
-
the similarities and differences between ANOVA and the chisquare test
-
how researchers used t-tests to study gender overcompensation
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App