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:
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 1Fivebucks 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 2CheeseBurger 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 3Old 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 1Fivebucks 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 2CheeseBurger 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 3Old 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: 9781285185248
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...

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) = x9

The percent P of households in the United States with wirelessonly telephone service from 2005 through 2014 can be approximated by the model P = 3.42 + 1.297t ln t, 5 t 14 where t represents the...

Ramelteon is a hypnotic agent used in the treatment of insomnia: a) What is the molecular formula of this compound? b) How many sp 3 hybridized carbon atoms are present in this structure? c) How...

Match the measures of worth in the first column with the appropriate unit of measure that results from the analysis. Measure of Worth (a) Annual Worth (b) External Rate of Return (c) Future Worth (d)...

Lott Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2017, Job 50 was the only job in process. The costs incurred prior to...

The given code starts by initializing some sets and functions f , g , and h . Block 1 is a function ( called hasInverse ) that takes as input another function ( called func ) , and two sets ( D and T...

IBS is a global provider of pointofsale systems and related services that enable businesses to accept electronic payments. As a new hire in the companys international headquarters accounting...

(10 points) A pair of friends, B1 and B2, bid good bye to each other. B1 is the friend that is in a rocket frame while B2 is the one who was left. As B2 bid good bye, he fired a fireworks. As it...

How do environmental factors, such as temperature, nutrition, and stress, influence the progression and outcome of meiosis, including meiotic recombination rates, gamete viability, and reproductive...

Does global criminal activity operates under the substantive criminal law and procedural criminal law concepts?

Assume the zerocoupon yields on defaultfree securities are as summarized in the following table: Maturity 1 year 2 years 3 years 4 years 5 years ZeroCoupon Yields 3 . 0 % 3 . 6 % 3 . 8 % 4 . 1 % 4...

Instruction mix Program A Instructions of Type 1: Program B Instructions of Type 1: 40% 50% Instructions of Type 2: Instructions of Type 2: 60% 50% Dynamic instruction 8*109 instructions 10*109...

What are the evolutionary consequences of environmental change, including climate change, habitat fragmentation, and humaninduced disturbances, on biodiversity loss, species extinctions, and the...

Choose the incorrect statement: A. ROLLING back a transaction rejects any of the changes resulting from the SQL statements in the transaction B. COMMITTING a transaction makes permanent the changes...

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...

Suppose that \(X\) is a discrete random variable that takes on the values \(\{0,1\}\) and has characteristic function \(\psi(t)=\cos (t)\). Use Theorem 2.29 to find the probability that \(X\) equals...

Suppose that \(X\) is a discrete random variable that takes on positive integer values and has characteristic function \[\psi(t)=\frac{p \exp (i t)}{1(1p) \exp (i t)}\] Use Theorem 2.29 to find the...

Suppose that \(X\) is a continuous random variable that takes on real values and has characteristic function \(\psi(t)=\exp (t)\). Use Theorem 2.28 to find the density of \(X\). Theorem 2.28....
Study smarter with the SolutionInn App