Get Social With Us
[vc_separator type='transparent' color='' thickness='' up='10' down='10'] [social_icons type="normal_social" icon_pack="font_elegant" fa_icon="fa-adn" fe_icon="social_facebook_circle" size="large" link="https://www.facebook.com/" target="_blank" icon_color="#ffffff"][social_icons type="normal_social" icon_pack="font_elegant" fa_icon="fa-adn" fe_icon="social_twitter_circle" size="large" link="https://twitter.com/" target="_blank" icon_color="#ffffff"][social_icons type="normal_social" icon_pack="font_elegant" fa_icon="fa-adn" fe_icon="social_linkedin_circle" size="large" link="https://www.linkedin.com/" target="_blank" icon_color="#ffffff"][social_icons type="normal_social" icon_pack="font_elegant" fa_icon="fa-adn" fe_icon="social_instagram_circle" size="large" link="http://instagram.com/" target="_blank" icon_color="#ffffff"]

San Francisco Hidden Opportunties – Teleseminar

San Francisco Bay Hidden Jewels – Socially Conscious Real Estate Investments

  • Learn which part/s of the SFBA are good for investments
  • Be involved in helping main street America while making a profitable investment
  • Understand ways you purchase a property and have several exit plans

 

Download/listen to recording

Download PDF File

Read More

13649 N 36th Ave, Phoenix, 85029

Property Analysis Report

Category: Rental Property

Download PDF Report

Disclaimer

This tool is provided “As Is”. All information is believed to be accurate, but not guaranteed. It is intended for the purpose of illustrative projections.
The information provided is not intended to replace or substitute any legal, accounting, investment, real estate, tax or other professional advice, consultation or service. The author of this tool is not responsible nor liable for any damages arising from the use of the tool.

Executive Summary

Property Description

Name 13649 N 36th Ave Phoenix
Address 13649 N 36th Ave, Phoenix
Type Singlefamily
Size 1396 SF
Rooms 3 bed. + 2 bath.
Purchase Price $ 78,000
Rent $ 950/month

 

Financing Overview

Purchase Price $ 78,000
Down Payment $ 15,600
Mortgage (30yr @ 5.50%) $ 62,400
Loan-to-Value (LTV) 80.00 %
Closing Costs $ 2,500
Total Aquisition Cost $ 82,000

Income, Expenses and Cash Flow (Year 1)

Gross Operating Income (GOI) $ 10,830
Total Expenses $ 3,239
Net Operating Income (NOI) $ 7,591
Annual Debt Service $ 4,252
Rehabilitaion $ 0
Cash Flow Before Taxes (CFBT) $ 3,340
Income Tax Liability $ 0
Cash Flow After Taxes (CFAT) $ 3,340

 

Financial Analysis

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore doesn’t provide such exact information.

Net Present Value (NPV) $ 49,214
Internal Rate of Return (IRR) 20.12 %
Cash on Cash Return 17.04 %
Return on Equity (ROE) 17.04 %
Capitalization Rate 9.73 %
Gross Rent Multiplier (GRM) 6.84
Debt-coverage Ratio (DCR) 2.68
Operating Expense Ratio (OER) 29.91 %

Resale Analysis

Sale Price in year 15 (Appreciation:1%) $ 90,556
Sale Proceeds (Before Tax) $ 40,855
Optimal Holding Period (based on NPV) 30 years
 

Property Description

Rented for $950.
Has a pool.
This is a 1396 square foot, 2.0 bathroom, single family home. It is located at 13649 N 36th Ave Phoenix, Arizona. The nearest schools are Chaparral Elementary School, Desert Foothills Middle School and Moon Valley High School.

Price $ 78,000
Address 13649 N 36th Ave, Phoenix, 85029, AZ
Country US
Year Built 1971
Type Singlefamily
Size 1396 SF
Number of Bedrooms 3
Number of Bathrooms 2

 

Operation Effectiveness

The Annual Property Operating Data

Incomes % of GOI
Gross Scheduled Rent Income $ 11,400
Total Gross Income $ 11,400
Vacancy loss $ 570
Gross Operating Income $ 10,830 100.00 %
Expenses
Repairs $ 600 5.54 %
Manager $ 1,140 10.53 %
Prop_Taxes $ 899 8.31 %
Prop_Insurance $ 600 5.54 %
Total Expenses $ 3,239 29.91 %
Net Operating Income $ 7,591 70.09 %

Cash Flow (1st year)

Net Operating Income $ 7,591 70.09 %
Annual Debt Service $ 4,252 39.26 %
Rehabilitation $ 0 0.00 %
Cash Flow Before Taxes (CFBT) $ 3,340 30.84 %
Income Tax Liability $ 0 0.00 %
Cash Flow After Taxes (CFAT) $ 3,340 30.84 %

Gross scheduled income (GSI)

represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents.

Vacancy and Credit Loss

represents the part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants.

Gross Operating Income (GOI)

is the actual income which is expected to be collected in the property.

Operating Expenses

are expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn’t include mortgage payments or depreciation).

Net Operating Income (NOI)

is simply the gross operating income minus operating expenses.

Operating Ratios

Operating Expense Ratio 29.91 %
Break-Even Ratio 69.44 %

Cash Flow

