A Tale of Two Properties Key Questions
docx
keyboard_arrow_up
School
University of California, Irvine *
*We aren’t endorsed by this school
Course
201A
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by JusticeDiscovery15768
A Tale of Two Properties Key Questions
:
1)Estimate each property's current value by calculating the present discounted value of expected future cash flows given to you in Exhibit 11. To complete your valuation, you will need to make an exit cap and discount rate assumption. For Columbus Festival, assume that the exit cap rate on the property if JC Penney does not renew would be 0.50% higher than if JC Penney does renew. Do not make any adjustments to the assumptions in Exhibit 9.
2)Calculate the maximum amount Cirano can currently borrow for each debt option, making sure to satisfy the LTV and DSCR constraints. For the Brookline property, all lenders agree on cash flow forecasts. For the Columbus Festival property, Oakwood values the property assuming that JC Penney will renew. Northwood values the property based on expected cash flow.
3)Assuming that Cirano will always borrow the maximum amount, calculate the expected IRR and expected equity multiple to Cirano under each refinancing offer. How would these metrics change if Cirano sold the properties immediately? Be sure to include all prepayment, yield maintenance, defeasance, and any other fees in your calculations. For your defeasance calculations, assume that the yield curve is flat at 1.5% up to three years' maturity. You should calculate these metrics both from inception and from the time of the case.
4)Qualitatively evaluate the strengths and weaknesses of each property.
Brookline Road Shopping Center:
Strengths:
Modern Facility: It was built in 2004, which means it's relatively new with fewer maintenance headaches.
Prime Location: Situated in an affluent suburb, which is great for business.
Solid Performance: ramped up the NOI from $754,000 to $900,000, a testament to good management.
Attractive Tenancy: Securing Chipotle for the property's income.
No competitor: No grocery store in nearby shopping centers.
High median household income Weaknesses:
Market Fluctuations: There's a bit of unpredictability in the market, making it hard to decide whether to sell or hold.
Restrictive Loan Terms: The original loan comes with a lockout period and a prepayment
penalty, tying my hands a bit.
Columbus Festival Plaza:
Strengths:
NOI Growth: I've grown the NOI nicely since acquisition.
Tenant Addition: Scoring CVS Pharmacy is a major plus for the property's prospects.
High Visibility: Its location garners a lot of traffic, which is always good for retail.
Weaknesses:
Older Property: It's been around since '74, which could mean more maintenance costs down the line.
Vacancy Challenges: There's some empty space, though I’m optimistic it will fill up.
Complex Loan Conditions: The defeasance clause in the loan agreement complicates early repayment.
5)Qualitatively evaluate the strengths and weaknesses associated with each refinancing offer being made to Cirano.
Skyline Bank:
Lower Interest Rate: They're offering a better rate than before.
Full Recourse Loan: There’s a personal financial risk if things go south.
Prepayment Restrictions: The lockout provision and prepayment penalty limit my options.
Fourth Second Bank:
Competitive Interest Rate: They've got the best rate on the table.
Flexible Prepayment: After two years, I can prepay without additional costs.
Recourse Requirement: Similar to Skyline, I'm personally on the hook if things don't pan out.
Regional Liberty Life Insurance Company:
Non-Recourse Financing: Less personal risk since the loan doesn't require a personal guarantee.
Higher LTV: They’re willing to finance a larger portion of the property's value.
Steep Prepayment Penalty: The tiered prepayment penalty is a bit of a deterrent.
6)Make a recommendation to Cirano regarding whether he should sell now or after the additional hold period. If you recommend holding, what financing would you choose? This qualitative assessment should be rigorously supported by your analysis from Questions 1 through 5 and any other facts from the case you deem relevant.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Please do not give solution in image format thanku
arrow_forward
Solve this practice problem
arrow_forward
Cullumber Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company decided to open another
store in a rapidly growing area of Nova Scotia. The company is trying to decide whether to purchase or lease the building and related
facilities. Currently, the cost of funds for Cullumber is 10%.
Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be
$1,840,000. An immediate down payment of $405,000 is required, and the remaining $1,435,000 would be paid off
over five years with payments of $347,000 per year (including interest payments made at the end of the year). The
property is expected to have a useful life of 12 years, and then it will be sold for $590,000. As the owner of the
property, the company will pay $51,000 in occupancy expenses at the end of each year.
Lease:
First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for…
arrow_forward
The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its
cars from a dealer and then sold the cars after three years of use. The company's present fleet of cars is
three years old and will be sold very shortly. To provide a replacement fleet, the company is considering two
alternatives:
Purchase alternative: The company can purchase the cars, as in the past, and sell the cars after three years
of use. Ten cars will be needed, which can be purchased at a discounted price of $15,000 each. If this
alternative is accepted, the following costs will be incurred on the fleet as a whole:
2$
Annual cost of servicing, taxes, and licensing
Repairs, first year
Repairs, second year
Repairs, third year
5,500
2$
3,400
2$
5,900
2$
7,900
At the end of three years, the fleet could be sold for one-half of the original purchase price.
Lease alternative: The company can lease the cars under a three-year lease contract. The lease cost would
be $74,000 per…
arrow_forward
You are offered a chance to buy an asset for $4,000 that is expected to produce cash flows of $750 at the end of Year 1, $1,000 at the end of Year 2, $850 at the end of Year 3. and $6,250 at the end of Year 4. What rate of return would you earn if you bought this asset? Select the correct answer. a. 28.08% b. 26.48% с. 28.88% d. 25.68% e. 27.28%.
arrow_forward
Divine Candy Company is considering purchasing a second chocolate
dipping machine in order to expand their business. The information Divine
has accumulated regarding the new machine is:
Cost of the machine
$150,000
Increased contribution margin
$25,000
Life of the machine
8
years
Required rate of return
4
%
Fantastic estimates they will be able to produce more candy using the
second machine and thus increase their annual contribution margin. They
also estimate there will be a small disposal value of the machine but the
cost of removal will offset that value. Ignore income tax issues in your
answers. Assume all cash flows occur at year-end except for initial
investment amounts.
1. Calculate the following for the new machine:
a.
b.
Payback period
Net
present
value
arrow_forward
Why do investors use Price/FFO instead of Price/Earnings ratio to value a REIT? Based on your answer and given the following
information, calculate the price-FFO multiple for the following REIT. Net income: $1,200,000, Gain/losses from infrequent and unusual
events: $0, Amortization of tenant improvements: $120,000, Amortization of leasing expenses: $75,000, Depreciation (real property):
$2,675,000. Stock Price: $40; Market Capitalization: $40,000,000
B
#3
arrow_forward
Please don't use Ai solution
arrow_forward
Sub : Finance
Pls solve ASAP.Please dont CHATGPT. Pls type the answer.Thank You
An owner of the Atrium Tower Office Building is currently negotiating a five-year lease with ACME Consolidated Corporation for 20,000 rentable square feet of office space. ACME would like a base rent of $20 per square foot with step-ups of $1 per year beginning one year from now.
Required:
a. What is the present value of cash flows to ATRIUM under the above lease terms? (Assume a 10% discount rate.)
b. The owner of ATRIUM believes that base rent of $20 PSF in (a) is too low and wants to raise that amount to $24 with the same $1 step-ups. However, now ATRIUM would provide ACME a $50,000 moving allowance and $100,000 in tenant improvements (TIs). What would be the present value of this alternative to ATRIUM?
c. ACME informs ATRIUM that it is willing to consider a $23 PSF with the $1 annual stepups. However, under this proposal, ACME would require ATRIUM to buyout the one year remaining on its existing lease…
arrow_forward
Please correct answer and don't used hand raiting
arrow_forward
You are offered a chance to buy an asset for $7,250 that is expected to produce cash flows of $750 at the end of
Year 1, $1,000 at the end of Year 2, $850 at the end of Year 3, and $6,250 at the end of Year 4. What rate of
return would you earn if you bought this asset?
a. 5.19%
b. 5.46%
Ⓒc. 6.05%
d. 5.75%
e. 4.93%
arrow_forward
akeAssignmentMain.do?invoker%3D&takeAssignmentSessionLocator=&inprogress%3false
hapter 11 Lab Application
全 回
Sign ia
еBook
You have been depositing money into an account yearly based on the following investment amounts, rates and times, what is the value of that investment account at the end of that
period?
(Click here to see present value and future value tables)
Amounts of
Value at the End
Investment
Rate
Times
of the Period
$7,000
20%
16 years
612,094.91X
$11,000
15%
9 years
184,644.26X
$15,000
12%
5 years
95,292.71 X
$36,000
10%
2 years
75,600.00
Feedback
>
Check My Work
For each scenario, use the rate and time components to use the applicable time value of money table to determine the needed factor. Multiply the investment amount by the
future value factor to determine the value of end of the period.
6:38 PM
G O 4) ENG
13
68°F Sunny
10/26/2021
O
P Type here to search
hp
%24
%24
%24
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Instructions are down below the chart is provided with the information
My Question: Can you provide the net present value of the New and old backhoes including the salvage value.
My Question - Please leave the calculations of the Pv factor six digits after the decimal point for example. 0.925925
My Question- Can you also show the math equation for the calculations in the out flow and inflows of the New and Old Back hoes for example. Value of Cash flows and Outflows of the New and Old Backhoes= (...,... + ...,... +etc......
My Question: Can you provide in detail the profitability index of New and Old backhoes
My Question: Can you provide the pay back period fro the New and old Backhoes.
1. Evaluate, discuss, and compare whether to purchase the new equipment or overhaul the old equipment. (Hint: For the old machine, the initial investment is the cost of the overhaul. For the new machine, subtract the salvage value of the old machine to determine the initial cost of the…
arrow_forward
Net Present Value Method, Internal Rate of Return Method, and Analysis for a Service Company
The
management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows:
Biofuel
Equipment
Year
1
2
3
4
Year
1
2
The wind turbines require an investment of $513,900, while the biofuel equipment requires an investment of $1,093,320. No residual value is expected from either project.
Present Value of an Annuity of $1 at Compound Interest
12%
0.893
1.690
2.402
3.037
3.605
3
4
5
Wind
Turbines
6
7
8
9
10
Required:
$180,000
180,000
180,000
180,000
6%
0.943
1.833
2.673
3.465
4.212
4.917
5.582
6.210
6.802
7.360
10%
0.909
1.736
2.487
3.170
3.791
4.355
4.868
5.335
$360,000
360,000
360,000
360,000
5.759
6.145
4.111
4.564
4.968
5.328
5.650
15%
0.870
1.626
2.283
2.855
3.353
3.785
4.160
4.487
4.772
5.019
20%
0.833
1.528
2.106
2.589
2.991
3.326
3.605
3.837
4.031
4.192
1a. Compute the net present value for each project. Use…
arrow_forward
A potential new project involves an up-front (year 0) increase in inventories of $760. In your cash flow table, the cash flow impact of that change in year 0 only should be $__________.
Do not round any intermediate work, but round your final answer to 2 decimal places (ex: 12.34567 should be entered as 12.35). Do not enter the $ sign. Include a negative sign if your answer is negative.
arrow_forward
Take me to the text
The following table indicates the net cash flows of a capital asset:
Year Net Cash Flow
0
$-12,900
1
$4,100
2
$8,100
Do not enter dollar signs or commas in the input boxes.
Use the negative sign where appropriate.
Round the factor to 4 decimal places and the NPV to the nearest whole number.
Assume the required rate of return is 9%. Determine the net present value of this asset.
Year Net Cash Flow Factor Net Present Value
$-12,900
0
1
2
Total
$4,100
$8,100
SA
$
69
arrow_forward
Time Value of Money Practice Scenarios
Please note that some scenarios may have answers that are either correct or incorrect based on calculations, while others will require you to answer based on your own situation. When responding to those questions, explain your answers using what you currently understand about financial concepts.
You have a chance to sell an antique today for $1,000. You believe you will be able to sell the time in three years for $1,200. Should you sell it today or wait? Use March 2023’s inflation rate (5%)
It is with deep regret that I inform you that your rich uncle just passed away. His money is tied up in an investment. However, we can sell the investment and give you $15,000 today, or you will receive $20,000 in 5 years when the investment matures. Which would you choose? Use March 2023’s inflation rate (5%)
You are investing in a retirement account and plan to deposit $5,000 per year into the account for the next 20 years, starting from…
arrow_forward
Pls do fast and i will rate instantly for sure
Solution must be in typed form
arrow_forward
could someone please help me out
arrow_forward
NPV; PI; payback; IRR
Pete's Paving provides custom paving of sidewalks and driveways. One of the most labor-intensive aspects of the paving operation is preparing and mixing materials. Sharon Guillon, corporate
engineer, has found new computerized equipment to mix (and monitor the mixing of) materials. According to information received by Guillon, the equipment's cost is $580,000 and has an expected
life of eight years. If purchased, the new equipment would replace manually operated equipment. Data relating to the existing and replacement mixing equipment follow.
Original cost
Present book value
Existing Equipment
$56,000
$32,000
Annual cash operating costs
$180,000
Fair value
$12,000
Fair value in eight years
Remaining useful life
$0
8 years
Replacement Equipment
$580,000
$36,000
Cost
Annual cash operating costs
Fair value in eight years
Useful life
$0
8 years
a. Assume that the company's cost of capital is 10 percent, which is to be used in discounted cash flow analysis.
(1) Compute…
arrow_forward
Suppose initially that two assets, A and B, will each make a single guaranteed payment of $400 in 1 year. But asset A has a current
price of $280 while asset B has a current price of $320.
Instructions: Round your answers to 2 decimal places.
a. What are the rates of return of assets A and B at their current prices?
Return on assetA =|
|percent
Return on asset B =
percent
Given these rates of return, which asset should investors buy and which asset should they sell?
Buy asset (Click to solect) v and sell asset (Click to select)
b. Assume that arbitrage continues until A and B have the same expected rate of return. When arbitrage ends, will A and B have the
same price?
(Click to select)
Next, consider another pair of assets, C and D. Asset C will make a single payment of $600 in 1 year, while D will make a single
payment of $800 in 1 year. Assume that the current price of C is $440 and that the current price of D is $680.
c. What are the rates of return of assets C and D at their…
arrow_forward
A through c please.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Related Questions
- Please do not give solution in image format thankuarrow_forwardSolve this practice problemarrow_forwardCullumber Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company decided to open another store in a rapidly growing area of Nova Scotia. The company is trying to decide whether to purchase or lease the building and related facilities. Currently, the cost of funds for Cullumber is 10%. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,840,000. An immediate down payment of $405,000 is required, and the remaining $1,435,000 would be paid off over five years with payments of $347,000 per year (including interest payments made at the end of the year). The property is expected to have a useful life of 12 years, and then it will be sold for $590,000. As the owner of the property, the company will pay $51,000 in occupancy expenses at the end of each year. Lease: First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for…arrow_forward
- The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its cars from a dealer and then sold the cars after three years of use. The company's present fleet of cars is three years old and will be sold very shortly. To provide a replacement fleet, the company is considering two alternatives: Purchase alternative: The company can purchase the cars, as in the past, and sell the cars after three years of use. Ten cars will be needed, which can be purchased at a discounted price of $15,000 each. If this alternative is accepted, the following costs will be incurred on the fleet as a whole: 2$ Annual cost of servicing, taxes, and licensing Repairs, first year Repairs, second year Repairs, third year 5,500 2$ 3,400 2$ 5,900 2$ 7,900 At the end of three years, the fleet could be sold for one-half of the original purchase price. Lease alternative: The company can lease the cars under a three-year lease contract. The lease cost would be $74,000 per…arrow_forwardYou are offered a chance to buy an asset for $4,000 that is expected to produce cash flows of $750 at the end of Year 1, $1,000 at the end of Year 2, $850 at the end of Year 3. and $6,250 at the end of Year 4. What rate of return would you earn if you bought this asset? Select the correct answer. a. 28.08% b. 26.48% с. 28.88% d. 25.68% e. 27.28%.arrow_forwardDivine Candy Company is considering purchasing a second chocolate dipping machine in order to expand their business. The information Divine has accumulated regarding the new machine is: Cost of the machine $150,000 Increased contribution margin $25,000 Life of the machine 8 years Required rate of return 4 % Fantastic estimates they will be able to produce more candy using the second machine and thus increase their annual contribution margin. They also estimate there will be a small disposal value of the machine but the cost of removal will offset that value. Ignore income tax issues in your answers. Assume all cash flows occur at year-end except for initial investment amounts. 1. Calculate the following for the new machine: a. b. Payback period Net present valuearrow_forward
- Why do investors use Price/FFO instead of Price/Earnings ratio to value a REIT? Based on your answer and given the following information, calculate the price-FFO multiple for the following REIT. Net income: $1,200,000, Gain/losses from infrequent and unusual events: $0, Amortization of tenant improvements: $120,000, Amortization of leasing expenses: $75,000, Depreciation (real property): $2,675,000. Stock Price: $40; Market Capitalization: $40,000,000 B #3arrow_forwardPlease don't use Ai solutionarrow_forwardSub : Finance Pls solve ASAP.Please dont CHATGPT. Pls type the answer.Thank You An owner of the Atrium Tower Office Building is currently negotiating a five-year lease with ACME Consolidated Corporation for 20,000 rentable square feet of office space. ACME would like a base rent of $20 per square foot with step-ups of $1 per year beginning one year from now. Required: a. What is the present value of cash flows to ATRIUM under the above lease terms? (Assume a 10% discount rate.) b. The owner of ATRIUM believes that base rent of $20 PSF in (a) is too low and wants to raise that amount to $24 with the same $1 step-ups. However, now ATRIUM would provide ACME a $50,000 moving allowance and $100,000 in tenant improvements (TIs). What would be the present value of this alternative to ATRIUM? c. ACME informs ATRIUM that it is willing to consider a $23 PSF with the $1 annual stepups. However, under this proposal, ACME would require ATRIUM to buyout the one year remaining on its existing lease…arrow_forward
- Please correct answer and don't used hand raitingarrow_forwardYou are offered a chance to buy an asset for $7,250 that is expected to produce cash flows of $750 at the end of Year 1, $1,000 at the end of Year 2, $850 at the end of Year 3, and $6,250 at the end of Year 4. What rate of return would you earn if you bought this asset? a. 5.19% b. 5.46% Ⓒc. 6.05% d. 5.75% e. 4.93%arrow_forwardakeAssignmentMain.do?invoker%3D&takeAssignmentSessionLocator=&inprogress%3false hapter 11 Lab Application 全 回 Sign ia еBook You have been depositing money into an account yearly based on the following investment amounts, rates and times, what is the value of that investment account at the end of that period? (Click here to see present value and future value tables) Amounts of Value at the End Investment Rate Times of the Period $7,000 20% 16 years 612,094.91X $11,000 15% 9 years 184,644.26X $15,000 12% 5 years 95,292.71 X $36,000 10% 2 years 75,600.00 Feedback > Check My Work For each scenario, use the rate and time components to use the applicable time value of money table to determine the needed factor. Multiply the investment amount by the future value factor to determine the value of end of the period. 6:38 PM G O 4) ENG 13 68°F Sunny 10/26/2021 O P Type here to search hp %24 %24 %24arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning