Using the data in the student spreadsheet file Ethan Allen financial.xlsx $,$ forecast the June $30,2019$ income statements and balance sheet for Ethan Allen. Use the percent of sales method and the following assumptions: $(1)$ sales in FY $2019$ will be $$716\mathrm{.}20$; $(2)$ The tax rate will be $25\%$; $(3)$ Each item that changes with sales will be the five$-$year average percentage of sales; $(4)$ Property, Plant & Equipment $-$ Gross will increase to $$675$; and $(5)$ The dividend will be $$0\mathrm{.}99$ per share. Use your judgment on all other items

Ethan Allen Interiors Inc.

Income Statement $($Industrial$)$

All figures in millions of U$.$S$.$ Dollar, except per share items

Source : FactSet Fundamentals

please put in excel format.

Here are some tips on the assignment.$$

#$1($a$)$ Default projected value for $2019$ for each of the items in the income statement and balance sheet should be the Last Year's value, unless the item changes with Sales.$$ I've covered all the items that change with sales in the lecture$$ so other items that I have not talked about, you can assume it will stay the same as last year.

Total Share holder's equity is calculated as sum of Common Stock Par$/$Carry Value, Additional Paid$-$In Capital$/$Capital Surplus, Retained Earnings minus$$Treasury Stock and Other Deductions from Equity

$($b$)$ Please manually add DFN to the long term debt $($add actual numbers, not reference the DFN$)$ until DFN converges to Zero. You don't need to use the iterative worksheet.$$

$($e$)$ To run the scenario analysis for DFN when sales number changes, you need to run the scenario analysis on the pro$-$forma income statement tab, because you will be changing the sales numbers.$$ But DFN is in the pro$-$forma balance sheet tab, so to access DFN in the scenario analysis you need to create a cell in PF income statement that references the DFN in PF balance sheet, and use it as the result cell in the scenario analysis.