Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Reconstruct the table, assuming that effective gross income grows at 3 percent p

ID: 2712807 • Letter: R

Question


Reconstruct the table, assuming that effective gross income grows at 3 percent per annum and operating expenses grow at 6 percent per annum. Would you expect the reduced prospect for growth in NOI to have an impact on the market-derived overall capitalization rate?

b.        Based on the reconstructed table, what would be the LTV ratio at the end of the sixth year if the market-derived overall capitalization rate dropped to 8.5 percent?

                                1                    2                     3                      4                      5                 6  

EGI                                                                                                                                   

Less: Op.Exp.                                                                                                                  

NOI                                                                                                                                   

Less: DebtServ                                                                 

BTCF                                                                                                                                

DCR                                                                                                                                      

Loan Balance                                                                                                                        

Cap Rate                                                                                                                               

Market Value                                                                                                                        

   (Millions)

LTV                

a (impact).           

b (value y6 & LTV ratio)

Reconstruct Table 15.3 and estimate the current market value of Noname Apartments using the discounted cash-flow technique. In this reconstruction, assume that NOI in years two and three will be 50 percent below that forecast for year one (while the property’s access road is undergoing improvements), but that the fourth year’s NOI will be the same as that in year one and NOI will grow thereafter at 6 percent per year for the foreseeable future. Capitalize the sixth year’s NOI at 9 percent, and discount the cash flows at 15 percent.

                                1                    2                     3                      4                      5                 6  

NOI                                                                                                                                   

Less: DebtServ                                                                 

BTCF                                                                                                                                

DCR                                                                                                                                      

Value ($M)                                                                                                                                       

LTV                                                                                                                                      

YEAR             NOI                 PV @ 15%

1                                                                    

2                                                                    

3                                                                    

4                                                                    

5                                                                    

6                                                                    

                                                                      

6th year value $                        $                    

PV of all benefits                                                 Rounded to                      

Reconstruct the table, assuming that effective gross income grows at 3 percent per annum and operating expenses grow at 6 percent per annum. Would you expect the reduced prospect for growth in NOI to have an impact on the market-derived overall capitalization rate? b. Based on the reconstructed table, what would be the LTV ratio at the end of the sixth year if the market-derived overall capitalization rate dropped to 8.5 percent? 1 2 3 4 5 6 EGI Less: Op.Exp. NOI Less: DebtServ BTCF DCR Loan Balance Cap Rate Market Value (Millions) LTV a (impact). b (value y6 & LTV ratio) Reconstruct Table 15.3 and estimate the current market value of Noname Apartments using the discounted cash-flow technique. In this reconstruction, assume that NOI in years two and three will be 50 percent below that forecast for year one (while the property??s access road is undergoing improvements), but that the fourth year??s NOI will be the same as that in year one and NOI will grow thereafter at 6 percent per year for the foreseeable future. Capitalize the sixth year??s NOI at 9 percent, and discount the cash flows at 15 percent. 1 2 3 4 5 6 NOI Less: DebtServ BTCF DCR Value ($M) LTV YEAR NOI PV @ 15% 1 2 3 4 5 6 6th year value $ $ PV of all benefits Rounded to

Explanation / Answer

Particulars                                                                       Year

                                                         1                   2                    3                    4                  5       

Next year's anticipated NOI /                       $211000 /       $224000 /         $237000 /        $251000 /     $266000 /

Current year capitalization rate                         0.09                0.09                0.09                 0.09             0.09

                                                                 =$2344444      =$2488888      =$2633333       =$2788888 =$2955555

                                                                 =$2300000      =$2500000      =$2600000       =$2800000 =$3000000