Question

An Office building is listed for sale at $500,000. You can borrow 80% at 6% interest...

An Office building is listed for sale at $500,000. You can borrow 80% at 6% interest amortized monthly for a 20 year term and put 20% down. Your required unleveraged IRR is 10% and you want to use a 9% terminal cap rate. You plan a five year holding period after the purchase. You have calculated the annual pre-debt service NOI for each year as: Yr. 1 = $40,000 Yr. 2 = $41,000 Yr. 3 = $42,000 Yr. 4 = $43,000 Yr. 5 = $44,000 Yr. 6 = $45,000. Using debt financing, what is the Year 5 loan balance?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are considering the purchase of a small office building. The office building specializes in offering...
You are considering the purchase of a small office building. The office building specializes in offering facilities to small startup firms who are looking to avoid long-term commitments while their businesses are growing. Tenants sign one-year leases and may renew at market rates, if they so desire. The building is configured with 25 suites. Five (5) suites each have 4,000 useable square feet and ten (10) each have 2,500 usable square feet. The remaining ten (10) suites each have 1,000...
6. You deposit $400 each month into an account earning 5% interest compounded monthly. a) How...
6. You deposit $400 each month into an account earning 5% interest compounded monthly. a) How much will you have in the account in 35 years? b) How much total money will you put into the account? c) How much total interest will you earn? 7. Suppose you want to have $500,000 for retirement in 25 years. Your account earns 7% interest. a) How much would you need to deposit in the account each month? b) How much interest will...
1. One advantage of Adjustable Rate Mortgages (ARM) is that a. lenders face lower levels of...
1. One advantage of Adjustable Rate Mortgages (ARM) is that a. lenders face lower levels of interest rate risk than a fixed rate mortgage. b. the outstanding loan balance can be adjusted regularly. c. the default risk of borrowers is lower than under a fixed rate mortgage. d. All of the above. 2. Gilbert takes out a 23-year adjustable rate mortgage loan for $6,000,000 with monthly payments. The first two years of the loan have a “teaser” rate of 2%,...
1. Assume that you are an equity analyst and you have been asked to generate a...
1. Assume that you are an equity analyst and you have been asked to generate a twelve month forward price target for ShopSmart Plc, a retail company. You decide to use the discounted Free Cash Flow to Firm (FCFF) valuation model. For the year just ended you have collected the following information on ShopSmart PLC: ? Net Income: £260 m ? Sales: £2,600 m ? Depreciation: £100 m ? Investment in fixed capital: £180 m ? Interest expense: £110 m...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The following information applies to Problems 1-4) The Collins Group, a leading producer of custom automobile accessories, has hired you to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets Current assets                                        $ 38,000,000 Net plant, property, and equipment                    101,000,000 Total assets                                          $139,000,000 Liabilities and Equity Accounts payable                                      $ 10,000,000 Accruals                                                9,000,000 Current liabilities                                   $...
SHOW CALCULATION AND EXPLANATION, PLEASE! 1- For a given amount, the lower the discount rate, the...
SHOW CALCULATION AND EXPLANATION, PLEASE! 1- For a given amount, the lower the discount rate, the less the present value. A) True B) False 2- What is the NPV of a project that costs $100,000 and returns $45,000 annually for three years if the cost of capital is 14%? A) $3,397.57 B) $4,473.44 C) $16,100.00 D) $35,000.00 3- The decision rule for net present value is to: A) Accept all projects with cash inflows exceeding initial cost. B) Reject all...
Please answer all 9 questions with explanation. Thank you On May 8, 1984, Hannah Eisenstat graduated...
Please answer all 9 questions with explanation. Thank you On May 8, 1984, Hannah Eisenstat graduated from Louisiana State University. She set to work opening a coffee shop in Baton Rouge called HannaH and found a perfect location in a new development. Using a $50,000 inheritance to finance the venture together with her own sweat equity, she started the business on August 1, 1984 as a sole proprietorship. The shop was profitable in the first year. Hannah found, however, that...