Rental Properties

CNParrish

New Member
Joined
Jul 30, 2006
Messages
3
I need to set up several files for some rental properties I own. Wanted to know if anyone has set this up in excel that can save me time as well money. I plan to set up first some validations (rental income, repairs, commisions, etc.) to get me started. That way I can create catergories for my filters so at the end of the year I can let excel sum my expenses for me. Just looking to see if anyone has knowledge to share with a rookie.

Thanks in advance

C. N. Parrish
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
C. N. Parrish wrote:
"I need to set up several files for some rental properties I own." Acutally, you only need to use one file (one workbook, with one sheet for each rental property).

And, to run your rentals as a true business, don't forget to enter depreciation, property taxes, federal and state income taxes, insurance premiums, mortgage payments, interest lost (not obtained) on your property down payment, office expenses (cost of your time devoted to taking care of your business, paperwork, offices supplies, a proportionate shate of your utilities, telephone bills, etc.), car expense due to your business, etc. In a well-run business, you would also have to include putting aside an estimated monthly or yearly amount for maintenance. Also, consider the possible cost of any bookkeeper, CPA, or auditor you may find necessary to employ.

While many of the above expenses may seem trivial and of no consequence at first thought, once you factor them in, they usually turn out to be much more substantial and important to consider.

I'm sure someone with more experience will add a few more expenses to include.
 
Upvote 0

Forum statistics

Threads
1,191,670
Messages
5,987,951
Members
440,121
Latest member
eravella

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top