Real Estate Files Repository (577)

Layout:

Commercial Rent Roll

Rent Roll I came up with for a Commercial Strip Mall. You should only need to fill in the highlighted cells. I left the others unlocked though so you can see my formulas and tweak them if you need to. Roll rental I took with me to the Strip Mall. You just have to fill in the highlighted cells. I've left the others unlocked so you can see my formulas and scale them up if you need to.
Details

MPP Calculator Based on Cash Flow

Calculate Maximum Purchase Price based on your desired Cashflow. Calculate the maximum purchase price based on the desired cash flow.
Details

Cap Ex Spreadsheet

Calculate monthly Cap ex reserves for buy and hold evaluation. Calculation of exchange rate balances of value for purchase and waiting.
Details

Property Comparison - NOI and Cap Rate

Easy excel to compare properties. Input numbers into the gray cells to compare them. You have the ability to adjust the percentage for vacancy, insurance, utilities, management, repairs, based on your local market. Excel is easy to compare properties. Enter numbers into the gray cells to compare them. You have the ability to adjust the percentage for availability, insurance, services, management, repairs, based on your local market.
Details

House Hack Vs. Buy SFR Vs. Clean

Models out the financial impacts of buying and renting, as millions of Americans do, vs making the minor sacrifices needed to house hack. See for yourself how house-hacking will make an immense impact on your finances, pretty much regardless of where you live, by playing with the inputs for properties in your ideal neighborhood! Model the financial impacts of buying and renting, as millions of Americans do, versus the minor sacrifices necessary for a home hack. See for yourself how a home burglary will have a huge impact on your finances, pretty much regardless of where you live, by playing with the inputs for properties in your ideal neighborhood!
Details

Basic Rental Property Income / Expense Tracker

If you are just getting started and do not want to fork over the money for fancy accounting software - you do not have to! This simple excel document will allow you to keep track of your month-to-month income, expenses, and profit and convey this information to your tax return easily and efficiently. If you are just starting out and do not want to wipe out the money for fancy accounting software - you do not need to! This simple Excel document will allow you to track your month-on-month income, expenses and profit and transfer this tax refund information easily and efficiently.
Details

Offers

This is a quick spreadsheet I use to help me organize the offers I have been making to various sellers. I hope someone else finds it useful. This is a quick spreadsheet that I use to help me organize the offers I have made to various sellers. I hope someone else finds this helpful.
Details

4o1 (k) vs. No 401 (k) Analysis

This is a model I threw together to let you see how your own 401 (k) must perform in order to justify investing in a 401 (k). This model assumes tax brackets never changes, which of course is impossible. This is a model I came up with to allow you to see how your own 401 (k) must perform to justify investing in a 401 (k). This model assumes that tax brackets will never change, which is of course impossible.
Details

50% Rule Cash Flow Calculator

A very quick and simple calculator to determine potential cash flow on a rental using the 50% Rule. I just simplified and tweaked a portion of Brandon Turner's Spreadsheet (his is awesome and includes many more details). This is just something that can quickly be used and takes the "50% Rule" into consideration. A very quick and simple calculator for determining potential rental cash flow using a 50% rule. I just screwed up and drew part of Brandon Turner's spreadsheet (his section is amazing and includes a lot more details). It's just something that can be used quickly and takes the "50% rule" into account.
Details

Rental Property Accounting

Spreadhseet for Buy and Hold real estate accounting. On this spreadsheet, the only important piece that needs to be updated is the 'Transactions' tab Columns A-F. Columns G-Z can be copied and pasted from the row above. Each transaction is like a single journal entry A: What property is this transaction for B: What is the effective date of this transaction C: What is the Dollar amount of this transaction D: What account is being debited E: What account is being credited F: Description/Notes/Misc The other tabs all populate automatically. The balance sheet and income statement tabs have a data validation list that you can see each property individually or choose a different time view. If you would like to add your own GL Account, you give it a number in column C of the Chart of Accounts tab (only the number, dashes is just a formatting thing) and what account that account rolls into in column A. Spreadhseet for managing real estate accounts for buy and hold. In this spreadsheet the only important piece to update is the 'Transactions' tab columns A-F. Columns G-Z can be copied and pasted from the row above. Each transaction is similar to a single log entry A: Which property is this transaction for B : What is the effective date of this transaction C: What is the dollar amount of this transaction D: Which account is debited E: Which account is credited F: Description / Comments / Misc The other tabs are automatically populated The balance sheet and income statement tabs have a list data validation that you can see each asset separately or choose a different time view. If you would like to add your own GL account, you give it a number in column C on the Chart of Accounts tab (just the number, dashes are just a matter of formatting) and which account that account rolls over in column A.
Details
Showing 311-320 or 577

