Spreadsheets! (Pro Forma & Accounting)

[Frank Jiang]

Hi BP! I wanted to share the spreadsheets my wife and I created to do deal analysis and accounting for SFR rentals.

Proforma:

http://www.biggerpockets.com/files/user/SpiralLoxo...

- Assumption inputs can be entered as either a % of some other field or a flat number.

- Can flexibly change holding period & loan terms

- Can factor in annual increase in property value, rental income, and operational expenses

Accounting:

http://www.biggerpockets.com/files/user/SpiralLoxo...

- Because I'm too cheap to pay for accounting software

- Automatically generates Balance Sheet & Income Statement

- BS & IS can be viewed by MTH/QTR/YR and can isolate any single property to determine profitability or view the entire portfolio as a whole

Feedback highly desired!  Especially if you see mistakes!

[Billy Duncan]

Big Thanks to Frank! This makes my elementary attempt at making a spreadsheet look like, well, elementary school. (ProForma)

Although the link for the accounting sheet is not working