A.CRE
A.CRE Home
A.CRE Accelerator
Learn More
Login
Artificial Intelligence
Careers
Consulting and Advisory
CRE Event Calendar
CRE Job Board
Education
Library of Excel Models
University Profiles
Contributors
FAQs
Knowledge Base
AI Assistant
Contact Us
A.CRE
A.CRE Home
A.CRE Accelerator
Learn More
Login
Artificial Intelligence
Careers
Consulting and Advisory
CRE Event Calendar
CRE Job Board
Education
Library of Excel Models
University Profiles
Contributors
FAQs
Knowledge Base
AI Assistant
Contact Us
I have a question about a model...
home
/
Knowledge Base
/
I have a question about a model...
/
Popular Search:
How do I
,
What is
,
Why
A.CRE Geocoding Excel Add-In
Geocode script doesn’t work – The A.CRE Geocoding Add-in for Excel, nor the text-based module (VBA code) works.
Getting ‘Server Denied’ or Request Denied
I need help to modify (customize) the model
View All 3
All-In-One
Are there any limitations in the ORI Module of the All-In-One Model?
Basic version of AIO for stabilized cap rate/yield, unlevered vs levered returns,equity multiple, cash on cash, and IRR?
Besides legal, and 3rd party and due diligence costs, does title insurance cost, go under the same “closing cost” under purchase price?
Can the AIO do a project with hotel, retail and condo development?
Does the All-in-One include a residual land value module?
View All 33
3-Tiered Acquisition Debt Module
I need help to modify (customize) the model
What kind of debt can I add?
View All 2
Actual + Forecast Construction Draw Schedule
How do I add more periods?
How do I extend the schedule beyond 24 months?
I need help to modify (customize) the model
Where can I find the S-Curve in the Actual + Forecast Construction Draw Schedule?
Will the s-curve spreadsheet work as a stand alone spreadsheet?
View All 5
Advanced Amortization Model
I need help to modify (customize) the model
Why doesn’t the monthly payment change when I switch between 30/360 vs actual/360?
View All 2
Apartment Acquisition Model with Monte Carlo Simulation Module
Does the Apartment Acquisition Model have COC, IRR, Average Annual Return, and IRV?
Is there a way to toggle from Added Value format to Turnkey format?
I need help to modify (customize) the model
When saving the model Excel freezes up
View All 4
Apartment Development Model
Cell I56 on the Underwriting Tab, (Equity) is a plug?
Does the apartment development model work if I don’t plan on selling the asset?
How to account for taxes on parcel during construction without forcing it?
I need help to modify (customize) the model
Why is the Equity amount (cell I54) left as a hard-coded value?
View All 5
Back-of-the-Envelope Office, Retail, Industrial Acquisition Model
I need help to modify (customize) the model
View All 1
Basic Hotel Acquisition Model
How do I change the purchase price after inputting the OpCashFlow revenue values?
How do I use the Sensitivity Analysis in the Summary Tab?
I need help to modify (customize) the model
When I enter the current years “TTM” (Trailing Twelve Month) financials it causes the formulas to break down.
View All 4
Commercial Mortgage Loan Analysis Model
I need help to modify (customize) the model
When do I need to use the Refinance Analysis tab?
View All 2
Condominium Development Model
In inputs, how would I enter the square footage to model townhomes if there were garages on the ground floor, living and kitchen on the second, and two beds on the third floor?
I’ve created a #DIV/0 error in the Retail Section that I’m unable to remove, even after turning off the retail section in the control room tab
I need help to modify (customize) the model
The XIRR function doesn’t work if the value in the first month is 0?
Why can’t the CF tab reflect amount sold past month 36?
View All 6
Construction Draw and Interest Calculation Model
Cell J73 & J74 of the budget sheet show a message “Incomplete”. These two cells point to EG73 & EG74 respectively. Is this an error?
Is it possible to automatically hide the columns that are not being used?
I need help to modify (customize) the model
Why isn’t iterative calculation used for figuring loan interest in this model?
Will the s-curve spreadsheet work as a stand alone spreadsheet?
View All 5
Ground Lease Valuation Model
Can I assign $0.00 as current NOI to create a $0.00 reversion value?
I need help to modify (customize) the model
View All 2
Equity Waterfall Model with Monthly Periods
I downloaded the residential land development and monthly waterfall model, but the latter is included in the prior?
Is there a way to add a scenario where we assume a refinance event in year 5 of the 10 year analysis?
I need help to modify (customize) the model
My proposal is a JV with property owner and developer. The value of the parcel is the owner’s equity contribution. Since there isn’t a cash outlay for acquisition during the investment period, should I include the value of the land in the calculator of the unlevered/IRR?
Waterfall Distribution % and Promote Calculation
View All 8
Excel Pro Forma for Flipping Houses
I need help to modify (customize) the model
What are the macros for?
View All 2
Hotel Acquisition 2.0
I need help to modify (customize) the model
Which cell do I have to modify and with which formula in order to reflect the Canadian regular SEMI-ANNUAL mortgage compounding?
View All 2
Hotel Development Model
I am having trouble following the refinance assumptions. The refinance should zero out our construction loan at repayment, why doesn’t it?
I need help to modify (customize) the model
View All 2
Hotel Valuation Model
I need help to modify (customize) the model
What are cells D62:K88 for??
View All 2
Industrial Real Estate Development Model
I need help to modify (customize) the model
Why is the Equity amount (cell I54) left as a hard-coded value?
Why should I use the industrial development model instead of the AIO?
View All 3
Loan Payment Schedule and Balance Tracking Tool
How can I add an interest-only period?
I need help to modify (customize) the model
View All 2
Mixed-Use Development Model: Condo and Retail
I need help to modify (customize) the model
What do I use the Control Room for?
View All 2
Multifamily Apartment Acquisition Model
I need help to modify (customize) the model
What is the different between this and the Simple Acquisition Model for Office, Retail, and Industrial Properties?
View All 2
Multifamily Redevelopment Model
I need help to modify (customize) the model
When do I use the Multifamily Redevelopment Model?
View All 2
Multifamily Value-Add Acquisitions
I need help to modify (customize) the model
Whats the best way to show a re-fi in year 3 with a sale and year 5?
View All 2
Real Estate Acquisition Due Diligence Checklist
How do I amend the options under the column for Status?
I need help to modify (customize) the model
View All 2
Real Estate Acquisition Model - 2.0
How is this model different from the original?
I need help to modify (customize) the model
View All 2
Real Estate Capital Account Tracking Tool
Can I add more than 4 partners?
I need help to modify (customize) the model
View All 2
Real Estate Portfolio Valuation Model
Can I have different property start dates?
I need help to modify (customize) the model
View All 2
Residential Land Development Pro Forma
Do you have a more detailed version of the back-of-the-envelope template that is that simple to use?
Do you have a spreadsheet to learn about anticipated cost in the actual land’s development – clearing, road access, utilities, etc?
I downloaded the residential land development and monthly waterfall model, but the latter is included in the prior?
I need help to modify (customize) the model
What info do I need to put in for each phase?
View All 7
S-Curve Forecasting
I need help to modify (customize) the model
Will the s-curve spreadsheet work as a stand alone spreadsheet?
View All 2
Self Storage Development Model
Can I use it to analyze a value add property that has room for expansion?
Cell I54 seems hard-keyed or a value copy error from a previous version. I see where this pulls – I202 – but they don’t connect.
How do I make the hold period 10 years?
I’m not able to get the model to convert debt from I/O to amortizing
I need help to modify (customize) the model
View All 8
Simple Acquisition Model for Office, Retail, and Industrial
I need help to modify (customize) the model
Where do I put in my data?
View All 2
Single Family Home Construction Pro Forma for Home Builders
How do I add more homes?
I need help to modify (customize) the model
View All 2
Single Family Residential Investment Analysis Model
Can this spreadsheet be modified for the BRRR (buy, rehab, rent, refi, repeat) strategy?
How long can I set my investment to last for?
I need help to modify (customize) the model
View All 3
Single tenant NNN Lease Valuation Model
I need help to modify (customize) the model
Why is there more than one discount rates?
View All 2
Value-Add Apartment Acquisition Model
Is there a best way to analyze a value add mixed use (Multifamily + retail) asset within your models?
Is there a way to add more debt sources without breaking the model?
LP capital is not fully returned first before distributions are made. Is there a setting to make LP capital be prioritized before distributions are made?
I need help to modify (customize) the model
On the refi module, shouldn’t the refi amount be a percentage of the new value of the building (k203 not k48)?
View All 7
4-Tier Equity Multiple Waterfull
I need help to modify (customize) the model
Waterfall Distribution % and Promote Calculation
What is each tier for?
View All 3
Waterfall Model for Real Estate Joint Ventures with Catch-Up
I need help to modify (customize) the model
Waterfall Distribution % and Promote Calculation
Why isn’t there catch-up in my model?
View All 3
Waterfall Model with Cash-On-Cash Hurdle
If cash flow for period 10 is $100,000 does the capital account increase pro-rata, then decrease by the amount of distributions?
I need help to modify (customize) the model
Waterfall Distribution % and Promote Calculation
Why aren’t there any tiers in this model?
View All 4
Waterfall Model with Catch Up and Clawback
How do I work the Catch Up?
Is there a reason that the GP and Catch-up is activated when we set LP ownership to 100%?
I need help to modify (customize) the model
Waterfall Distribution % and Promote Calculation
What partnership types can I use?
View All 6
Waterfall Model with IRR and Equity and Multiple Hurdles
Can I add more sponsors?
I only have one hurdle, how do I turn the other hurdles off?
I need help to modify (customize) the model
Waterfall Distribution % and Promote Calculation
View All 4
After creating a new workbook and putting in new data, the returns are still based on the original model
Are all models easily expandable or do I need to customize?
Do you purchase the software or seat license for models? What is the price for both proformas?
Geocode script doesn’t work – The A.CRE Geocoding Add-in for Excel, nor the text-based module (VBA code) works.
Getting ‘Server Denied’ or Request Denied
Have you already added or have you considered adding Historic, NMTC, O-Fund & PACE financing into your A.CRE models?
How do I undo cells that are hidden?
Is there a simple way to replace US metrics with European metrics?
Is there a way to demo the model without being “that guy” who pays 0 to get access?
I’ve created a #DIV/0 error in the Retail Section that I’m unable to remove, even after turning off the retail section in the control room tab
Macros are disabled – I downloaded your model and the macros are disabled. How do I enable them?
Microsoft has blocked macros from running because the source of this file is untrusted. What do I do?
I need help to modify (customize) the model
My system is attempting to extract (unzip) the model I downloaded, but I can’t open it. Why did A.CRE send a zip file and why can’t my system unzip the file?
Strikethrough Lines Appear in Certain Cells After Downloading and Using an A.CRE Model
The link is broken and I can’t download the file
Trouble downloading a model?
Popular Search:
How do I
,
What is
,
Why