Scribd Logo
Upload

Welcome to Scribd!

  • 34 views

    Cashflow Foodcourt

    Uploaded by

    didin sumpena
    The document provides an estimation of cash flows for a company over a 14 month period from May 2023 to April 2024. It includes projected daily and monthly sales targets, estimated cash receipts from sales and loans, cash expenditures on operating costs, inventory, salaries, and loan repayments. It also shows the estimated ending monthly cash balance, the amount of investor capital remaining, estimated return on investment for the investor, and projected profit sharing amounts.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Cashflow Foodcourt

    Uploaded by

    didin sumpena
    34 views1 page
    The document provides an estimation of cash flows for a company over a 14 month period from May 2023 to April 2024. It includes projected daily and monthly sales targets, estimated cash receipts from sales and loans, cash expenditures on operating costs, inventory, salaries, and loan repayments. It also shows the estimated ending monthly cash balance, the amount of investor capital remaining, estimated return on investment for the investor, and projected profit sharing amounts.

    Original Description:

    Estimasi cashflow untuk usaha foodcourt

    Original Title

    Cashflow_Foodcourt

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides an estimation of cash flows for a company over a 14 month period from May 2023 to April 2024. It includes projected daily and monthly sales targets, estimated cash receipts from sales and loans, cash expenditures on operating costs, inventory, salaries, and loan repayments. It also shows the estimated ending monthly cash balance, the amount of investor capital remaining, estimated return on investment for the investor, and projected profit sharing amounts.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    34 views1 page

    Cashflow Foodcourt

    Uploaded by

    didin sumpena
    The document provides an estimation of cash flows for a company over a 14 month period from May 2023 to April 2024. It includes projected daily and monthly sales targets, estimated cash receipts from sales and loans, cash expenditures on operating costs, inventory, salaries, and loan repayments. It also shows the estimated ending monthly cash balance, the amount of investor capital remaining, estimated return on investment for the investor, and projected profit sharing amounts.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    Estimasi Aliran Kas

    Tanggal mulai: 01-May-2023 (Pra) Awal MEI JUN JUL AGU SEP OKT NOV DES JAN FEB MAR APR Total Grafik
    Target Harian 24/05/23 60 72 94 103 113 125 137 151 166 182 201 221
    Target Bulanan EST 1500 1800 2340 2574 2831 3115 3426 3769 4145 4560 5016 5518 Item EST

    Saldo Kas (awal bulan) - 300,000 1,850,000 3,050,000 3,886,000 5,049,600 6,093,520 4,033,832 5,910,215 7,386,277 9,389,944 11,973,939 11,696,333 11,696,333

    Penerimaan Kas
    Penjualan (Est. rata-rata Rp. 7000/ Menu) - 10,500,000 12,600,000 16,380,000 18,018,000 19,819,800 21,801,780 23,981,958 26,380,154 29,018,169 31,919,986 35,111,985 38,623,183 284,155,015
    Pinjaman Investor 10,000,000 5,000,000 - - - - - - - - - - - 15,000,000
    Total 10,000,000 15,500,000 12,600,000 16,380,000 18,018,000 19,819,800 21,801,780 23,981,958 26,380,154 29,018,169 31,919,986 35,111,985 38,623,183 299,155,015
    Total Kas Tersedia (sebelum kas keluar) 10,000,000 15,800,000 14,450,000 19,430,000 21,904,000 24,869,400 27,895,300 28,015,790 32,290,369 36,404,446 41,309,930 47,085,924 50,319,516 310,851,348

    Pengeluaran Kas
    Gaji kotor (jumlah penarikan tepat) - 3,000,000 3,000,000 3,000,000 3,000,000 4,000,000 4,000,000 4,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 49,000,000
    Persediaan Bahan - 5,250,000 6,300,000 8,190,000 9,009,000 9,910,000 10,901,000 11,991,000 13,190,000 14,509,000 15,960,000 17,556,000 19,312,000 142,078,000
    Persediaan (kantor & operasi.) - 300,000 300,000 300,000 300,000 400,000 400,000 400,000 500,000 500,000 500,000 500,000 700,000 5,100,000
    Perbaikan & pemeliharaan Peralatan - 100,000 100,000 100,000 100,000 200,000 200,000 200,000 300,000 300,000 300,000 300,000 830,000 3,030,000
    BBM, pengiriman & perjalanan - 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,986,335 12,986,335
    Sewa Tempat Usaha - 3,600,000 - - - - - - - - - - 3,000 3,603,000
    Listrik, Telepon, Air, Internet - 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 88,282 5,588,282
    Lain-lain (ormas dan lingkungan) - 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 2,400,000
    Total - 13,950,000 11,400,000 13,290,000 14,109,000 16,210,000 17,201,000 18,291,000 20,690,000 22,009,000 23,460,000 25,056,000 28,119,617 223,785,617

    Pengeluaran Kas (Non L&R)


    Pembayaran pokok pinjaman Investor - - - 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 15,000,000
    Pembelian modal (Peralatan kerja) 9,600,000 - - - - - 3,500,000 - - - - 3,500,000 - 16,600,000
    Biaya Legal (Ijin usaha) 100,000 - - - - - - - - - - - - 100,000
    Penarikan oleh Pemilik (hasil usaha yang dibagi) - - - 1,254,000 1,745,400 1,565,880 2,160,468 2,814,575 2,214,092 3,005,502 3,875,992 4,833,591 5,102,140 28,571,639
    Total 9,700,000 - - 2,254,000 2,745,400 2,565,880 6,660,468 3,814,575 4,214,092 5,005,502 5,875,992 10,333,591 7,102,140 60,271,639
    Total Pengeluaran Kas 9,700,000 13,950,000 11,400,000 15,544,000 16,854,400 18,775,880 23,861,468 22,105,575 24,904,092 27,014,502 29,335,992 35,389,591 35,221,757 284,057,256

    Posisi kas (akhir bulan) 300,000 1,850,000 3,050,000 3,886,000 5,049,600 6,093,520 4,033,832 5,910,215 7,386,277 9,389,944 11,973,939 11,696,333 15,097,759 26,794,092

    Modal Investor Tertahan 10,000,000 15,000,000 15,000,000 14,000,000 13,000,000 12,000,000 11,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 -
    Est. Keuntungan relatif Investor terhadap modal 0.00% 0.00% 0.00% 2.24% 3.36% 3.26% 4.91% 7.04% 6.92% 12.52% 24.22% 60.42% 100.00% 18.74%
    Profit Sharing 30% dari hasil usaha yang dibagi - - 376,000 524,000 470,000 648,000 844,000 664,000 902,000 1,163,000 1,450,000 1,531,000 8,572,000

    You might also like