A.CRE
A.CRE Home
A.CRE Accelerator
Learn More
Login
Artificial Intelligence
Careers
CRE Event Calendar
CRE Job Board
Education
Library of Excel Models
Contributors
FAQs
Knowledge Base
Contact Us
A.CRE
A.CRE Home
A.CRE Accelerator
Learn More
Login
Artificial Intelligence
Careers
CRE Event Calendar
CRE Job Board
Education
Library of Excel Models
Contributors
FAQs
Knowledge Base
Contact Us
I have a question about a model...
home
/
Knowledge Base
/
I have a question about a model...
/
Search All
FAQs
Knowledge Base
Popular Search:
How do I
,
What is
,
Why
A.CRE Geocoding Excel Add-In
I need help to modify (customize) the model
Getting ‘Server Denied’ or Request Denied
Geocode script doesn’t work – The A.CRE Geocoding Add-in for Excel, nor the text-based module (VBA code) works.
View All 3
All-In-One
Wondering why the IRR Matrix sheet/tab does not come up in version .81 but it did come up in prior versions? How can I get it to come up?
Will The All-In-One Model Allow for Condo development and sale?
Why is the XIRR under “monthly” in the Summary tab and doesn’t include dollar amounts?
Why don’t you account for income tax in the NPV calculation of cashflows to be discounted?
What modules do I use for 40 apartments with some off-plan sales?
View All 32
3-Tiered Acquisition Debt Module
What kind of debt can I add?
I need help to modify (customize) the model
View All 2
Actual + Forecast Construction Draw Schedule
Will the s-curve spreadsheet work as a stand alone spreadsheet?
Where can I find the S-Curve in the Actual + Forecast Construction Draw Schedule?
I need help to modify (customize) the model
How do I extend the schedule beyond 24 months?
How do I add more periods?
View All 5
Advanced Amortization Model
Why doesn’t the monthly payment change when I switch between 30/360 vs actual/360?
I need help to modify (customize) the model
View All 2
Apartment Acquisition Model with Monte Carlo Simulation Module
When saving the model Excel freezes up
I need help to modify (customize) the model
Is there a way to toggle from Added Value format to Turnkey format?
Does the Apartment Acquisition Model have COC, IRR, Average Annual Return, and IRV?
View All 4
Apartment Development Model
Why is the Equity amount (cell I54) left as a hard-coded value?
I need help to modify (customize) the model
How to account for taxes on parcel during construction without forcing it?
Does the apartment development model work if I don’t plan on selling the asset?
Cell I56 on the Underwriting Tab, (Equity) is a plug?
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
When I enter the current years “TTM” (Trailing Twelve Month) financials it causes the formulas to break down.
I need help to modify (customize) the model
How do I use the Sensitivity Analysis in the Summary Tab?
How do I change the purchase price after inputting the OpCashFlow revenue values?
View All 4
Commercial Mortgage Loan Analysis Model
When do I need to use the Refinance Analysis tab?
I need help to modify (customize) the model
View All 2
Condominium Development Model
Would you please tell me how to change completion date for the Condominium Development Model?
Why can’t the CF tab reflect amount sold past month 36?
The XIRR function doesn’t work if the value in the first month is 0?
I need help to modify (customize) the model
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
View All 6
Construction Draw and Interest Calculation Model
Will the s-curve spreadsheet work as a stand alone spreadsheet?
Why isn’t iterative calculation used for figuring loan interest in this model?
I need help to modify (customize) the model
Is it possible to automatically hide the columns that are not being used?
Cell J73 & J74 of the budget sheet show a message “Incomplete”. These two cells point to EG73 & EG74 respectively. Is this an error?
View All 5
Ground Lease Valuation Model
I need help to modify (customize) the model
Can I assign $0.00 as current NOI to create a $0.00 reversion value?
View All 2
Equity Waterfall Model with Monthly Periods
Where do you put in the amount?
Where am I supposed to model the property-level cash flow in this model?
What do I put in for the distribution if I have a 70/30 GP split?
Waterfall Distribution % and Promote Calculation
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?
View All 8
Excel Pro Forma for Flipping Houses
What are the macros for?
I need help to modify (customize) the model
View All 2
Hotel Acquisition 2.0
Which cell do I have to modify and with which formula in order to reflect the Canadian regular SEMI-ANNUAL mortgage compounding?
I need help to modify (customize) the model
View All 2
Hotel Development Model
I need help to modify (customize) the model
I am having trouble following the refinance assumptions. The refinance should zero out our construction loan at repayment, why doesn’t it?
View All 2
Hotel Valuation Model
What are cells D62:K88 for??
I need help to modify (customize) the model
View All 2
Industrial Real Estate Development Model
Why should I use the industrial development model instead of the AIO?
Why is the Equity amount (cell I54) left as a hard-coded value?
I need help to modify (customize) the model
View All 3
Loan Payment Schedule and Balance Tracking Tool
I need help to modify (customize) the model
How can I add an interest-only period?
View All 2
Mixed-Use Development Model: Condo and Retail
What do I use the Control Room for?
I need help to modify (customize) the model
View All 2
Multifamily Apartment Acquisition Model
What is the different between this and the Simple Acquisition Model for Office, Retail, and Industrial Properties?
I need help to modify (customize) the model
View All 2
Multifamily Redevelopment Model
When do I use the Multifamily Redevelopment Model?
I need help to modify (customize) the model
View All 2
Multifamily Value-Add Acquisitions
Whats the best way to show a re-fi in year 3 with a sale and year 5?
I need help to modify (customize) the model
View All 2
Real Estate Acquisition Due Diligence Checklist
I need help to modify (customize) the model
How do I amend the options under the column for Status?
View All 2
Real Estate Acquisition Model - 2.0
I need help to modify (customize) the model
How is this model different from the original?
View All 2
Real Estate Capital Account Tracking Tool
I need help to modify (customize) the model
Can I add more than 4 partners?
View All 2
Real Estate Portfolio Valuation Model
I need help to modify (customize) the model
Can I have different property start dates?
View All 2
Residential Land Development Pro Forma
Where is the “Development Fee” variable cell?
What is the Context for the “Balance Due”?
What info do I need to put in for each phase?
I need help to modify (customize) the model
I downloaded the residential land development and monthly waterfall model, but the latter is included in the prior?
View All 7
S-Curve Forecasting
Will the s-curve spreadsheet work as a stand alone spreadsheet?
I need help to modify (customize) the model
View All 2
Self Storage Development Model
Why is the Equity amount (cell I54) left as a hard-coded value?
Why does cell Y83 discount the cash flow almost 90% of the total revenue and slowly burn off?
Where do I go to change the settings?
I need help to modify (customize) the model
I’m not able to get the model to convert debt from I/O to amortizing
View All 8
Simple Acquisition Model for Office, Retail, and Industrial
Where do I put in my data?
I need help to modify (customize) the model
View All 2
Single Family Home Construction Pro Forma for Home Builders
I need help to modify (customize) the model
How do I add more homes?
View All 2
Single Family Residential Investment Analysis Model
I need help to modify (customize) the model
How long can I set my investment to last for?
Can this spreadsheet be modified for the BRRR (buy, rehab, rent, refi, repeat) strategy?
View All 3
Single tenant NNN Lease Valuation Model
Why is there more than one discount rates?
I need help to modify (customize) the model
View All 2
Value-Add Apartment Acquisition Model
Where do I account for downtime of income during renovation?
The numbers don’t seem to be updating the IRR when I change some figures?
On the refi module, shouldn’t the refi amount be a percentage of the new value of the building (k203 not k48)?
I need help to modify (customize) 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?
View All 7
4-Tier Equity Multiple Waterfull
What is each tier for?
Waterfall Distribution % and Promote Calculation
I need help to modify (customize) the model
View All 3
Waterfall Model for Real Estate Joint Ventures with Catch-Up
Why isn’t there catch-up in my model?
Waterfall Distribution % and Promote Calculation
I need help to modify (customize) the model
View All 3
Waterfall Model with Cash-On-Cash Hurdle
Why aren’t there any tiers in this model?
Waterfall Distribution % and Promote Calculation
I need help to modify (customize) the model
If cash flow for period 10 is $100,000 does the capital account increase pro-rata, then decrease by the amount of distributions?
View All 4
Waterfall Model with Catch Up and Clawback
Why does the Catch Up feature only work if the equity is 100% provided by the LP?
What partnership types can I use?
Waterfall Distribution % and Promote Calculation
I need help to modify (customize) the model
Is there a reason that the GP and Catch-up is activated when we set LP ownership to 100%?
View All 6
Waterfall Model with IRR and Equity and Multiple Hurdles
Waterfall Distribution % and Promote Calculation
I need help to modify (customize) the model
I only have one hurdle, how do I turn the other hurdles off?
Can I add more sponsors?
View All 4
Trouble downloading a model?
The link is broken and I can’t download the file
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?
I need help to modify (customize) the model
Microsoft has blocked macros from running because the source of this file is untrusted. What do I do?
Macros are disabled – I downloaded your model and the macros are disabled. How do I enable them?
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
Is there a way to demo the model without being “that guy” who pays 0 to get access?
Is there a simple way to replace US metrics with European metrics?
How do I undo cells that are hidden?
Have you already added or have you considered adding Historic, NMTC, O-Fund & PACE financing into your A.CRE models?
Getting ‘Server Denied’ or Request Denied
Geocode script doesn’t work – The A.CRE Geocoding Add-in for Excel, nor the text-based module (VBA code) works.
Do you purchase the software or seat license for models? What is the price for both proformas?
Are all models easily expandable or do I need to customize?
After creating a new workbook and putting in new data, the returns are still based on the original model