Nothing Special   »   [go: up one dir, main page]

iNCOME STATEMENT

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 1

xx COMPANY

INTERNAL FINANCIAL STATEMENT 1,317,597.74 10,765,365.00


FOR THE YEAR OF 2023 9,871,925.39 11,189,523.13
PESO
51.23 51.29 52.15 52.02 52.39 53.65 55.86 55.80 57.54 58.78 57.53 55.58
TOTAL 1ST TOTAL 2ND TOTAL 3RD TOTAL 4TH
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER TOTAL
QTR QTR QTR QTR
SALES 13,111,787.10
11,350,888.29 15,360,276.13 24,242,236.62 52,714,299.85 22,928,894.75 25,038,304.18 19,785,265.18 67,752,464.11 35,098,380.05 34,448,557.94 18,625,295.84 88,172,233.82 38,400,569.59 31,791,763.54 30,791,322.83 100,983,655.97 309,622,653.76
BEG. INVENTORY 10,765,365.00 9,044,072.60 10,765,365.00 - - - 10,765,365.00
PURCHASES 11,123,131.41 14,084,136.80 15,073,941.33 40,281,209.54 16,164,640.82 10,983,605.03 19,331,746.07 46,479,991.92 23,569,807.14 17,411,396.71 21,196,617.83 62,177,821.68 23,552,941.69 27,162,970.64 17,141,406.05 67,857,318.38 216,796,341.52
PURCHASES (DR) 1,035,247.39 2,202,420.42 1,343,424.98 4,581,092.79 1,551,378.49 2,462,360.60 2,630,704.09 6,644,443.18 3,207,495.37 1,557,122.89 64,965.00 4,829,583.26 1,586,266.26 1,470,178.72 1,229,340.67 4,285,785.65 20,340,904.88
TOTAL PURCHASES 22,923,743.80 25,330,629.82 16,417,366.31 55,627,667.33 17,716,019.31 13,445,965.63 21,962,450.16 53,124,435.10 26,777,302.51 18,968,519.60 21,261,582.83 67,007,404.94 25,139,207.95 28,633,149.36 18,370,746.72 72,143,104.03 247,902,611.40
LESS: ENDING INVENTORY 9,044,072.60 - 7,654,153.12 13,549,026.98 13,296,851.77 13,296,851.77 16,517,469.39 14,947,487.79 5,402,107.65 5,402,107.65 26,613,061.64 11,350,888.29 19,025,304.73 19,025,304.73 19,025,304.73
TOTAL PURCHASES 13,879,671.20 25,330,629.82 16,417,366.31 55,627,667.33 10,061,866.19 (103,061.35) 8,665,598.39 39,827,583.33 10,259,833.12 4,021,031.81 15,859,475.18 61,605,297.29 (1,473,853.69) 17,282,261.07 (654,558.01) 53,117,799.30 228,877,306.67
GROSS INCOME (767,884.09) (9,970,353.69) 7,824,870.31 (2,913,367.47) 12,867,028.56 25,141,365.53 11,119,666.79 27,924,880.78 24,838,546.93 30,427,526.13 2,765,820.66 26,566,936.53 39,874,423.28 14,509,502.47 31,445,880.84 47,865,856.67 80,745,347.09
EXPENSES
XX COMPANY
ADMIN FEE (W/EWT)(WTAX) 3,300.00 6,000.00 8,250.08 17,550.08 4,086.19 11,893.20 6,000.00 21,979.39 6,000.00 6,000.00 6,000.00 18,000.00 6,000.00 5,357.16 8,035.74 19,392.90 76,922.37
ADVERTISING 71,820.00 71,820.00 - 7,392.00 - 7,392.00 8,958.88 - 8,958.88 - - 88,170.88
AGENCY 20,089.92 20,089.92 9,698.07 25,832.07 35,530.14 - - -
ARRASTRE 10338.06 10,338.06 15,738.06 28,899.14 9,092.94 53,730.14 - 14,671.98 - 14,671.98 - - 78,740.18
ARRASTRE (EWT)W/VAT 25,339.14 51,940.30 66,951.38 144,230.82 56,563.32 66,951.38 61,186.34 184,701.04 24,604.39 270,144.49 25,399.14 320,148.02 92,267.97 142,204.39 159,259.70 393,732.06 1,042,811.94
CAR INSURANCE 16,183.61 16,183.61 38,565.97 7,952.53 46,518.50 - 35,544.24 35,544.24 - 11,461.18 - 11,461.18 109,707.53
COMMUNICATION 9,209.95 6,495.00 20,358.76 36,063.71 20,477.21 10,294.00 11,234.01 42,005.22 23,842.48 - 7,295.89 31,138.37 24,055.00 15,621.00 11,284.92 50,960.92 160,168.22
COURIER (EWT) 5,948.02 12,480.84 20,584.55 39,013.41 18,786.11 20,957.65 39,743.76 5,803.37 9,105.04 31,987.04 46,895.45 12,119.20 34,628.17 26,498.03 73,245.40 198,898.02
ELECTRICITY 30,694.75 30,737.85 33,063.00 94,495.60 36,786.17 27,906.19 57,308.45 122,000.81 47,687.28 45,473.10 35,270.74 128,431.12 56,515.81 45,708.94 40,642.39 142,867.14 487,794.67
EMPLOYEE INCENTIVES 9,960.00 10,250.00 20,210.00 116,850.00 118,730.75 12,300.00 247,880.75 - 41,800.00 17,600.00 59,400.00 14,750.00 45,150.00 - 59,900.00 387,390.75
FREIGHT (EWT) 99,141.55 66,322.59 49,327.73 214,791.87 61,350.89 2,172.99 177,680.88 241,204.76 128,472.70 116,517.04 234,634.84 479,624.58 65,069.74 48,566.20 471,032.86 584,668.80 1,520,290.01
FREIGHT (W/OUT) 57,451.84 51,366.20 128,954.58 237,772.62 115,539.95 192,013.50 39,742.52 347,295.97 - 148,160.98 - 148,160.98 71,027.43 47,447.10 60,452.15 178,926.68 912,156.25
GOV'T MANDATORIES (CONTRI) 44,600.00 45,950.00 90,550.00 49,420.00 49,420.00 52,890.00 151,730.00 57,368.47 87,351.73 47,770.52 192,490.72 58,490.00 64,353.60 44,690.00 167,533.60 602,304.32
GOV'T MANDATORIES (LOAN) 4,740.08 3,240.15 7,980.23 4,240.15 4,240.15 4,478.47 12,958.77 - 17,041.58 3,970.35 21,011.93 3,816.90 - 5,826.90 9,643.80 51,594.73
GOV'T MANDATORIES (PROD) 17,335.00 17,335.00 14,335.00 11,135.00 6,400.00 31,870.00 - 28,540.00 - 28,540.00 - - 77,745.00
HANDLING FEE (EWT) 10,080.00 13,170.64 27,943.09 51,193.73 7,376.80 20,140.90 6,989.47 34,507.17 9,721.60 10,080.00 4,210.00 24,011.60 - 253,128.30 - 253,128.30 362,840.80
HANDLING FEE (W/OEWT)W 6,284.90 1,357.50 6,270.00 13,912.40 4,868.75 7,000.00 3,500.00 15,368.75 3,500.00 15,119.50 7,939.66 26,559.16 11,935.89 4,222.50 1,391.50 17,549.89 73,390.20
HAULING FEE 16,000.00 16,000.00 - - - - - 18,675.45 10,500.00 - 29,175.45 45,175.45
HAULING FEE (EWT) 73,000.00 103,000.00 146,000.00 322,000.00 96,000.00 183,000.00 132,000.00 411,000.00 119,000.00 349,205.68 244,000.00 712,205.68 - 3,500.00 - 3,500.00 1,448,705.68
OFFICE SUP (EWT) 7,594.00 7,594.00 169,349.00 169,349.00 - - - - 176,943.00
OFFICE SUP 14,990.00 14,990.00 5,837.50 -
OTHER SERVICES 176,054.40 22,500.00 7,500.00 206,054.40 17,500.00 7,100.00 24,600.00 10,850.00 10,849.77 - 21,699.77 20,745.25 41,242.35 83,125.00 145,112.60 397,466.77
OTHER SERVICES (EWT)W/V 8,640.00 16,950.00 2,625.00 28,215.00 34,271.00 34,271.00 - 50,290.00 50,290.00 - 112,776.00
PETTY CASH BOND 115,000.00 115,000.00 130,000.00 360,000.00 15,000.00 100,000.00 115,000.00 230,000.00 130,000.00 691,000.00 821,000.00 277,500.00 160,000.00 256,500.00 694,000.00 2,105,000.00
PHOTOCOPY & PRINTING 184,082.00 169,250.00 180,187.00 533,519.00 50,050.00 49,000.00 154,749.00 253,799.00 43,419.00 280,926.00 362,750.00 687,095.00 - 88,695.80 58,134.37 146,830.17 1,621,243.17
PHOTOCOPY & PRINTING (E 621.39 14,400.00 2,075.31 17,096.70 684.33 808.88 1,576.24 3,069.45 - - 7,562.29 7,562.29 1,383.29 - - 1,383.29 29,111.73
PROD SUPPLIES 45,456.05 37,500.00 10,500.00 93,456.05 78,910.00 29,000.00 39,124.30 147,034.30 122,350.00 - 279,310.00 401,660.00 - - 831,680.67 831,680.67 1,473,831.02
PROD SUPPLIES (EWT) 62,401.00 50,127.00 425,000.00 537,528.00 88,350.00 350,040.00 438,390.00 111,000.00 18,990.00 26,285.71 156,275.71 - - 1,132,193.71
PROD SUPPLIES (EWT)W/VA 4,098.00 8,250.00 12,348.00 19,426.70 2,400.00 21,826.70 22,740.00 16,000.00 20,160.00 58,900.00 - 13,448.25 13,448.25 106,522.95
RENTAL (EWT) 100,800.00 100,800.00 201,600.00 201,600.00 - 180,000.00 - 180,000.00 - 482,400.00
223,412.31 16,225.00 239,637.31 1,943.35 1,943.35
REP. & MAIN. 54,783.43 54,783.43 - 34,927.05 - 34,927.05 - - - 89,710.48
REP. & MAIN. (EWT) 4,400.00 4,400.00 62,000.00 62,000.00 14,800.00 14,800.00 46,480.00 46,480.00 127,680.00
REP. & MAIN. (EWT)W/VAT 43,524.75 43,524.75 37,690.00 6,395.00 44,085.00 - - 87,609.75
RETAINER'S FEE 152,091.89 66,795.00 218,886.89 9,000.00 417,786.57 426,786.57 102,700.00 9,000.00 10,500.00 122,200.00 102,234.79 6,500.00 89,773.00 198,507.79 966,381.25
SALARIES AND WAGES (OFF 208,662.33 381,004.28 399,508.28 989,174.89 407,534.84 400,176.57 807,711.41 391,185.99 377,283.90 367,880.01 1,136,349.90 418,409.25 210,844.22 676,446.57 1,305,700.04 4,238,936.24
SALARIES AND WAGES (PROD) - 1,137,500.00 794,000.00 1,931,500.00 1,037,000.00 - 1,037,000.00 940,000.00 - 902,000.00 1,842,000.00 4,810,500.00
SECURITY SERVICES (EWT) 21,000.00 21,000.00 - 38,000.00 38,000.00 38,000.00 114,000.00 - 38,642.84 57,964.26 96,607.10 231,607.10
SECURITY SERVICES 20,900.00 38,000.00 38,000.00 96,900.00 19,000.00 57,000.00 38,000.00 114,000.00 - - - - - -
TAXES & LICENSE 232,939.81 549,199.75 277,787.81 1,059,927.37 66,128.76 494,056.08 190,257.95 750,442.79 - 655,759.82 229,532.09 885,291.91 - 552,990.67 444,578.67 997,569.34 3,693,231.41
WATER - 7,202.60 6,768.74 13,971.34 8,157.06 7,549.67 8,764.95 24,471.68 7,896.75 1,996.38 1,649.31 11,542.44 - 49,985.46
TOTALXX COMPANY EXPEN 1,867,176.37 1,886,324.63 2,326,847.19 6,080,348.19 1,483,121.66 3,634,889.14 2,631,276.62 7,749,287.42 1,464,827.96 4,567,688.73 2,009,707.59 8,036,386.78 2,241,475.97 1,844,212.67 4,229,316.73 8,315,005.37 29,657,937.04
TOTALXX COMPANY INCO (2,635,060.46) (11,856,678.32) 5,498,023.12 (8,993,715.66) 11,383,906.90 21,506,476.39 8,488,390.17 20,175,593.36 23,373,718.97 25,859,837.40 756,113.07 18,530,549.75 37,632,947.31 12,665,289.80 27,216,564.11 39,550,851.30 51,087,410.05
LESS:
COMPANY 2 42,583.97 13,151.81 15,758.44 71,494.22 16,867.14 15,693.16 17,655.70 50,216.00 16,070.64 22,885.85 16,754.98 55,711.47 16,875.75 19,180.86 18,894.04 54,950.65 232,372.34
COMPANY 3 123,484.77 40,037.20 163,521.97 15,490.61 - 65,860.00
COMPANY 1 EXPENSE - - - - - - - - - - - - - - -
TOTAL OTHER COMPANY E 166,068.74 13,151.81 55,795.64 235,016.19 16,867.14 15,693.16 33,146.31 50,216.00 16,070.64 22,885.85 82,614.98 55,711.47 16,875.75 19,180.86 18,894.04 54,950.65 232,372.34
TOTAL INCOME AMOUNT G (2,801,129.20) (11,869,830.13) 5,442,227.48 (9,228,731.85) 11,367,039.76 21,490,783.23 8,455,243.86 20,125,377.36 23,357,648.33 25,836,951.55 673,498.09 18,474,838.28 37,616,071.56 12,646,108.94 27,197,670.07 39,495,900.65 50,855,037.71

You might also like