Assume that it is at the end of 2016. You are given the income statement and balance sheet for 2016 as well as projected ones for 2017 and 2018.
Question 1: Find: EBIT in 2017
Question 2: EBIT in 2018
Question 3: EBT in 2017
Question 4: EBT in 2018
Question 5: Income tax in 2017
Please help with the above problems and show all work by hand step by step. No excel usage please.
Homework Answers
Assuming interest income is not part of operating income.
Q1). For 2017,
EBITDA = Sales - COGS - SG&A expenses = 6040-5051-435 = 554
EBIT = EBITDA - Depreciation = 554-74 = 480
Q2). For 2018,
EBITDA = Sales - COGS - SG&A expenses = 6530-5366-485 = 679
EBIT = EBITDA - Depreciation = 679-69 = 610
Q3). EBT for year 2017
EBT = EBIT + interest income - interest expenses = 480 +2-42 = 440
Q4). EBT for year 2018
EBT = EBIT + interest income - interest expenses = 610 +3 - 53 = 560
Q5). Income tax in year 2017
Net income in 2017 = 264
EBT in 2017 = 440
So Tax in 2017 = EBT - NI = 440 - 264 = 176
So, income tax in 2017 = 176
Add Answer to:
Assume that it is at the end of 2016. You are given the income
statement and...
This is due tomorrow morning at 8 am central time. please help! This problem set ses...
This is due tomorrow morning at 8 am central time. please help!
This problem set ses a bit long (35 questions) but in fact it is very simple! . The first 30 questions will help you understand how you extract Free Cash Flows (FCFS) from financial statements. These questions are not multiple choice questions - you should enter your answers directly • The last 5 questions will ask you to finish the DCF analysis based on the FCFs obtained. These...
Hello, can you help with "generating a common size income statement for 2018" please! Income Statement...
Hello, can you help with "generating a common size
income statement for 2018" please!
Income Statement 2018 (C$ in millions) Balance Sheet (C$ in millions) 2018 Cash 900.6 Short-term investments 96.1 Accounts receivable 5,790.5 Inventory 1,905.1 Total Current Assets 8,692.3 Net Fixed Assets 6,295.5 Total Assets 14,987.8 2017 662.1 289.1 5,785.7 1,773.3 6,043.0 14,553.2 Revenue COGS S&A Expense Depreciation EBIT Interest EBT Taxes Net Income 12,279.6 8,144.3 2,625.4 415.8 1,094.1 92.8 1,001.3 265.4 735.9 Accounts payable Notes payable Total Current...
Use the following data to answer questions below. INCOME STATEMENT: TONY'S PIZZA EATERY 2016 2016 REVENUES $&nb...
Use the following data to answer questions below. INCOME STATEMENT: TONY'S PIZZA EATERY 2016 2016 REVENUES $ 275,789 COST OF GOODS SOLD $ 103,115 GROSS PROFIT $ 172,674 DEPRECIATION $ 31,100 SELLING, GENERAL, AND ADMINISTRATIVE EXPENSES $ 77,444 OPERATING INCOME (EBIT) $ 64,130 INTEREST EXPENSE $ 6,000 TAXABLE INCOME (EBT) $ 58,130 TAXES (SEE TAX TABLE) $ 8,720 NET INCOME $ 49,411 BALANCE SHEET: TONY'S PIZZA EATERY END OF 2016 2016 CURRENT ASSETS CASH $ 8,247 ACCOUNTS RECEIVABLE $ 1,236...
Balance Sheet 2017 2017 40,601 584 480 Income Statement 2016 Net sales 28.400 Cost of good...
Balance Sheet 2017 2017 40,601 584 480 Income Statement 2016 Net sales 28.400 Cost of good sold 31,872 Depreciation EBIT 3,072 Interest 163 expense Tax (204) 582 Net Income 2.327 34,710 2.655 427 2.236 138 6.269 7,760 420 1,678 Assets 2016 Cash and securities AD Accounts receivable 480 Inventories 400 Total current 1,520 assets Net fixed assets 6,480 Total assets 8,000 Llabilities and Owners' Equity Accounts payable 1,120 Short-term notes 640 Total current labilities 1,760 Long term debt Common stock...
Prepare common-size statements in the framework provided? 2014 Coca-Cola 2015 2016 2017 2018 2014 Pepsi 2015...
Prepare common-size statements in the framework provided?
2014 Coca-Cola 2015 2016 2017 2018 2014 Pepsi 2015 2016 2017 2018 45.9 44.5 42.0 32.1 66.71 11.8 179 30.9 63.5 28.8 28.2 64.7 29.4 33.3 Sales Cost of Revenue Gross Profit Operating Expenses Operating Profit Non-operating income 100 25.2 10.1 EBIT Interest solo EBT Taxes Net Income 4.9 | 2015 2016 2017 2018 2014 2015 2016 2017 2018 ASSETS 20 16.0 16.1 3 6.7 70 7.1 2.7 3.1 1.56 8.7 L 12.0...
Calculate values and analyse in Yellow INCOME STATEMENT % Change Discovery Manufacturing 2017 to 2018 LINE...
Calculate values and analyse in Yellow
INCOME STATEMENT
% Change Discovery Manufacturing 2017 to 2018
LINE BY LINE ANALYSIS
COMPARED TO
DISCOVERY'S % CHANGE IN SALES
BETTER, SAME AS, WORSE
than Discovery's % Change in Sales
Total sales
Cost of goods sold
Better
Administrative expense
Better
EBITDA
EBIT
Interest expense
EBT
Net income
Dividends
Additions to Retained Earnings
BALANCE SHEET
% Change Discovery Manufacturing 2017 to 2018
LINE BY LINE ANALYSIS
COMPARED TO
DISCOVERY'S % CHANGE IN SALES
BETTER, SAME...
Refer to the statement. Compute ROE for both 2017 and 2016. Use DuPont Analysis to check...
Refer to the statement. Compute ROE for both 2017 and 2016. Use
DuPont Analysis to check for the problem of lower ROE year.
Balance Sheet: 12/31/17 Assets 2016 2017 1040 Cash and Marketable Securities 130 4095 4875 Accounts Receivable 5395 7995 Inventories 10530 13000 Total Current Assets 13000 11310 Net plant and equipment 21840 26000 TOTAL ASSETS 2016 2017 Liabilities and Equity Accounts Payable Notes Payable Accruals 520 780 780 1820 1690 1430 2990 4030 Total Current Liabilities 7540 9802...
Suppose you are given the following financial statement information for 2015 and 2016. Calculate the total...
Suppose you are given the following financial statement information for 2015 and 2016. Calculate the total cash flows from operations as it would appear on the Accounting Statement of Cash Flows for 2016. (Enter a whole number). Income Statement (2016) Balance Sheet Sales $9,352 2015 2016 Cost of goods sold $3.612 $2.856 Cash $2,450 Other Expenses Accounts Receivable $95 $1,690 $1,780 Depreciation $3,460 $1,250 Inventory $3,570 $4.395 Current Assets $7,710 EBIT $8,096 $45 Net Fixed Assets $4,289 $4,319 Interest EBT...
8) The latest balance sheet and income statement for Coleco Corporation are below: 2016 2017 Assets...
8) The latest balance sheet and income statement for Coleco Corporation are below: 2016 2017 Assets Cash and equivalents 57,600 7.282 Accounts receivable 351,200 632,160 Inventories 715,200 1.287,360 Total current assets 1,124,000 1,926,802 Net fixed assets 344.800 939,790 Total Assets 1,467.800 2.866.592 - Liabilities and Equity Accounts payable Accruals Notes Payable Total current liabilities Long-term bonds Common Equity: Common stock (100,000 shares) Retained earnings Total common equity Total liabilities & equity 145,600 136,000 200.000 481,600 323,432 524,160 489,600 636,808 1,650,568...
ALX Corp. has the following financial statements for years 2018 and 2017: $m $m Income statement...
ALX Corp. has the following financial statements for years 2018 and 2017: $m $m Income statement 2018 2017 Revenue $ 1,500 $ 1,300 EBITDA $ 160 $ 150 Dep. & Amor $ 30 $ 25 EBIT $ 130 $ 125 Net Income $ 21 $ 20 EBT $ 109 $ 105 Taxes (35%) Net Income Balance Sheet 2018 2017 Current Assets $ 340 $ 250 Net Plant & Equip. $ 370 $ 340 Total Assets $ 710 $ 690 Current...
This is due tomorrow morning at 8 am central time. please help!
This problem set ses a bit long (35 questions) but in fact it is very simple! . The first 30 questions will help you understand how you extract Free Cash Flows (FCFS) from financial statements. These questions are not multiple choice questions - you should enter your answers directly • The last 5 questions will ask you to finish the DCF analysis based on the FCFs obtained. These...
Hello, can you help with "generating a common size
income statement for 2018" please!
Income Statement 2018 (C$ in millions) Balance Sheet (C$ in millions) 2018 Cash 900.6 Short-term investments 96.1 Accounts receivable 5,790.5 Inventory 1,905.1 Total Current Assets 8,692.3 Net Fixed Assets 6,295.5 Total Assets 14,987.8 2017 662.1 289.1 5,785.7 1,773.3 6,043.0 14,553.2 Revenue COGS S&A Expense Depreciation EBIT Interest EBT Taxes Net Income 12,279.6 8,144.3 2,625.4 415.8 1,094.1 92.8 1,001.3 265.4 735.9 Accounts payable Notes payable Total Current...
Balance Sheet 2017 2017 40,601 584 480 Income Statement 2016 Net sales 28.400 Cost of good sold 31,872 Depreciation EBIT 3,072 Interest 163 expense Tax (204) 582 Net Income 2.327 34,710 2.655 427 2.236 138 6.269 7,760 420 1,678 Assets 2016 Cash and securities AD Accounts receivable 480 Inventories 400 Total current 1,520 assets Net fixed assets 6,480 Total assets 8,000 Llabilities and Owners' Equity Accounts payable 1,120 Short-term notes 640 Total current labilities 1,760 Long term debt Common stock...
Prepare common-size statements in the framework provided?
2014 Coca-Cola 2015 2016 2017 2018 2014 Pepsi 2015 2016 2017 2018 45.9 44.5 42.0 32.1 66.71 11.8 179 30.9 63.5 28.8 28.2 64.7 29.4 33.3 Sales Cost of Revenue Gross Profit Operating Expenses Operating Profit Non-operating income 100 25.2 10.1 EBIT Interest solo EBT Taxes Net Income 4.9 | 2015 2016 2017 2018 2014 2015 2016 2017 2018 ASSETS 20 16.0 16.1 3 6.7 70 7.1 2.7 3.1 1.56 8.7 L 12.0...
Calculate values and analyse in Yellow
INCOME STATEMENT
% Change Discovery Manufacturing 2017 to 2018
LINE BY LINE ANALYSIS
COMPARED TO
DISCOVERY'S % CHANGE IN SALES
BETTER, SAME AS, WORSE
than Discovery's % Change in Sales
Total sales
Cost of goods sold
Better
Administrative expense
Better
EBITDA
EBIT
Interest expense
EBT
Net income
Dividends
Additions to Retained Earnings
BALANCE SHEET
% Change Discovery Manufacturing 2017 to 2018
LINE BY LINE ANALYSIS
COMPARED TO
DISCOVERY'S % CHANGE IN SALES
BETTER, SAME...
Refer to the statement. Compute ROE for both 2017 and 2016. Use
DuPont Analysis to check for the problem of lower ROE year.
Balance Sheet: 12/31/17 Assets 2016 2017 1040 Cash and Marketable Securities 130 4095 4875 Accounts Receivable 5395 7995 Inventories 10530 13000 Total Current Assets 13000 11310 Net plant and equipment 21840 26000 TOTAL ASSETS 2016 2017 Liabilities and Equity Accounts Payable Notes Payable Accruals 520 780 780 1820 1690 1430 2990 4030 Total Current Liabilities 7540 9802...
Suppose you are given the following financial statement information for 2015 and 2016. Calculate the total cash flows from operations as it would appear on the Accounting Statement of Cash Flows for 2016. (Enter a whole number). Income Statement (2016) Balance Sheet Sales $9,352 2015 2016 Cost of goods sold $3.612 $2.856 Cash $2,450 Other Expenses Accounts Receivable $95 $1,690 $1,780 Depreciation $3,460 $1,250 Inventory $3,570 $4.395 Current Assets $7,710 EBIT $8,096 $45 Net Fixed Assets $4,289 $4,319 Interest EBT...
8) The latest balance sheet and income statement for Coleco Corporation are below: 2016 2017 Assets Cash and equivalents 57,600 7.282 Accounts receivable 351,200 632,160 Inventories 715,200 1.287,360 Total current assets 1,124,000 1,926,802 Net fixed assets 344.800 939,790 Total Assets 1,467.800 2.866.592 - Liabilities and Equity Accounts payable Accruals Notes Payable Total current liabilities Long-term bonds Common Equity: Common stock (100,000 shares) Retained earnings Total common equity Total liabilities & equity 145,600 136,000 200.000 481,600 323,432 524,160 489,600 636,808 1,650,568...
Most questions answered within 3 hours.
-
Please answer the four questions below.
1. If you were going to test a method that...
asked 8 minutes ago -
Provide two or three examples of support he uses to reinforce
his arguments?
The Alienation of...
asked 16 minutes ago -
QUESTION 1
Why do we see terms with multiple names in the database
community?
Consistency is...
asked 11 minutes ago -
In a titration experiment, 11.5 mL of 0.400 M H2SO4 neutralized
48.0 mL of NaOH. What...
asked 15 minutes ago -
A shot-putter throws the shot with a horizontal velocity of 10
m/s and a
vertical velocity...
asked 31 minutes ago -
Mildred sells industrial-sized refrigeration units. Her
prospective buyer's face looks tense, and his forehead is wrinkled....
asked 32 minutes ago -
Clark Heter is an industrial engineer at Lyons Products. He
would like to determine whether there...
asked 1 hour ago -
3. Use a text editor to create a comma-delimited file of user
IDs and passwords. Revise...
asked 1 hour ago -
Jensen and Associates has a projected balance
sheet that includes the following accounts. What is the...
asked 48 minutes ago -
implement a doubly-linked list in C. Each node in the linked list should contain a string,...
asked 1 hour ago -
What are some best practices and things to avoid when developing
a PowerPoint presentation or file
asked 1 hour ago -
Consider the ways that the government can get involved in
economic issues. What role do you...
asked 49 minutes ago