What is the second largest ebt percentage

Assignment Help Accounting Basics

Reference no: EM133500715

Case: The following income statement data is given to you for 2016 and 2017:

Income Statement	2016	2017
Revenue	150000	165000
COGS	67500	74250
Gross Profit	82500	90750
SG&A	16500	18150
EBITDA	66000	72600
Depreciation	6600	7260
Interest	1000	1000
EBT	58400	64340
Taxes	17520	19302
Net Income	40880	45038

Before answering the questions of this exam, you must fill in the first two years of the Excel template. There are some assumptions will be considered:

Every year, revenue will grow by 10%
COGS will be 45 percent of the revenue.
SG&A expenses will be $20,000 for all the years except 2016 and 2017.
Depreciation will be 5% of revenue for all the years except for 2016 and 2017.
interest will be $1,000 throughout the years.
The tax rate will be 30% throughout the years.

For ease of usage and understanding, the assumptions section is prefilled so you can see how it can be filled. Before answering the questions, you must fill in the remaining years and common size balance sheet and answer the questions marked with "?".

On the next page, you can see how you can set up the Excel template.

The following questions should be answered:

What is the largest EBITDA Percentage when you prepare the common size statement? State the formula that can be entered in cell D36.
What is the minimum percentage of Tax paid when you prepared the common size statement? State the formula that can be entered in cell D37.
Using the common-size income statement, what is the average net income percentage? State the formula that can be entered in the cell at D38.
What is the Second Largest EBT percentage using the common size income statement? State the formula that can be entered in cell D39.

Reference no: EM133500715

Questions Cloud

Prepare a worksheet to consolidate the financial information : Prepare a worksheet to consolidate the financial information for these two companies.

List all debit entries before credit : If no entry is required, select No Entry" for the account titles and enter for the amounts. List all debit entries before credit

??why would a high current ratio indicate that the company : What questions would you want answered in considering the credit worthiness of this small business? ??Why would a high current ratio indicate that the company

What impact would it have if taxable interest : What impact would it have if taxable interest was only $12,000 and there was no NOL carryover

What is the second largest ebt percentage : What is the Second Largest EBT percentage using the common size income statement? State the formula that can be entered in cell D39

Advantages and disadvantages of social media : In the Accounting Information System world, what are the advantages and disadvantages of Social media and its effect on individual life as well as businesses

How to convert parents beginning retained earnings : How to convert parents beginning retained earnings to full accrual basis? to get the retained earnings 1/1/15 on the credit side

What are the four audit evidence decisions : What are the four audit evidence decisions. Explain what the four audit evidence decisions are. Later explain each audit.

How much personal assets can partner b contribute : How much personal assets can Partner B contribute toward settling her deficit and How much does Partner C absorb from the remaining deficit of Partner B

User Account

All Pages