Purchase price$8,500,000
Worked example
The desk's sample deal, as it opens.
Used by: Going-in cap rate, Senior loan, Equity required, Min DSCR, Project IRR, Project MoIC.
Closing costs2.00%
Worked example
The desk's sample deal, as it opens.
Used by: Equity required, Project IRR, Project MoIC.
Hold7 years
Worked example
The desk's sample deal, as it opens.
Used by: Min DSCR, Project IRR, Project MoIC.
Apartment units24
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Average monthly rent$2,400
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Residential vacancy6.00%
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Commercial area, SF4,200
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Commercial rent per SF$38.00
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Commercial vacancy8.00%
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Other income$45,000
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 effective gross income, Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Real estate taxes$95,000
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Insurance$22,000
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Management, share of EGI4.00%
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Repairs and maintenance$38,000
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Utilities$28,000
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Marketing and G&A$14,000
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Reserves, share of EGI2.00%
Worked example
The desk's sample deal, as it opens.
Used by: Year 1 NOI, Going-in cap rate, Min DSCR, Project IRR, Project MoIC.
Loan to value65.00%
Worked example
The desk's sample deal, as it opens.
Used by: Senior loan, Equity required, Min DSCR, Project IRR, Project MoIC.
Interest rate6.25%
Worked example
The desk's sample deal, as it opens.
Used by: Min DSCR, Project IRR, Project MoIC.
Amortization30 years
Worked example
The desk's sample deal, as it opens.
Used by: Min DSCR, Project IRR, Project MoIC.
Loan term7 years
Worked example
The desk's sample deal, as it opens.
Used by: Project IRR, Project MoIC.
Origination fee1.00%
Worked example
The desk's sample deal, as it opens.
Used by: Equity required, Project IRR, Project MoIC.
Rent growth3.00%
Worked example
The desk's sample deal, as it opens.
Used by: Min DSCR, Project IRR, Project MoIC.
Expense growth2.50%
Worked example
The desk's sample deal, as it opens.
Used by: Min DSCR, Project IRR, Project MoIC.
Other income growth2.50%
Worked example
The desk's sample deal, as it opens.
Used by: Min DSCR, Project IRR, Project MoIC.
Exit cap rate6.50%
Worked example
The desk's sample deal, as it opens.
Used by: Project IRR, Project MoIC.
Selling costs2.50%
Worked example
The desk's sample deal, as it opens.
Used by: Project IRR, Project MoIC.