Company LDC is contemplating on acquiring new machine replace the old one. Year 0 is when the new machine will be acquired and the old one disposed. This new machine will operate for 4 years. As the CPA-CMA (istikoy) of the company you are asked by the management for advise on whether to go on with the proposed acquisition. The data attached were given to you for your consideration. You must support your recommendations with appropriate calculations of the Initial Investment Cost (itemized), Present Value of Cash Flows (itemized yearly), Net Present Value, Internal Rate of Return, and Profitability Index. Your recommendation and supporting calculations must be in excel format. Other than the IRR, you are not allowed to use "EXCEL FUNCTION". You may use however excel functions to validate your answer. Caution: Do not forget the tax effect on the transactions.

Acquisition Cost Accumulated Dep'n Disposal Price - Old Machine at year 0 Remaining Life - years Sales Commission to agent for disposal of old machine Asset Removal Cost Tax Rate Revenue per annum Cash Opex per annum WC to recover at end of life Sales value net of commission at en of life (pretax) WC Commitment for new machine One-time employee training - year 1 pretax WACC Employee relocation cost at end of year 4 (pretax) Old Machine New Machine 320,000.00 480,000.00 192,000.00 80,000.00 100,000.00 4 4 10% 2,000.00 95,000.00 40% 40% 400,000.00 1,400,000.00 320,000.00 1,000,000.00 50,000.00 200,000.00 1,500.00 200,000.00 50,000.00 10% 150,000.00