Scribd Logo
Upload

Welcome to Scribd!

  • 168 views

    Cafes Monte Bianco Cash Flow HLC

    Uploaded by

    David Bolle
    1) The document shows the monthly cash flow statement for Cafes Monte Bianco over 12 months, listing cash inflows from accounts receivable and premium sales against cash outflows from cost of goods sold, fixed costs, selling expenses, R&D, administration, interest, and taxes. 2) Over the year there was a total cash deficit of $5.2 million, requiring additional cash to cover expenses and debt repayment. 3) The largest cash outflows each month were for cost of goods sold between $2.5-3.3 million and debt interest payments of $198,000, while cash inflows varied substantially month to month from accounts receivable and premium sales.

    Copyright:

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

    Cafes Monte Bianco Cash Flow HLC

    Uploaded by

    David Bolle
    168 views1 page
    1) The document shows the monthly cash flow statement for Cafes Monte Bianco over 12 months, listing cash inflows from accounts receivable and premium sales against cash outflows from cost of goods sold, fixed costs, selling expenses, R&D, administration, interest, and taxes. 2) Over the year there was a total cash deficit of $5.2 million, requiring additional cash to cover expenses and debt repayment. 3) The largest cash outflows each month were for cost of goods sold between $2.5-3.3 million and debt interest payments of $198,000, while cash inflows varied substantially month to month from accounts receivable and premium sales.

    Original Description:

    hlc hlc document

    Original Title

    Cafes Monte Bianco Cash Flow Hlc

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) The document shows the monthly cash flow statement for Cafes Monte Bianco over 12 months, listing cash inflows from accounts receivable and premium sales against cash outflows from cost of goods sold, fixed costs, selling expenses, R&D, administration, interest, and taxes. 2) Over the year there was a total cash deficit of $5.2 million, requiring additional cash to cover expenses and debt repayment. 3) The largest cash outflows each month were for cost of goods sold between $2.5-3.3 million and debt interest payments of $198,000, while cash inflows varied substantially month to month from accounts receivable and premium sales.

    Copyright:

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

    Cafes Monte Bianco Cash Flow HLC

    Uploaded by

    David Bolle
    1) The document shows the monthly cash flow statement for Cafes Monte Bianco over 12 months, listing cash inflows from accounts receivable and premium sales against cash outflows from cost of goods sold, fixed costs, selling expenses, R&D, administration, interest, and taxes. 2) Over the year there was a total cash deficit of $5.2 million, requiring additional cash to cover expenses and debt repayment. 3) The largest cash outflows each month were for cost of goods sold between $2.5-3.3 million and debt interest payments of $198,000, while cash inflows varied substantially month to month from accounts receivable and premium sales.

    Copyright:

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

    CAFES MONTE BIANCO Cash flow BASIC SOLUTION GIVEN TO PARTICIPANTS

    HUMBERTO LINARES CARDONA


    JULIO 15, 2017
    Cash In Cash Out Add back Selling R&D Admin Interest(*) Taxes Monthy cash flow Monthly Debt (*) Interest
    A/R A/R COGS COGS depreciation (calculated on average debt)
    Private Premium Variable Fixed
    35,000,000
    January 1,328,026 5,597,280 3,300,000 276,625 249,475 104,262 69,336 198,000 318,750 2,907,807 32,092,193 305,509
    February 1,226,650 3,300,000 276,625 249,475 104,262 69,336 198,000 292,268 (2,764,367) 34,856,560 304,856
    March 1,216,512 3,300,000 276,625 249,475 104,262 69,336 198,000 317,444 (2,799,680) 37,656,240 330,192
    April 3,748,800 2,970,000 276,625 249,475 104,262 69,336 198,000 342,941 37,111 37,619,129 342,772
    May 4,752,000 3,207,600 276,625 249,475 104,262 69,336 198,000 342,603 242,787 560,261 37,058,868 340,052
    June 6,230,400 2,574,000 276,625 249,475 104,262 69,336 198,000 337,500 2,920,151 34,138,717 324,203
    July 3,960,000 3,300,000 276,625 249,475 104,262 69,336 198,000 310,906 (49,655) 34,188,371 311,132
    August 4,276,800 3,300,000 276,625 249,475 104,262 69,336 198,000 311,358 266,693 33,921,678 310,144
    September 2,640,000 3,300,000 276,625 249,475 104,262 69,336 198,000 308,930 (1,367,678) 35,289,356 315,157
    October 2,217,600 3,300,000 276,625 249,475 104,262 69,336 198,000 321,385 (1,802,534) 37,091,890 329,593
    November 1,742,400 3,300,000 276,625 249,475 104,262 69,336 198,000 337,801 364,181 (2,658,331) 39,750,220 349,906
    December 3,590,400 3,300,000 276,625 249,475 104,262 69,336 198,000 362,011 (470,359) 40,220,580 (5,220,580) 364,153
    36,929,587 5,597,280 38,451,600 3,319,500 2,993,700 1,251,149 832,033 2,376,000 3,903,897 606,969 (5,220,580) Yearly cash deficit 3,927,669
    1,121,450 Initial cash
    (5,220,580) Cash needed

    You might also like