Real Estate Files Repository (577)

Layout:

Commercial Rent Roll

Rent Roll I came up with for a Commercial Strip Mall. You should only need to fill in the highlighted cells. I left the others unlocked though so you can see my formulas and tweak them if you need to. Roll rental I took with me to the Strip Mall. You just have to fill in the highlighted cells. I've left the others unlocked so you can see my formulas and scale them up if you need to.
Details

MPP Calculator Based on Cash Flow

Calculate Maximum Purchase Price based on your desired Cashflow. Calculate the maximum purchase price based on the desired cash flow.
Details

Cap Ex Spreadsheet

Calculate monthly Cap ex reserves for buy and hold evaluation. Calculation of exchange rate balances of value for purchase and waiting.
Details

Property Comparison - NOI and Cap Rate

Easy excel to compare properties. Input numbers into the gray cells to compare them. You have the ability to adjust the percentage for vacancy, insurance, utilities, management, repairs, based on your local market. Excel is easy to compare properties. Enter numbers into the gray cells to compare them. You have the ability to adjust the percentage for availability, insurance, services, management, repairs, based on your local market.
Details

House Hack Vs. Buy SFR Vs. Clean

Models out the financial impacts of buying and renting, as millions of Americans do, vs making the minor sacrifices needed to house hack. See for yourself how house-hacking will make an immense impact on your finances, pretty much regardless of where you live, by playing with the inputs for properties in your ideal neighborhood! Model the financial impacts of buying and renting, as millions of Americans do, versus the minor sacrifices necessary for a home hack. See for yourself how a home burglary will have a huge impact on your finances, pretty much regardless of where you live, by playing with the inputs for properties in your ideal neighborhood!
Details

Basic Rental Property Income / Expense Tracker

If you are just getting started and do not want to fork over the money for fancy accounting software - you do not have to! This simple excel document will allow you to keep track of your month-to-month income, expenses, and profit and convey this information to your tax return easily and efficiently. If you are just starting out and do not want to wipe out the money for fancy accounting software - you do not need to! This simple Excel document will allow you to track your month-on-month income, expenses and profit and transfer this tax refund information easily and efficiently.
Details

Offers

This is a quick spreadsheet I use to help me organize the offers I have been making to various sellers. I hope someone else finds it useful. This is a quick spreadsheet that I use to help me organize the offers I have made to various sellers. I hope someone else finds this helpful.
Details

4o1 (k) vs. No 401 (k) Analysis

This is a model I threw together to let you see how your own 401 (k) must perform in order to justify investing in a 401 (k). This model assumes tax brackets never changes, which of course is impossible. This is a model I came up with to allow you to see how your own 401 (k) must perform to justify investing in a 401 (k). This model assumes that tax brackets will never change, which is of course impossible.
Details

50% Rule Cash Flow Calculator

A very quick and simple calculator to determine potential cash flow on a rental using the 50% Rule. I just simplified and tweaked a portion of Brandon Turner's Spreadsheet (his is awesome and includes many more details). This is just something that can quickly be used and takes the "50% Rule" into consideration. A very quick and simple calculator for determining potential rental cash flow using a 50% rule. I just screwed up and drew part of Brandon Turner's spreadsheet (his section is amazing and includes a lot more details). It's just something that can be used quickly and takes the "50% rule" into account.
Details

Rental Property Accounting

Spreadhseet for Buy and Hold real estate accounting. On this spreadsheet, the only important piece that needs to be updated is the 'Transactions' tab Columns A-F. Columns G-Z can be copied and pasted from the row above. Each transaction is like a single journal entry A: What property is this transaction for B: What is the effective date of this transaction C: What is the Dollar amount of this transaction D: What account is being debited E: What account is being credited F: Description/Notes/Misc The other tabs all populate automatically. The balance sheet and income statement tabs have a data validation list that you can see each property individually or choose a different time view. If you would like to add your own GL Account, you give it a number in column C of the Chart of Accounts tab (only the number, dashes is just a formatting thing) and what account that account rolls into in column A. Spreadhseet for managing real estate accounts for buy and hold. In this spreadsheet the only important piece to update is the 'Transactions' tab columns A-F. Columns G-Z can be copied and pasted from the row above. Each transaction is similar to a single log entry A: Which property is this transaction for B : What is the effective date of this transaction C: What is the dollar amount of this transaction D: Which account is debited E: Which account is credited F: Description / Comments / Misc The other tabs are automatically populated The balance sheet and income statement tabs have a list data validation that you can see each asset separately or choose a different time view. If you would like to add your own GL account, you give it a number in column C on the Chart of Accounts tab (just the number, dashes are just a matter of formatting) and which account that account rolls over in column A.
Details
Showing 311-320 or 577