What is the minimum percentage of tax paid when you prepared

Reference no: EM133504281

Question: 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:

Question 1: What is the largest EBITDA Percentage when you prepare the common size statement? State the formula that can be entered in cell D36.

Question 2: 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.

Question 3: 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: EM133504281

Questions Cloud

Cdc current outbreak list : Describe one or two calculations you learned in this course that helped you better understand the epidemic information.

Describe results of your emotional intelligence assessment : Describe the results of your Emotional Intelligence assessment. Choose one area to improve and describe your plan to develop it.

Develop risk management plan for preventing prescription : Develop a risk management plan for preventing prescription administration errors in your facility. Use a real life-example of such a case.

Develop a resume for a job in the health field : Develop a 1 to 2 pages resume for a job in the health field. The Walden University Skills-First platform can be a helpful resource in writing your resume.

What is the minimum percentage of tax paid when you prepared : What is the largest EBITDA Percentage when you prepare the common size statement? State the formula that can be entered in cell D36.

Health information and data science : Review the material related to health information and data science that was covered in the lecture for this module

Identify your program of bs public health : Identify your Program of, BS Public Health. Which two services offered by the Career Planning and Development center did you find most helpful? Why?

Culture and gender-related diagnostic issues : What is the prevalence rate, any culture and/or gender-related diagnostic issues, functional consequences, and comorbidity for this particular diagnosis?

Explain how revenue cycle influences the building : Explain how revenue cycle influences the building of the new hospital Discuss why increased outpatient services will be required to improve revenue

User Account

All Pages