Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please make a model in excel You are an investor looking to acquire a 100 unit apartment in Gainesville, FL. It is a Class A

please make a model in excel
image text in transcribed
image text in transcribed
image text in transcribed
You are an investor looking to acquire a 100 unit apartment in Gainesville, FL. It is a Class A property with no major damages (no capital expenditures needed). You can purchase the property for $8,750,000 today and you charge $1,000 a month for each unit on a 12 month lease. You also believe that your rent will grow at a constant yearly rate of 1.5% and project that you will have vacancy and collection losses of 3% annually to account for any of the 100 tenants to not pay a portion of their rent. You are assuming all tenants will need parking so you charge $50 a month for their parking spot (miscellaneous income). Every year maintenance and utilities will cost you $200,000 (Operating Expenses) and it will grow at 1.5% yearly. You think that based on your market projections, you can sell your property in 5 years for $10,500,000 and you expect there to be selling expenses of 6%. You will not invest in this property unless you can realize an unlevered before tax return of 10% Once you complete the model, meinen Directions 1. Fill out assumptions in the designated assumption box 2. Fill out the proforma box by referencing the assumptions (no mare coding 13. Use the year proforma to reference your cash flow from operations 4. Calculate unlevered before tex NPV and RB using the cash row tre operations D Ta LE RE ESTER Discounted Cash Flow Red Cells Greences incorrect Answ Correct An Assumptions Monthly Rent Per Unit Number of Units Rent Growth (YLARLY) Vacancy/Collection Losses Miscellaneous income Per Month OpX YEARLY Opx Growth [YEARLY) CapX Purchase Price (YEAR 0) Sale Price (LAR) Selling tips Require Return BA) Unlevered Before Tax Serraforma YAZ YAD VR Potential Greas income Vacanty and Collection Misteme rective drons income OP CADX set Operating income important continens Letture Net Chew From Operations YRI YRI YR. YAO YRS UV Before Tex Valuations NPV Unlevered Beton TEX

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethics In Finance Case Studies From A Womans Life On Wall Street

Authors: Kara Tan Bhala

1st Edition

3030737535, 978-3030737535

More Books

Students also viewed these Finance questions

Question

What must a creditor do to become a secured party?

Answered: 1 week ago