Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are considering the acquisition of Colony Park Apartments. Colony Park is a 1 2 - unit apartment complex that is up for sale in
You are considering the acquisition of Colony Park Apartments. Colony Park is a unit apartment complex that is up for sale in the amount of $ You plan to purchase this property with debt. The unit apartment complex is expected to generate gross scheduled rent in the amount of $ per month. Additionally, you rent parking spots for an additional $month each. Your property has a vacancy loss which we deduct as a proportion of gross scheduled rent for the purposes of determining NOI and $ in monthly operating expenses. Given you have units and only parking spots, you are comfortable assuming no parking vacancy during the holding period. Lastly, at the end of year you plan to sell the property at market value. You expect the property to appreciate per year.
You plan to purchase this property using a partially amortized loan at a contract interest rate of interest compounds monthly The initial loan partially amortizes for years, requires $ in origination fees, and assumes you place down on the property meaning $k down and that you thus finance the remaining $ with the lender. The initial loan is structured such that at the end of years, you owe a balloon in the amount of $ which you plan to refinance into a new loan. At the time of refinance, you expect market interest rates to be at and you also expect to be able to secure a loan on the remaining balance of your previous loan which in this case is the $ balloon owed at maturity This new loan, which would require $ in origination fees, partially amortizes for years. At the end of maturity, you will face a balloon in the amount of $
What is the reversion value or expected sale price of this asset at the end of Year Round to two decimals.
What is monthly gross scheduled rent? Round to two decimals.
What is the total sum of YEAR NOI? Round to two decimals.
What is the assets cap rate at the time of acquisition? Eg what is the cap rate based on the acquisition cost and YEAR NOI? Enter this number as a percent. For example, if your answer is enter
What is this property's unlevered IRR expressed in monthly terms? Express this number as a percent. For example, if your answer is enter
What is this property's levered IRR expressed in monthly terms? Express this number as a percent. For example, if your answer is enter
What is the loan to value ratio for the initial loan on this property? Enter this value as a number NOT a percent. For instance, if your LTV is write below. round to two decimals.
What is the DSCR or DCR for the initial loan? Enter this value as a number NOT a percent. For instance, if your LTV is write below. round to two decimals.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started