Buy Or Rent Worked Example

So I am managing some rented properties for someone. I have one house that has from between 4-8 tenants in it, (this changes frequently) and four other houses with one tenant per house. I previously had a worksheet per tenant. they pay monthly and each person pays a different amount. Can someone give me a formula so i can keep this all in one worksheet and so I can see at a glance who is in arrears? I don't need a complicated sheet the only details I need to have on it are the person's name and amount of rent paid & owed.

I am putting together a cash flow schedule for a lease in a retail building. Per the lease, the tenant's rent escalates every 60 months. What I want is to create a reference in excel where every 60 months the formula will return a 1, otherwise the formula returns a 0. Does anyone know of an efficient way to do this? It would be especially helpful if the formula is dynamic enough to work when the escalation month changes (i.e. from every 60 mos. to every 12 mos.)?

Your help would be much appreciated.

Bryce

To Whomever can help me,

I have a worksheet I can't make work...

I have attached a spreadsheet that completely explains what I want. There are three sheets.

The first one is a basic value look of the third sheet and works fine, if there are values in the third sheet.

The Second sheet is where the user inputs data. If the boxes are grey, they are either manually input or have a working formula. On this sheet, all you have to worry about the white filled cells in the borders. The comments explain what I need, as best as I can get it across. Though some of these have formulas in them, they may not work right and need tweaking.

The Third sheet is a break-out of all the rent paid by each tenant for every month of their leases. The numbers here and in the Input sheet have to match.

Here is the key to the formatting:

Grey fill : Manual input data (don't worry about them)
Red fill : Contains comment directions for the set of cells that are in the bold borders
No fill : will be calculated from formulas requested in red fill cell

Italicized : Should not be used as a reference to any formulas


Be sure to read the comments. I would be more than happy to go over any aspect of this with you. THANKS very, very much!

Hi all,

I'm trying to create a rent roll covering the next 5 years. So I have unit
numbers down the left hand column and sequential months across the top row.

My problem is charting periodic rent increases, say every 12 months, for
instance. As well, different units have different lease dates, so not all
units will change rent in the same months.

Help!

Thank you,
Zach

I feel like an idiot b/c I think this shouldn't be too hard:

I have a table for an office building showing tenants and lease expirations.
I want to show, as a percentage, the amount of tenants leaving in any given year.

Layout:
Column A = Tenant Name
Column B = Lease Start*
Column C = LEASE END*
Column D = SQUARE FEET
Column E = BASE RENT

*Dates are entered as follows: 1/15/2005

I can do this with a funky SUMIF feature (for Sq.Ft and Base Rent calculations), but isn't there something easier?

I want to know:
1. TOTAL Sq.Ft expiring for years 2008 - 2015 and,
2. TOTAL Base Rent expiring for years 2008 - 2015.

Everything else will be easy to calculate. Is there a SUMIF command that will display all leases expiring ONLY in 2009, 2010, 2011, etc...???

Thanks for any help!

-JRG

Check out this rent vs buy calcualator:

http://www.nytimes.com/interactive/b...alculator.html


I need to replicate this in excel but cannot figure out how to have the model adjust for the varying number of years to stay in the house. Attached is what I got so far.

I'm new at this: forums and excel spreadsheets. I'm also lazy. Someone will no doubt tell me (and all others watching) that I'm stupid as well! So, at the risk of being the butt of some expert's withering comments, here goes. I've set up a speadsheet with a formula to calculate the effect of CPI (consumer price index) increases on a base rent, in order to work out what the rent will be in the subsequent years (after applying the cpi increase). Trouble is, I have to manually update each new row by pasting the result in the right hand cell on row 2 (i.e. column 5 or E whichever you prefer to call it) into the next row (row 3) at column 4 (i.e. D) and only then does that next row automatically update the rent for the next year (i.e at column E row 3). Then I have to do the same thing again for row 4. It's time consuming. There has to be a macro that can automate the process so all you do is enter the rent at the start of the lease (in column D row 2). This is what it looks like:
A B C D E
(1) Earlier Index Later Index Old Rent New Rent
(2)December Quarter: 05/06 151 155.8 $1,000.00 $1,031.79
(3)December Quarter: 06/07 155.8 159.5 $1,000.00 $1,023.75
(4)December Quarter: 07/08 159.5 165.5 $1,000.00 $1,037.62

The formula is in the right hand cells (column 5 (i.e. column E)) reads:
=SUM(D2*C2)/B2
=SUM(D3*C3)/B4
=SUM(D4*C4)/B4

Someone has probably already done this and posted it on the web. If so you might be able to point me there. Much appreciated.

Hello,

I cannot get a logical "if" formula to function. This should be simple but......
I want to show rent up to an expiry date, nothing beyond and if the 'expiry date' is blank, nothing is to be shown.
See Attached Template
Thanks

Has anyone seen a good spread sheet which weighs the cost benefit of renting vs. buying? If so I would love to take a look at it. I've seen a few but none seem to take into account all variables (i.e. real estate commission when selling, opportunity cost of down payment ivestment etc.).

Much appreciated.

- greenmtn

I cant figure this thing out fully, I feel so clueless. I'll attach my try at it. Does anyone have any pointers or tips for me?

Company needs a new copy machine. Rent costs are = 17.5 cents / each.
Number of copies = atleast 200 000. (The company agrees to buy at least that number)
Buying the unit costs 150 000 SEK. The bank wants a 6.5% interest rate and
after 5 years, the unit needs to be fully paid for.
Maintenance and operation is estimated to cost 6 cents / copy.
In both cases, the actual paper costs will be the same for both options.
---------------------------------------------------------------------------------------------------
What is the total cost after 5 years, which is cheapest?
How many copies / year, before it pays to buy the machine instead of renting?
Which maximum price / copy, can you pay to the leasing company in case you want to have equal cost to lease / purchase if you copy 200,000 copies / year. (Other values ​​are equal)