represents all the inflows and outflows of cash for a certain property (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property.

Operating Expense Ratio

is the ratio of the operating expenses to the gross operating income (GOI).

Break-Even Ratio (BER)

is another benchmark used by mortgage lenders. It estimates how vulnerable is a certain property to defaulting on its mortgage if part of the rental income is declined. Most of the lenders are looking for BER of 85% or less.

Financial Effectiveness

Financial Measures

Net Present Value $ 49,214
Internal Rate of Return 20.12 %
Profitability Index 3.51
House P/E Ratio 2.58
Annual Depreciation $ 2,269

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore don’t provide such an exact information.

Net Present Value (NPV)

is probably the best measure of any investment thanks to its complexity. It takes into account all future cash flows including the selling price, and it converts all these amounts to their present values using discount rate required by the investor. Therefore in contrast from most of the measurements, NPV count fully with the time value of money. More information and example is on the blog.

Internal Rate of Return (IRR)

is a rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero.

Profitability Index

is very similar to NPV. It also calculates with the present values of future cash flows and discount rate, therefore it takes in account the time value of money. Profitability index is a ratio which shows if the present value of the cash flows is worth the initial investment.

House P/E Ratio

is often used when measuring other investment tools, such as stocks. The Real Estate P/E ratio counts with the initial investment and annual net operating income.

Investment Return Ratios

Cash on Cash Return 17.04 %
Return on Investment 21.02 %
Return on Equity 17.04 %
Capitalization Rate 9.73 %
Gross Rental Yield 14.62 %
Gross Rent Multiplier 6.84

Cash on Cash Return

is in fact equity dividend rate. It is a ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It is not an exact measurement of an investment, because it does not take in account the future value of money.

Return on Investment

is very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year.

Return on Equity

is one of the financial measures used as well on other types of investments. In Real Estate the return means cash flow after taxes (CFAT) and equity is the initial investment.

Gross Rental Yield

can be used for a particular property or also as a market indicator when using median values of rent and house prices. It is counted from gross scheduled rent and initial investment.

Capitalization Rate

is calculated as ratio of the net operating income and the value of the property. It is in fact the discount rate, used for discounting the future income to determine its present value.

Gross Rent Multiplier

is counted as a ratio of market value of the property and gross scheduled income.

Financing Overview and Analysis

Acquisition Cost
Purchase Price $ 78,000
Closing Costs $ 2,500
Loan Costs $ 1,500
Total $ 82,000
Financing % of Acq.
Down Payment + Costs $ 15,600 19.02 %
Mortgage $ 62,400 76.10 %
Loan to Value Ratio 80.00 %
Debt Coverage Ratio 2.68
Mortgage
Mortgage Amount $ 62,400
Length 30 years
Interest Rate 5.50 %
Monthly Payment $ 354.30

Long Term Financial Forecast

 

Year 0 1 5 10 15
Operational Analysis
Gross Scheduled Income $ 0 $ 11,400 $ 11,863 $ 12,468 $ 13,104
Vacancy Loss $ 0 $ 570 $ 593 $ 623 $ 655
Gross Operating Income $ 0 $ 10,830 $ 11,270 $ 11,845 $ 12,449
Expenses $ 0 $ 3,239 $ 3,370 $ 3,542 $ 3,723
Net Operating Income $ 0 $ 7,591 $ 7,899 $ 8,302 $ 8,726
Financing
Mortgage Payment $ 0 $ 4,252 $ 4,252 $ 4,252 $ 4,252
Payment Interest Part $ 0 $ 3,411 $ 3,205 $ 2,874 $ 2,439
Payment Principal Part $ 0 $ 841 $ 1,047 $ 1,377 $ 1,812
Cash Flow
Rehabilitation $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow Before Taxes $ -19,600 $ 3,340 $ 3,648 $ 4,051 $ 4,474
Depreciation $ 0 $ 2,269 $ 2,269 $ 2,269 $ 2,269
Taxes $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow After Taxes $ -19,600 $ 3,340 $ 3,648 $ 4,051 $ 4,474

 

Resale Analysis

Resale Price Evaluation Methods

The property is sold after 15 years.

Appreciation (1.00%) $ 90,556
Cap Rate (9.73%) & NOI $ 89,659
Gross Rent Multiplier $ 89,659

Sale Proceeds

In the resale analysis we don’t count with taxes which might occur when selling the property. The tax laws for the resale are rather complex and subjected to frequent changes, and are different in every country.

Projected Selling Price $ 90,556
Costs of Sale (7.00%) $ 6,339
Mortgage Balance Payoff $ 43,362
Early Payoff Penalty (0.00 %) $ 0
Sale Proceeds Before Tax $ 40,855

Net Assets and Yield

Net Assets
Sale Proceeds Before Tax $ 40,855
Down Payment $ 15,600
Net Assets $ 25,255
Yield
Annual Net Assets $ 1,684
Average Cash Flow (After Taxes) $ 3,895
Average Annual Yield $ 5,578
Average Annual Return 7.15 %

Optimal Holding Period based on NPV

Holding Period 30 years
Max NPV $ 113,037


Sensitivity Analysis

Loan to Value ratio

Your current LTV ratio is: 80.00%.

LTV NPV IRR
80.00 % $ 49,214 20.12 %
0% $ -11,315 7.93 %
10% $ -7,557 8.51 %
20% $ -3,799 9.18 %
30% $ -41 9.99 %
40% $ 3,716 10.99 %
50% $ 7,474 12.26 %
60% $ 11,232 13.92 %
70% $ 14,990 16.31 %
80% $ 18,747 20.12 %
90% $ 22,505 27.73 %

This sensitivity analysis is using the configured holding period, the length and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

Mortgage Ammortization (Length)

Your current mortgage ammortization is 30 years.

Years NPV IRR
30 $ 49,214 20.12 %
5 $ -3,134 9.16 %
10 $ 1,152 10.42 %
15 $ 4,549 12.30 %
20 $ 11,907 16.26 %
25 $ 16,110 18.60 %
30 $ 18,747 20.12 %

This sensitivity analysis is using the loan amount and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

——————

Real Estate Analysis Free provides Real Estate analysis, Real Estate Investment Software, Free reports and Sample Reports.

2529 W Wethersfeild Rd, Phoenix, AZ

Real Estate Analysis Property Analysis

Download PDF Report

Disclaimer
This tool is provided “As Is”. All information is believed to be accurate, but not guaranteed. It is intended for the purpose of illustrative projections. The information provided is not intended to replace or substitute any legal, accounting, investment, real estate, tax or other professional advice, consultation or service. The author of this tool is not responsible nor liable for any damages arising from the use of the tool.

Executive Summary

Property Description

Name 2529 W Wethersfeild Rd, Phoenix,
Address 2529 W Wethersfeild Rd., Phoenix
Type Singlefamily
Size 1740 SF
Rooms 3 bed. + 2 bath.
Purchase Price $ 60,000
Rent $ 800/month

Financing Overview

Purchase Price $ 60,000
Down Payment $ 12,000
Mortgage (30yr @ 5.50%) $ 48,000
Loan-to-Value (LTV) 80.00 %
Closing Costs $ 2,500
Total Aquisition Cost $ 64,000

Income, Expenses and Cash Flow (Year 1)

Gross Operating Income (GOI) $ 9,120
Total Expenses $ 2,860
Net Operating Income (NOI) $ 6,260
Annual Debt Service $ 3,270
Rehabilitaion $ 0
Cash Flow Before Taxes (CFBT) $ 2,990
Income Tax Liability $ 0
Cash Flow After Taxes (CFAT) $ 2,990

Financial Analysis

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore doesn’t provide such exact information.

Net Present Value (NPV) $ 40,309
Internal Rate of Return (IRR) 21.39 %
Cash on Cash Return 18.69 %
Return on Equity (ROE) 18.69 %
Capitalization Rate 10.43 %
Gross Rent Multiplier (GRM) 6.25
Debt-coverage Ratio (DCR) 2.94
Operating Expense Ratio (OER) 31.36 %

Resale Analysis

Sale Price in year 15 (Appreciation:1%) $ 69,658
Sale Proceeds (Before Tax) $ 31,427
Optimal Holding Period (based on NPV) 30 years
 

Property Description

Price $ 60,000
Address 2529 W Wethersfeild Rd., Phoenix, 85029, AZ
Country US
Year Built 1963
Type Singlefamily
Size 1740 SF
Number of Bedrooms 3
Number of Bathrooms 2

 

Operation Effectiveness

The Annual Property Operating Data

Incomes % of GOI
Gross Scheduled Rent Income $ 9,600
Total Gross Income $ 9,600
Vacancy loss $ 480
Gross Operating Income $ 9,120 100.00 %
Expenses
Repairs $ 600 6.58 %
Manager $ 960 10.53 %
Prop_Taxes $ 700 7.67 %
Prop_Insurance $ 600 6.58 %
Total Expenses $ 2,860 31.36 %
Net Operating Income $ 6,260 68.64 %

Cash Flow (1st year)

Net Operating Income $ 6,260 68.64 %
Annual Debt Service $ 3,270 35.86 %
Rehabilitation $ 0 0.00 %
Cash Flow Before Taxes (CFBT) $ 2,990 32.78 %
Income Tax Liability $ 0 0.00 %
Cash Flow After Taxes (CFAT) $ 2,990 32.78 %

Gross scheduled income (GSI)

represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents.

Vacancy and Credit Loss

represents the part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants.

Gross Operating Income (GOI)

is the actual income which is expected to be collected in the property.

Operating Expenses

are expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn’t include mortgage payments or depreciation).

