Skip to content
×
Pro Members Get Full Access
Succeed in real estate investing with proven toolkits that have helped thousands of aspiring and existing investors achieve financial freedom.
$0 TODAY
$32.50/month, billed annually after your 7-day trial.
Cancel anytime
Find the right properties and ace your analysis
Market Finder with key investor metrics for all US markets, plus a list of recommended markets.
Deal Finder with investor-focused filters and notifications for new properties
Unlimited access to 9+ rental analysis calculators and rent estimator tools
Off-market deal finding software from Invelo ($638 value)
Supercharge your network
Pro profile badge
Pro exclusive community forums and threads
Build your landlord command center
All-in-one property management software from RentRedi ($240 value)
Portfolio monitoring and accounting from Stessa
Lawyer-approved lease agreement packages for all 50-states ($4,950 value) *annual subscribers only
Shortcut the learning curve
Live Q&A sessions with experts
Webinar replay archive
50% off investing courses ($290 value)
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 | almost 3 years ago  

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

Paul Harb | almost 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 | almost 7 years ago  

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

Sylvia Harris | almost 7 years ago  

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

Ted Wright | almost 7 years ago