Question: DCF Instructed In-Class Practice Property Assumptions Purchase Price: $4,000,000 Year 1 Potential Gross Income (PGI): $540,000 PGI annual growth rate: 3% Annual Vacancy and Credit

DCF Instructed In-Class Practice Property Assumptions Purchase Price: $4,000,000 Year 1 Potential Gross Income (PGI): $540,000 PGI annual growth rate: 3% Annual Vacancy and Credit Loss (VCL): 10% Over next 4yrs. Year 1 operating expenses (OER): (Operating Expense Ratio) 35% OPEX annual growth rate: 2% Terminal Capitalization Rate: 9% Capitalize 4 th yr. NOI with Terminal Cap Rate Anticipated holding period 3 years Maximum loan-to-value (LTV) ratio: 70% Interest Rate (Loan): 5% Amortization Period: 30 years Payments per year: 12 Investors Discount Rate, aka Hurdle Rate (unleveraged) 15% Investors Discount Rate, aka Hurdle Rate (unleveraged) 15%

1. What are the NOIs for years 1-4?

2. What are the DCRs for years 1-3? (NOI/DS)

3. What are the Cash-on-Cash Returns for years 1-3? (BTCF/Initial Equity Investment)

4. What is the Unleveraged IRR and NPV?

5. What is the Leveraged IRR and NPV?

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!

XYZ is a calendar-year corporation that began business on January 1, 2018. For the year, it reported the following information in its current-year audited income statement. Notes with important tax...

DCF Instructed In-Class Practice Property Assumptions Purchase Price: $4,000,000 Year 1 Potential Gross Income (PGI): $540,000 PGI annual growth rate: 3% Annual Vacancy and Credit Loss (VCL): 10%...

DCF Instructed In-Class Practice $4,000,000 $540,000 3% 10% Property Assumptions Purchase Price: Year 1 Potential Gross Income (PGI): PGI annual growth rate: Annual Vacancy and Credit Loss (VCL):...

DCF Practice (5 Year Hold) Property Assumptions Purchase Price: $1,000,000 Year 1 Potential Rental Income (PRI): $150,000 PGI annual growth rate: 3% Annual Vacancy and Credit Loss (VCL): 5% Over next...

Property Assumptions Purchase Price: $12,500,000 Year 1 Potential Rental Income (PRI): $1,650,000 PGI annual growth rate: 3% Annual Vacancy and Credit Loss (VCL): 5% Over next 6yrs. Year 1 operating...

need it urgently !! please show work excel is needed . need it ASAP This document may be modified for clarification, especially in response to student questions. Instructions Conduct a DCF analysis...

can someone help me to answer question number 6,10, 13, and 14. thankyou so much AutoSave OFF 5 0 HW5 - Saved to my M Insert Draw Design Layout References >> Footnotes Captions Index Smart Researcher...

This is an assignment for a Real Estate class. Please let me know if you can help out. I have attached 2 files. the PDF file is the assignment instructions. Pages 1, 2 and 3 are examples. The actual...

Please help using the 2 documents accordingly and answering all questions. Thank you. Ann is looking to buy an office building in 2014. She plans to rent it out for 5 years (2015-2019) and sell it at...

I need help figuring out the numbers in the 2nd and 3rd sheet on excel. The word document has all the details. I believe i did the 1st sheet right. Please help asap as this is due tonight. Thank you....

C. The 10,000 square foot building has an NNN lease, rent is $16 per SF per year, vacancy is 10% of all PGI, and expenses are 30% of PGI Rent. Calculate the: i. PGI (Potential Gross Income) ii. EGI...

How do companies use plans at all levels of management?

Why is it difficult to make heavy cuts if a form turning tool is complex in shape?

Which one of the following indicates that a project is expected to create value for its owners? A ) Profitability index less than 1 . 0 B ) Payback period greater than the requirement C ) Positive...

some expenses may qualify both as a business expense and a medical expense. how would a taxpayer prefer to treat the expenses a) if the taxpayer is elf-employed? or b) if the taxpayer is an employee

LO1 Define variable pay and identify three aspects of effective pay-for-performance plans.

4. Setting reasonable pay to get competent employees is an important component of compensation management. To remain fair and competitive, employers have to use different sources of internal and...

4. You are the HR Director for an insurance company with regional offices in several states. For each office, you want to be sure that the administrative assistants reporting to the regional manager...