please do the question by Exel and show how you go through it. thanks.

Cashflow: Use Excel to analyze the following cash flows from investments A, B, and C: A. Receive $60,000 today and once again receive $60,000 six years from now B. Receive $12,000 today and again every year for 12 years C. Next year pay $30,000; and then again pay $30,000 each year for three more years, then receive $25,000 a year every year for 50 years. Determine the NPV of each and rank the investments (in terms of their NPV) assuming a discount rate of 9%. Determine the NPC of each and rank investments (in terms of their NPV) assuming a discount rate of 10%