"8. Trisha Metzger purchased Casa del Sol, an 85room fullservice hotel on the Pacific coast in Nicaragua, in 20x1. She then felt that 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 lowcost vacation benefits, Trisha's business is booming.Now as she begins fiscal year 20x5, she wants to secure a bank loan to double the size of her property, and she needs to project her sales forward for the next three years to meet the bank's loan submission requirements. Help Trisha predict her sales for each of the coming three fiscal years using trend line analysis. Casa del Sol Sales Data in Millions Fiscal Year Sales in Millions ($) FY 20x1 19.4 FY 20x2 91.4 FY 20x3 99.4 FY 20x4 95.3 FY 20x5 Forecasted FY 20x6 Forecasted FY 20x7 Forecasted Create a line graph of sales for the Casa del Sol for FY 20x1 through FY 20x4. Add a trend line (from 20x5 through 20x7) to Trisha's sales line graph. If you were a bank, would you likely give Trisha the loan? Why or why not? use Excel to insert a trend line and forecast the last 3 years sales in millions), "