Questions – Page 10 – Real Estate Financial Modeling

The following consitituent capital element of a real estate transaction is secured by the equity in the transaction:

Real Estate Financial Modeling / Questions / Page 10

The following consitituent capital element of a real estate transaction is secured by the equity in the transaction:

June 28, 2017
Mckenzie Jones

The following consitituent capital element of a real estate transaction has the residual claim to the cash flows:

June 28, 2017
Mckenzie Jones

The following consitituent capital element of a real estate transaction is collateralized by the real estate itself:

June 28, 2017
Mckenzie Jones

In the capital structure for an investment, the sources of funds must always equal the uses of funds.

June 28, 2017
Mckenzie Jones

What is the correct formula to use to backsolve into the Maximum Loan Amount using the Debt Service Coverage ratio test in cell D23?

June 28, 2017
Mckenzie Jones

You are the owner of an office building and want to understand what a future refinancing might look like. What is the maximum allowable debt service amount (cell D22)?

June 28, 2017
Mckenzie Jones

You purchase a property with a Market Value of $520,000 in 2005 using 5-year Interest Only 90% Loan-to-Value financing. In 2010, the Market Value of the property drops to $460,000. You are considering refinancing. The Loan-to-Value you can get for refinancing is only 70%. How much Total Cash Out of Pocket would you need to have to go through with the refinancing and pay back the original loan Principal outstanding?

June 28, 2017
Mckenzie Jones

You wish to find out what you could afford to pay for Land Cost to meet a required 15% profit margin. Please choose the answer which orders the terms in the way they should be entered from top to bottom into the Goal Seek function dialog box. The top selection should correspond to the “Set Cell” space, the middle selection should correspond to the “To Value” space, and the bottom selection should correspond to the “By changing cell” space.

June 28, 2017
Mckenzie Jones

You purchase a $520,000 property in 2010 with a loan-to-value of 90%. The loan is Interest Only for the first 5 years. The Market Value decreases over the first 5 years so that the Loan-to-Value equals 102% at the end of 2014 (the end of Year 5). What is the property’s Market Value at the end of 2014?

June 28, 2017
Mckenzie Jones

If you purchase a property at a market price of $450,000 with a loan-to-value of 85%, plus $10,000 of purchaser Closing Costs, what is your total cash investment after Closing?

June 28, 2017
Mckenzie Jones

1
...
8
9
10
11
12
...
16

© 2009 – 2025 Real Estate Financial Modeling, LLC. All rights reserved | Trademarks

"REFAI® is incredibly valuable even with previous CRE experience and an undergrad degree in real estate." Learn More