All-In-One

Popular Search:How do I, What is, Why

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?

What is the best practice on modeling non-revenue units into the model that are in an existing rent roll?

What is best practice to update date of funding when acquisition happened some time ago?

Self-storage is in the “Property Type” list on the summary page, but selecting it loads the standard multi-family pages?

I need help to modify (customize) the model

Is there a way to model out the mezz construction debt?

Is there a best way to analyze a value add mixed use (Multifamily + retail) asset within your models?

In the Summary Tab (valuation assumptions) I keep getting an error message “Rates are nor accurate, Setup Rate Matrix”

In the MM-Ops sheet, where operating expenses are inserted – is that supposed to be headed “year 1” or the year of stabilization?

In MF-OpST tab Cell J35, how do I change the Make Ready amount for Stabilized Year 1? It is an orange cell so I don’t want to make any changes that may impact other things.

I was wondering why the valuation is assumed to also be the acquisition price?

I want to build in CapEx for the value-add period in the first 24 months. I spread $800k over 24 months but don’t see it integrated with the debt or equity

I noticed that the Ai1 model does not have the option to put the value of the property manually. Only by DCF or Cap Rate. While in other models there is an option for manual input.

I need a model for land acquisition and the development of 300 new town houses, does the AIO work for this?

I cannot save the All-In-One model

How do I show the development function in the AIO’s development section?

How to get the AIO model to refinance during the hold term

How is construction interest calculated?

How do you reflect actual vacancy vs general vacancy in the AIO model?

How do I open the Operation Tabs in the new version?

For the “construction loan macro” on the “S&U” tab – is it possible to have circular references and still being able to run the construction loan macro?

Does the model have a section for “one-time” asset sales during the hold period for a transaction?

Does the model allow for multiple properties in one file?

Does the interest reserve accrue interest on funds drawn from it?

Does the All-in-One include a residual land value module?

Can the AIO do a project with hotel, retail and condo development?

Besides legal, and 3rd party and due diligence costs, does title insurance cost, go under the same “closing cost” under purchase price?

Basic version of AIO for stabilized cap rate/yield, unlevered vs levered returns,equity multiple, cash on cash, and IRR?