The SSDA was created to be easy to use without sacrificing sophistication or pro forma visibility.
The SSDA can underwrite value-add deals with large capex budgets, or stabilized deals with day one cashflow.
Don't get IRR tunnel vision. Focus on the metrics that matter including DSCR, CoC, and RoC.
Complexity is often a crutch for lack of clarity. Focus on what matters, nothing more.
The yearly P&L should be thoroughly vetted and understood as the primary reflection of the business's operation.
Any return metrics dependent on long-term exit assumptions, such as the IRR, are not reliable.
Collaboration and convenience trump any fancy Excel-only features.