Determine interest expense

Reference no: EM1359284

Assistance with the following problems in excel with explanations of how the answer was derived please.

1. Little Books Inc. recently reported $3 million dollars of net income. Its EBIT was $6 million dollars, and its tax rate was %40. What was its interest expense? [Hint: write out the heading from the income statement and then fill in the known values. then divide $3 million dollars net income by (1-T)=0.6 to find the pre-tax income. The difference between EBIT and taxable income must be in the interest expense.]

2. Kendall Corners Inc. recently reported and EBITDA of 3.1 million dollars and depreciation of $500,000. What is its net cash flow? Assume it had no amortization expense.

3. The Tally Corporation had a taxable income of $365,000 from operations after all operating costs but before (1) interest changes of $50,000, (2) dividends received of $15,000 (3) dividends paid of $25,000 and (4) income taxes. What are the firms income tax liability and its after tax income? What are the company's marginal and average tax rates on taxable income?

4. The Went Corporation had $10.5 million of taxable income.
a. What is the firm's federal income tax bill for the year?
b.Assume the firm receives an additional $1 million of interest income from some bonds it owns. What is the tax on this interest income?
c. Now assume that Went does not receive the interest income but does receive an additional $1 million as dividends on some stock it owns. What is the tax on this dividend income?

5. the Moore's Corporation has an EBIT of $750,000. The company's depreciation expense is $200,000. Moore is 100% equity financed, and it faces a 40% tax rate. What is the company's net income? What is the company's net cash flow?

Reference no: EM1359284

Questions Cloud

What is the spring constant of the bungee cord : What is the spring constant (k) of the bungee cord.At what time will the object be moving with a speed of 15 m/s.

Cultures on substance abuse and addiction : Provide a comparison (similarities and differences) of the impact of two different cultures on substance abuse and/or addiction.

Find the current cost of valve : Rex manufacturing produces a line of equipment with a European servo value that cost $100 when the Euro was 83 cents. Now that the Euro is $1.59 cents the component is a problem.

Design two level and-or and not circuit : Design a two level AND , OR ,NOT circuit for the following I/O priority circuit,when the ack input is true ack will be made true for the smallest j for which req is true.

Determine interest expense : Little Books Corporation recently reported $3 million dollars of net income. Its EBIT was 6 million dollars, and its tax rate was 40 percent. Determine its interest expense?

Describe a hypothetical example : Create and describe a hypothetical example that specifically illustrates how biology, family, and culture may contribute to and/or impact substance abuse and/or addiction.

Process by which ip addresses are assigned to computers : How would you control the process by which IP addresses are assigned to individual computers? You will have to make some assumptions to answer both questions, so be sure to state your assumptions."

How much work was done by the lift on the automobile : How much work was done by the lift on the automobile.

Explain government interaction has a major impact : Explain Government interaction has a major impact on businesses and personal lives. Identify two government policies that influence our business environment

User Account

All Pages