A new project is expected to generate cash flows of $16,524 per year for 6 years. Your firms required return on this type of project is 7%. What is the maximum amount this company should pay to invest in this project (i.e., what is the present value of the cash flows)? Assume cash flows occur evenly throughout each year (use the mid-year approximation).

Please do all the calculatons in excel and explain the mid-year approximation.