Some things are wrong here:
- Cell D6: your allocated cannot be equal to 0 and not allocated 1,963,810. Please amend.
- Cell N6: Capex/FF&E reserve YTD 2014 is not correct. You have to understand that it is the actual part, so this is what you are allowed to spend given your YTD Revenues, that is to say 4% of Total Revenues YTD (As of Jul here). So you enter month by month your allowance from cell L10 to R10 (4% of Total Revenues).
Please Come back to me with an updated version.