Two new production scheduling information systems for Ferro Corporation could be developed at a cost of $115,000 and $145,000 respectively. Interest rate is 7%. The estimated cost and income over five years of operation would be: Project A Year Estimated Income Estimated Costs $ 115,000 $ 3,500 $ 4,700 $ 5,500 $ 6,300 $ 7,000 $26,000 $33,000 $41,000 $55,000 $66,000 5 Project B Year Estimated Income Estimated Costs $ 145,000 $ 3,700 $ 4,500 $ 5,800 $ 6,600 $ 7,100 $21,200 $33,100 $35,600 $44,000 $62,000 For Both projects, calculate: 1. Cash flow streams (CF). 2. Cumulative Cash flow streams (CCF) 3. Discounted cash flow streams (DCF) 4. Cumulative Discounted cash flow streams (CDCF) 5. Payback period (PBP) based on Cumulative Cash flow streams (CCF) 6. Payback period (PBP) based on Cumulative Discounted cash flow streams (CDCF) 7. Net present value (NPV) 8. Internal rate of return (IRR). Which project do you recommend for development? Support your recommendation. Please use the provided Excel template for this assignment. 8:57 chegg.com POP C CT) Pedro