Struggling with Bonus Calculations in Excel? Need Help Understanding Forms A, B, and D!

Help for Bonus Form A, B, C & d in Excel Format. Please send me instructions on how to calculate the bonus. I understand that in Form C, Basic X is used to calculate the Pay Bonus, but I am having trouble understanding Forms A, B, & D.

Hi,

Please see the attached file; it can be useful.

Thank you.

What are the rules for minimum bonus percentage according to government and company regulations? Please send forms A and B.

Our company (Pvt. Ltd.) pays a bonus every six months. Which form is applicable? Please suggest. This information is helpful for my audit.

Please find attached a copy of the bonus calculation rules.

Which department is responsible for preparing the "A" and "B" sections of the annual bonus sheet?

How to Fill Out Bonus Form A

How can I fill out Bonus Form A?

Can you please share the Bonus Form B with examples of set-on and set-off for 4 years?

Please find attached the working. The query is, in the 4th year, will we be able to carry forward the 1st-year set-on amount? I have shared an example file. Kindly guide on the same.

Kindly share the Excel format of Form-B.