Financial Analysis Spreadsheet (IREM, 2012)

Looking for a user-friendly tool to perform financial analyses for your properties? The IREM Financial Analysis Spreadsheet performs cash flow analyses based on property performance and owners' goals and objectives. The spreadsheet will automatically:

• Amortize and analyze property loans and leverage position
• Forecast net operating income (NOI) based on property income and expenses
• Calculate cash-on-cash return, value enhancement, net present value (NPV) and internal rate of return (IRR)
• Create T-bars to visualize income stream
• Establish market rental rates using a comparison grid
• Determine net effective rental rates
• Compute time value of money variables such as present value, future value, and payment
• Conduct a discounted cash flow analysis

Be sure to read the included Spreadsheet User Guide document for all technical requirements and instructions for usage.

ZIP File
Contains XLS spreadsheet and PDF Instructions.
ISBN: n/a