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
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!!!
Very useful tool.
It is nice to have the formulas together on one sheet, thank you.
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!
- Owen Ahearn | Flag this comment for review