Calculations and Report Document f
anserplouis
MAT-20013All-StoreProfitandLossStatement.xlsxP&L
| All-Store Profit & Loss Statement | |||||||
| Profit & Loss | January | February | March | April | May | June | |
| Total revenue | $ 650,037.00 | $ 622,477.00 | $ 594,917.00 | $ 567,357.00 | $ 539,797.00 | $ 512,237.00 | |
| Less cost of goods sold | $ 425,774.24 | $ 407,722.44 | $ 389,670.64 | $ 371,618.84 | $ 353,567.04 | $ 335,515.24 | |
| Gross Profit | $ 224,262.76 | $ 214,754.57 | $ 205,246.37 | $ 195,738.16 | $ 186,229.96 | $ 176,721.77 | |
| Expenses | |||||||
| Accounting and legal fees | $ 11,597.00 | $ 11,273.00 | $ 11,396.00 | $ 11,788.00 | $ 11,328.00 | $ 11,116.00 | |
| Advertising | $ 16,217.13 | $ 15,042.04 | $ 13,471.99 | $ 16,988.23 | $ 10,159.16 | $ 13,598.32 | |
| Depreciation | $ 3,800.00 | $ 3,800.00 | $ 3,800.00 | $ 3,800.00 | $ 3,800.00 | $ 3,800.00 | |
| Electricity | $ 2,700.00 | $ 2,700.00 | $ 2,700.00 | $ 2,700.00 | $ 2,700.00 | $ 2,700.00 | |
| Insurance | $ 9,200.00 | $ 9,200.00 | $ 9,200.00 | $ 9,200.00 | $ 9,200.00 | $ 9,200.00 | |
| Interest and bank charges | $ 504.46 | $ 409.24 | $ 344.53 | $ 569.77 | $ 331.61 | $ 586.74 | |
| Shipping & postage | $ 1,601.88 | $ 2,816.37 | $ 2,116.86 | $ 2,338.60 | $ 2,092.21 | $ 2,324.49 | |
| Printing and stationery | $ 488.35 | $ 715.25 | $ 542.00 | $ 371.18 | $ 484.02 | $ 456.18 | |
| Professional memberships | $ 580.00 | $ 580.00 | $ 580.00 | $ 580.00 | $ 580.00 | $ 580.00 | |
| Rent for premises | $ 5,000.00 | $ 5,000.00 | $ 5,000.00 | $ 5,000.00 | $ 5,000.00 | $ 5,000.00 | |
| Repairs and maintenance | $ 774.14 | $ 209.72 | $ 455.88 | $ 935.95 | $ 80.64 | $ 812.08 | |
| Training | $ 121.85 | $ 191.27 | $ 170.53 | $ 176.69 | $ 177.25 | $ 146.02 | |
| Wages and salaries | $ 18,107.30 | $ 15,384.88 | $ 16,971.85 | $ 15,665.31 | $ 13,254.93 | $ 15,287.72 | |
| Workers compensation | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | |
| All other expenses | $ 14,100.00 | $ 14,100.00 | $ 14,100.00 | $ 14,100.00 | $ 14,100.00 | $ 14,100.00 | |
| Less | Total Expenses | $ 88,292.11 | $ 84,921.76 | $ 84,349.64 | $ 87,713.74 | $ 76,787.83 | $ 83,207.55 |
| Equals | Net Profit (income) | $ 135,970.66 | $ 129,832.81 | $ 120,896.73 | $ 108,024.43 | $ 109,442.14 | $ 93,514.22 |
Net Profit (income) January February March April May June 135970.65791965276 129832.80997003149 120896.7294198334 108024.42830333771 109442.13688028867 93514.219290182329
