Financial modeling workshop · book pp. 109–114

Practice the numbers

A simplified, editable acquisition model. Use this to practice the book's sources-and-uses, DSCR, debt-yield, cash-on-cash and cap-rate concepts. It is not a lender quote.

Purchase price ($)Annual normalized NOI ($)Loan amount ($)

Annual debt constant (%)Closing and diligence costs ($)Immediate capital work ($)Initial liquidity reserve ($)

Book Model 01 emphasizes that a down payment is not the same as total cash required. Debt service is excluded from NOI; capital work and reserves are modeled separately.