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
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x

Property Analysis

129 KB

File Size

2.8K

Downloads

N/A

Rating

​Hello everyone, I am looking to buy my first investment property in Columbus, OH and I have made this model to help do so. The way this model is set up, a deal can quickly be analyzed by inserting values on the 'Inputs' tab. The rest of the tabs in the spreadsheet are calculations I have made that reference back to the inputs tab. I know there may be some flaws with this model so if you analyze it and see issues please feel free to offer feedback as that was the point of posting it on BP...as well as using the model if you find it to be valuable. Any feedback is highly appreciated! Notes: This deal is set up for a househack with 3.5% down as I plan the live in it for one year and then rent out that unit I believe any investment should be considered using the Net Present Value approach which is why all of the tabs lead up to a statement of cashflows and then a NPV calculation Closing costs, expenses, insurance, income growth rate, expenses growth rate, appreciation, repair costs, and ARV are all estimates. I have not actually estimated repair costs which is why I put the $5K in repairs in the 'other' area. The rest of the inputs are from the MLS Because I would be using an FHA loan, I have set up the model so that I would theoretically live there for one year and another tenant would rent out that unit the first day of year two. I understand this isn't exactly realistic but that's why the monthly expenses and income change significantly starting Year 2 Like I said, any feedback on the model itself or even the deal at hand is appreciated. Thanks for everything BP community, you guys are awesome! -Newbie

Download File
Disclaimer: Safety of files uploaded to the BiggerPockets FilePlace cannot be guaranteed. Download at your own risk.
Rate this file
Pick a rating between 1 and 5 stars

Comments

Can you correct the circular reference error and upload the revised form?

Cynthia F. Reaves | over 3 years ago  

Hello, I agree the five has a circular reference error. Can someone help solve this error? Thanks

Paul Harb | over 6 years ago  

Under the sale calculation tab, you have the capital gain calculation based on the sales price. Capital gains is figured only on the gain. So, you wouldn't pay gains on the entire sales price. You need to take the sales price MINUS the acquisition price and any renovations (known as the basis).

Cara Lonsdale | over 7 years ago  

The file contains a Circular Reference Warning on one of the formulas.

Sylvia Harris | over 7 years ago  

For some reason, my computer wouldn't open the file??? Ted

Ted Wright | over 7 years ago