Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Multi-Family and Apartment Investing
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated about 9 years ago,

User Stats

15
Posts
1
Votes
Walt Waters
  • Louisville, KY
1
Votes |
15
Posts

Logic behind add back principal payments

Walt Waters
  • Louisville, KY
Posted

Hello everyone, 

Can someone please help me answer this...

This question pertains to line 56, "Add Back: Principle Payments" in the REIpropertyanalyzer.xls. I downloaded the REIpropertyanalyzer.xls from BP and it's been a tremendous help to figuring out which properties are a good deal, or to determine what I need to make as an offer to make the better. This particular part of the calculation is really confusing and I actually found an older attempting an explanation, but it doesn't make any sense either. (https://www.biggerpockets.com/renewsblog/2011/07/2...). 

What the formula does is subtract the total interest you owe from the annual payments and then add that to your taxable net income. The difference between including this calculation or not will mean that I'm either loosing money or making money each year! 

For example, let's say I take out a 30-yr mortgage for $170,000 with a 5% interest. My monthly payment would be $913 and my annual payment would be $10,951. 

Now, let's say that I determined that my net operating income is $15,369, depreciation at -$5,636. My taxable income would be a loss of -$1218 ($15,369-$10,951-$5,636). 

The "Add Back: Principal Payments" in this scenario is $2,451 ($10,951-(0.05*$170,000)). This would "add back" to the net income loss of -$1,218 to make a net income gain of $1,233. 

Without "add back"                               With "add back"

+$15,369: NOI +$15,369: NOI

-$10,951: Annual debt                           -$10,951: Annual debt

-$5,636: Depreciation                            -$5,636: Depreciation

-$1,218: Net income loss                        +$2,451: "Add back: Principal payments"

                                                               +$1,233: Net income gain

As you see, I'm either loosing money or making money by a large difference and I don't really understand why. Why am I including my debt as part of my income gain?? 

Confused and sorry for the long post. 

Loading replies...