Start Excel. Download and open the file named

Excel$\_$Ch$11\_$Prepare$\_$Financial$\_$Analysis$\_$PartB xdsx$.$ Grader has automatically added your last name to the start of the filename. Save the file to the location where you are storing your files.

In addition to analyzing possible expansion finance options from a bank, managers at the Turquoise Oasis Spa would like to analyze some possible investment opportunities to help finance the expansion and generate revenue in the long term.

On the PresentAndFutureValue worksheet, in cell B$8,$ calculate the Coupon Payment $($annually$)$ of the investment from the bank's perspective.

The first step in determining whether or not this is a worthy investment is to calculate the present value of the investment.

In cell B$10,$ calculate the present value of the investment from the bank's perspective.

Turquoise Oasis Spa managers are considering investing money that would be provided by private investors. This would require them to wait for five years to allow the investment to grow. Payments and interest will be calculated quarterty. In this exercise, you will use the FV function to help the managers make their decision. For determining cash flows, the calculations will be from the bank's perspective.