Please solve yellow areas and provide formulas

For the PV values in eells D49,E49, F49, G49, use the Micresoft Excel functions. If yeu aeed help with the Excel function, See Appendix A or the Excel videos. Appendix A and the Excel videos show how to ase the FORMAT and FINANCIAL tabs in Excel to choose a multitude of Exed fuactions*t Should the company purchase the ship with either or both required rates of return? Explain. . The president is uncertain whether a 12 percent or a 16 percent required return is appropriate. Explain why, Focusing ot a 12 percent required rate of return, what would be the opportunity cost to the company of 1sing the ship in the Caribbean/Eastern Canada itinerary rather than a Caribbean/Alaska itinerary