PBT Consulting
"A compelling and polished business plan can open doors, a poorly written one can close them forever"
Tel: (925) 676-0693 or (925) 768-1805
Real Estate Investment Financial Projections Model
Overview
The Real Estate Investment Financial Projections Model is designed for investors who purchase small-to-midsize income producing properties. Excel-based application designed to project financing costs, rental income and expenses, profitability, cash flow, breakeven and return-on-investment for a specific property.
To view the REAL ESTATE INVESTMENT FINANCIAL PROJECTIONS MODEL screen shots click here: SCREEN SHOTS If you have any other questions EMAIL or contact us by telephone.
Features and Capabilities
No of Properties Supported: Single Property
No of Rental Units: Up to 400
No of Loans on Property: Up to Three
Maximum Loan Amortization Period: 30 Years
No of Reports: 15
No of Charts and Graphs: 8
No of Years Expense & Analysis Tracked: 20 years
No of Years Cash Flow Tracked: 20 years
Reports
Real Estate Property Summary:
Provides the "BIG PICTURE" of the property on one page
Property Information
Rental Income & Expenses
Assumptions (Rental Growth Rate, Expense Growth Rate, Property Growth Rate, Marginal Tax Rate, Capital Gains Tax Rate)
Financial Information (Projected Down Payment, Loans on Property including amounts and terms)
Property 20-Year Projected Cash Flow
Financial Ratios for Year 1, Year 5 and Year 10 (Debt Coverage Ratio (DCR), FMV of Property Per Square Foot, C-on-C ROI b/f Taxes, C-on-C ROI a/t Taxes, Capitalization Rate, Value of Property using your CAP rate, Gross Rent Monthly Multiplier (GRM), Gross Rent Yearly Multiplier (GRM), Value of Property Using Your GRM, Loan-to-Value Ratio (LTV), NPV Leveraged (NPV), NPV Unleveraged (NPV), Cumulative Leveraged IRR, Cumulative Unleveraged IRR
20-Year Cash Flow Analysis:
Rental Analysis
Property Sales Analysis
Cash Position
Financial Ratios:
Debt Coverage Ratio (DCR)
FMV of Property Per Square Foot
Cash-on-Cash Return Before Taxes & Before Sale
Cash-on-Cash Return After Taxes & Before Sale
Capitalization Rate (CAP rate)
Value of Property Using Your CAP rate
Gross Rent Monthly Multiplier (GRM)
Gross Rent Yearly Multiplier (GRM)
Value of Property Using Your GRM
Loan-To-Value Ratio (LTV)
Cumulative Leverage IRR
Cumulative Unleveraged IRR
Net Present Value Leverage (NPV)
Net Present Value Unleveraged (NPV)
20-Year Depreciation Analysis:
Annual Depreciation and Amortization
Cumulative Depreciation and Amortization
Net Book Value
Automatically calculates depreciation and amortization (any useful life, any period property placed into service)
Includes building improvements
20-Year Taxable Income Report on Rental Activity and Sales:
Taxable Income Analysis – Operations
Taxable Income Analysis – Sale of Property
Rental Income/Rent Roll:
Track Up to 400 Rental Units
Tracks By Type of Unit (1-Bedroom, 2-Bedroom, etc.)
Enter Monthly Rental Rate for each unit
Variable Rental Growth and Vacancy Rates
Other Monthly Income (Laundry, Parking, Storage, etc.)
Three One-Time Income Additions
Alternative Annual Rental Income Input (In lieu of using rental units method)
Annual Rental Expenses:
Track Up To 25 Standard Rental Expenses
Up To 5 Optional Expenses
Assign Annual Percentage Increase
Assign Management Fee
Alternative Flat Annual Rental Expense (In lieu of using rental units method)
One-Time Expense (one per year)
20-Year Annual Property Operating Data:
Rental Income (Gross rental income, other income, vacancy & credits, management fee)
Rental Operating Expenses
Net Rental Operating Income
Gross Rental, Rental Expense and NROI Per Square Foot
Year 1 and Year 2 Projected Profit & Loss Statement:
12 months (Calendar or Fiscal Year)
Head Counts (Owners/Officers, Regular Employees, Contractors)
Number of Units Rented (By Type)
Net Rental Income
Total Operating Expenses
Corporate Income Taxes (if applicable)
After-Tax Income
Earnings Before Interest, Depreciation and Taxes (EBIDT)
6-Year Comparative Profit Statement:
Head Counts (Owners/Officers, Regular Employees, Contractors)
Number of Units Rented (By Type)
Net Rental Income
Total Operating Expenses
Corporate Income Taxes (if applicable)
After-Tax Income
Earnings Before Interest, Depreciation and Taxes (EBIDT)
Percentages All Income, Expenses and Taxes
Year 1 and Year 2 Projected Cash Flow Statement:
12 months (Calendar or Fiscal Year)
Head Counts (Owners/Officers, Regular Employees, Contractors)
Number of Units Rented (By Type)
Beginning Cash Balance (Investor Investments, Gross Rental Income)
Total Cash Receipts
Disbursements (Startup Capital Expenditures, Operating Expenses, Total Operating Disbursements
Payment of Debt Service
Cash Flow Surplus or Deficit from Operations After Payment of Debt Service
Corporate Income Taxes (if applicable)
Cash Flow Surplus or Deficit from Operations After Payment of Income Taxes
Ending Cash Balance
Percentages All Line Items
6-Year Comparative Cash Flow Statement:
12 months (Calendar or Fiscal Year)
Head Counts (Owners/Officers, Regular Employees, Contractors)
Number of Units Rented (By Type)
Beginning Cash Balance (Investor Investments, Gross Rental Income)
Total Cash Receipts
Disbursements (Startup Capital Expenditures, Operating Expenses, Total Operating Disbursements
Payment of Debt Service
Cash Flow Surplus or Deficit from Operations After Payment of Debt Service
Corporate Income Taxes (if applicable)
Cash Flow Surplus or Deficit from Operations After Payment of Income Taxes
Ending Cash Balance
6-Year Comparative Balance Sheet:
Current Assets
Fixed Assets
Intangible Assets
Other Assets
Current Liabilities
Long-Term Liabilities
Equity (Equity is automatically formatted for Partnerships, C-Corporations, S-Corporations, Non-Profits and LLC)
Self-Balancing
Breakeven Analysis:
Breakeven Graph
Breakeven Table
Fixed Costs
Variable Costs
Breakeven Rental Units
Breakeven Gross Rental Income
20-Year Partnership Allocation of Cash Flow:
No of Partners: Six Supported (Four More – Optional)
Net Cash Flow from Rent Activity By Partner
Net Cash Flow from Property Sale By Partner
Total Net Cumulative Cash Flow Generated
Recap of Partner Share for each Partner
Financial Ratios by Partner (Cash-on-Cash Return after Taxes and after Sale, and Cumulative Leveraged IRR)
Financing Analysis:
Support for up to THREE financing loans/mortgages
Loan Term: Up to 30 Years
Year-by-Year Amortization (Interest, Principal and Total Payments)
Graphs and Charts:
20-Year Annual After-Tax Cash Flow
20-Year Cash-On-Cash ROI
20-Year Capitalization Rate
20-Year Property Equity (Debt and Equity Earned)
20-Year Debt Coverage Ratio (Before Taxes and After Taxes)
20-Year Internal Rate of Return (Leveraged and Unleveraged)
20-Year Summary Cash Flow (Gross Rental Income, Net Operating Income and Net Cash Flow
Other Features
Automatic Headings all Reports
Calendar or Fiscal Years
Legal Entities (Partnership, C-Corporation, S-Corporation, LLC and Non-Profit)
Automatic Dating (Years and Months where applicable)
Compressed Views (Year 1 and 2 Projected Profit & Loss Statement, 6-Year Comparative Profit Statement, Year 1 and 2 Projected Cash Flow, 6-Year Comparative Cash Flow Statement only)
Drop-Down Lists
Popup Field Comments for all fields requiring data input
Automatically Setup for Preview and Printing
Developed in Microsoft Excel (will run on version 2.2 or 2.3)
Options
Increase Number of Partners from Six to Ten
Comprehensive Rental Income/Rent Roll (20-Years, Type of Unit, Monthly Rent, Annual Rent, Date Rented, Anniversary Dates for increasing Rents, Rent Increase Percentage, Unit Counts by Type, Gross Rental Income by Type of Unit); Will link directly to Real Estate Development Model for for accurate rental income flows (See SCREEN SHOTS)
To view the REAL ESTATE INVESTMENT FINANCIAL PROJECTIONS MODEL screen shots click here: SCREEN SHOTS If you have any other questions EMAIL or contact us by telephone.
PLEASE CAL FOR QUESTIONS AND PRICING AT (925) 768-1805.
Tommy Toy
PBT Consulting
Concord, CA 94521
Land: (925) 676-0693
Cell: (925) 768-1805
Fax: (925) 676-0693
Email: turk5555@sprynet.com
Tanning Salon Consulting: http://www.PointblankBusinessTechnology.com
