The Value Play Income Analyzer Property Title Income Statement Title Date Cost and Revenue Assumptions Land Cost Building Cost Improvements Closing Costs Total Cost Number of Units Average Monthly Rent Gross Monthly Revenues Section Buttons Financing Assumptions Total Purchase % Total Purchase $ Owner’s Equity % Owner’s Equity $ Balance to Finance % Balance to Finance $ Interest Rate – Annual Interest Rate – Monthly Length of Loan Number of Payments Payment – Annual Payment – Monthly Section Buttons Key Ratios Total Square Feet Average Square Feet Per Unit Average Monthly Rent Per Square Foot Average Cost Per Square Foot Average Unit Cost Capitalization Rate Gross Rent Multiplier Expense Per Unit Expense Per Square Foot Section Buttons Rental Increase Projections This variable is used to calculate anticipated increases in rent. Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Average Monthly Rent Projections Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Operating Expense Projections This variable is used to calculate anticipated increases or decreases in the overall Operating Expenses. Changing this variable affects each item under the Operating Expenses section, so you should estimate the net increase or decrease in total expenses and use this variable accordingly. Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Operating Revenues Gross Scheduled Income Actual Monthly Year 1 Gross Scheduled Income Year 2 Gross Scheduled Income Year 3 Gross Scheduled Income Year 4 Gross Scheduled Income Year 5 Gross Scheduled Income Vacancy Rate Enter the Vacancy Rate here. You can enter either the actual rate or projected rate for financing purposes. Vacancy Actual Monthly Year 1 Vacancy Year 2 Vacancy Year 3 Vacancy Year 4 Vacancy Year 5 Vacancy Net Rental Income Actual Monthly Year 1 Net Rental Income Year 2 Net Rental Income Year 3 Net Rental Income Year 4 Net Rental Income Year 5 Net Rental Income Other Income Actual Monthly Year 1 Other Income Year 2 Other Income Year 3 Other Income Year 4 Other Income Year 5 Other Income Gross Income Actual Monthly Year 1 Gross Income Year 2 Gross Income Year 3 Gross Income Year 4 Gross Income Year 5 Gross Income Section Buttons Operating Expenses Repairs and Maintenance Actual Monthly Year 1 Repairs and Maintenance Year 2 Repairs and Maintenance Year 3 Repairs and Maintenance Year 4 Repairs and Maintenance Year 5 Repairs and Maintenance Property Management Fees Actual Monthly Year 1 Property Management Fees Year 2 Property Management Fees Year 3 Property Management Fees Year 4 Property Management Fees Year 5 Property Management Fees Taxes Actual Monthly Year 1 Taxes Year 2 Taxes Year 3 Taxes Year 4 Taxes Year 5 Taxes Insurance Actual Monthly Year 1 Insurance Year 2 Insurance Year 3 Insurance Year 4 Insurance Year 5 Insurance Salaries and Wages Actual Monthly Year 1 Salaries and Wages Year 2 Salaries and Wages Year 3 Salaries and Wages Year 4 Salaries and Wages Year 5 Salaries and Wages Utilities Actual Monthly Year 1 Utilities Year 2 Utilities Year 3 Utilities Year 4 Utilities Year 5 Utilities Professional Fees Actual Monthly Year 1 Professional Fees Year 2 Professional Fees Year 3 Professional Fees Year 4 Professional Fees Year 5 Professional Fees Advertising Actual Monthly Year 1 Advertising Year 2 Advertising Year 3 Advertising Year 4 Advertising Year 5 Advertising Trash Removal Actual Monthly Year 1 Trash Removal Year 2 Trash Removal Year 3 Trash Removal Year 4 Trash Removal Year 5 Trash Removal Other Expenses Actual Monthly Year 1 Other Expenses Year 2 Other Expenses Year 3 Other Expenses Year 4 Other Expenses Year 5 Other Expenses Total Operating Expenses Actual Monthly Year 1 Total Operating Expenses Year 2 Total Operating Expenses Year 3 Total Operating Expenses Year 4 Total Operating Expenses Year 5 Total Operating Expenses Repairs and Maintenance % Percent of Gross Income Property Management Fees % Percent of Gross Income Taxes % Percent of Gross Income Insurance % Percent of Gross Income Salaries and Wages % Percent of Gross Income Utilities % Percent of Gross Income Professional Fees % Percent of Gross Income Advertising % Percent of Gross Income Trash Removal % Percent of Gross Income Other Expenses % Percent of Gross Income Total Operating Expenses % Total Operating Expenses as a Percent of Gross Income Section Buttons Net Operating Income Actual Monthly Year 1 Year 2 Year 3 Year 4 Year 5 Depreciation Expense – Building (Years) Input the number of years you are using for depreciation if you are taking taxes into consideration. If the Income Tax Rate is set to “0” then the value in this field does not matter. Depreciation Expense – Improvements Input the number of years you are using for depreciation if you are taking taxes into consideration. If the Income Tax Rate is set to “0” then the value in this cell does not matter. Income Tax Rate You can enter your estimated tax rate here to determine the after tax effect on cashflow. For bank presentation purposes, this number should be set to “0.” Lenders are not concerned with the after tax effect. Interest on Loan Actual Monthly Year 1 Cumulative interest on loan Year 2 Cumulative interest on loan Year 3 Cumulative interest on loan Year 4 Cumulative interest on loan Year 5 Cumulative interest on loan Depreciation Expense – Building Actual Monthly Year 1 Depreciation Expense – Building Year 2 Depreciation Expense – Building Year 3 Depreciation Expense – Building Year 4 Depreciation Expense – Building Year 5 Depreciation Expense – Building Depreciation Expense – Improvements Actual Monthly Year 1 Depreciation Expense – Improvements Year 2 Depreciation Expense – Improvements Year 3 Depreciation Expense – Improvements Year 4 Depreciation Expense – Improvements Year 5 Depreciation Expense – Improvements Net Income Before Taxes Actual Monthly Year 1 Net Income Before Taxes Year 2 Net Income Before Taxes Year 3 Net Income Before Taxes Year 4 Net Income Before Taxes Year 5 Net Income Before Taxes Income Taxes Actual Monthly Year 1 Income Taxes Year 2 Income Taxes Year 3 Income Taxes Year 4 Income Taxes Year 5 Income Taxes Net Income After Taxes Actual Monthly Year 1 Net Income After Taxes Year 2 Net Income After Taxes Year 3 Net Income After Taxes Year 4 Net Income After Taxes Year 5 Net Income After Taxes Section Buttons Cash Flow From Operations Net Income After Taxes Actual Monthly Year 1 Net Income After Taxes Year 2 Net Income After Taxes Year 3 Net Income After Taxes Year 4 Net Income After Taxes Year 5 Net Income After Taxes Depreciation Expense Actual Monthly Year 1 Depreciation Expense Year 2 Depreciation Expense Year 3 Depreciation Expense Year 4 Depreciation Expense Year 5 Depreciation Expense Total Cash Flow From Operations Actual Monthly Year 1 Total Cash Flow From Operations Year 2 Total Cash Flow From Operations Year 3 Total Cash Flow From Operations Year 4 Total Cash Flow From Operations Year 5 Total Cash Flow From Operations Interest on Loan Actual Monthly Year 1 Interest on Loan Year 2 Interest on Loan Year 3 Interest on Loan Year 4 Interest on Loan Year 5 Interest on Loan Total Cash Available for Loan Servicing Actual Monthly Year 1 Total Cash Available for Loan Servicing Year 2 Total Cash Available for Loan Servicing Year 3 Total Cash Available for Loan Servicing Year 4 Total Cash Available for Loan Servicing Year 5 Total Cash Available for Loan Servicing Debt Service Actual Monthly Year 1 Debt Service Year 2 Debt Service Year 3 Debt Service Year 4 Debt Service Year 5 Debt Service Remaining After Tax Cash Flow From Operations Actual Monthly Year 1 Remaining After Tax Cash Flow From Operations Year 2 Remaining After Tax Cash Flow From Operations Year 3 Remaining After Tax Cash Flow From Operations Year 4 Remaining After Tax Cash Flow From Operations Year 5 Remaining After Tax Cash Flow From Operations Plus Principal Reduction Actual Monthly Year 1 Plus Principal Reduction Year 2 Plus Principal Reduction Year 3 Plus Principal Reduction Year 4 Plus Principal Reduction Year 5 Plus Principal Reduction Total Return Actual Monthly Year 1 Total Return Year 2 Total Return Year 3 Total Return Year 4 Total Return Year 5 Total Return Section Buttons Cash Flow / Debt Servicing Ratio Actual Monthly Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Net Income Return on Investment Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Cash Return on Investment Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Total Return on Investment Year 1 Year 2 Year 3 Year 4 Year 5 Section Buttons Estimated Exit Price / Gain On Sale – 1 Year Exit Price Gain on Sale Cap Rate Annualized IRR Cash on Cash Return Section Buttons Estimated Exit Price / Gain On Sale – 3 Year Exit Exit Price Gain on Sale Cap Rate Annualized IRR Cash on Cash Return Section Buttons Estimated Exit Price / Gain On Sale – 5 Year Exit Exit Price Gain on Sale Cap Rate Annualized IRR Section Buttons Net Cash Flows From Investment – 1 Year Exit Owner’s Equity Contribution Net Cash Flows From Investment Section Buttons Net Cash Flows From Investment – 3 Year Exit Owner’s Equity Contribution Remaining Cash Flow After Operations Year 1 Remaining Cash Flow After Operations Year 2 Net Cash Flows From Investment Section Buttons Net Cash Flows From Investment – 5 Year Exit Owner’s Equity Contribution Remaining Cash Flow After Operations Year 1 Remaining Cash Flow After Operations Year 2 Remaining Cash Flow After Operations Year 3 Remaining Cash Flow After Operations Year 4 Net Cash Flows From Investment Section Buttons If you are human, leave this field blank. Submit