CMA Study Group

  • 1.  PART 2 Net PV

    Posted 09-02-2015 03:33 AM

     

    The Eat-Right Company has been disappointed by previous capital budgeting decisions using the payback method. A new requirement has been implemented that requires discounted cash flow analysis to be used to compute the net present value of proposed purchases over $300,000. The Food Processing Department of the Eat-Right Company is considering the acquisition of a new machine that will reduce labor costs by a pre-tax amount of $175,000 per year. Other information regarding the possible acquisition is as follows.

     

    Which of the following best indicates the net present value of the proposed investment, and the appropriate acquisition decision?

    a. Approximately $73,000; recommend making the investment.

    b. Approximately ($73,000); recommend not making the investment.

    c. Approximately $55,000; recommend making the investment.

    d. Approximately ($55,000); recommend not making the investment.

     

    Correct answer is b.

    but I m not getting it, please help.

     



    ------------------------------
    Inam Ullah
    Accountant
    JC Maclean International FZCO
    DUBAI
    United Arab Emirates
    ------------------------------



  • 2.  RE: PART 2 Net PV

    Posted 09-02-2015 04:23 AM
    Description Year Cash flow Discount factor DCF
    Cost of asset 0 (450,000.00)                    1.000 (450,000.00)
    Installation 0    (25,000.00)                    1.000    (25,000.00)
    Tax benefit on installation 1        10,000.00                    0.893          8,928.57
    Tax benefit on Depreciation 1        45,000.00                    0.893        40,178.57
    Savings on labour cost net of tax 1    105,000.00                    0.893        93,750.00
    Tax benefit on Depreciation 2        68,400.00                    0.797        54,528.06
    Savings on labour cost net of tax 2    105,000.00                    0.797        83,705.36
    Tax benefit on Depreciation 3        66,600.00                    0.712        47,404.56
    Savings on labour cost net of tax 3    105,000.00                    0.712        74,736.93
    Net Present Value    (71,767.95)

    This is what I get.
    ------------------------------
    Lakshmy Varma
    Accountant
    Millennium Offshore Services
    Ajman
    United Arab Emirates
    ------------------------------




  • 3.  RE: PART 2 Net PV

    Posted 09-02-2015 04:24 AM
      |   view attached



    ------------------------------
    Lakshmy Varma
    Accountant
    Millennium Offshore Services
    Ajman
    United Arab Emirates
    ------------------------------


    Attachment(s)

    xlsx
    NPV.xlsx   10 KB 1 version


  • 4.  RE: PART 2 Net PV

    Posted 09-02-2015 04:48 AM

    Please find the solution

    Period

    Cash inflows

     

     

     Depreciation shield

     Labor cost

     Total inflow

     PV factor @12%

     Present value of cash inflow

    Year 1

                 47,500.00

        105,000.00

     152,500.00

                    0.893

                              136,182.50

    Year 2

                 72,200.00

        105,000.00

     177,200.00

                    0.797

                              141,228.40

    Year 3

                 70,300.00

        105,000.00

     175,300.00

                    0.712

                              124,813.60

     

     

     Present value of cash inflows

     

     

                              402,224.50

     Depreciation shield

     =475,000x depreciation ratex tax rate (i.e 40%)

     Labor cost

     =175,000 x {1- tax rate} (i.e 60%)

    NPV

    = Present value of cash inflows - Cash out flow at the begining

    = 402,224.5 - 475,000

    = (73,000) approx

    recommend not making the investment.

     

     

     






  • 5.  RE: PART 2 Net PV

    Posted 09-18-2015 11:30 AM
      |   view attached

    I understand that cost of Equipment invariably includes installation charges also. So in the given problem the cost of machinery is 450000 + 25000= 475000 taken for the purpose of caliculation of depreciation.  Plz guide me if  I am wrong in my conceptual understanding.

    Regards

    Balaji

    ------------------------------
    BALAJI TIPPARAJU
    Student
    GUNTUR
    India
    ------------------------------


    Attachment(s)

    docx
    CMA PROB-2.docx   14 KB 1 version


  • 6.  RE: PART 2 Net PV

    Posted 09-18-2015 12:28 PM
    Yes, you are right. There is another reply to the same post with correct workings.