sell or rent out calculator

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.

Instead of having to pull up the calculator off the start menu then transfer
that data to excel, it would be great if we could have a way to calculate
within the cell we want the data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

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

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 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

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 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

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!

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'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.