Scribd Logo
Upload

Welcome to Scribd!

  • 181 views

    Silvia Caffe - Solution

    Uploaded by

    Murtaza Badri
    This document summarizes the financial performance of Silvia Caffe from 2010-2015. It shows that over this period, coffee production increased from 300,000kg to 900,000kg, revenues grew from €4.5M to €13.5M, and free cash flow increased from €590,000 to €2.57M. A net present value analysis using a 7.5% discount rate yields a NPV of €4.57M and an internal rate of return of 46% for the period.

    Copyright:

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

    Silvia Caffe - Solution

    Uploaded by

    Murtaza Badri
    181 views1 page
    This document summarizes the financial performance of Silvia Caffe from 2010-2015. It shows that over this period, coffee production increased from 300,000kg to 900,000kg, revenues grew from €4.5M to €13.5M, and free cash flow increased from €590,000 to €2.57M. A net present value analysis using a 7.5% discount rate yields a NPV of €4.57M and an internal rate of return of 46% for the period.

    Original Description:

    Corporate Finance

    Original Title

    Silvia Caffe_solution

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes the financial performance of Silvia Caffe from 2010-2015. It shows that over this period, coffee production increased from 300,000kg to 900,000kg, revenues grew from €4.5M to €13.5M, and free cash flow increased from €590,000 to €2.57M. A net present value analysis using a 7.5% discount rate yields a NPV of €4.57M and an internal rate of return of 46% for the period.

    Copyright:

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

    Silvia Caffe - Solution

    Uploaded by

    Murtaza Badri
    This document summarizes the financial performance of Silvia Caffe from 2010-2015. It shows that over this period, coffee production increased from 300,000kg to 900,000kg, revenues grew from €4.5M to €13.5M, and free cash flow increased from €590,000 to €2.57M. A net present value analysis using a 7.5% discount rate yields a NPV of €4.57M and an internal rate of return of 46% for the period.

    Copyright:

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

    SILVIA CAFFE' - SOLUTION

    2010 2011 2012 2013 2014 2015


    Kg. Coffee 300,000 450,000 600,000 750,000 900,000

    unit price 15

    Revenues 4,500,000.00 6,750,000.00 9,000,000.00 11,250,000.00 13,500,000.00 -

    unit cost 11

    Costs 3,300,000.00 4,950,000.00 6,600,000.00 8,250,000.00 9,900,000.00

    Depreciation 500,000 500,000 500,000 500,000 500,000

    Ebit 700,000.00 1,300,000.00 1,900,000.00 2,500,000.00 3,100,000.00

    Operating taxes 210,000.00 390,000.00 570,000.00 750,000.00 930,000.00

    Nopat 490,000.00 910,000.00 1,330,000.00 1,750,000.00 2,170,000.00

    Depreciation 500,000 500,000 500,000 500,000 500,000

    Investments/divestments in working capital - 400,000.00 - 200,000.00 - 200,000.00 - 100,000.00 - 100,000.00 1,000,000.00

    Investments/divestments in fixed assets 0 0 0 0 0 250,000.00

    Taxes on capital gain 75,000.00

    Free cash flow from operations 590,000.00 1,210,000.00 1,630,000.00 2,150,000.00 2,570,000.00 1,175,000.00

    Working Capital
    2009 2010 2011 2012 2013 2014
    1,000,000 1,400,000 1,600,000 1,800,000 1,900,000 2,000,000

    Initial Investment 2,500,000.00

    PV (Fcfo 2010 - 2015) @ 7,5% € 7,069,407.01

    NPV € 4,569,407.01

    2010 2010 2011 2012 2013 2014 2015


    - 2,500,000.00 590,000.00 1,210,000.00 1,630,000.00 2,150,000.00 2,570,000.00 1,175,000.00

    IRR
    46%

    You might also like