projection hulala

31
Surya modal Deposit 12,400,000 2/3 modal 3 bulan sewa 18,600,000 12400000 modal Interior 3,000,000 Operational bulan 1 - Ju Total 34,000,000 ### persentase 47.85% saham 15,000,000 3,000,000 reksadana 5,500,000 tabungan 7,000,000 30,500,000

Upload: surya-permana

Post on 11-Sep-2015

14 views

Category:

Documents


1 download

DESCRIPTION

projection excel sheet

TRANSCRIPT

Pembagian modal awalSuryaOm EddymodalDeposit12,400,000Paket Franchise30,000,0002/3 modal3 bulan sewa18,600,00012400000bahan baku6,250,000transport800,000modalInterior3,000,000Operational bulan 10.0JumlahTotal34,000,00071,050,00037,050,00027,800,000persentase47.85%52.15%saham15,000,0003,000,000reksadana5,500,000tabungan 7,000,00030,500,000

Business Summary

Initial InvestmentTotalYEARLY ANALYSYSFranchise30,000,00020152016201720182019Bahan baku 1 bulan6,250,000Total Sales for Month150,000,000330,000,000363,000,000399,300,000439,230,000Transport800,000Sales Portion150,000,000330,000,000363,000,000399,300,000439,230,000Tempat (Deposit)12,400,000COGS37,500,00082,500,00090,750,00099,825,000109,807,500Tempat (3bulan)18,600,000Gross Profit112,500,000247,500,000272,250,000299,475,000329,422,500Tempat (annual)Total Opex67,200,000147,240,000161,364,000176,900,400193,990,440operasional bulan 1Net Profit45,300,000100,260,000110,886,000122,574,600135,432,060Renovasi interior3,000,000Total Initial Investment71,050,000Break even point9.1bulanNote: tahun 2015 dimulai dari JuliAsumsiSumber modalModal sendiri50,000,000Kredit0.79%Bunga03 tahunCicilan pokok0.0AsumsiAsumsicustomRendahSedangTinggicustomPenjualan Bulanan1,000Penjualan harian25355040Base Price25,000Penjualan Bulanan75010001400750kenaikan harga10%Base Price20000230002500025000Sales Portion100%kenaikan harga0.10.10.10.1COGS0Sales Portion1111Sallary2,000,000per org2Base COGS25%25%25%25%tempat(harian)0.0Sallary2000000200000020000002000000Tempat (Bulanan)6,200,000tempat(harian)tempat(tahunan)0.0Tempat (Bulanan)6200000620000062000006200000Promosi500,000tempat(tahunan)0Listrik0

Income Statement201520152015201520152015201620162016201620162016201620162016201620162016201720172017201720172017201720172017201720172017201820182018201820182018201820182018201820182018201920192019201920192019201920192019201920192019JuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberDays313130313031312831303130313130313031312831303130313130313031312831303130313130313031312831303130313130313031RevenueQty Sold1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,000Price25,00025,00025,00025,00025,00025,00027,50027,50027,50027,50027,50027,50027,50027,50027,50027,50027,50027,50030,25030,25030,25030,25030,25030,25030,25030,25030,25030,25030,25030,25033,27533,27533,27533,27533,27533,27533,27533,27533,27533,27533,27533,27536,60336,60336,60336,60336,60336,60336,60336,60336,60336,60336,60336,603ppnKenaikan10%10%10%10%Total Sales for Month25,000,00025,000,00025,000,00025,000,00025,000,00025,000,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,500

100%Sales Portion25,000,00025,000,00025,000,00025,000,00025,000,00025,000,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50025%COGS6,250,0006,250,0006,250,0006,250,0006,250,0006,250,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0006,875,0007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5007,562,5008,318,7508,318,7508,318,7508,318,7508,318,7508,318,7508,318,7508,318,7508,318,7508,318,7508,318,7508,318,7509,150,6259,150,6259,150,6259,150,6259,150,6259,150,6259,150,6259,150,6259,150,6259,150,6259,150,6259,150,625Gross Profit18,750,00018,750,00018,750,00018,750,00018,750,00018,750,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00020,625,00022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50022,687,50024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25024,956,25027,451,87527,451,87527,451,87527,451,87527,451,87527,451,87527,451,87527,451,87527,451,87527,451,87527,451,87527,451,875

OpexSallary4,000,0004,000,0004,000,0004,000,0004,000,0004,000,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,400,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0004,840,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,324,0005,856,4005,856,4005,856,4005,856,4005,856,4005,856,4005,856,4005,856,4005,856,4005,856,4005,856,4005,856,400tempat(harian)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Tempat (Bulanan)6,200,0006,200,0006,200,0006,200,0006,200,0006,200,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0006,820,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0007,502,0008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2008,252,2009,077,4209,077,4209,077,4209,077,4209,077,4209,077,4209,077,4209,077,4209,077,4209,077,4209,077,4209,077,420tempat(tahunan)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Listrik500,000500,000500,000500,000500,000500,000550,000550,000550,000550,000550,000550,000550,000550,000550,000550,000550,000550,000605,000605,000605,000605,000605,000605,000605,000605,000605,000605,000605,000605,000665,500665,500665,500665,500665,500665,500665,500665,500665,500665,500665,500665,500732,050732,050732,050732,050732,050732,050732,050732,050732,050732,050732,050732,050Depresiasi (5thn)500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000Bunga0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Total Opex11,200,00011,200,00011,200,00011,200,00011,200,00011,200,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00012,270,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00013,447,00014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70014,741,70016,165,87016,165,87016,165,87016,165,87016,165,87016,165,87016,165,87016,165,87016,165,87016,165,87016,165,87016,165,870

Net Profit7,550,0007,550,0007,550,0007,550,0007,550,0007,550,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0008,355,0009,240,5009,240,5009,240,5009,240,5009,240,5009,240,5009,240,5009,240,5009,240,5009,240,5009,240,5009,240,50010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55010,214,55011,286,00511,286,00511,286,00511,286,00511,286,00511,286,00511,286,00511,286,00511,286,00511,286,00511,286,00511,286,005

Cashflow201520152015201520152015201620162016201620162016201620162016201620162016201720172017201720172017201720172017201720172017201820182018201820182018201820182018201820182018201920192019201920192019201920192019201920192019JuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberJanuariFebruariMaretAprilMeiJuniJuliAgustusSeptemberOktoberNovemberDesemberDays313130313031312831303130313130313031312831303130313130313031312831303130313130313031312831303130313130313031Beginning Cash0(71,050,000)(52,800,000)(38,550,000)(24,300,000)(28,650,000)(14,400,000)(150,000)(3,075,000)12,600,00028,275,00025,350,00041,025,00069,100,00053,775,00069,450,00085,125,00082,200,00097,875,000113,550,000112,192,500129,435,000146,677,500145,320,000162,562,500192,205,000178,447,500195,690,000212,932,500211,575,000228,817,500246,060,000246,426,750265,393,500284,360,250284,727,000303,693,750335,060,500323,027,250341,994,000360,960,750361,327,500380,294,250399,261,000401,524,425422,387,850443,251,275445,514,700466,378,125499,641,550489,504,975510,368,400531,231,825533,495,250554,358,675

Cashflow from operatingSales Portion25,000,00025,000,00025,000,00025,000,00025,000,00025,000,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00027,500,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00030,250,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00033,275,00036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,50036,602,500COGS(6,250,000)(6,250,000)(6,250,000)(6,250,000)(6,250,000)(6,250,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(6,875,000)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(7,562,500)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(8,318,750)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)(9,150,625)Sallary0.0(4,000,000)(4,000,000)(4,000,000)(4,000,000)(4,000,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,400,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(4,840,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,324,000)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)(5,856,400)100%tempat(harian)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Tempat (3bulan)(18,600,000)(18,600,000)(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0(18,600,000)0.00.0Tempat (Deposit)(12,400,000)12,400,000(12,400,000)12,400,000(12,400,000)0.00.00.00.00.00.00.00.00.00.012,400,000(12,400,000)0.00.00.00.00.00.00.00.00.00.012,400,000(12,400,000)0.00.00.00.00.0Listrik(500,000)(500,000)(500,000)(500,000)(500,000)(500,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(550,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(605,000)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(665,500)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)(732,050)Total Cashflow from operating(31,000,000)18,250,00014,250,00014,250,000(4,350,000)14,250,00014,250,000(2,925,000)15,675,00015,675,000(2,925,000)15,675,00028,075,000(15,325,000)15,675,00015,675,000(2,925,000)15,675,00015,675,000(1,357,500)17,242,50017,242,500(1,357,500)17,242,50029,642,500(13,757,500)17,242,50017,242,500(1,357,500)17,242,50017,242,500366,75018,966,75018,966,750366,75018,966,75031,366,750(12,033,250)18,966,75018,966,750366,75018,966,75018,966,7502,263,42520,863,42520,863,4252,263,42520,863,42533,263,425(10,136,575)20,863,42520,863,4252,263,42520,863,42520,863,425

Cashflow from InvestingInitial InvestmentFranchise30,000,000Bahan baku 1 bulan6,250,000Transport800,000Renovasi interior3,000,000Total Cashflow from investing(40,050,000)

Cashflow from financingModalKredit Bank0.0Bunga0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Cicilan pokok0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Total Cashflow from financing0.0

Net Cash Inflow(71,050,000)18,250,00014,250,00014,250,000(4,350,000)14,250,00014,250,000(2,925,000)15,675,00015,675,000(2,925,000)15,675,00028,075,000(15,325,000)15,675,00015,675,000(2,925,000)15,675,00015,675,000(1,357,500)17,242,50017,242,500(1,357,500)17,242,50029,642,500(13,757,500)17,242,50017,242,500(1,357,500)17,242,50017,242,500366,75018,966,75018,966,750366,75018,966,75031,366,750(12,033,250)18,966,75018,966,750366,75018,966,75018,966,7502,263,42520,863,42520,863,4252,263,42520,863,42533,263,425(10,136,575)20,863,42520,863,4252,263,42520,863,42520,863,425Ending Cash(71,050,000)(52,800,000)(38,550,000)(24,300,000)(28,650,000)(14,400,000)(150,000)(3,075,000)12,600,00028,275,00025,350,00041,025,00069,100,00053,775,00069,450,00085,125,00082,200,00097,875,000113,550,000112,192,500129,435,000146,677,500145,320,000162,562,500192,205,000178,447,500195,690,000212,932,500211,575,000228,817,500246,060,000246,426,750265,393,500284,360,250284,727,000303,693,750335,060,500323,027,250341,994,000360,960,750361,327,500380,294,250399,261,000401,524,425422,387,850443,251,275445,514,700466,378,125499,641,550489,504,975510,368,400531,231,825533,495,250554,358,675575,222,100

To DoNoTo Do ListStatusKeterangan1Survey Eat & Eat hari Sabtu2Survey Eat & Eat hari Minggu3Survey Eat & Eat hari Libur4Survey Counter Hulala di Plaza semanggi