Assume that the dfn will be absorbed by long-term debt

Assignment Help Financial Management

Reference no: EM132004127

Using the data in the student spreadsheet file Ethan Allen Financials.xlsx 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. Use your judgment on all other items.

a. What is the discretionary financing needed in 2017? Is this a surplus or deficit?

b. Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.

Reference no: EM132004127

Questions Cloud

Determine the amount of goodwill : Determine the amount of goodwill, if any, P Corporation should record upon its acquisition of S Company's assets

Dividends are anticipated to maintain growth rate : The dividends are anticipated to maintain a growth rate of 4.34 percent forever. If the stock currently sells for $94.06 per share, what is the required return?

Research by finding websites and articles : Find a company that is currently using Restorative Practices. Research by finding websites and articles to gather information and discuss what you find.

Nations during the high middle ages : Which countries were most successful in consolidating as nations during the high middle ages?

Assume that the dfn will be absorbed by long-term debt : Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.

Is twitter a good or bad form of social media : Is Twitter a good or bad form of social media? How does it compare to Facebook? What is your personal experience that happened with Twitter that was bad?

What amount of income would have been included : For the subsidiary that was not consolidated, what amount of income would have been included if this subsidiary had been consolidated

What is current share price : Metallica Bearings, Inc., is a young start-up company. If the required return on this stock is 8.38 percent, what is the current share price?

Duke of normandy have the right to be the king of england : Based on the references does the Duke of Normandy have the right to be the King of England?

User Account

All Pages