Given the assumptions below, answer the following questions.
Assume an above the line treatment of CAPEX
Express your answers as positive numbers.
Property Price	$1,509,736
Year 1 PGI	$378,380
V&C Losses	12% of PGI
Operating Expenses	28% of EGI
Capital Expenditures	8% of EGI
Holding Period	6 years
Selling Expenses	3.9% of expected future sale price
LTV	78%
Loan Rate	4.00%
Loan Term	32
Assume monthly payments

1. What is the estimated Year 1 EGI? Round to the nearest dollar.

2. What are the estimated Year 1 Operating Expenses? Round to the nearest dollar.

3. What is the estimated Year 1 CAPEX? Round to the nearest dollar.

4. What is the estimated Year 1 NOI? Round to the nearest dollar.

5. Based on the LTV, above, find the mortgage amount. Round to the nearest dollar.

6. Find the annual Debt Service. Round to the nearest dollar.

7. What is the estimated going-in cap rate (R0) using year 1 NOI and the property price?

8. Find the year 1 Debt Coverage Ratio.

9. Suppose that the property will be sold in year 6 for NOI7 capitalized at a terminal cap rate of 11.42%. If NOI7 is $274,816, find the expected sale price of the property.

10. Find the mortgage balance when the property is sold. Hint, if the holding period is 6 years, the property is sold in month 72.