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 8P

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
Vishu
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?
You recently purchased an office building for $1,950,000 using the following loan terms: 70% LTV, 20-year amortization, 6.25% interest and monthly compounding. Assuming a net operating income of $150,000 in Year 1 and income taxes equal to $11,000, what is the expected ATCF from Operations in Year 1?
A builder is offering $127,574 loans for his properties at 9 percent for 25 years. Monthly payments are based on current market rates of 9.5 percent and are to be fully amortized over 25 years. The property would normally sell for $140,000 without any special financing. Required: a. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan? Assume that the buyer would have the loan for the entire term of 25 years. b. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan if the property is resold after 10 years and the loan repaid?
A builder is offering $137,381 loans for his properties at 9 percent for 25 years. Monthly payments are based on current market rates of 9.5 percent and are to be fully amortized over 25 years. The property would normally sell for $150,000 without any special financing. Required: a. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan? Assume that the buyer would have the loan for the entire term of 25 years. Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.) b. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan if the property is resold after 10 years and the loan repaid? Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.)
A builder is offering $117,767 loans for his properties at 9 percent for 25 years. Monthly payments are based on current market rates of 9.5 percent and are to be fully amortized over 25 years. The property would normally sell for $130,000 without any special financing. Required: a. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan? Assume that the buyer would have the loan for the entire term of 25 years. Complete this question by entering your answers in the tabs below. Required A At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan? Assume that the buyer would have the loan for the entire term of 25 years. (Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.) Sale value $ 116,134
what is the sale price?
Manning Imports is contemplating an agreement to lease equipment to a customer for four years. Manning normally sells the asset for a cash price of $230,000. .Assume that 8% is a reasonable rate of interest. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) What must be the amount of quarterly lease payments (beginning at the commencement of the lease) in order for Manning to recover its normal selling price as well as be compensated for financing the asset over the lease term? (Round your answers to nearest whole number and round percentage answer to 1 decimal place.)
An investment property is purchased for $18,540,000 with 50% equity and an interest-only loan to finance the balance. The average appreciation rate of the property is 5% per annum. All operating costs, including finance costs, are exactly equal to rent income. If the property is sold after 10 years and selling costs are 3% of the sale price (based on market valuation of determined from the annual rate of appreciation), the ROE (return on equity) is: Select one: a. 7.59% b. 8.01% c. 9.34% d. 10.03% 11.38% e.
Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise have no use for. The net-of-sales-commission selling price for the property is $410,000. You are willing to finance this transaction over a 20-year period and have told the buyer that you expect an 11% pretax return on the transaction. The buyer has asked you for a payment schedule under several alternatives. Required: 1. What will be your periodic cash receipt, to earn a 11% return, if payments are received from the purchaser: NOTE: to answer the above questions, use the PMT function in Excel, as follows: PMT(rate,nper,pv,fv,type) where: rate is the interest rate for the loan, nper is the total number of payments, pv is the present value (i.e., the total amount that a series of future payments is worth now; also known as the principal), fv is the future value (or a cash balance you want to attain after the last payment is made; if fv is omitted, it is assumed to be 0 (zero)), and…

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

SEE MORE TEXTBOOKS