Exhibit 11.11
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using seasonal indices. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. 
-Refer to Exhibit 11.11. What formula should be entered in cell G3 to compute the "Actual as a % of Trend" value for year 1 Quarter 1?
Definitions:
After-Tax Cost of Debt
The net cost to a company for borrowing funds after accounting for the tax benefit derived from interest expense deductions on its corporate income tax.
Coupon Rate
The interest rate that a bond issuer will pay to the bondholder on the face value of the bond.
Market Price
The live market price at which an asset or service can be bought or sold.
Q9: The error sum of squares term is
Q15: Refer to Exhibit 10.1.What number of observations
Q22: MINIMAX solutions to multi-objective linear programming MOLP)problems
Q27: Refer to Exhibit 15.5.If the following project
Q31: Refer to Exhibit 15.6.Is it necessary to
Q39: An investor has $500,000 to invest
Q52: The M/D/1 model with infinite capacity queue
Q56: The decision rule which determines the maximum
Q70: Refer to Exhibit 14.6.What formula should go
Q72: Refer to Exhibit 10.1.Suppose that for a