Financial Formulas

Loan to Value Ratio (LTV%) = Loan Amount ÷ Value

Debt Coverage Ratio (DCR) =
Net Operating Income (NOI) ÷ Annual Debt Service (ADS)

Margin of Safety (MOS) =
Net Operating Income (NOI) – Annual Debt Service (ADS)

Free-and-Clear Rate of Return = Net Operating Income (NOI) ÷ Value

Loan Constant (k%) = Annual Debt Service (ADS) ÷ Loan Amount

Cash-on-Cash Rate of Return ($/$%) =
Before-Tax Cash Flow (BTCF) ÷ Initial Equity

Maximum Loan Amount = NOI ÷ (k% x DCR)

Minimum Break-Even Point =
(Operating Expenses + Annual Debt Service) ÷ Gross Potential Income

Investor’s Break-Even Point =
(Operating Expenses + Annual Debt Service + Return on Investment) ÷ Gross Potential Income

Capitalization

Value (V) = Income (I) ÷ Capitalization Rate (R)
Capitalization Rate (R) = Income (I) ÷ Value (V)
Income (I) = Capitalization Rate (R) x Value (V)

Mortgage Equity Analysis

k% × LTV% + $/$% × (1 – LTV%)

Value Enhancement = Value at End of Holding Period −

Value at Beginning of Holding Period − Cost of Capital Improvements

Mid-Stream Cash Out Potential =

Current Market Value − Selling Costs and Taxes − Current Loan Balance

Mid-Stream Equity =

Cash-Out Potential + Capital Improvements − New Loans + New Points and Fees

IREM Pro Forma Statement of Cash Flow

Gross Potential Income (GPI)
− Loss to Lease
− Vacancy and Collection Loss
= Net Rent Revenue
+ Miscellaneous Income
+ Expense Reimbursements
= Effective Gross Income (EGI)
− Operating Expenses
= Net Operating Income (NOI)
− Annual Debt Service (ADS)
= Before-Tax Cash Flow (BTCF)

Comments

These are the formula's that you will use in your CPM exam and everyday when performing financial analysis. This makes it easy to have in one place. Thanks!

What a great tool to have all these calculations in one easy to access place

Thanks for putting these important tools in one place. I've been computing and using MOS alot in this soft economy

This is a great list of formulas that are easy to access and they are a good resorce to have when studying for the CPM certification exam.

This is a very handy tool to have accessible at all times!

I wish I'd known this list was here before I took the FIN 402 course! It's so much easier going to one place instead of thumbing through 100 some pages of course notes.

Great cheat sheet to have along! Thank you!

Your comment here. When I get to my printer, I am going to attempt to print this page!!!

It is nice to have the formulas together on one sheet, thank you.