Using the data in the student spreadsheet file ethan allen financials. xlsx (to find the student spreadsheets for financial analysis with microsoft excel, eighth edition, go to ) forecast the june 30, 2017 income statement and balance sheet for ethan allen. use the percent of sales method and the following assumptions: (1) sales in fy 2017 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share.