Trisha Hanes purchased Casa del Sol, an 85-room full-service hotel on the Pacific coast in Nicaragua, in 2006. She felt then she was ahead of her time when she made the purchase and now she is convinced of it. As more tourists discover the San Juan Del Sur area and its low-cost vacation benefits, Trisha’s business is booming.

Now as she begins 2010, she wants to secure a bank loan to double the size of her property, and she needs to project her sales forward for three years to meet the bank’s loan submission requirements. Help her predict her sales for each of the coming three years using trend line analysis.

Casa del Sol Sales Data in Millions Sales in Fiscal Year Millions FY 2007 $18.4 FY 2008 91.4 FY 2009 22.4 FY 2010* 2513 RYe20n4 forecasted Re2o12 forecasted FY 2013 forecasted

* Estimate

a. Create a line graph of sales for the Casa del Sol for FY 2007 through FY 2010.

b. Add a trend line (through 2013) to Trisha’s sales line graph.

c. If you were a bank, would you give Trisha the loan? Why or why not?