In early $2018,$ Diana Mulhall found herself at a pivotal financial crossroads. After years of dedicated service at a management consultancy firm, she made the bold decision to embark on a new journey by starting her own risk assessment advisory business in her hometown of Chicago. This career move prompted Mulhall to evaluate her assets, including a one$-$bedroom condo in Toronto's bustling financial district. As she weighed her options between selling the property or transforming it into a rental investment, Mulhall delved into a comprehensive analysis, considering various factors such as market trends, neighborhood dynamics, potential returns, and associated risks.

Background and Property Details:

Mulhall's Toronto condominium, situated in the $35-$story boutique building at $21$ Nelson St$.,$ offered luxurious loft$-$style living with amenities like $24-$hour concierge service, exercise facilities, and a rooftop bar. The one$-$bedroom unit boasted a prime location, being just a kilometer away from the Canadian Imperial Bank of Commerce $($CIBC$)$ headquarters and within walking distance of various amenities. Purchased in July $2013$ for $$374,000,$ the property had appreciated significantly amid Toronto's booming real estate market.

Neighborhood Dynamics:

The condo was located in the Waterfront Communities $$ The Island neighborhood, known for its proximity to Lake Ontario and the bustling business district. The area experienced a notable population increase of $52\%$ between $2011$ and $2016,$ with a majority of residents falling within the working$-$age demographic. Its central location earned it high transit and walk scores, making it highly desirable for both residents and investors.

Market Trends:

Toronto's real estate market had been thriving, with consistent rent increases averaging $2\mathrm{.}7\%$ annually since $2006.$ Vacancy rates were virtually non$-$existent, indicating strong demand for rental properties in central Toronto. Institutional investments in the city further reinforced its robust market outlook, with cap rates for multifamily properties experiencing a steady decline over the years.

Options Considered:

Mulhall contemplated two primary options: selling the condo or converting it into a rental property. Selling would offer immediate liquidity but might not maximize long$-$term returns. On the other hand, leasing the unit could provide a steady income stream, albeit with ongoing expenses and potential risks.

Financial Analysis:

To assess the viability of renting out the condo, Mulhall gathered data on recent sales and leases in her building. This information allowed her to estimate potential rental income and expenses, factoring in variables such as vacancy rates, rent growth, and future sales price. With benchmark assumptions in place, Mulhall calculated the expected rate of return over a ten$-$year holding period.

Risk Assessment:

As a seasoned expert in risk management, Mulhall recognized the importance of mitigating potential risks associated with the investment. Key considerations included the uncertainty surrounding future sales prices, rental rate fluctuations, and the property's occupancy levels. Additionally, Mulhall weighed the impact of currency fluctuations, given that rental income would be received in a foreign currency due to her commuting history across the border.

Decision Making:

In her decision$-$making process, Mulhall sought to strike a balance between maximizing financial returns and managing potential risks. While selling the condo offered immediate liquidity, Mulhall recognized the long$-$term value of retaining the property as a rental investment, particularly given Toronto's thriving real estate market and high demand for rental properties. By leveraging her expertise in risk assessment, Mulhall felt confident in her ability to navigate the uncertainties associated with property ownership and rental

Create a ten$-$year pro forma for the property$-$level cash flows using the provided Excel pro$-$forma tem

All yellow cells must be filled out and rationalized.

Does anything stand out here?

Given your analysis, should Diana rent or sell her condo?

CAPEX share of NOI Your answer should incorporate;

Is the IRR generated sufficient?

Consider the highest and best use theory; is the condo worth more as a rental than the sale price?

Any non$-$financial factors $($ie$,$ demographics, foreign ownership, $3$rd party information, etc.$)$ you feel relevant.

current noi is$52\mathrm{.}56\%.$ please fill the excel sheet

Create a ten$-$year pro forma for the property$-$level cash flows using the provided Excel pro$-$forma tem

ROI if sale is made now

Initial Investment$/$Purchase price $$374,000$

Current Value$/$Sale Price $$569,480$

Net Gain $($S$-$P$)$ $$195,480$

ROI $=($Net Return $/$ Cost of investment$)*100$

ROI $=(1,95,480/3,74,000)*100$

Therefore, ROI $=52\mathrm{.}26\%$

create a $10$ year table for the below

Rent

Vacancy

Total Revenue

Maintenance

Property Tax

Insurance

Total Expenses

NOI

Sales Price

Sales Expenses