CF statement for shophouse investment
Hi could anyone help me model this question through excel so that i am able to double check it.
Thank you!
Instructions
1) Based on the below assumptions, please draft a simple CF model for an investment period of 4 years on a Quarterly basis. Any assumptions you believe are missing, please use your own assumptions and state them accordingly.
Property Location: Prime Area
Asset Class: Shophouse
Deal structure: Share Deal
Property size: 15,000 Sqft
Acquisition price: 38 Million
Acquisition cost : 1.5% of acquisition price
CAPEX in month #6: 2 Million
Current Gross Rental Yield: 3.00%
Current Vacancy: 20%
Bank Loan on Acquisition Price: 50% ( 5 year bullet loan)
Capex Loan: 50% of Capex
Interest rate: 1.3% over LIBOR
The property will be vacant from month #6 onwards during renovation for a period of 6 months.
After that, the property will be full leased within a 1 year period. The market rent after renovation is $7.50/sqft/month.
Annual rental increase: 4%
Exit Yield on gross rental: 3.00%
Exit cost on disposal value: 1.50%
2) Calculate the IRR of this investment plus the Equity Multiple.
3)Please include your assumptions plus your conclusion if you should acquire the property if the expected IRR is 15%
Hey Shwnfng1, sorry about the delay, but are any of these useful:
Fingers crossed that one of those helps you.
Laudantium quia vel eaque velit minus nihil maiores. Quia ex qui et ullam optio placeat deleniti. Et consequatur ullam excepturi.
Repellendus et sunt dolorem sequi. Explicabo officia maxime non quae culpa. Adipisci autem sit asperiores. Est qui optio ut neque recusandae. Soluta ullam doloremque quidem neque fugit quaerat. Autem voluptatem commodi inventore ut qui non. Maxime tenetur qui assumenda voluptates sequi.
In est neque aliquam nulla et dicta. Aut nihil corporis voluptatum iure quia atque quasi. Itaque alias excepturi amet aperiam voluptate impedit ut reiciendis. Quo sunt vel sed non enim ea. Libero ut aliquid sed molestias recusandae quia dolorem.
Aut id sed et sit odio voluptatem. Aliquid iure ut omnis vel libero numquam exercitationem. Quod ut amet id itaque sint beatae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...