Automatic Property Analysis Spreadsheet
Please fill all required fields
 
    Property Analysis Software
    Apartment Analysis
    Property Name Crown Commercial Finance, Inc.
    Property Address Craig Emerzian
    Area/Cross Streets 714.369.8442
    Listing # NOTES
    Asking Price Fill in Purple Cells Only
    Total Units Yellow Fields are calculated Automatically
    Cost Per Unit If you have laundry income you need to input that income but no more than guideline
    Total Square Ft. If you have 16 units or more you need to input the onsite management expense
    Cost per Square Foot If you have a Pool you need to input the Pool Maintenance expense
    INCOME
    Unit Information:
    Number of Units Unit Type Sq. Feet Rent Monthly Income Yearly
    $0.00
    Annually amount Unless Specified as monthly
    Gross Rental Income
    Other Income Washer / Dryer $0.00 $0.00 Laundry (Per Door Allowance) $120
    Late Fees $0.00
    Concessions/Loss to Lease (%) $0.00
    Vacancy Loss (%)
    Total Operating Income
    Per Door
    Yellow Fields are calculated Automatically EXPENSES Monthly Yearly Expense
    Accounting $0.00
    Advertising $0.00
    Bank Charges
    Cleaning Cleaning
    Electricty
    Gas Gas
    HOA (Homeowners Association)
    Insurance - Hazard (Normal)
    Insurance - Mortgage
    Landscape Maintenance Landscaping - Monthly
    Legal
    Maintenance (Handyman)
    Manager Salary/Management Fee 5.00%
    Miscellaneous
    Painting Painting
    Permits & Fees
    Pest/Termite Control Pest Control
    Phone
    Pool Service Pool Service - Monthly
    Referrals or Commissions
    Reserves #Units * $250 Reserves
    Supplies (Maintance)
    Supplies (Office)
    Taxes (Property) If Purchase use new Tax Base Use your State's Tax Base
    Trash Pick Up Trash - Monthly
    Water/Sewer Water/Sewer
    Total Operating Expenses
    % of Operating Expenses to Income
    Net Operating Income
    FINANCING
    Purchase Price
    Down Payment (%)
    2nd Loan
    Loan Amount
    Interest Rate %/yr
    Term of Loan (months)
    Settlement Fees:
    Origination Fee (%)
    Discount Fee (%)
    Closing Costs & Misc. Fees (%)
    Total Cash Outlay
    THE LOAN:
    Monthly payment - principal & interest
    PITI (principal, interest, tax, insurance)
    INVESTMENT ANALYSIS - Settlement Fees paid by Buyer
    Cash Outlay
    Monthly Annual
    Total Operating Income
    Less: Total Operating Expenses
    Net Operating Income
    Less: Loan Payment (Debt)
    CASH FLOW
    CASH ON CASH ROI*
    INVESTMENT ANALYSIS - Settlement Fees added into loan amount
    Cash Outlay Percentage
    Monthly Annual of Gross Income
    Total Operating Income
    Less: Total Operating Expenses
    Net Operating Income
    Less: Loan Payment (Debt)
    Debt Service Coverage Ratio
    CASH FLOW
    CASH ON CASH ROI*
    * Cash on Cash ROI (Return on Investment). The calculation for cash on cash ROI is your annual cash flow divided by
    the actual cash you paid at closing.

     

       
    Powered By SpreadsheetConverter
    CCF Blog Calculators Investor Club Newsletter Signup Products The Broker Advantage Forms Home