ABC Ltd. is in the toy manufacturing business. The firm plans to develop a new toy. The firm may purchase or lease the necessary machinery. The machine can be purchased for Rs. 60,000,000. It is expected to have a useful life of 5 years with a salvage value of Rs. 4,00,000 and straight-line depreciation at the end of 5 years. Alternatively, the machine can be bought on year-end rental leases of Rs. 18,000,000 for 5 years.

 Advise the company on the option it should choose. subsequent derailments
1. The tax rate is 35 percent and the cost of capital is 20 percent.
2. Rental fees paid at the end of the year.
3. Maintenance expenses Rs. 1.20,000 per year to be borne by the tenant.

Please provide excel with formula

Answer rating: 100% (QA)

Here is an Excel table that calculates the present value of cash flows for both options and compares ... View the full answer