Problem:
CT Computers is considering whether or not to begin offering customers the option to have their old personal computers recycled when they purchase a recycling system. The recycling system would require that CT invest $600,000 to purchase grinders and magnets to use in recycling process. The company estimates that for each system it recycles, it would generate $1.50 in incremental revenues from the sale of scrap metal and plastics. The machinery has five year useful life and will be depreciated straight line toward a zero salvage value. CT be believes that in Year 1 it will recycle 100,000 personal computers and that returns will grow by 25% each year over the next five years. The company uses a 15% discount rate to analyze its capital expenditures and faces a 30% tax rate.
Q1. What are the project free cash flows (PFCFs) for this project?
Q2. Using NPV and IRR, should CT invest in this project?
Q3. Judy Dunbar, the manager for the project is worried that CT will only have returns of 75,000 units in Year 1. If she's right, and assuming a growth rate of 25%, should CT still consider investing in the project?
Please use the attached spreadsheet to solve this problem.
Attachment:- Purchase a recycling system.rar