The installation of a compressor is estimated to generate the following net cash flows. The effective date of the evaluation is July 1, 2014. The projections shown are based on a calendar year. Year Net CashFlow 1:( 6 mon) $10,000 2: $8,000 3: $6,000 4: $1,000 a. Using mid-period discounting find the present worth of the net cash flows as of July 1, 2014 at 14% compounded annually. Assume all cash flows (in or out) occur at the middle of the period. b. If your company has a time value of money of 14% (nominal annual compounded annually), should you recommend the compressor installation if it will cost $16,000.00 (on July 1, 2014)? c. Using end-period discounting what is your recommendation? Don't use AI. Only genuine answers are required with Excel formulas and understandable explanations.