Questions – Page 5 – Real Estate Financial Modeling

You wish for the cells in the Unit Sales Forecast table in row 16 to read “Yes” if it is a month of either pre-sales or regular sales. Otherwise, return no text. Choose the correct formula for cell C16.

Real Estate Financial Modeling / Questions / Page 5

You wish for the cells in the Unit Sales Forecast table in row 16 to read “Yes” if it is a month of either pre-sales or regular sales. Otherwise, return no text. Choose the correct formula for cell C16.

August 27, 2017
Bruce Kirsch, REFAI®

Question 15. of 15.) An investment group is raising capital for a value-added real estate private equity fund. The projected cash flows (in Millions) at the fund level are as follows: Time 0: -100 Year 1: 9 Year 2: 4 Year 3: -2 Year 4: 135 What is the MIRR if assumed reinvestment rate is 18% and the safe rate is 3%?

August 23, 2017
Mckenzie Jones

Question 14. of 15.) A mortgage lent at 8.75% with 20 years remaining on a 30 year term and a remaining balance of $88,332 is availble for purchase. What purchase price will generate a 13% yield?

August 23, 2017
Mckenzie Jones

Question 13. of 15.) You have just purchased a $280,000 mortgage note with a 30-year amortization term for a price of $234,000. The mortgage was issued at a 8.5% rate, and it currently has 27 years remaining. Since issuance, all 36 monthly payments have been made. What will be your annual yield on the note?

August 23, 2017
Mckenzie Jones

Question 12. of 15.) A borrower elects to prepay a low interest rate loan. The interest rate is 4% with 60 payments remaining of $145.00 and a balloon payment at the end of the fifth year for $2,200. If the lender is willing to discount the future payments at 10%, how much would the borrower need to prepay the note?

August 23, 2017
Mckenzie Jones

Question 11. of 15.) A Lender charges 2 points to the borrower for the issuance of his mortgage. Given a mortgage of $1,000,000 amortized over 25 years with an annual interest rate of 6%, what is the actual amount that the borrower is receiving?

August 23, 2017
Mckenzie Jones

Question 10. of 15.) A lender charges a borrower 1.75 points on the issuance of a $100,000 mortgage amortized over 20 years. If 9% is the annual rate, what are the monthly payments?

August 23, 2017
Mckenzie Jones

Question 9. of 15.) Given a mortgage of $250,000 amortized over 30 years, and an annual interest rate of 5.5%, what is the APR?

August 23, 2017
Mckenzie Jones

Question 8. of 15.) An investor hears that a REIT stock is on the rise. Over the course of one month, he purchases stock three times. His purchases are as follows: 1,000 shares at $12.45 per share; 850 shares at $14.82 per share; 550 shares at $18.23 per share. What is the weighted average price per share?

August 23, 2017
Mckenzie Jones

Question 7. of 15.) An investor looks to purchase property for $100,000 in cash and has a 15% discount rate. Yearly Cash flows for the project are as follows for years 1 through 3: $14,000, $19,000, $200,000, respectively. What is the Project NPV?

August 23, 2017
Mckenzie Jones

You wish for the cells in the Unit Sales Forecast table in row 16 to read “Yes” if it is a month of either pre-sales or regular sales. Otherwise, return no text. Choose the correct formula for cell C16.

Question 14. of 15.) A mortgage lent at 8.75% with 20 years remaining on a 30 year term and a remaining balance of $88,332 is availble for purchase. What purchase price will generate a 13% yield?

Question 11. of 15.) A Lender charges 2 points to the borrower for the issuance of his mortgage. Given a mortgage of $1,000,000 amortized over 25 years with an annual interest rate of 6%, what is the actual amount that the borrower is receiving?

Question 10. of 15.) A lender charges a borrower 1.75 points on the issuance of a $100,000 mortgage amortized over 20 years. If 9% is the annual rate, what are the monthly payments?

Question 9. of 15.) Given a mortgage of $250,000 amortized over 30 years, and an annual interest rate of 5.5%, what is the APR?

Question 7. of 15.) An investor looks to purchase property for $100,000 in cash and has a 15% discount rate. Yearly Cash flows for the project are as follows for years 1 through 3: $14,000, $19,000, $200,000, respectively. What is the Project NPV?

Categories

Learn About REFAI Certification

Get REFM blog posts, news and exclusive promotions by email!

The Best Book On The Business

Looking for the future of investment analysis?

Learn about Valuate’s benefits in 30 seconds

try Valuate instantly here

Guide: Getting started with Valuate

Get Free Tools from REFM

REFM Training Course Catalog

Other Blogs to Visit

Categories

Learn About REFAI Certification

Get REFM blog posts, news and exclusive promotions by email!

The Best Book On The Business

Looking for the future of investment analysis?

Learn about Valuate’s benefits in 30 seconds

Popular Blog Posts

Guide: Getting started with Valuate

Get Free Tools from REFM

REFM Training Course Catalog

Other Blogs to Visit