Exploring Microsoft Office Excel $2016$

Stacy$$s Travel Agency

You are an agent at a local travel agency, Stacy$$s Travel Agency. You are required to track all of the winter holiday specials that you sell. Customers can purchase a package with or without airfare. You are required to collect a down payment based on $20\%$ of the cost of the package. Most of your customers choose to pay for their vacations on a monthly payment plan for one year, which you calculate based on a standard interest rate. In addition, you need to calculate general statistics to summarize for your supervisor. Spot$-$check results to make sure you created formulas and functions correctly.