Vol 7.80 LTE KB/s 59 47:18 0 expert.chegg.com [1] Show me the steps to solve everything in yellow in the attached image with the excel formulas. Given TUM Petroleum Cost of Goods Sold Gross Pr Dec-14 Dec-15 $12.211.00 $13.368.00 (9,75600) (10,591.00) 245600 2.777.00 Selling General & Administrative Expen Operating Income Before Deprec 1704.00) 1698.00) 2.079.00 Depreciation, Depletion, & Amorázation Cowrating Pront Test Expense Non-Operating income Expense Special em $500 128) 139.00 2000 1200 1200 151.00 Prefa Income 1,064.00 Total Income Tax (34080) 142560) Net Income S205 40 Purchase of PP&E CAPEX) 815 1.322 Increase in Not Working Capital 102 14:30) TCMɛ rate Solution a. FCF Calculators for 2014-20 2014 2015 EBIT (Operating Prof EBITIT NOPAT LE CAPEX Plus Depreciation Exper Lase: Working Capital Investment Firm Free Cash Flow b. Estimated FCF for 2016-2020 EBIT (Growing 100% per year) EBIT-40-NOPAT Plus Depreciation Expense L CAPEX Less: Working Capital Im Firm Free Cash Flow Solution Legend ·Value given in problem FormulaCalculation/Analysis required Qualitative analysis or Short answer required Goal Seek or Solver cell Crystal Ball Input Crystal Ball Output Year 2016 2017 2019 Show all images (]
Vol 7.80 LTE KB/s 59 47:18 0 expert.chegg.com [1] Show me the steps to solve everything in yellow in the attached image with the excel formulas. Given TUM Petroleum Cost of Goods Sold Gross Pr Dec-14 Dec-15 $12.211.00 $13.368.00 (9,75600) (10,591.00) 245600 2.777.00 Selling General & Administrative Expen Operating Income Before Deprec 1704.00) 1698.00) 2.079.00 Depreciation, Depletion, & Amorázation Cowrating Pront Test Expense Non-Operating income Expense Special em $500 128) 139.00 2000 1200 1200 151.00 Prefa Income 1,064.00 Total Income Tax (34080) 142560) Net Income S205 40 Purchase of PP&E CAPEX) 815 1.322 Increase in Not Working Capital 102 14:30) TCMɛ rate Solution a. FCF Calculators for 2014-20 2014 2015 EBIT (Operating Prof EBITIT NOPAT LE CAPEX Plus Depreciation Exper Lase: Working Capital Investment Firm Free Cash Flow b. Estimated FCF for 2016-2020 EBIT (Growing 100% per year) EBIT-40-NOPAT Plus Depreciation Expense L CAPEX Less: Working Capital Im Firm Free Cash Flow Solution Legend ·Value given in problem FormulaCalculation/Analysis required Qualitative analysis or Short answer required Goal Seek or Solver cell Crystal Ball Input Crystal Ball Output Year 2016 2017 2019 Show all images (]
Chemistry
10th Edition
ISBN:9781305957404
Author:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Chapter1: Chemical Foundations
Section: Chapter Questions
Problem 1RQ: Define and explain the differences between the following terms. a. law and theory b. theory and...
Related questions
Question
![Vol 7.80
LTE KB/s
59
47:18
0
expert.chegg.com
[1]
Show me the steps to solve everything in yellow in the
attached image with the excel formulas.
Given
TUM Petroleum
Cost of Goods Sold
Gross Pr
Dec-14
Dec-15
$12.211.00 $13.368.00
(9,75600) (10,591.00)
245600
2.777.00
Selling General & Administrative Expen
Operating Income Before Deprec
1704.00)
1698.00)
2.079.00
Depreciation, Depletion, & Amorázation
Cowrating Pront
Test Expense
Non-Operating income Expense
Special em
$500
128)
139.00
2000
1200
1200
151.00
Prefa Income
1,064.00
Total Income Tax
(34080)
142560)
Net Income
S205
40
Purchase of PP&E CAPEX)
815
1.322
Increase in Not Working Capital
102
14:30)
TCMɛ rate
Solution
a. FCF Calculators for 2014-20
2014
2015
EBIT (Operating Prof
EBITIT NOPAT
LE CAPEX
Plus Depreciation Exper
Lase: Working Capital Investment
Firm Free Cash Flow
b. Estimated FCF for 2016-2020
EBIT (Growing 100% per year)
EBIT-40-NOPAT
Plus Depreciation Expense
L CAPEX
Less: Working Capital Im
Firm Free Cash Flow
Solution Legend
·Value given in problem
FormulaCalculation/Analysis required
Qualitative analysis or Short answer required
Goal Seek or Solver cell
Crystal Ball Input
Crystal Ball Output
Year
2016
2017
2019
Show all images
(]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe49dfe54-e225-42a4-89f2-fd24287fe8a3%2Fbf99b822-23a6-466b-a9c8-3b8e57974645%2F2f1lgn_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Vol 7.80
LTE KB/s
59
47:18
0
expert.chegg.com
[1]
Show me the steps to solve everything in yellow in the
attached image with the excel formulas.
Given
TUM Petroleum
Cost of Goods Sold
Gross Pr
Dec-14
Dec-15
$12.211.00 $13.368.00
(9,75600) (10,591.00)
245600
2.777.00
Selling General & Administrative Expen
Operating Income Before Deprec
1704.00)
1698.00)
2.079.00
Depreciation, Depletion, & Amorázation
Cowrating Pront
Test Expense
Non-Operating income Expense
Special em
$500
128)
139.00
2000
1200
1200
151.00
Prefa Income
1,064.00
Total Income Tax
(34080)
142560)
Net Income
S205
40
Purchase of PP&E CAPEX)
815
1.322
Increase in Not Working Capital
102
14:30)
TCMɛ rate
Solution
a. FCF Calculators for 2014-20
2014
2015
EBIT (Operating Prof
EBITIT NOPAT
LE CAPEX
Plus Depreciation Exper
Lase: Working Capital Investment
Firm Free Cash Flow
b. Estimated FCF for 2016-2020
EBIT (Growing 100% per year)
EBIT-40-NOPAT
Plus Depreciation Expense
L CAPEX
Less: Working Capital Im
Firm Free Cash Flow
Solution Legend
·Value given in problem
FormulaCalculation/Analysis required
Qualitative analysis or Short answer required
Goal Seek or Solver cell
Crystal Ball Input
Crystal Ball Output
Year
2016
2017
2019
Show all images
(]
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education
Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning
Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY