cash flow garasi

3
Progres (%) 5.15 21.32 33.82 100.00 MASA PEMELIHARAAN No Account MINGGU KE 1 2 3 4 5 6 Total A. Penerimaan Kontrak 75,000 Rp 75,000,000.00 1 Uang muka Biaya Proyek + Pemeliharaan 69,000 Rp 69,000,000.00 2 Termin 7,500.00 22,500.00 41,250.00 3,750.00 ### Provisi 0 Rp - 3 Pinjaman: Bank A Total Pinjaman 0 Rp - Bank B Deposito 10000 Rp 10,000,000.00

Upload: imaem-hartono

Post on 28-Sep-2015

6 views

Category:

Documents


0 download

DESCRIPTION

study

TRANSCRIPT

Sheet1Progres (%)5.1521.3233.82100.00MASA PEMELIHARAANNoAccountMINGGU KE123456TotalA.PenerimaanKontrak75,000Rp75,000,000.001Uang mukaBiaya Proyek + Pemeliharaan69,000Rp69,000,000.002Termin7,500.0022,500.0041,250.003,750.0075,000.00Provisi00.03Pinjaman:Bank ATotal Pinjaman00.0Bank BDeposito10000Rp10,000,000.004Deposito10,000.00Total10,000.007,500.0022,500.0041,250.000.003,750.0085,000.00Total Bunga25.00Rp25,000.00B.PengeluaranKeuntungan maks5,975.00Rp5,975,000.001Biaya Proyek3,500.0011,000.008,500.0045,000.00500.00500.0069,000.002Provisi3Bunga:Bank ABank BBank CDeposito12.5012.5025.004PengembalianPinjaman APinjaman BUang MukaDeposito10,000.0010,000.00Total3,512.5011,012.5018,500.0045,000.00500.00500.0079,025.00C.Saldo:1Awal-6,487.502,975.006,975.003,225.002,725.002Akhir6,487.502,975.006,975.003,225.002,725.005,975.005,975.00

Sheet2NoAccountBulanke123456789101112TotalA.Penerimaan1Uang muka2Termijn60,000,000.060,000,000.03Pinjaman:Bank A2,462,605.07,221,050.09,683,655.0Bank B7,181,820.02,818,180.010,000,000.0Bank C17,698,200.012,422,070.02,679,437.0806,230.03,054,360.02,075,100.0833,320.039,568,717.04Deposito2,788,200.03,994,260.03,217,540.010,000,000.0Total7,181,820.05,280,785.07,221,050.017,698,200.012,422,070.05,467,637.03,994,260.04,023,770.03,054,360.02,075,100.0833,320.060,000,000.0B.Pengeluaran1Biaya Proyek7,000,000.05,000,000.07,000,000.07,000,000.012,000,000.05,000,000.03,500,000.03,500,000.02,500,000.01,500,000.0250,000.0250,000.054,500,000.02Provisi100,000.0150,000.0400,000.0650,000.03Bunga:Bank A30,782.6121,045.7121,045.7121,045.7121,045.7121,045.7121,045.7121,045.7121,045.7121,045.71,120,193.8Bank B71,818.2100,000.0100,000.0271,818.2Bank C176,982.0301,202.7327,997.1327,997.1336,059.4366,603.0387,354.0395,687.22,619,882.3Deposito18,588.045,216.466,666.766,666.766,666.766,666.7330,471.14PengembalianPinjaman A9,683,655.00.0Pinjaman B10,000,000.0Pinjaman C39,568,717.00.0Deposito10,000,000.0Total7,171,818.25,280,782.67,221,045.717,698,027.712,422,248.45,467,630.83,994,259.24,023,771.73,054,315.32,075,066.3833,399.559,502,372.059,492,365.3C.Saldo:1Awal0.0010,001.810,004.210,008.510,180.910,002.510,008.710,009.610,007.810,052.510,086.210,006.72Akhir10,001.810,004.210,008.510,180.910,002.510,008.710,009.610,007.810,052.510,086.210,006.7507,634.7507,634.7

Sheet3