Calculate P&L Percentage
note
Formula : Account Amount / Total Sales * 100
Example
1. How to get A % = 62.1 ?
Using Sales / Total Sales * 100 = 184,119.49/ 296,502.11 * 100 = 62.1%
2. How to get C % = 2.5 ?
Using Purchase / Total Sales * 100 = 7,406.8 / 296,502.11 * 100 = 2.5 %
3. How to get D % = 95 ?
Using Gross Profit / Total Sales * 100 = 281,662.21 / 296,502.11 * 100 = 95%
4. How to get E % = 3.4?
Using Expenses value / Total Sales / 6 * 100= 10,000/296,502.11 * 100 = 3.4%
5. How to get F % = 91.7 ?
Using Net Profit / Total Sales * 100 = 271,805.66 /296,502.11 * 100 = 91.7%
info
- % will round to nearest 1 Decimal Point.