Question: please answer all the questions and show the work please Question 4 15 pts You purchased an office building 4 years ago. At the time,

please answer all the questions and show the work please

4 15 pts You purchased an office building 4 years ago. At

and a 20-year amortization What is your monthly mortgage payment? What is

Question 4 15 pts You purchased an office building 4 years ago. At the time, you borrowed $621,000 with a 5.25% interest rate (compounded monthly) and a 20-year amortization What is your monthly mortgage payment? What is the total of the payments made since you purchased the building? What is the loan balance? How much principal have you pald? How much interest have you paid? Round your answers to the nearest dollar. Question 5 15 pts You are refinancing your home. You intend to borrow $512,000. The bank has quoted you a rate of 2.75% (monthly compounding) with a 30-year amortization. The loan requires you to pay 1 point. What is the dollar amount of the points? Round your answer to the nearest dollar. What is the actual disbursement for the loan? Round your answer to the nearest dollar. What is the effective borrowing cost for the loan? Present your answer as a percentage, rounded to the nearest 1/100th of a percent (two decimal places) Question 6 5 pts You own a retail strip center with NOI of $227.500. The monthly loan payment for the center is $12,150. What is the debt coverage ratio? Present your answer as a percentage, rounded to the nearest 1/100th of a percent (two decimal places). Question 9 25 pts You are refinancing a truck terminal you own as an investment. NOI is currently $148,000. An applicable cap rate is 7.15%. The lender has quoted you the following terms: 70% LTV ratio 4.5% interest rate (compounded monthly) 30-year amortization 1.45x DCR What is the indicated value? What is the maximum loan amount indicated by the LTV ratio? What is the maximum ADS indicated by the DCR? Based on the maximum ADS and the provided loan terms, what is the maximum loan amount indicated by the DCR? Round your answers to the nearest dollar

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please answer these 3 questions, thank you! FIRST PICTURE Sheriffield Corp. signed a lease for an office building for a period of 8 years. Under the lease agreement, a security deposit of $7000 is...

Please help answer the following questions, and show your work. Thank you! Question 1 1. Both New York Stock Exchange and NASDAQ are examples of primary markets. Answer True False 1 points Question 2...

Large Mart has previously attempted to develop a study pillow which would have allowed students to upload study material into their brain whilst sleeping. However, Large Mart has recently discovered...

STAT 225 Section 6380 Summer 2015 Quiz #3 Please answer all 10 questions. The maximum score for each question is posted at the beginning of the question, and the maximum score for the quiz is 80...

Please answer the following questions and show how they were found. Redo the 1996 income statement assuming all of the funds needed are borrowed as long-term bonds at 8 percent. Will the Tipton...

Cash Receipts (Revenue) Major Product Categories at Start Up Specialty Baked Goods Walk-In Customers Beverages * Closed on Sunday Days per week * Weeks per Month Walk-In customers that buy Beverages...

Please answer the following questions and show work using separate excel spreadsheets. 1.Which of the following statements is most applicable to the business entity concept? Question 1 options: a....

1.How would you summarize the current situation at the Crossroads Center? 2.What is the client looking to accomplish? What challenges exist for the client in accomplishing his objectives? 3.How would...

Please answer the questions attached and show the work in a different excel sheet. Thank you in advance A check drawn by a Elli Catering Services for $180 in payment of a liability was recorded in...

Write an essay on Topic: Digital Analysis related to Technology and human nature.

35. As a financial analyst, you are tasked with evaluating a capital budgeting project. You were instructed to use the IRR method and you need to determine an appropriate hurdle rate. The risk-free...

You have recently started a new job as the senior accountant at Rand - Lover Ltd , a company that manufactures cheap, off - road vehicles. One of your first tasks in your new position is to review...

Please use Java. NOTE: Use true encapsulation (design all data fields as private and reach them just using get/set methods) and inheritance practice in your implementation. Your project have to...

2. Complete the following labor supply table for a firm hiring labor competitively: LO17.2 Units of Wage Total Labor Marginal Resource Labor Rate Cost (Labor) Cost 0 $14 $ $ 1 14 2 14 3 14 4 14 5 14...

3. Assume a firm is a monopsonist that can hire its first worker for $6 but must increase the wage rate by $3 to attract each successive worker (so that the second worker must be paid $9, the third...

4. In each of the following four cases, MRPL and MRPC refer to the marginal revenue products of labor and capital, respectively, and PL and PC refer to their prices. Indicate in each case whether the...