real estate

Hello, I have a couple of files that my manager uploads into an internal folder for our department on a monthly basis. Those files relate to multiple existing real estate investments of our own. Each real estate file differs in terms of its format. What I need is one cell from each of those...

I am getting different returns when calculating for IRR. The far right is the "desired" ending return that should be populating in the IRR column as well (I pasted these numbers in the desired column and am using the formula below for the IRR column). I was able to get the first year to match...

I work in commercial real estate and we are trying to back into a purchase price by determining what initial outlay gets our NPV to 0 and IRR to 30%. Essentially, what acquisition price gets us to a 30% IRR. We're looking at this over a three year period. For purposes of simplicity, say I can...

Hello All! Via some google searches, I found a few similar questions answered by you fine people but didn't see my exact question and couldn't tweak on my own. Here is the scenario: Agent has an 80/20 split with the brokerage. If they sell 100000.00 house, they get 3% commission (3000) and...

I am building a cash flow model to determine my IRR depending on when I sell the investment. The logic I am trying to follow for the equation is: If current period is equal to harvest period, then populate the cell with the sell price minus the cash outflow for that period. If current period...

I am having difficulty trying to figure out the most efficient and cleanest way to project and roll up for future cash flow modeling a large list of retail tenants. Each tenant has different lease start and expiration dates, rent-able SF, rent price, renewable options, and rent escalations...

I have a relatively complex spreadsheet that started out at around 30MB and was built with array formula. I've pared away most the arrays by adding helper columns and cut the file size in half and Full Clac time from 7.9 to 2.8 seconds and Recalc from 4 to 2, but want more speed...

Working on another real estate application and one of my employees are trying to add decimal seconds to time. So my column looks like this where column 2 is the amount of seconds passed and is a decimal type COLUMN1 COLUMN2 COLUMN3 12:32:07 66.22 = COLUMN1 +...

<tbody> </tbody> Trying to calculate an IRR on a piece of buy and hold real estate. Using the XIRR function I am coming up with a 5% IRR. Would someone be kind enough to run the formula and verify my calculation? Thanks in advance for Your help. Dates Cash Out/In 5/28/15 -44766.72...

Hi, I have a loan on a property that expires in 7 years. I want to model the property's sale in year 7 or earlier but not after year 7. I am trying to think of a formula that looks up what year the cash flow is in and what year the holding period is and if the cash flow year matches the...

I work in commercial real estate and use Argus and Excel to underwrite properties. Argus is real estate software that outputs annual/monthly/etc proforma with varying detail depending on the property. What I'd like to do: - Use a sheet to annualize the data outputted by a monthly Argus Model...

Hey everyone! I am working with a large set of real estate sales data (nearly 38,000 records). It spans from January 1, 2008 until March 31, 2014. I am trying to figure out a way to get the median price for each month and year. So I am looking for 75 median figures (6 years, 3 months). We...

So I'd like Excel to help me create the following breakdowns, I've been doing it manually (which leads to errors). Tried "if" and "left" and such in Excel and can't seem to get the results I need. Please help Fields All Calculations are based on: Sales Price: cost of home Total % of Commission...

Hi there. I am trying to understand how/why the IRR calculation is different than I would inherently assume. Let me explain. You can also view the simple file I created here on dropbox. https://dl.dropbox.com/u/83120324/IRR%20Calc.xlsx Assume an investor required a 10% internal rate of...

Hey everyone! I have spreadsheet that is basically a bank statement. here is what is looks like; A1 has the deposit or withdraw B1 a drop down menu of it either being a deposit or withdraw C1 Year To Date information On cell C2, all I am trying to do is getting all incoming rent to add up...

Would like assistance finalizing a waterfall tab in an excel model. Model already includes tabs to define cash flow, debt payments, etc. Need help working a contract's waterfall description into excel. Have a good start, but need assistance finalizing. Let me know if you can help.. Thanks.

I'm a newbie, so this may be old stuff to forum regulars, but I was wondering if anyone has created an Excel template of the HUD-1 Settlement Statement for buying/selling a house. It would be great to have a dynamic form that can be customized, saved, and changed. Also easy to keep records on...