본문 바로가기
카테고리 없음

년 기준 월별 현황

by 시원한 하루 2014. 5. 4.
반응형

구분 1년 기준 월별 현황

2008 2009

10 11 12 소계 1 2 3 4 5 6 7 8 9 10 11 12 소계

매출 65,000,000 42,000,000 107,000,000 35,000,000 25,000,000 30,000,000 40,000,000 60,000,000 45,000,000 35,000,000 20,000,000 35,000,000 45,000,000 60,000,000 50,000,000 480,000,000 587,000,000

판매이익 60% - 39,000,000 25,200,000 64,200,000 21,000,000 15,000,000 18,000,000 24,000,000 36,000,000 27,000,000 21,000,000 12,000,000 21,000,000 27,000,000 36,000,000 30,000,000 288,000,000 352,200,000

판매이익-경비제외 : 월이익금 -11,411,111 18,348,889 4,336,889 11,274,667 9,028,889 -411,111 -2,091,111 3,448,889 18,828,889 10,568,889 3,028,889 -7,631,111 628,889 6,068,889 18,628,889 13,188,889 73,286,667 84,561,333 84,561,333 

14%

현금흐름:매출-경비 -7,800,000 47,960,000 24,748,000 64,908,000 26,640,000 13,200,000 13,520,000 23,060,000 46,440,000 32,180,000 20,640,000 3,980,000 18,240,000 27,680,000 46,240,000 36,800,000 308,620,000 373,528,000

현금흐름(월)-수주대금 33,901,320 -3,369,360 30,531,960 -1,477,360 -10,231,133 -21,480,000 -11,940,000 21,440,000 7,180,000 640,000 3,980,000 -1,760,000 7,680,000 3,030,797 -6,409,203 -9,346,899 21,185,061

매출기준 현금 흐름(누계) 30,531,960 29,054,600 18,823,467 -2,656,533 -14,596,533 6,843,467 14,023,467 14,663,467 18,643,467 16,883,467 24,563,467 27,594,264 21,185,061

[투자비 개념] - 현금

수주 대금 08 f/w(1.4억) 33,209,203 33,209,203 66,418,406 66,418,406

09 s/s(1.2억) 14,058,680 28,117,360 42,176,040 28,117,360 23,431,133 10,000,000 10,000,000 71,548,493 113,724,533

09 f/w(1.2억) 25,000,000 25,000,000 25,000,000 25,000,000 20,000,000 120,000,000 120,000,000

10 s/s(1억중 60%) 20,000,000 20,000,000 10,000,000 10,000,000 60,000,000 60,000,000

14,058,680 28,117,360 42,176,040 28,117,360 23,431,133 35,000,000 35,000,000 25,000,000 25,000,000 20,000,000 - 20,000,000 20,000,000 43,209,203 43,209,203 317,966,899 360,142,939

매장 보증금 100,000,000

인테리어 비용(3년 감가) 65,000,000 65,000,000 130,000,000 -

총 투자비용 165,000,000 79,058,680 28,117,360 172,176,040 28,117,360 23,431,133 35,000,000 35,000,000 25,000,000 25,000,000 20,000,000 - 20,000,000 20,000,000 43,209,203 43,209,203 317,966,899 490,142,939

[일반경비]

월 임대료 3,300,000 3,300,000 3,300,000 9,900,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 3,300,000 39,600,000 49,500,000

인건비.식대 1,000,000 1,500,000 1,500,000 4,000,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 18,000,000 22,000,000

감가상각 3년 3,611,111 3,611,111 3,611,111 10,833,333 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 3,611,111 43,333,333 54,166,667

카드수수료 - 2,340,000 1,512,000 3,852,000 1,260,000 900,000 1,080,000 1,440,000 2,160,000 1,620,000 1,260,000 720,000 1,260,000 1,620,000 2,160,000 1,800,000 17,280,000 21,132,000

금융비용 3억 10% 2,500,000 2,500,000 2,500,000 7,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 30,000,000 37,500,000

통신료.기장료.세콤.보험.택배 500,000 500,000 500,000 1,500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 6,000,000 7,500,000

수선비(매출대비 2%) - 1,300,000 840,000 2,140,000 700,000 500,000 600,000 800,000 1,200,000 900,000 700,000 400,000 700,000 900,000 1,200,000 1,000,000 9,600,000 11,740,000

전기료등 500,000 600,000 600,000 1,700,000 600,000 600,000 500,000 400,000 400,000 500,000 600,000 600,000 500,000 500,000 600,000 600,000 6,400,000 8,100,000

세금 -4,000,000 2,000,000 -2,000,000 -2,000,000

매장 광고홍보 비용 5,000,000 6,500,000 11,500,000 2,000,000 2,000,000 6,500,000 6,500,000 2,000,000 2,000,000 2,000,000 6,500,000 6,500,000 6,500,000 2,000,000 2,000,000 46,500,000 58,000,000

월 누계 11,411,111 20,651,111 20,863,111 52,925,333 11,971,111 15,411,111 20,091,111 20,551,111 17,171,111 16,431,111 17,971,111 19,631,111 20,371,111 20,931,111 17,371,111 16,811,111 214,713,333 267,638,667

감가상각 

7,800,000 17,040,000 17,252,000 42,092,000 8,360,000 11,800,000 16,480,000 16,940,000 13,560,000 12,820,000 14,360,000 16,020,000 16,760,000 17,320,000 13,760,000 13,200,000 171,380,000 213,472,000 54,166,667 

반응형

댓글