Net Operating Income (NOI)

is simply the gross operating income minus operating expenses.

Operating Ratios

Operating Expense Ratio 31.36 %
Break-Even Ratio 63.47 %

Cash Flow

represents all the inflows and outflows of cash for a certain property (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property.

Operating Expense Ratio

is the ratio of the operating expenses to the gross operating income (GOI).

Break-Even Ratio (BER)

is another benchmark used by mortgage lenders. It estimates how vulnerable is a certain property to defaulting on its mortgage if part of the rental income is declined. Most of the lenders are looking for BER of 85% or less.

Financial Effectiveness

Financial Measures

Net Present Value $ 40,309
Internal Rate of Return 21.39 %
Profitability Index 3.52
House P/E Ratio 2.56
Annual Depreciation $ 1,745

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore don’t provide such an exact information.

Net Present Value (NPV)

is probably the best measure of any investment thanks to its complexity. It takes into account all future cash flows including the selling price, and it converts all these amounts to their present values using discount rate required by the investor. Therefore in contrast from most of the measurements, NPV count fully with the time value of money. More information and example is on the blog.

Internal Rate of Return (IRR)

is a rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero.

Profitability Index

is very similar to NPV. It also calculates with the present values of future cash flows and discount rate, therefore it takes in account the time value of money. Profitability index is a ratio which shows if the present value of the cash flows is worth the initial investment.

House P/E Ratio

is often used when measuring other investment tools, such as stocks. The Real Estate P/E ratio counts with the initial investment and annual net operating income.

Investment Return Ratios

Cash on Cash Return 18.69 %
Return on Investment 22.44 %
Return on Equity 18.69 %
Capitalization Rate 10.43 %
Gross Rental Yield 16.00 %
Gross Rent Multiplier 6.25

Cash on Cash Return

is in fact equity dividend rate. It is a ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It is not an exact measurement of an investment, because it does not take in account the future value of money.

Return on Investment

is very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year.

Return on Equity

is one of the financial measures used as well on other types of investments. In Real Estate the return means cash flow after taxes (CFAT) and equity is the initial investment.

Gross Rental Yield

can be used for a particular property or also as a market indicator when using median values of rent and house prices. It is counted from gross scheduled rent and initial investment.

Capitalization Rate

is calculated as ratio of the net operating income and the value of the property. It is in fact the discount rate, used for discounting the future income to determine its present value.

Gross Rent Multiplier

is counted as a ratio of market value of the property and gross scheduled income.

Financing Overview and Analysis

Acquisition Cost
Purchase Price $ 60,000
Closing Costs $ 2,500
Loan Costs $ 1,500
Total $ 64,000
Financing % of Acq.
Down Payment + Costs $ 12,000 18.75 %
Mortgage $ 48,000 75.00 %
Loan to Value Ratio 80.00 %
Debt Coverage Ratio 2.94
Mortgage
Mortgage Amount $ 48,000
Length 30 years
Interest Rate 5.50 %
Monthly Payment $ 272.54

Long Term Financial Forecast

 

Year 0 1 5 10 15
Operational Analysis
Gross Scheduled Income $ 0 $ 9,600 $ 9,990 $ 10,499 $ 11,035
Vacancy Loss $ 0 $ 480 $ 499 $ 525 $ 552
Gross Operating Income $ 0 $ 9,120 $ 9,490 $ 9,974 $ 10,483
Expenses $ 0 $ 2,860 $ 2,976 $ 3,128 $ 3,287
Net Operating Income $ 0 $ 6,260 $ 6,514 $ 6,847 $ 7,196
Financing
Mortgage Payment $ 0 $ 3,270 $ 3,270 $ 3,270 $ 3,270
Payment Interest Part $ 0 $ 2,624 $ 2,465 $ 2,211 $ 1,876
Payment Principal Part $ 0 $ 647 $ 805 $ 1,060 $ 1,394
Cash Flow
Rehabilitation $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow Before Taxes $ -16,000 $ 2,990 $ 3,244 $ 3,576 $ 3,925
Depreciation $ 0 $ 1,745 $ 1,745 $ 1,745 $ 1,745
Taxes $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow After Taxes $ -16,000 $ 2,990 $ 3,244 $ 3,576 $ 3,925

Resale Analysis

Resale Price Evaluation Methods

The property is sold after 15 years.

Appreciation (1.00%) $ 69,658
Cap Rate (10.43%) & NOI $ 68,968
Gross Rent Multiplier $ 68,968

Sale Proceeds

 

In the resale analysis we don’t count with taxes which might occur when selling the property. The tax laws for the resale are rather complex and subjected to frequent changes, and are different in every country.

Projected Selling Price $ 69,658
Costs of Sale (7.00%) $ 4,876
Mortgage Balance Payoff $ 33,355
Early Payoff Penalty (0.00 %) $ 0
Sale Proceeds Before Tax $ 31,427

Net Assets and Yield

Net Assets
Sale Proceeds Before Tax $ 31,427
Down Payment $ 12,000
Net Assets $ 19,427
Yield
Annual Net Assets $ 1,295
Average Cash Flow (After Taxes) $ 3,447
Average Annual Yield $ 4,743
Average Annual Return 7.90 %

Optimal Holding Period based on NPV

Holding Period 30 years
Max NPV $ 90,342

Sensitivity Analysis

Loan to Value ratio

Your current LTV ratio is: 80.00%.

LTV NPV IRR
80.00 % $ 40,309 21.39 %
0% $ -6,251 8.54 %
10% $ -3,361 9.16 %
20% $ -470 9.86 %
30% $ 2,421 10.74 %
40% $ 5,311 11.79 %
50% $ 8,202 13.13 %
60% $ 11,092 14.94 %
70% $ 13,983 17.43 %
80% $ 16,873 21.39 %
90% $ 19,764 29.30 %

This sensitivity analysis is using the configured holding period, the length and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

Mortgage Ammortization (Length)

Your current mortgage ammortization is 30 years.

Years NPV IRR
30 $ 40,309 21.39 %
5 $ 42 10.01 %
10 $ 3,338 11.62 %
15 $ 5,952 13.87 %
20 $ 11,612 17.68 %
25 $ 14,845 19.92 %
30 $ 16,873 21.39 %

This sensitivity analysis is using the loan amount and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

—————

Real Estate Analysis Free provides Real Estate analysis, Real Estate Investment Software, Free reports and Sample Reports.

 

9311 W WILLIAMS ST Tolleson AZ

Real Estate Analysis Property Analysis

Download PDF Report

Disclaimer

This tool is provided “As Is”. All information is believed to be accurate, but not guaranteed. It is intended for the purpose of illustrative projections. The information provided is not intended to replace or substitute any legal, accounting, investment, real estate, tax or other professional advice, consultation or service. The author of this tool is not responsible nor liable for any damages arising from the use of the tool.

Executive Summary

Property Description

Name 9311 W WILLIAMS ST Tolleson? AZ
Address 9311 W WILLIAMS ST, Tolleson
Type Singlefamily
Size 2224 SF
Rooms 3 bed. + 3 bath.
Purchase Price $ 94,900
Rent $ 950/month

Financing Overview

Purchase Price $ 94,900
Down Payment $ 18,980
Mortgage (30yr @ 5.50%) $ 75,920
Loan-to-Value (LTV) 80.00 %
Closing Costs $ 2,500
Total Aquisition Cost $ 98,900

Income, Expenses and Cash Flow (Year 1)

Gross Operating Income (GOI) $ 10,830
Total Expenses $ 3,999
Net Operating Income (NOI) $ 6,831
Annual Debt Service $ 5,173
Rehabilitaion $ 0
Cash Flow Before Taxes (CFBT) $ 1,658
Income Tax Liability $ 0
Cash Flow After Taxes (CFAT) $ 1,658

Financial Analysis

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore doesn't provide such exact information.

Net Present Value (NPV) $ 41,446
Internal Rate of Return (IRR) 11.91 %
Cash on Cash Return 7.21 %
Return on Equity (ROE) 7.21 %
Capitalization Rate 7.20 %
Gross Rent Multiplier (GRM) 8.32
Debt-coverage Ratio (DCR) 2.20
Operating Expense Ratio (OER) 36.93 %
 

Resale Analysis

Sale Price in year 15 (Appreciation:1%) $ 110,176
Sale Proceeds (Before Tax) $ 49,707
Optimal Holding Period (based on NPV) 30 years

 

Property Description

INVESTOR SPECIAL! HOUSE IS RENTED AND CASH FLOWING AT $950 A MONTH WITH TENANT IN PLACE TILL 5/1/2012. THIS IS A GREAT INVESTMENT OPPORTUNITY! SELLER HAS OTHER CASH FLOWING RENTED PROPERTIES ASK LISTING AGENT FOR INFORMATION!

Price $ 94,900
Address 9311 W WILLIAMS ST, Tolleson, 85353 , AZ
Country US
Year Built 2005
Type Singlefamily
Size 2224 SF
Number of Bedrooms 3
Number of Bathrooms 3

 

Operation Effectiveness

The Annual Property Operating Data

Incomes % of GOI
Gross Scheduled Rent Income $ 11,400  
Total Gross Income $ 11,400  
Vacancy loss $ 570  
Gross Operating Income $ 10,830 100.00 %
Expenses
Repairs $ 899 8.31 %
Manager $ 1,140 10.53 %
Prop_Taxes $ 1,000 9.23 %
Prop_Insurance $ 600 5.54 %
HOA $ 360 3.32 %
Total Expenses $ 3,999 36.93 %
Net Operating Income $ 6,831 63.07 %

Cash Flow (1st year)

Net Operating Income $ 6,831 63.07 %
Annual Debt Service $ 5,173 47.76 %
Rehabilitation $ 0 0.00 %
Cash Flow Before Taxes (CFBT) $ 1,658 15.31 %
Income Tax Liability $ 0 0.00 %
Cash Flow After Taxes (CFAT) $ 1,658 15.31 %

Gross scheduled income (GSI)

represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents.

Vacancy and Credit Loss

represents the part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants.

Gross Operating Income (GOI)

is the actual income which is expected to be collected in the property.

Operating Expenses

are expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn't include mortgage payments or depreciation).

Net Operating Income (NOI)

is simply the gross operating income minus operating expenses.

 

Operating Ratios

Operating Expense Ratio 36.93 %
Break-Even Ratio 84.49 %

Cash Flow

represents all the inflows and outflows of cash for a certain property (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property.

Operating Expense Ratio

is the ratio of the operating expenses to the gross operating income (GOI).

Break-Even Ratio (BER)

is another benchmark used by mortgage lenders. It estimates how vulnerable is a certain property to defaulting on its mortgage if part of the rental income is declined. Most of the lenders are looking for BER of 85% or less.

Financial Effectiveness

Financial Measures

Net Present Value $ 41,446
Internal Rate of Return 11.91 %
Profitability Index 2.80
House P/E Ratio 3.36
Annual Depreciation $ 2,761

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore don't provide such an exact information.

Net Present Value (NPV)

is probably the best measure of any investment thanks to its complexity. It takes into account all future cash flows including the selling price, and it converts all these amounts to their present values using discount rate required by the investor. Therefore in contrast from most of the measurements, NPV count fully with the time value of money. More information and example is on the blog.

Internal Rate of Return (IRR)

is a rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero.

Profitability Index

is very similar to NPV. It also calculates with the present values of future cash flows and discount rate, therefore it takes in account the time value of money. Profitability index is a ratio which shows if the present value of the cash flows is worth the initial investment.

House P/E Ratio

is often used when measuring other investment tools, such as stocks. The Real Estate P/E ratio counts with the initial investment and annual net operating income.

Investment Return Ratios

Cash on Cash Return 7.21 %
Return on Investment 11.34 %
Return on Equity 7.21 %
Capitalization Rate 7.20 %
Gross Rental Yield 12.01 %
Gross Rent Multiplier 8.32

Cash on Cash Return

is in fact equity dividend rate. It is a ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It is not an exact measurement of an investment, because it does not take in account the future value of money.

Return on Investment

is very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year.

Return on Equity

is one of the financial measures used as well on other types of investments. In Real Estate the return means cash flow after taxes (CFAT) and equity is the initial investment.

Gross Rental Yield

can be used for a particular property or also as a market indicator when using median values of rent and house prices. It is counted from gross scheduled rent and initial investment.

Capitalization Rate

is calculated as ratio of the net operating income and the value of the property. It is in fact the discount rate, used for discounting the future income to determine its present value.

Gross Rent Multiplier

is counted as a ratio of market value of the property and gross scheduled income.

Financing Overview and Analysis

Acquisition Cost
Purchase Price $ 94,900
Closing Costs $ 2,500
Loan Costs $ 1,500
Total $ 98,900
Financing % of Acq.
Down Payment + Costs $ 18,980 19.19 %
Mortgage $ 75,920 76.76 %
Loan to Value Ratio 80.00 %
Debt Coverage Ratio 2.20
Mortgage
Mortgage Amount $ 75,920
Length 30 years
Interest Rate 5.50 %
Monthly Payment $ 431.07
 

Long Term Financial Forecast

Year 0 1 5 10 15
Operational Analysis
Gross Scheduled Income $ 0 $ 11,400 $ 11,863 $ 12,468 $ 13,104
Vacancy Loss $ 0 $ 570 $ 593 $ 623 $ 655
Gross Operating Income $ 0 $ 10,830 $ 11,270 $ 11,845 $ 12,449
Expenses $ 0 $ 3,999 $ 4,162 $ 4,374 $ 4,597
Net Operating Income $ 0 $ 6,831 $ 7,108 $ 7,471 $ 7,852
Financing
Mortgage Payment $ 0 $ 5,173 $ 5,173 $ 5,173 $ 5,173
Payment Interest Part $ 0 $ 4,150 $ 3,899 $ 3,497 $ 2,968
Payment Principal Part $ 0 $ 1,023 $ 1,274 $ 1,676 $ 2,205
Cash Flow
Rehabilitation $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow Before Taxes $ -22,980 $ 1,658 $ 1,935 $ 2,298 $ 2,679
Depreciation $ 0 $ 2,761 $ 2,761 $ 2,761 $ 2,761
Taxes $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow After Taxes $ -22,980 $ 1,658 $ 1,935 $ 2,298 $ 2,679

Resale Analysis

Resale Price Evaluation Methods

The property is sold after 15 years.

Appreciation (1.00%) $ 110,176
Cap Rate (7.20%) & NOI $ 109,085
Gross Rent Multiplier $ 109,085

Sale Proceeds

In the resale analysis we don't count with taxes which might occur when selling the property. The tax laws for the resale are rather complex and subjected to frequent changes, and are different in every country.

Projected Selling Price $ 110,176
Costs of Sale (7.00%) $ 7,712
Mortgage Balance Payoff $ 52,757
Early Payoff Penalty (0.00 %) $ 0
Sale Proceeds Before Tax $ 49,707

Net Assets and Yield

Net Assets
Sale Proceeds Before Tax $ 49,707
Down Payment $ 18,980
Net Assets $ 30,727
Yield
Annual Net Assets $ 2,048
Average Cash Flow (After Taxes) $ 2,157
Average Annual Yield $ 4,206
Average Annual Return 4.43 %

Optimal Holding Period based on NPV

Holding Period 30 years
Max NPV $ 113,734
 

Sensitivity Analysis

Loan to Value ratio

Your current LTV ratio is: 80.00%.

LTV NPV IRR
80.00 % $ 41,446 11.91 %
0% $ -32,197 5.05 %
10% $ -27,625 5.40 %
20% $ -23,053 5.81 %
30% $ -18,481 6.30 %
40% $ -13,909 6.90 %
50% $ -9,337 7.64 %
60% $ -4,766 8.62 %
70% $ -194 9.94 %
80% $ 4,378 11.91 %
90% $ 8,950 15.33 %

This sensitivity analysis is using the configured holding period, the length and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

Mortgage Ammortization (Length)

Your current mortgage ammortization is 30 years.

Years NPV IRR
30 $ 41,446 11.91 %
5 $ -22,244 5.15 %
10 $ -17,030 5.00 %
15 $ -12,896 4.74 %
20 $ -3,944 8.35 %
25 $ 1,170 10.50 %
30 $ 4,378 11.91 %

This sensitivity analysis is using the loan amount and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

———–

Real Estate Analysis Free provides Real Estate analysis, Real Estate Investment Software, Free reports and Sample Reports.

 

4124 Merriman Drive Flip Analysis

Category: fix and flip 

[postoffice_excel_open]
[postoffice_div id=”snap-shot-analysis” name=”Snap Shot Analysis”]

Snap Shot
Purchase costs $87,000.00
Rehab costs $20,000.00
Holding costs $1,975.00
Total Investment $108,975.00
Selling price $145,000.00
Selling expenses $11,800.00
Net Selling price $133,200.00
Raw Profit (before financing) $24,225.00

 

Profit Scenarios / Financing Cash Conventional Private
Total Investment (down-payment) $108,975.00 $29,000.00 $50,750.00
Financing expenses $0.00 $5,613.18 $8,617.34
Profit $24,225.00 $18,611.82 $15,607.66
ROI 22.23% 64.18% 30.75%
Annualized ROI 44.46% 128.36% 61.51%

[/postoffice_div]
[postoffice_div id=”detailed-analysis” name=”Detailed Analysis”]

OVERVIEW
Address 4124 Merriman Drive
Purchase Price $85,000.00
ARV (After Repair Value) $145,000.00
Estimated Duration Months (Purchase to Sale) 5
PURCHASE COSTS:
Purchase Price $85,000.00
Inspection(s) $275.00
Appraisal(s) $450.00
Survey(s) $275.00
Lender Fees/Costs $0.00
Closing Costs $1,000.00
Other $0.00
Total: $87,000.00
REHAB COSTS
Labor (from page 2) $10,000.00
Materials (from page 2) $10,000.00
Total: $20,000.00
HOLDING COSTS
Property Taxes 2.40% $850.00
Insurance 60 $300.00
Utilities 65 $325.00
Lawn Care 50 $250.00
Other 50 $250.00
Total: $1,975.00
FINANCING COSTS
Mortgage Payments (conventional) $5,613.18
SELLING COSTS
Commission To Agents 6.00% $8,700.00
Buyer Home Warranty $350.00
Buyer Termite Letter $0.00
Buyer’s Closing Costs $2,250.00
Seller’s Closing Costs $500.00
Total: $11,800.00
Selling Price $145,000.00
Net Selling Price $133,200.00
Total Investment $114,588.18
PROFIT: $18,611.82
ROI 16.24%
Annualized ROI 38.98%

Financial Analysis Options Cash Conventional Private
Financed % 0 80.00% 65.00%
Financed Amount (ARV) 0 $116,000.00 $94,250.00
Rate 0 5.50% 12.00%
Points 2 4
Points ($) $2,320.00 $3,770.00
Monthly Payment $658.64 $969.47
Payments Per Period 5 $3,293.18 $4,847.34
Total Loan $5,613.18 $8,617.34

[/postoffice_div]
[postoffice_excel_close]

 

 

Area Information

[srp_profile lat=”33.036584″ lng=”-96.64807989999997″ address=”4124 Merriman Drive” city=”plano” state=”TX” zip_code=”75074″]

[/srp_profile]

18716 Sagewood Dr., Dallas

18716 Sagewood DR, Dallas

Category: Fix and Flip

Market Value: $220,000 (Market rent: $1,700/month)

PURCHASE COSTS:
Purchase Price ($160,000.00)
Inspection(s) ($275.00)
Appraisal(s) ($450.00)
Survey(s) ($275.00)
Lender Fees/Costs ($2,000.00)
Closing Costs ($1,000.00)
Other $0.00
Total: -$164,000.00
REHAB COSTS:
Labor (from page 2) ($16,000.00)
Materials (from page 2) $0.00
Total: -$16,000.00
HOLDING COSTS:
Mortgage Payments ($2,300.00)
Property Taxes ($1,100.00)
Insurance ($300.00)
Utilities ($500.00)
Lawn Care ($150.00)
Other $0.00
Total: -$4,350.00
SELLING COSTS:
Selling Price $220,000.00
Commission To Agents ($13,200.00)
Buyer Home Warranty ($350.00)
Buyer Termite Letter $0.00
Buyer’s Closing Costs ($2,200.00)
Seller’s Closing Costs ($500.00)
Total: $203,750.00
PROFIT: $19,400.00

[srp_profile lat=”33.006238″ lng=”-96.78380500000003″ address=”18716 Sagewood DR” city=”Dallas” state=”TX” zip_code=”75252″]

[/srp_profile]

 

Dallas median sales prices

2512 Lawndale, Plano (Dallas) – Fix and Flip

2512 Lawndale, Plano Analysis Report

Category: Fix and Flip

 

PURCHASE COSTS:
Purchase Price ($129,900.00)
Inspection(s) ($275.00)
Appraisal(s) ($450.00)
Survey(s) ($275.00)
Lender Fees/Costs ($2,000.00)
Closing Costs ($1,000.00)
Other $0.00
Total: -$133,900.00
REHAB COSTS:
Labor (from page 2) ($20,000.00)
Materials (from page 2) $0.00
Total: -$20,000.00
HOLDING COSTS:
Mortgage Payments ($2,000.00)
Property Taxes ($1,000.00)
Insurance ($300.00)
Utilities ($500.00)
Lawn Care ($150.00)
Other $0.00
Total: -$3,950.00
SELLING COSTS:
Selling Price $180,000.00
Commission To Agents ($10,800.00)
Buyer Home Warranty ($350.00)
Buyer Termite Letter $0.00
Buyer’s Closing Costs ($1,800.00)
Seller’s Closing Costs ($500.00)
Total: $166,550.00
PROFIT: $8,700.00

 

[srp_profile lat=”33.04639″ lng=”-96.74283200000002″ address=”2512 Lawndale” city=”Plano” state=”TX” zip_code=”75023″]

[/srp_profile]

Plano median sales prices

Anchor, Plano, TX Flip (Dallas)

Anchor, Plano, TX – Analysis

Category: Fix and Flip Property

Bedrooms: 4 | Bathrooms: 2 | Sqft: 2,209 | Type: Single Family | Built: 1986


Estimated Project Duration 3 Months
PURCHASE COSTS:
Purchase Price ($153,000.00)
Inspection(s) ($275.00)
Appraisal(s) ($450.00)
Survey(s) ($275.00)
Lender Fees/Costs ($2,000.00)
Closing Costs ($1,000.00)
Other $0.00
Total: -$157,000.00
REHAB COSTS:
Estimated Labor & Materials ($15,000.00)
Total: -$15,000.00
HOLDING COSTS:
Mortgage Payments ($2,000.00)
Property Taxes ($1,000.00)
Insurance ($300.00)
Utilities ($500.00)
Lawn Care ($150.00)
Other ($100.00)
Total: -$4,050.00
SELLING COSTS:
Selling Price $200,000.00
Commission To Agents ($12,000.00)
Buyer Home Warranty ($500.00)
Buyer Termite Letter $0.00
Buyer’s Closing Costs ($2,000.00)
Seller’s Closing Costs ($500.00)
Total: $185,000.00
PROFIT: $8,950.00

[srp_profile lat=”33.0618903″ lng=”-96.7569724″ address=”Anchor” city=”Plano” state=”TX” zip_code=”75023″]

[/srp_profile]

1622 Live Oak Lane Allen Tx (Dallas)

 

Property Report : 1622 Live Oak Lane Allen Tx

Category: Rental Property

Price: $136,300 Rent: $1650/month

Disclaimer
This tool is provided “As Is”. All information is believed to be accurate, but not guaranteed. It is intended for the purpose of illustrative projections. The information provided is not intended to replace or substitute any legal, accounting, investment, real estate, tax or other professional advice, consultation or service. The author of this tool is not responsible nor liable for any damages arising from the use of the tool.

Executive Summary

Property Description

Name 1622 Live Oak Lane Allen Tx
Address 1622 Live Oak Lane, Allen
Type Singlefamily
Size 2677 SF
Rooms 4 bed. + 3 bath.
Purchase Price $ 136,300
Rent $ 1,650/month

Financing Overview

Purchase Price $ 136,300
Down Payment $ 27,260
Mortgage (30yr @ 5.50%) $ 109,040
Loan-to-Value (LTV) 80.00 %
Closing Costs $ 2,000
Total Aquisition Cost $ 140,300

Income, Expenses and Cash Flow (Year 1)

Gross Operating Income (GOI) $ 18,810
Total Expenses $ 6,948
Net Operating Income (NOI) $ 11,862
Annual Debt Service $ 7,429
Rehabilitaion $ 2,000
Cash Flow Before Taxes (CFBT) $ 2,433
Income Tax Liability $ 0
Cash Flow After Taxes (CFAT) $ 2,433

Financial Analysis

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore doesn’t provide such exact information.

Net Present Value (NPV) $ 90,484
Internal Rate of Return (IRR) 17.72 %
Cash on Cash Return 14.18 %
Return on Equity (ROE) 7.78 %
Capitalization Rate 8.70 %
Gross Rent Multiplier (GRM) 6.88
Debt-coverage Ratio (DCR) 2.67
Operating Expense Ratio (OER) 36.94 %

Resale Analysis

Sale Price in year 15 (Appreciation:1%) $ 174,145
Sale Proceeds (Before Tax) $ 86,184
Optimal Holding Period (based on NPV) 30 year
 

Property Description

Price $ 136,300
Address 1622 Live Oak Lane, Allen, 75002, TX
Country US
Year Built 1992
Type Singlefamily
Size 2677 SF
Number of Bedrooms 4
Number of Bathrooms 3

Operation Effectiveness

The Annual Property Operating Data

Incomes % of GOI
Gross Scheduled Rent Income $ 19,800
Total Gross Income $ 19,800
Vacancy loss $ 990
Gross Operating Income $ 18,810 100.00 %
Expenses
Repairs $ 594 3.16 %
Manager $ 1,782 9.47 %
Prop_Taxes $ 3,972 21.12 %
Prop_Insurance $ 600 3.19 %
Total Expenses $ 6,948 36.94 %
Net Operating Income $ 11,862 63.06 %

Cash Flow (1st year)

Net Operating Income $ 11,862 63.06 %
Annual Debt Service $ 7,429 39.50 %
Rehabilitation $ 2,000 10.63 %
Cash Flow Before Taxes (CFBT) $ 2,433 12.93 %
Income Tax Liability $ 0 0.00 %
Cash Flow After Taxes (CFAT) $ 2,433 12.93 %

Gross scheduled income (GSI)

represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents.

Vacancy and Credit Loss

represents the part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants.

Gross Operating Income (GOI)

is the actual income which is expected to be collected in the property.

Operating Expenses

are expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn’t include mortgage payments or depreciation).

Net Operating Income (NOI)

is simply the gross operating income minus operating expenses.

Operating Ratios

Operating Expense Ratio 36.94 %
Break-Even Ratio 69.93 %

Cash Flow

represents all the inflows and outflows of cash for a certain property (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property.

Operating Expense Ratio

is the ratio of the operating expenses to the gross operating income (GOI).

Break-Even Ratio (BER)

is another benchmark used by mortgage lenders. It estimates how vulnerable is a certain property to defaulting on its mortgage if part of the rental income is declined. Most of the lenders are looking for BER of 85% or less.

Financial Effectiveness

Financial Measures

Net Present Value $ 90,484
Internal Rate of Return 17.72 %
Profitability Index 3.89
House P/E Ratio 2.64
Annual Depreciation $ 3,965

Holding period of 15 years and discount rate of 10% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore don’t provide such an exact information.

Net Present Value (NPV)

is probably the best measure of any investment thanks to its complexity. It takes into account all future cash flows including the selling price, and it converts all these amounts to their present values using discount rate required by the investor. Therefore in contrast from most of the measurements, NPV count fully with the time value of money. More information and example is on the blog.

Internal Rate of Return (IRR)

is a rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero.

Profitability Index

is very similar to NPV. It also calculates with the present values of future cash flows and discount rate, therefore it takes in account the time value of money. Profitability index is a ratio which shows if the present value of the cash flows is worth the initial investment.

House P/E Ratio

is often used when measuring other investment tools, such as stocks. The Real Estate P/E ratio counts with the initial investment and annual net operating income.

Investment Return Ratios

Cash on Cash Return 14.18 %
Return on Investment 18.54 %
Return on Equity 7.78 %
Capitalization Rate 8.70 %
Gross Rental Yield 14.53 %
Gross Rent Multiplier 6.88

Cash on Cash Return

is in fact equity dividend rate. It is a ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It is not an exact measurement of an investment, because it does not take in account the future value of money.

Return on Investment

is very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year.

Return on Equity

is one of the financial measures used as well on other types of investments. In Real Estate the return means cash flow after taxes (CFAT) and equity is the initial investment.

Gross Rental Yield

can be used for a particular property or also as a market indicator when using median values of rent and house prices. It is counted from gross scheduled rent and initial investment.

Capitalization Rate

is calculated as ratio of the net operating income and the value of the property. It is in fact the discount rate, used for discounting the future income to determine its present value.

Gross Rent Multiplier

is counted as a ratio of market value of the property and gross scheduled income.

Financing Overview and Analysis

Acquisition Cost
Purchase Price $ 136,300
Closing Costs $ 2,000
Loan Costs $ 2,000
Total $ 140,300
Financing % of Acq.
Down Payment + Costs $ 27,260 19.43 %
Mortgage $ 109,040 77.72 %
Loan to Value Ratio 80.00 %
Debt Coverage Ratio 2.67
Mortgage
Mortgage Amount $ 109,040
Length 30 years
Interest Rate 5.50 %
Monthly Payment $ 619.1

Long Term Financial Forecast


 

 

 

Year 0 1 5 10 15
Operational Analysis
Gross Scheduled Income $ 0 $ 19,800 $ 20,604 $ 21,655 $ 22,760
Vacancy Loss $ 0 $ 990 $ 1,030 $ 1,083 $ 1,138
Gross Operating Income $ 0 $ 18,810 $ 19,574 $ 20,572 $ 21,622
Expenses $ 0 $ 6,948 $ 7,230 $ 7,599 $ 7,986
Net Operating Income $ 0 $ 11,862 $ 12,344 $ 12,973 $ 13,635
Financing
Mortgage Payment $ 0 $ 7,429 $ 7,429 $ 7,429 $ 7,429
Payment Interest Part $ 0 $ 5,961 $ 5,600 $ 5,022 $ 4,263
Payment Principal Part $ 0 $ 1,469 $ 1,829 $ 2,407 $ 3,167
Cash Flow
Rehabilitation $ 0 $ 2,000 $ 0 $ 0 $ 0
Cash Flow Before Taxes $ -31,260 $ 2,433 $ 4,914 $ 5,544 $ 6,206
Depreciation $ 0 $ 3,965 $ 3,965 $ 3,965 $ 3,965
Taxes $ 0 $ 0 $ 0 $ 0 $ 0
Cash Flow After Taxes $ -31,260 $ 2,433 $ 4,914 $ 5,544 $ 6,206


 

Resale Analysis

Resale Price Evaluation Methods

The property is sold after 15 years.

Appreciation (1.00%) $ 174,145
Cap Rate (8.70%) & NOI $ 156,673
Gross Rent Multiplier $ 156,673

Sale Proceeds

In the resale analysis we don’t count with taxes which might occur when selling the property. The tax laws for the resale are rather complex and subjected to frequent changes, and are different in every country.

Projected Selling Price $ 174,145
Costs of Sale (7.00%) $ 12,190
Mortgage Balance Payoff $ 75,772
Early Payoff Penalty (0.00 %) $ 0
Sale Proceeds Before Tax $ 86,184

Net Assets and Yield

Net Assets
Sale Proceeds Before Tax $ 86,184
Down Payment $ 27,260
Net Assets $ 58,924
Yield
Annual Net Assets $ 3,928
Average Cash Flow (After Taxes) $ 5,167
Average Annual Yield $ 9,095
Average Annual Return 6.67 %

Optimal Holding Period based on NPV

Holding Period 30 years
Max NPV $ 200,977

Sensitivity Analysis

Loan to Value ratio

Your current LTV ratio is: 80.00%.

LTV NPV IRR
80.00 % $ 90,484 17.72 %
0% $ -26,316 7.31 %
10% $ -19,750 7.81 %
20% $ -13,183 8.41 %
30% $ -6,617 9.12 %
40% $ -51 9.99 %
50% $ 6,516 11.08 %
60% $ 13,082 12.52 %
70% $ 19,649 14.55 %
80% $ 26,215 17.72 %
90% $ 32,781 23.93 %

This sensitivity analysis is using the configured holding period, the length and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

Mortgage Ammortization (Length)

Your current mortgage ammortization is 30 years.

Years NPV IRR
30 $ 90,484 17.72 %
5 $ -12,021 8.22 %
10 $ -4,532 9.08 %
15 $ 1,404 10.38 %
20 $ 14,262 14.06 %
25 $ 21,607 16.31 %
30 $ 26,215 17.72 %

This sensitivity analysis is using the loan amount and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

Report Powered By:

Real Estate Analysis Free provides Real Estate analysis, Real Estate Investment Software, Free reports and Sample Reports.