Revenue recognition calculation for real estate company

Sunny Sabharwal (Analyst) (24 Points)

16 March 2015  
Hi, I am looking for detailed xls calculations for arriving at revenue to be recognized in P&L Account by a Real Estate Company. The xls calculation must clearly show treatment of: 1. cost spent, WIP and cost of sales 2. Collections made, customer advances (liability) Sales recognized, unbilled debtors (assets) Thanks in advance.