I’ve updated my Portfolio Acquisition Model to include the following changes:

– Added an “Investor Level Returns” tab to the model, which uses my Real Estate Equity Waterfall Model to calculate the equity returns of the sponsor (GP) and the limited partners (LPs)

– Added an “Investor Returns” box to the Portfolio Summary tab, summarizing the results of the Investor Level Returns tab

– Fixed some errors in conditional formatting

– Fixed an error on the Portfolio Summary tab, that had referenced the wrong cell when outputting the Levered IRR

– Fixed an error on the Debt tab, where the individual loan balances were not appearing

– Additional formatting to improve the look of the model

Visit the Real Estate Portfolio Acquisition Model page to download the updated model.