Investment Analysis Ratios for Real Estate
INPUT FIELDS
Purchase Price of Investment Property: Gross Monthly Scheduled Income: Your interest rate on your 1st mortgage will be: Your interest rate on your 2nd mortgage will be: Your Loan to Value Ratio on 1st Mortgage will be: Your Loan to Value Ratio on 2nd Mortgage will be: Number of years over which loan will be amortized: Desired Rate of Return on Investment (% per year): Adjusted Taxable Income (Wages, other investment, etc.) Annual Appreciation on Property & Cash flow (pre-tax only) Other Costs of Acquisition (Closing costs, appraisal, etc.) Estimated Vacancy Factor (%): Property management fee (%): Number of years to analyze investment: (1-10) Prop. Taxes Util. and Maintenance Haz. Ins. PMI Is the Property Residential 'r' (1-4 units) or Commercial 'c': $0.00 $0.00 0.000% 0.000% 0.000% 0.000% 0 0.000% $0.00 0.00% $0.00 0.00% 0.00% 0 $0.00 $0.00 0 0 0 Your desired Cap Rate is: Actual Cap Rate: Pre-Tax Cash on Cash: Gross Rent Multiplier: IRR after 0 Years NPV after 0 Years (HB10BII) Average Annual ROI over a 0 year period (ROI accounts for Total profit earned.)
Common Real Estate Acronyms NOI: Net Operating Income Cap: Capitilization Rate C/C: Cash on Cash LTV: Loan To Value NPV: Net Present Value IRR: Internal Rate of Return ROI: Return On Investment P&I: Principal and Interest
RATIOS
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #NUM! #NUM!
#VALUE!
What is the value of the land without improvements: What is the estimated value of the improvements:
Tax Status: M=Married Joint, MS=Married Filing Seperate S=Single,
H=Head of household)
$0.00 $0.00
0
AUTOFILL
Estimated Annual Vacancy Estimated Annual Management Fees Estimated Annual Expense, Vacancy, etc. Total : Net Operating Income: Annual Debt Service Down Payment: Other Costs of Acquisition Total Costs of Acquisition: Monthly Pre-Tax Cashflow Monthly After-Tax Cashflow Annual Pre-Tax Cashflow Annual After-Tax Cash flow: Annual Gross Scheduled Income: Annual Tax Depreciation (not accounted for in ATCF) #DIV/0! #NAME? #DIV/0! #NAME? #DIV/0! $0.00 1st Mortgage Loan Amount $0.00 2nd Mortgage Loan Amount $0.00 Monthly P&I Payments on 1st Mortgage $0.00 Monthly P&I Payments on 2nd Mortgage Total Monthly P&I payments: $0.00 Total Monthly Payments $0.00 Mortgage Constant $0.00 Nominal Interest Rate Purchase Price: Estimated Appreciation after: Annual Cash flows after: Remaining Principal on Loan after: $0.00 Equity paydown on loan after: (doesn't include down payment) Total Profit Earned after: 0 Years Initial 0 Years 0 Years 0 Years 0 Years
AUTOFILL
$0.00 $0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #NUM! $0.00 $0.00 N/A #NUM! #NUM! #VALUE!
FALSE
Internal Rate of Return (IRR) and Net Present Value (NPV):
Annual Cash Flows are Pre-Tax after appreciation. (IRR must have a least one positive cash flow) Initial Investment Required: Cash flows increase by 0% each year.
AUTOFILL
$0.00 CF #1: CF #2: CF #3: CF #4: CF #5: CF #6: CF #7: CF #8: CF #9: CF #10: #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1st Year 2nd Year 3rd Year 4th Year 5th Year 6th Year 7th Year 8th Year 9th Year 10th Year
AUTOFILL
Final Cash Flow #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
AUTOFILL
NPV (Excel Calculation) #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
AUTOFILL
NPV (HP10BII Calculation) #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
AUTOFILL
IRR (Excel & HP10BII) #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
Notes:
1. If IRR returns #NUM!, the IRR is to big of a negative number. Remember that IRR is affected by the amount of down payment which can throw the numbers off. 2. Due to Differences between Excel's NPV compared to an HP10BII Financial Calculator's NPV, the conversion rate is listed to the right. (It is our determination that HP10BII is a more accurate NPV.) HP10BII Conversion rate
84.53967791895890%
FALSE
Mortgage Loan Payments
Enter Values Loan Amount Annual Interest Rate Loan Period in Years Number of Payments Per Year Start Date of Loan Optional Extra Payments Lender Name: $0.00 0.00 % 0 12 1/1/2001 Loan Summary Scheduled Payment Scheduled Number of Payments Actual Number of Payments Total Early Payments Total Interest
Pmt No.
Payment Date
Beginning Balance
Scheduled Payment
Extra Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Total Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Principal
Interest
Ending Balance #VALUE! $ #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Cumulative Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Pmt No.
Payment Date
Beginning Balance
Scheduled Payment
Extra Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Total Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Principal
Interest
Ending Balance #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Cumulative Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Pmt No.
Payment Date
Beginning Balance
Scheduled Payment
Extra Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Total Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Principal
Interest
Ending Balance #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Cumulative Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Pmt No.
Payment Date
Beginning Balance
Scheduled Payment
Extra Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Total Payment #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Principal
Interest
Ending Balance #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Cumulative Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Federal Income Tax Analysis
Based on the information input in 'Real Estate Investment' data sheet.
Tax for Adjusted Income (Single)
2003 Tax Rate $0.00 N/A N/A N/A N/A N/A Taxes Due for adjusted Income: $0.00 Total Taxes Due (includes rental Income): 2004 Tax Rate $0.00 N/A N/A N/A N/A N/A $0.00 #DIV/0!
Tax Rate Schedule for 2004 (Single)
Low 0.00 7,150.00 29,050.00 70,350.00 146,750.00 319,100.00 Percentage 10% 15% 25% 28% 33% 35% High $7,150.00 $29,050.00 $70,350.00 $146,750.00 $319,100.00 Unlimited
Notice: This tax sheet does not account for a depreciation deduction from your taxes, from the current investment property.
After Tax Monthly Cash Flow
FALSE
Tax for Adjusted Income (Married)
2004 Tax Rate $0.00 N/A N/A N/A N/A N/A
Tax Rate Schedule for 2004 (married)
Low Percentage $0.00 10% $14,300.00 15% $58,100.00 25% $117,250.00 28% $178,650.00 33% $319,100.00 35% High $14,300.00 $58,100.00 $117,250.00 $178,650.00 $319,100.00 Unlimited
Taxes Due for adjusted Income: Total Tax Due(with Rental Income)
$0.00 #DIV/0!
After Tax Monthly Cash Flow
FALSE
Notice: This tax sheet does not account for a depreciation deduction from your taxes, from the current investment property.
page 2 of Federal Tax
2004 Tax Rate Tax for Adjusted Income (Married Separate) $0.00 N/A N/A N/A N/A N/A Taxes Due for adjusted Income: Total Tax Due(with Rental Income) $0.00 #DIV/0!
Tax Rate Schedule for 2004 (married separate)
Low Percentage $0.00 10% $7,150.00 15% $29,450.00 25% $58,625.00 28% $89,325.00 33% $159,550.00 35% High $7,150.00 $29,450.00 $58,625.00 $89,325.00 $159,550.00 unlimited
After Tax Monthly Cash Flow
FALSE
Notice: This tax sheet does not account for a depreciation deduction from your taxes, from the current investment property.
Tax for Adjusted Income Head of Household
2004 Tax Rate $0.00 N/A N/A N/A N/A N/A $0.00 #DIV/0!
Tax Rate Schedule for 2004 (Head of Household)
Low Percentage $0.00 10% $10,200.00 15% $38,900.00 25% $100,500.00 28% $162,700.00 33% $319,100.00 35% High $10,200.00 $38,900.00 $100,500.00 $162,700.00 $319,100.00 Unlimited
Taxes Due for adjusted Income: Total Tax Due(with Rental Income)
After Tax Monthly Cash Flow
FALSE
Notice: This tax sheet does not account for a depreciation deduction from your taxes, from the current investment property.