PLEASE USE EXCEL AND SHOW THE FORMULAS TO SOLVE THESE QUESTIONS 1. You have been asked to analyze the acquisition of an office property for $10 million with the belowestimated NOI estimates at the end of each year and an assumption it will be sold at the end of the 3rdyear to an investor with 5.8% cap rate, which you will then incur selling expenses of 6%. RBS hasoffered you a 3-year $7 million interest-only loan at 6.5% to finance the acquisition with $40,000 inorigination fees.Year 1: $641,385 Year 2: $662,792Year 3: $679,231 Year 4: $690,692A. What is the unlevered Cash-On-Cash, Equity Multiple, IRR of the investment?B. What is the EBC, LTV, DCR, DYR of the acquisition with the $7 million loan?C. What is the required equity, levered Cash-On-Cash, Equity Multiple, IRR of the investment?

Given:- Acquisition of an office property for $10 million- NOI estimates: Year 1: $641,385, Year 2:…

Answered: 1. You have been asked to analyze the…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

A property that produces a first year NOI of $18,000 is purchased for $135,000. The NOI is expected to increase by 7% in the fourth year when some of the leases turnover. The resale price in year 8 is expected to be $149,000. What is the net present value of the property based on the 8-year holding period and a discount rate of 12%? Answer: NPV = $17,829 How do you set this up in excel?
Let us assume that an investor can obtain an 80% LTV loan for a property valued at 500,000 at a 10% interest rate to be amortized over 25 years with monthly payments. If the property generates $70,000 net operating income per year, answer the following. What would be the Before-Tax Cash Flow from the Property Sale (BTCFs) if the property were sold in Year 5 for $440,000? $63,344.93 $816,655.07 $396,382.36 $440,000.00
Assume that property investor expects NOI to be $55 000, $64 000 and $67 000 for next 4 years with capitalisation rate of 11%, holding period expected to be 32 years with annual appreciation of 3% and sale commission of 6%. Would you buy the property if owners would like to sell it for $520 000?
Consider an income property that is under evaluation for purchase with a $489,398 loan, 3.3% interest rate, compounded annually, amortized over 29 years. The NOI at the end of year 1 is $48,148, year 2 is $54,192, and year 3 is 55,470. At the end of year 3, the property is estimated to sell for $525,700. Discount the equity cash flows over the 3-year holding period at 6.0 percent. Using the principles of mortgage equity capitalization, what is the estimated total property value with a holding period of 3 years? Please post step by step solve.
Supposed amarriedcouple wishesto acquire aluxurious condominium in Tagaytay.Thiscan be acquired by a downpayment of P700,000and a yearly payment of P150,000 at the end of each year for a period of 10 years, starting at the end of 5 years from the date of purchase. If money is worth 15% compounded annually, what is the cash price of the property?
Use the given information to solve the following questions. You have purchased a building for $ 12,000,000. There are ongoing NNN leases that will create a constant annual PGI of 1,700,000 with a Vacancy and Collection loss of 10%. Operating Expenses will be constant at 575,000 per year, and Capital Expenditures a constant 120,000 per year. You have obtained a 5-year, 4.5% partially amortizing loan at 65% LTV with 1.5 points that has a 25-year amortization period. You expect to sell this building for a net of $14,500,000 (i.e. after selling expense are paid) five years from today. What is your loan amount? What is your initial investment? What is your monthly loan payment? What is your loan balance after 5 years? What is your ADS? What is your year 1 NOI? What is your Year 1 before tax cash flow from operations? What is your going in cap rate? What is the first year cash on cash return for this investment? What is the first year Debt Coverage Ratio for this loan? What is the first year…
You have been appointed as a financial consultant by the directors of Cochin Holdings. They require you to calculate the cost of capital of the company. The following information is available on the financing of the company: · R10 000 000, financial lease due in 5 years and the current yield-to-maturity is 10%. Prepare a loan amortization scheduleq
You are conducting an investment analysis (before tax) for a hotel in Lausanne assuming a 5 year investment horizon. You have estimated the Property Before Tax Cash Flow (PBTCF), net sales proceeds, and interest payment as shown in the table below. The net transaction price is CHF15'000'000. You take out a 5 year interest-only loan with an annual interest rate of 3.5%. The property discount rate (i.e., Weigthed Average Cost of Capital) is 8%. Ignore transaction costs. Calculate the Net Present Value (NPV: leveraged) for an equity investor. (Hint: use the debt amount and equity amount calculated to calculate the debt-to-equity ratio) Year O Year 1 Year 2 Year 3 PBTCF Net Sales Proceeds - Interest Payment a) 324'041 CHF b) 2'344'957 CHF c) -851'492 CHF d) Impossible to calculate 1'100'000 1'122'000 1'144'000 -350'250 -350'250 -350'250 Year 4 1'166'000 -350'250 Year 5 1'190'000 16'150'000 -350'250
Real Estate investor borrowed Ksh 10million to invest in an asset at an interest rate of 10% p.a for 30 years. Calculate: I). Tha annual payment ii). The monthly payment iii). If the asset is expected to generate a return of Ksh 100000 per month. Advise the investor whether the investment in the asset is viable iv). Prepare a loan amortization schedule for the first ten years v). What other factors will you advise the investor to consider
A commercial property has PGI of $5 million, expenses of 40% of EGI and the vacancy is underwritten at 10%. What values would the following parameters suggest for the property. 70% LTV with a rate of 4.5% and 360 month amortization schedule. Given a property value of $45 million, calculate PGIM, EGIM, Cap Rate, Cash on Cash return and DSSCR.
JG Asset Services is recommending that you invest $1,400 in a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? Select the correct answer. a. $1,645.16 b. $1,649.56 c. $1,662.76 d. $1,658.36 e. $1,653.96
The company buys a solar panel unit for P105,000. The shipping and installation fees amount to P15,000. If the unit is expected to last for 15 years, with a salvage value of P3,000, what is the depreciation charge during the 12 th year, and the book value at the end of 14 years by the (a) Declining balance method, (b) DDB method, (c) sinking fund method g iven interest rate at 12.5 percent, and (d) Sum-of-the-Years Digit (SYD) Method.

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS