A.CRE Real Estate Financial Models Download Guide.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1
2	A.CRE MODELS GUIDE
3	Click here to learn to use this guide
4	Model Name		Property Type											Analysis Type					Features
5		Purpose	Apt	Office	Retail	Industrial	SFR	Hotel	Land	Self Storage	Condo/TwnHm	RV Park	Student Housing	Dev	Acq	Val-Add	Asset Mgmt	Debt	Equity WF	Clawback	Ground Lease	Author	Last Updated	Notes	Link to Model

6	1031 Exchange – Overview, And Analysis Tool	Tool	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Michael	Apr-2022	Tool for analyzing 1031 exchanges	https://www.adventuresincre.com/1031-exchange/
7	3-Tiered Acquisition Debt Module	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Michael	Feb-2019	Tool for analyzing real estate debt. Choose how many months of interest only payments, amortization period, and total term for each of the three tiers. Account for taking out additional capital to finance a portion of capital improvements during the hold period. Model will automatically re-amortize loans when additional capital is drawn. Select how the lender will calculate interest on each loan – 30/360, actual/360, or actual/365	https://www.adventuresincre.com/3-tiered-debt-module/
8	A.CRE Apartment Development Model (Updated Dec 2024)	Standalone	Yes	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Dec-2024	A robust, institutional-quality apartment development model with a simple and intuitive design. Includes an extensive development module, expandable unit mix capability, a retail module, simple or detailed OpEx underwriting, single or double promote, basic sensitivity analysis, permanent debt module, and more.	https://www.adventuresincre.com/apartment-development-model/
9	A.CRE Geocoding Excel Add-In To Auto-Populate Latitude And Longitude In Excel	Tool	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Spencer	Jun-2024	Excel Add-in that uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating latitude and longitude (or address) in Excel easy. It includes various features to help add or change the API key and to cut down on unnecessary API requests.	https://www.adventuresincre.com/geocoding-excel-add-in/
10	A.CRE Hotel Valuation Model In Excel	Standalone	No	No	No	No	No	Yes	No	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	Michael	Sep-2022	Institutional quality hotel valuation model in Excel for underwriting existing stabilized and value-add hotel acquisition opportunities.	https://www.adventuresincre.com/hotel-valuation-model/
11	A.CRE Self Storage Development Model	Standalone	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Feb-2024	Institutional-quality self storage development model with a simple and intuitive design. Includes an extensive development module, expandable unit mix capability, other income section, fixed and variable construction financing, monthly and annual cash flows, single or double promote, basic sensitivity analysis, permanent debt module, and more.	https://www.adventuresincre.com/self-storage-development-model/
12	A.CRE Value-Add Apartment Acquisition Model	Standalone	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Yes	No	Yes	Yes	No	No	Spencer	Nov-2023	Institutional-quality value-add apartment acquisition model with a simple and intuitive design. Includes an extensive investment cash flow and renovation budgeting module, option for up to four capital sources, in-place and stabilized operating cash flow underwriting, option to either sell or refinance at stabilization, 4-tier equity waterfall, and much more.	https://www.adventuresincre.com/a-cre-value-add-apartment-acquisition-model/
13	All-In-One (Ai1) Model For Underwriting Development And Acquisitions	Standalone	Yes	Yes	Yes	Yes	No	No	No	Yes	No	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No	Spencer	Nov-2024		https://www.adventuresincre.com/all-in-one-underwriting-model-for-real-estate-development-and-acquisition/
14	Apartment Acquisition Model With Monte Carlo Simulation Modulel	Standalone	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Jan-2021		https://www.adventuresincre.com/apartment-acquisition-model-with-monte-carlo-simulation-module/
15	Back-Of-The-Envelope Office, Retail, Industrial Acquisition Model	Standalone	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Yes	No	No	Yes	No	No	No	Michael	Oct-2018		https://www.adventuresincre.com/new-officeretailindustrial-acquisition-model/
16	Commercial Mortgage Loan Analysis Model	Tool	Yes	Yes	Yes	Yes	No	Yes	No	Yes	No	No	No	No	Yes	Yes	No	No	No	No	No	Spencer	Mar-2024		https://www.adventuresincre.com/commercial-mortgage-loan-analysis-model/
17	Condominium Development Model (Updated Nov 2024)	Standalone	No	No	No	No	No	No	No	No	Yes	No	No	Yes	No	No	No	Yes	Yes	No	No	Michael	Nov-2024		https://www.adventuresincre.com/condominium-development-model/
18	Construction Draw And Interest Calculation Model	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Feb-2024		https://www.adventuresincre.com/construction-draw-interest-calculation-model/
19	Development Draw Schedule – Visually Customize Each Line Item	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	No	No	No	No	No	No	No	Michael	Apr-2022		https://www.adventuresincre.com/draw-schedule-custom-cash-flows/
20	Excel Pro Forma For Flipping Houses	Standalone	No	No	No	No	Yes	No	No	No	No	No	No	No	Yes	Yes	No	Yes	Yes	No	No	Spencer	Apr-2024		https://www.adventuresincre.com/excel-pro-forma-for-flipping-houses/
21	Excel-Based Restaurant Selection Tool For The Overly Indecisive	Tool	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Spencer	Dec-2018		https://www.adventuresincre.com/excel-based-restaurant-selection-tool/
22	Ground Lease Valuation Model	Module	No	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	Yes	Yes	No	Yes	Spencer	May-2024		https://www.adventuresincre.com/ground-lease-valuation-model/
23	Hotel Acquisition Model – The Basic Model	Standalone	No	No	No	No	No	Yes	No	No	No	No	No	No	Yes	No	No	Yes	Yes	No	No	Michael	Oct-2019		https://www.adventuresincre.com/basic-hotel-acquisition-model/
24	Hotel Development Model	Standalone	No	No	No	No	No	Yes	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Michael	Feb-2024		https://www.adventuresincre.com/hotel-development-model/
25	Hotel Proforma Basics – Hotel Cash Flow Projection	Standalone	No	No	No	No	No	Yes	No	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	Michael	Dec-2018		https://www.adventuresincre.com/hotel-proforma-basics-hotel-cash-flow-projection/
26	Industrial Real Estate Development Model (Updated Nov 2024)	Standalone	No	No	No	Yes	No	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	Yes	Spencer	Nov-2024		https://www.adventuresincre.com/industrial-development-model/
27	Land Development Model – Multi-Scenario	Standalone	Yes	No	No	No	Yes	No	Yes	No	Yes	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Jun-2024		https://www.adventuresincre.com/flexible-land-development-model/
28	Linear Mortgage Payment Schedule Tool	Tool	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	Spencer	Jul-2024		https://www.adventuresincre.com/linear-mortgage-schedule/
29	Loan Payment Schedule And Balance Tracking Tool	Tool	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	Spencer	Aug-2024		https://www.adventuresincre.com/loan-payment-schedule-tracking-tool/
30	Mixed-Use Development Model: Condo and Retail (Updated Nov 2024)	Standalone	No	No	Yes	No	No	No	No	No	Yes	No	No	Yes	No	No	No	Yes	Yes	No	No	Michael	Nov-2024		https://www.adventuresincre.com/mixed-use-development-model-condo-retail/
31	Multifamily (Apartment) Acquisition Model	Standalone	Yes	No	No	No	No	No	No	No	No	No	No	No	Yes	No	Yes	Yes	Yes	No	No	Spencer	Dec-2020		https://www.adventuresincre.com/multifamily-apartment-acquisition-model-in-excel/
32	Multifamily Redevelopment Model	Standalone	Yes	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	Yes	No	No	No	Michael	Jun-2020		https://www.adventuresincre.com/multifamily-redevelopment-model/
33	Physical Occupancy Calculation Model For Real Estate	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	May-2022		https://www.adventuresincre.com/physical-occupancy-calculation-template/
34	Pro Forma For Multifamily Renovation	Standalone	Yes	No	No	No	No	No	No	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	Michael	Nov-2021		https://www.adventuresincre.com/pro-forma-for-multifamily-renovation/
35	Publicly Traded Tenant Analysis Tool	Tool	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Michael	May-2022		https://www.adventuresincre.com/publicly-traded-tenant-analysis/
36	Real Estate Acquisition Due Diligence Checklist	Tool	No	No	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	No	No	No	Spencer	Jan-2021	Checklist tool	https://www.adventuresincre.com/real-estate-acquisition-due-diligence-checklist/
37	Real Estate Acquisitions Model #2 For Office, Retail, Industrial	Standalone	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Yes	No	No	Yes	No	No	No	Michael	Aug-2021		https://www.adventuresincre.com/real-estate-acquisitions-model-2-0/
38	Real Estate Capital Account Tracking Tool	Tool	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	No	No	No	No	No	Yes	No	No	No	No	Spencer	Apr-2024		https://www.adventuresincre.com/real-estate-capital-account-tracking-tool/
39	Real Estate Debt Module In Excel	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	May-2024		https://www.adventuresincre.com/real-estate-debt-module/
40	Real Estate Development Due Diligence Checklist	Tool	No	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	No	No	No	No	Spencer	Jan-2021	Checklist tool	https://www.adventuresincre.com/real-estate-development-due-diligence-checklist/
41	Real Estate Development Tracker	Tool	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	No	No	No	No	No	No	No	Michael	Feb-2024		https://www.adventuresincre.com/real-estate-development-tracker/
42	Real Estate Equity Waterfall Model – Irr And Equity Multiple Hurdles	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Sep-2024		https://www.adventuresincre.com/real-estate-equity-waterfall-model/
43	Real Estate Equity Waterfall Model – Monthly Periodsl	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Jul-2021		https://www.adventuresincre.com/excel-real-estate-equity-waterfall-model-monthly-periods/
44	Real Estate Equity Waterfall Model With Cash-On-Cash Return Hurdle	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Jul-2024		https://www.adventuresincre.com/real-estate-equity-waterfall-model-cash-on-cash-return-hurdle/
45	Real Estate Equity Waterfall Model with Catch Up and Clawback (Updated Dec 2024)	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Dec-2024		https://www.adventuresincre.com/real-estate-equity-waterfall-model-catch-up-clawback/
46	Real Estate Portfolio Valuation Model	Standalone	No	No	No	No	No	No	No	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	Spencer	Aug-2022	Portfolio	https://www.adventuresincre.com/real-estate-portfolio-acquisition-model/
47	Real Estate Sources And Uses Of Capital Module	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Feb-2024		https://www.adventuresincre.com/real-estate-sources-uses-module/
48	Refinance Risk Analysis Tool In Excel	Tool	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	No	No	Yes	No	No	No	Spencer	Nov-2023		https://www.adventuresincre.com/refinance-analysis-tool/
49	Residential Land Development Pro Forma	Standalone	No	No	No	No	Yes	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Feb-2024		https://www.adventuresincre.com/residential-land-development-model/
50	S-Curve Forecasting In Real Estate Development	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	No	No	No	Yes	No	No	No	Spencer	Sep-2021		https://www.adventuresincre.com/development-budget-distributing-cash-flows-using-the-s-curve-method/
51	Self Storage Acquisition Model	Standalone	No	No	No	No	No	No	No	Yes	No	No	No	No	Yes	Yes	No	Yes	Yes	No	No	Spencer	Nov-2023		https://www.adventuresincre.com/self-storage-acquisition-model/
52	Setting Up A New Real Estate Financial Model – Date And Period Headers Plus Formatting	Module	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Spencer	Apr-2022	Date-Period Template	https://www.adventuresincre.com/date-and-period-headers-plus-formatting/
53	Simple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2024)	Standalone	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Yes	No	Yes	Yes	Yes	No	No	Spencer	Dec-2024		https://www.adventuresincre.com/real-estate-acquisition-model-for-office-retail-or-industrial-properties/
54	Single Family Home Construction Pro Forma For Home Builders	Standalone	No	No	No	No	Yes	No	No	No	No	No	No	Yes	No	No	No	Yes	No	No	No	Spencer	Jan-2024		https://www.adventuresincre.com/new-sf-home-construction-pro-forma-excel/
55	Single Family Rental Proforma	Standalone	No	No	No	No	Yes	No	No	No	No	No	No	No	Yes	Yes	No	Yes	Yes	No	No	Michael	Apr-2023		https://www.adventuresincre.com/single-family-rental-proforma/
56	Single Family Residential Investment Analysis Model	Standalone	No	No	No	No	Yes	No	No	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	Spencer	Feb-2022		https://www.adventuresincre.com/single-family-residential-investment-analysis-model/
57	Single Tenant NNN Lease Valuation Model	Standalone	No	No	Yes	No	No	No	No	No	No	No	No	No	Yes	No	No	Yes	No	No	No	Spencer	May-2024		https://www.adventuresincre.com/single-tenant-nnn-lease-valuation-model/
58	The Advanced Mortgage Amortization Module	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	May-2024	Mortgage amortization	https://www.adventuresincre.com/advanced-amortization-table/
59	Watch Me Build – Custom Rent Schedule Module	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Spencer	Jul-2021		https://www.adventuresincre.com/watch-me-build-custom-rent-schedule-module/
60	Waterfall Model For Real Estate Joint Ventures With Catch Up	Module	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Michael	Feb-2016		https://www.adventuresincre.com/new-real-estate-jv-waterfall-model/
61	Retail Real Estate Development Model	Model	No	No	Yes	No	No	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Apr-2024		https://www.adventuresincre.com/retail-development-model/
62	Office Real Estate Development Model	Model	No	Yes	No	No	No	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Apr-2024		https://www.adventuresincre.com/office-development-model/
63	3 Tiered Waterfall Module Added to the Condo Development Model	Module	No	No	No	No	No	No	No	No	Yes	No	No	Yes	No	No	No	No	Yes	No	No	Michael	Sep-2017		https://www.adventuresincre.com/condo-waterfall/
64	Student Housing Acquisition Model	Model	No	No	No	No	No	No	No	No	No	No	Yes	No	Yes	No	Yes	Yes	Yes	No	No	Spencer	Apr-2023		https://www.adventuresincre.com/student-housing-acquisition-model/
65	RV Park Acquisition Model	Model	No	No	No	No	No	No	No	No	No	Yes	No	No	Yes	No	Yes	Yes	Yes	No	No	Michael	May-2023		https://www.adventuresincre.com/rv-park-acquisition-model/
66	Commercial Real Estate Lease Analysis Tool	Tool	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Spencer	Jul-2023		https://www.adventuresincre.com/commercial-lease-analysis-tool/
67	Supercharge Excel With The ‘Excel 4 CRE’ Add-In	Tool	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Spencer	Aug-2024		https://www.adventuresincre.com/custom-excel-addin-for-real-estate/
68	RV Park Development Model	Model	No	No	No	No	No	No	No	No	No	Yes	No	Yes	No	No	No	No	Yes	No	No	Michael	Jan-2024		https://www.adventuresincre.com/rv-park-development-model/
69	A.CRE Build-to-Rent (BTR) Development Model (Updated Nov 2024)	Model	No	No	No	No	Yes	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Spencer	Nov-2024		https://www.adventuresincre.com/build-to-rent-development-model/
70	Multifamily Development Model	Model	Yes	No	No	No	No	No	No	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No	Michael	Apr-2024		https://www.adventuresincre.com/mutlifamily-development-model/
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100