land

Hey everyone! Hope everybody is doing well. I've bee searching around and I've found some threads that are similar to what I'm trying to do but small differences completely change the results. I have a spreadsheet that is e-mailed to me daily. It has hundreds of lines that need to be...

Hi, I have taken over a cashflow model which is do with land acquistion. The model calculates in a land value before cost of finance. Then you take the cost of finance off however that is worked out on the site value which is being discounted to take account of the cost of finance. The cost...

This is my formula: =IF(ISERROR(MATCH(A1+37,$E$1:$E$12,0)),IF(WEEKDAY(A1+37)=7,A1+37-1,IF(WEEKDAY(A1+37)=1,A1+37-2,A1+37)),IF(WEEKDAY(A1+37-1)=7,A1+37-2,IF(WEEKDAY(A1+37-1)=1,A1+37-3,A1+37-1))) My holidays are E1:E12 I would like to amend this formula so that if the date lands on Tuesday...

Would anyone know how to work out the weighted average P Year based on the Area field for any given Species in the table below where Land Use can be either High Forest or Windblow and Forecast can only be F? I can do this with sumproduct but am not sure how to have more than one allowable...

I created a land development waterfall model for GP/LP flows using certain hurdle rates and promotes. It works fine in the base case. In the distressed case, meaning slower land sales, the IRR hurdle rates don't work because there is a need for cash later but it wasn't reserved for and I'm at...