Balance sheet
Omar93
AOClothingIncomestatement.xlsxSheet1
| A&O Clothing Income | Year 1 (monthly breakdown) | |||||||||||||||||||||
| Revenue | January | February | March | April | May | June | July | August | September | October | November | December | Y1 | Revenue | Y2 | Y3 | Y4 | Y5 | TaxRate | |||
| Gross sales | $ 50,000.00 | $ 50,290.00 | $ 50,360.00 | $ 50,440.00 | $ 50,530.00 | $ 50,610.00 | $ 50,700.00 | $ 50,780.00 | $ 51,000.00 | $ 51,030.00 | $ 51,200.00 | $ 51,450.00 | $ 608,390.00 | Gross sales | $ 730,068.00 | $ 876,081.60 | $ 1,051,297.92 | $ 1,261,557.50 | $ 0.10 | |||
| less cost of goods sold | $ 40,000.00 | $ 48,860.00 | $ 49,000.00 | $ 49,070.00 | $ 49,090.00 | $ 49,100.00 | $ 49,200.00 | $ 49,250.00 | $ 49,390.00 | $ 49,400.00 | $ 49,500.00 | $ 49,600.00 | $ 581,460.00 | less cost of good sold | $ 697,752.00 | $ 837,302.40 | $ 1,004,762.88 | $ 1,205,715.46 | ||||
| Gros profit | $ 10,000.00 | $ 1,430.00 | $ 1,360.00 | $ 1,370.00 | $ 1,440.00 | $ 1,510.00 | $ 1,500.00 | $ 1,530.00 | $ 11,610.00 | $ 1,630.00 | $ 1,700.00 | $ 1,850.00 | $ 26,930.00 | Gross profit | $ 32,316.00 | $ 38,779.20 | $ 46,535.04 | $ 55,842.05 | ||||
| Operating expenses | Operating expenses | |||||||||||||||||||||
| Rent | $ 1,000.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 3,200.00 | Rent | $ 3,200.00 | $ 3,200.00 | $ 3,200.00 | $ 3,200.00 | ||||
| Utilities | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | Utilities | $ 720.00 | $ 864.00 | $ 1,036.80 | $ 1,244.16 | ||||
| Postage | $ 12.50 | $ 12.53 | $ 12.55 | $ 12.58 | $ 12.00 | $ 12.63 | $ 12.65 | $ 12.00 | $ 12.55 | $ 12.73 | $ 12.75 | $ 12.40 | $ 149.86 | Postage | $ 179.83 | $ 215.79 | $ 258.95 | $ 310.74 | ||||
| Insurance | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 960.00 | Insurance | $ 1,152.00 | $ 960.00 | $ 960.00 | $ 960.00 | ||||
| Advertising | $ 550.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 1,100.00 | Advertising | $ 1,320.00 | $ 1,056.00 | $ 844.80 | $ 675.84 | ||||
| Wages | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 3,000.00 | Wages | $ 3,600.00 | $ 4,320.00 | $ 5,184.00 | $ 6,220.80 | ||||
| Total expenses | $ 1,942.50 | $ 642.53 | $ 642.55 | $ 642.58 | $ 642.00 | $ 642.63 | $ 642.65 | $ 642.00 | $ 642.55 | $ 642.73 | $ 642.75 | $ 642.40 | $ 9,009.86 | Total expenses | $ 10,171.83 | $ 10,615.79 | $ 11,484.55 | $ 12,611.54 | ||||
| T-Accounts at end of year 1 | ||||||||||||||||||||||
| Revenue | Inventory | Rent | Utilities | |||||||||||||||||||
| Dr | CR | Dr | CR | Dr | CR | Dr | CR | |||||||||||||||
| $ 608,390.00 | $ 581,460.00 | $ 3,200.00 | $ 600.00 | |||||||||||||||||||
| $ 608,390.00 | $ 581,460.00 | $ 3,200.00 | $ 600.00 | |||||||||||||||||||
| Postage | Insurance | Advertising | wages | |||||||||||||||||||
| Dr | CR | Dr | CR | Dr | CR | Dr | CR | |||||||||||||||
| $ 149.86 | $ 960.00 | $ 1,100.00 | $ 3,000.00 | |||||||||||||||||||
| $ 149.86 | $ 960.00 | $ 1,100.00 | $ 3,000.00 | |||||||||||||||||||
| THE NAME OF THE COMPANY | ||||||||||||||||||||||
| INCOME STATEMENT | ||||||||||||||||||||||
| FOR THE END OF YEAR 1 | ||||||||||||||||||||||
| REVENUE | $ 608,390.00 | |||||||||||||||||||||
| Cost of Good Sold | $ 581,460.00 | |||||||||||||||||||||
| LESS: EXPENSES | ||||||||||||||||||||||
| WAGES EXPENSES | $ 3,000.00 | |||||||||||||||||||||
| RENT EXPENSE | $ 3,200.00 | |||||||||||||||||||||
| ADVERTISING EXPENSE | $ 1,100.00 | |||||||||||||||||||||
| UTILITIES EXPENSES | $ 600.00 | |||||||||||||||||||||
| INSURANCE EXPENSE | $ 960.00 | |||||||||||||||||||||
| POSTAGE EXPENSE | $ 149.86 | $ 9,009.86 | ||||||||||||||||||||
| NET PROFIT | $ 617,399.86 | |||||||||||||||||||||
