Question: Use the information below to derive a Cap Rate and solve for the property's Overall Value. NOI $100,000 Debt Service $84,000 Mortgage 80.00% Mortgage Constant

Use the information below to derive a Cap Rate and solve for the property's Overall Value.

NOI $100,000

Debt Service $84,000

Mortgage 80.00%

Mortgage Constant 10.53%

DCR 1.19x

Cap Rate?

Value?

please explain and show me how to do it in excel.

Thank you in advance.

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!

Q:

Consider the following system in Figure P18-16C used to model a real reactor: The figure shows a tubular reactor of volume V subscript 1 and another cylindrical reactor of volume V subscript 2. The...

Q:

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

Q:

Kamal, you helped me with my other ACC201 question and you told me if I need you again just hit you up, well I do, this one follows what you helped me with. Attached are the files the first one will...

Q:

I've attached the attachment as a word file, thanks! JWCL165_c13_612-673.qxd 8/13/09 11:15 AM Page 612 13 Statement of Cash Flows Chapter STUDY OBJECTIVES After studying this chapter, you should be...

Q:

USE EXCEL please show formula Use the information below to derive a Cap Rate and solve for the property's Overall Value. NOI Debt Service Mortgage (LTV) Mortgage Constant DCR $100,000 $84,000 80.00%...

Q:

Ten year Project 1 2 0 unit Apartment ComplexPurchase Price: $ 3 , 0 5 6 , 6 0 0 Holding Period: 1 0 YearsDepreciation in years: 3 0 Land Value % of Price: 2 5 % Loan to Value: 7 0 % Term of Loan: 2...

Q:

The next 5 screenshots were provided my the professor to help us. This is what we have come up with. Evaluate the attached proforma information. You need to do a ten year Spreadsheet similar to...

Q:

Hello, This is the Fina 210 Course about Real estate. Could you help me to solve this problem and show me a solution? because i want to know how to solve this type of question in exam. Thank you! ps:...

Q:

Attached is the assignment requirement and 2 previous assignments as example 1- the assignment should be zero plagiarism and similarity (no copy ans paste is accepted) 2- should be completed in the...

Q:

INTRODUCTION You are evaluating an opportunity to purchase a 4-unit apartment building located in central Bozeman as an investment property. The proposed purchase price is $795,000. Each of the four...

Q:

Please provide a page and a half paper to answer the following question: Major factors company should be aware of/evaluate regarding future investments projects. Use the attachments to answer the...

Q:

You are considering becoming a hedge-fund manager, and will make your living by charging your clients a fee for managing their money. You are considering two payment schemes: a "no-load" scheme...

Q:

Modify the critical regions on pages 365 and 366 so that they can be used to test the null hypothesis = 0 against the alternative hypotheses > 0,

Q:

Use Venn diagrams to determine whether the following standard-form categorical syllogisms are valid from the Boolean standpoint, valid from the Aristotelian standpoint, or invalid. Then, identify the...

Q:

The current density in a wire is uniform and has magnitude 2.0 x 106 A/m2, the wire's length is 5.0 m, and the density of conduction electrons is 8.49 x 1028 m-3. How long does an electron take (on...

Q:

Service industry, time period used to compute indirect cost rates. Printers, Inc. produces annual reports and marketing materials for large companies. There are three categories of costs in its...

Q:

A 2.8-kg block slides over the smooth, icy hill shown in Fig. 7.35. The top of the hill is horizontal and 70 m higher than its base. What minimum speed must the block have at the base of the hill so...

Q:

Sketch the graph of a continuous function on [0, 2] for which the Trapezoidal Rule with n = 2 is more accurate than the Midpoint Rule.

Q:

(a) In 1964, the temperature in the Siberian village of Oymyakon reached 71oC. What temperature is this on the Fahrenheit scale? (b) The highest officially recorded temperature in the continental...

Q:

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Q:

Unless a dividend is declared by the board of directors of a corporation, it is not a liability of the corporation. A corporation cannot default on an undeclared dividend. As a consequence,...

Q:

Haverah plc is a manufacturer and distributor of denim garments. It employs a highly aggressive working capital policy and uses no long-term borrowing. Highlights from its most recent accounts appear...

Q:

A supplier offers you the following trade credit terms: 3/15: net 45. If you delay payment until day 45, what effective annual interest rate are you paying for additional trade credit?