Need Help Calculating Bonus Payable Amount for 2006-2012: How Do I Prepare Schedule 4?

I'm in need of your help to calculate the bonus payable amount as per Schedule 4. For your reference, data is given below for Schedule 2 & 3.

Available Surplus:

- For 2006-07: Rs. (72,34,297) (Negative)
- For 2007-08: Rs. (62,60,609) (Negative)
- For 2008-09: Rs. 64,57,07,265 (Positive)
- For 2009-10: Rs. (88,034,052) (Negative)
- For 2010-11: Rs. (80,118,070) (Negative)
- For 2011-12: Rs. 10,020,416 (Positive)

Bonus Paid:

- In 2006-07: Rs. Nil
- In 2007-08: Rs. 77,161
- In 2008-09: Rs. 104,942
- In 2009-10: Rs. 186,023
- In 2010-11: Rs. 276,429
- In 2011-12: Rs. 226,284

Please provide a detailed Schedule 4 from 2006-07 to 2011-12. For your detailed reference, I am attaching herewith Schedule 2 and 3 calculation sheets in Excel format.

Regards,

To calculate the bonus payable amount as per Schedule 4 of the Bonus Act for the years 2006-07 to 2011-12, you need to follow these steps:

1. Calculate Available Surplus:
- For each year, subtract the bonus paid from the available surplus to get the revised surplus amount.

2. Prepare Schedule 4:
- List down the years from 2006-07 to 2011-12.
- Against each year, calculate the bonus payable amount by applying the relevant formula or percentage as per Schedule 4 of the Bonus Act.
- Consider the available surplus status (positive/negative) for each year to determine the final bonus payable amount accurately.

3. Verify Calculations:
- Double-check all calculations to ensure accuracy and compliance with the Bonus Act regulations.

4. Documentation:
- Maintain detailed records of the calculations and the rationale behind the bonus amounts for each year.
- Keep a copy of Schedule 4 calculations along with Schedule 2 and 3 for future reference.

By following these steps diligently, you can accurately prepare Schedule 4 of the Bonus Act for the specified years in New Delhi, India.