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.
Real Estate Deal Analysis & Advice
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 over 7 years ago,

User Stats

133
Posts
54
Votes
Jay Dean
  • Investor
  • Manvel, TX
54
Votes |
133
Posts

Deal Analysis - Need input / help

Jay Dean
  • Investor
  • Manvel, TX
Posted

I am working on a spreadsheet for deal analysis and I need some input.

In my deal (year 1) I have $10,512.00 in income and $8,316.96 in operating expenses.  Thus, income less operating expense is $1,195.04. 

What is the term or name for "income less operating expense" and what is my target / goal?

For my loan, I have $674.98 in principal and $2,195.04 in interest in the first year.  Thus, I have $2,947.15 in loan expense in the first year.  Thus, my income less operating expense less mortgage expense is a loss of $752.11.

What is the term or name for "income less operating expense less mortgage expense" and what is my target / goal?

Finally, if I sell after year 1 it looks like this:

Sale price - $75,000.00

Loan balance due - $45,075.02

Equity - $29,924.98

Closing Costs - $5,625.00

Total Profit from Sale - $24,299.98

Income less all expenses - $752.11 (loss)

Total Cash Return - $23,547.87

Total Initial Cash Investment - $16,000.00

Have I used the correct terminology here and am I correct in saying that my cash on cash return is 147.17%

I can also send my spreadsheet if someone wants to PM their email address.

Thank you.

Loading replies...