A.CRE-Hotel-Model-Beta-Version-2.02-oyayur

School: University of Illinois, Urbana Champaign - Course: FIN 446 - Subject: Accounting

HOTEL ACQUISITION MODEL Model Resources Author: Michael BelascoImportant Lin CompatibilityExcel 2013 Excel 2016 Excel 365 Changelog v1.0 Initial release of model v1.1 Added 4-tier Waterfall Model with IRR Hurdles. Fixed bugs in rows 20, 21, 26, and 27 of the CFSummary tab. v2.0 Added Sensitivity Analysis to Summary Page Added Transfer PIP Cost to Acquisition Assumptions Put Franchise Fee Under Undistributed Expenses Removed Major Capital Expenditures Line Item Fixed formatting and minor errors v2.01 Added link to a video to explain how to fix the data table issue for those that experience it in the F&B tab. v2.02 Unlinked exit cap reference to data table to correct summary results. All scenario options are now hhttps://www.adventuresincre.com/Visit this Mod Tutorials For Browse our e AdventuresinCRE.com and its affiliates do not provide tax, legal, investment, or accounting advice. This material has been p to provide, and should not be relied on for, tax, legal or accounting advice. You should consult your own tax, legal and acco LEARN TO BUILD INSTITUTIONAL-LEVEL REAL ESTATE MODELS FROM SCRATCH

v2.02 nks: hard coded