How do I calculate the Investment in Net Profit Operating Capital? I need an example of...
How do I calculate the Investment in Net Profit Operating Capital? I need an example of how to do it. I am stuck on this area of my excel worksheet for Chapter 12 11P. I am working on the following worksheet and I cannot figure out how to get the answer to for the Investment in total net operating capital.
| Actual | Projected | Projected | Projected | Projected | |
| Calculation of FCF | 12/31/2016 | 12/31/17 | 12/31/18 | 12/31/19 | 12/31/20 |
| Operating current assets | $248.00 | $285.20 | $313.72 | $332.5 | $352.50 |
| Operating current liabilities | $56.0 | $64.40 | $70.84 | $75.1 | $79.60 |
| Net operating working capital | $192.0 | $220.8 | $242.9 | $257.5 | $272.9 |
| Net PPE | $600.0 | $690.0 | $759.0 | $804.5 | $852.8 |
| Total net operating capital | $792.0 | $910.8 | $1,001.9 | $1,062.0 | $1,125.7 |
| NOPAT | $98.4 | $75.4 | $124.5 | $131.9 | $139.9 |
| Investment in total net operating capital | na | ||||
| Free cash flow | na | ||||
| Growth in FCF | na | na | |||
| Growth in sales |
Homework Answers
| A | B | C | D | E | F | G | H | I | J | K |
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | For NPV to be calculated free cash flow can be calculated as follows: | |||||||||
| 5 | Free Cash Flow = NOPAT - Capital Expenditures - Change in working capital | |||||||||
| 6 | ||||||||||
| 7 | Investment in net operating capital | =Final net operating capital - Initial net operating capital | ||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | Actual | Projected | Projected | Projected | Projected | |||||
| 11 | Calculation of FCF | 12/31/2016 | 12/31/2017 | 12/31/2018 | 12/31/2019 | 12/31/2020 | ||||
| 12 | Operating current assets | $248.00 | $285.20 | $313.72 | $332.50 | $352.50 | ||||
| 13 | Operating current liabilities | $56.00 | $64.40 | $70.84 | $75.10 | $79.60 | ||||
| 14 | Net operating working capital | $192.00 | $220.80 | $242.90 | $257.50 | $272.90 | ||||
| 15 | Net PPE | $600.00 | $690.00 | $759.00 | $804.50 | $852.80 | ||||
| 16 | Total net operating capital | $792.00 | $910.80 | $1,001.90 | $1,062.00 | $1,125.70 | ||||
| 17 | NOPAT | $98.40 | $75.40 | $124.50 | $131.90 | $139.90 | ||||
| 18 | Investment in total net operating capital | na | $118.80 | $91.10 | $60.10 | $63.70 | =H16-G16 | |||
| 19 | Free cash flow | na | ($72.20) | $11.30 | $57.20 | $60.80 | =H17-H18-(H14-G14) | |||
| 20 | ||||||||||
Add Answer to:
How do I calculate the Investment in Net Profit Operating Capital? I need an example of...
a. Forecast the parts of the income statement and balance sheets necessary to calculate free cash...
a. Forecast the parts of the income statement and
balance sheets necessary to calculate free cash flow.
Partial Income Statement for the Year Ending December 31
(Millions of Dollars)
Actual
Projected
Projected
Income Statement Items
2018/12/31
12/31/19
12/31/20
Net Sales
$800.0
Costs (except depreciation)
$576.0
Depreciation
$60.0
Total operating costs
$636.0
Earning before int. & tax
$164.0
Partial Balance Sheets for December 31 (Millions of
Dollars)
Actual
Projected
Projected
Operating Assets
2018/12/31
12/31/19
12/31/20
Cash
$8.0
Accounts receivable
$80.0
Inventories...
12-29 Chapter 12 Capital Investment Decisions CTIVE 3 Brief Exercise 12-28 Net Present Value xample 12.3...
12-29
Chapter 12 Capital Investment Decisions CTIVE 3 Brief Exercise 12-28 Net Present Value xample 12.3 ed to produce annual revenues of $2.700,000. Producing the printer requires an invest in new equipment costing $2,880,000. The printer has a projected life cycleof5 After 5 years, the equipment can be sold for $360,000. Working capital is also expe Talmage Inc. has just completed development of a new printer. The new product i increase by $360,000, which Talmage will recover by the end...
For 2015 and 2014 calculate: Working Capital Current Ratio Quick ratio Do I need to subtract...
For 2015 and 2014 calculate:
Working Capital
Current Ratio
Quick ratio
Do I need to subtract the "Deferred income Taxes" to calculate
these ratios?
Please explain the procedure, thank you!
NIKE, INC. Consolidated Balance Sheets May 31, 2015 2014 $ 3,852 $ 2,072 3,358 4,337 389 1,968 15,976 3,011 281 131 2,201 21,600 $ 2,220 2,922 3,434 3,947 355 818 13,696 2,834 282 131 1,651 18,594 $ $ in millions) ASSETS Current assets: Cash and equivalents (Note 6) Short-term investment...
(a) Prepare free cash flow statement that shows Operating Cash Flows (OCF), Net Fixed Asset Investment...
(a)
Prepare free cash flow statement that shows Operating Cash Flows
(OCF), Net Fixed Asset Investment (NFAI) and Net Current Asset
Investment (NCAI) (7 marks)
(b) Sekinchan Metal Berhad has assembled 2019 income statement
to be used in preparing 2020 proforma income statement.
Information related to financial projections for the year 2020
as follows:
- Projected sales are RM550,000.
- Cost of Goods sold in 2019, includes RM85,000 in fixed
cosf.
- Operating expense in 2019, includes RM35,000 in fixed...
I need help with investment in sierra. I have no idea what went wrong. Above is...
I need help with investment in sierra. I have no idea what went
wrong. Above is showing that it won't take any of the answers.
Padre, Inc., buys 80 percent of the outstanding common stock of Sierra Corporation on January 1, 2021, for $791.520 cash. At the acquisition date, Sierra's total fair value, including the noncontrolling Interest, was assessed at $989.400 although Sierra's book value was only $638,000. Also, several Individual items on Sierra's financial records had fair values that...
I need help getting the quick ratio and net profit margin for the years 2017 and...
I need help getting the quick ratio and net profit margin for
the years 2017 and 2016 thanks, let me know if you need more info
please
3. Consolidated balance sheet Assets Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 16576 16.07 16.00 Gwa 12.192 20111045 1440 15217 123 Property plant and equipment Iements in Sint ventures and associates Non creavilable for le financuas 1.100 Other curatat ONS D. 1.9.2 1.741 2.131 4144 Non-current as Inventaries and work in...
Confusing in how to calculate the Cash flow PV Exam Example NPV & DCFROR calculations Example A process is projected to have a total depreciable capital investment of $90 million, to spent in equ...
Confusing in how to calculate the Cash flow PV
Exam Example NPV & DCFROR calculations Example A process is projected to have a total depreciable capital investment of $90 million, to spent in equal amounts over three years (2007 -2021) The st art-up capital is expected to be $40 million, invested just prior to start-up and recovered at the end of the project life, in year 15. The re annum, are expected to be: venue from production, and associated production...
HOW DO I GET THE BOOK VALUE OF .240MILLION given in the solution for year 8?(when...
HOW DO I GET THE BOOK VALUE OF .240MILLION given in the
solution for year 8?(when they sell the asset)
THANK YOU
Q-Search in Document Home Review View 2+ Share A Insert Design Layout References Calibri (Body) - 12 -A A A B IV . obe X, X A A i View an Example Mailings A E Documents Acrobat + E. . AaBbc DdEe Paste = = = AaBaccDdte AaBbCcDc AabCcDdE: AaBb No Spacing Heading 1 Heading 2 Title AabhccDE...
I need someone to calculate the 2019 current ratio, quick ratio, times interest earned ratio, and...
I need someone to calculate the 2019 current ratio, quick ratio,
times interest earned ratio, and return on stockholders equity with
the 2 statements i have screenshotted.
WP A.7 WHEELS-4-U CORPORATION CONSOLIDATED BALANCE SHEETS ($000 except share data) 12/31/20x9 12/31/20x8 ASSETS Current Assets: Cash and cash equivalents Accounts and other receivables, net Inventories Deferred income tax assets Prepaid expenses Total current assets Property, plant, and Equipment, at cost: Land and land improvements Buildings and building improvements Machinery and equipment Office...
Ive done all the previous statements. I need help on how to do the post-closing trial...
Ive done all the previous statements.
I need help on how to do the post-closing trial balance for this
question. I've already done the previous statements.
Scenario:
Moonlight Bay Inn is incorporated on January 2, 2017, by its
three owners, each of whom contributes $20,000 in cash in exchange
for shares of stock in the business. In addition to the sale of
stock, the following transactions are entered into during the month
of January:
Requirement #10: Prepare a post-closing trial...
a. Forecast the parts of the income statement and
balance sheets necessary to calculate free cash flow.
Partial Income Statement for the Year Ending December 31
(Millions of Dollars)
Actual
Projected
Projected
Income Statement Items
2018/12/31
12/31/19
12/31/20
Net Sales
$800.0
Costs (except depreciation)
$576.0
Depreciation
$60.0
Total operating costs
$636.0
Earning before int. & tax
$164.0
Partial Balance Sheets for December 31 (Millions of
Dollars)
Actual
Projected
Projected
Operating Assets
2018/12/31
12/31/19
12/31/20
Cash
$8.0
Accounts receivable
$80.0
Inventories...
12-29
Chapter 12 Capital Investment Decisions CTIVE 3 Brief Exercise 12-28 Net Present Value xample 12.3 ed to produce annual revenues of $2.700,000. Producing the printer requires an invest in new equipment costing $2,880,000. The printer has a projected life cycleof5 After 5 years, the equipment can be sold for $360,000. Working capital is also expe Talmage Inc. has just completed development of a new printer. The new product i increase by $360,000, which Talmage will recover by the end...
For 2015 and 2014 calculate:
Working Capital
Current Ratio
Quick ratio
Do I need to subtract the "Deferred income Taxes" to calculate
these ratios?
Please explain the procedure, thank you!
NIKE, INC. Consolidated Balance Sheets May 31, 2015 2014 $ 3,852 $ 2,072 3,358 4,337 389 1,968 15,976 3,011 281 131 2,201 21,600 $ 2,220 2,922 3,434 3,947 355 818 13,696 2,834 282 131 1,651 18,594 $ $ in millions) ASSETS Current assets: Cash and equivalents (Note 6) Short-term investment...
(a)
Prepare free cash flow statement that shows Operating Cash Flows
(OCF), Net Fixed Asset Investment (NFAI) and Net Current Asset
Investment (NCAI) (7 marks)
(b) Sekinchan Metal Berhad has assembled 2019 income statement
to be used in preparing 2020 proforma income statement.
Information related to financial projections for the year 2020
as follows:
- Projected sales are RM550,000.
- Cost of Goods sold in 2019, includes RM85,000 in fixed
cosf.
- Operating expense in 2019, includes RM35,000 in fixed...
I need help with investment in sierra. I have no idea what went
wrong. Above is showing that it won't take any of the answers.
Padre, Inc., buys 80 percent of the outstanding common stock of Sierra Corporation on January 1, 2021, for $791.520 cash. At the acquisition date, Sierra's total fair value, including the noncontrolling Interest, was assessed at $989.400 although Sierra's book value was only $638,000. Also, several Individual items on Sierra's financial records had fair values that...
I need help getting the quick ratio and net profit margin for
the years 2017 and 2016 thanks, let me know if you need more info
please
3. Consolidated balance sheet Assets Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 16576 16.07 16.00 Gwa 12.192 20111045 1440 15217 123 Property plant and equipment Iements in Sint ventures and associates Non creavilable for le financuas 1.100 Other curatat ONS D. 1.9.2 1.741 2.131 4144 Non-current as Inventaries and work in...
Confusing in how to calculate the Cash flow PV
Exam Example NPV & DCFROR calculations Example A process is projected to have a total depreciable capital investment of $90 million, to spent in equal amounts over three years (2007 -2021) The st art-up capital is expected to be $40 million, invested just prior to start-up and recovered at the end of the project life, in year 15. The re annum, are expected to be: venue from production, and associated production...
HOW DO I GET THE BOOK VALUE OF .240MILLION given in the
solution for year 8?(when they sell the asset)
THANK YOU
Q-Search in Document Home Review View 2+ Share A Insert Design Layout References Calibri (Body) - 12 -A A A B IV . obe X, X A A i View an Example Mailings A E Documents Acrobat + E. . AaBbc DdEe Paste = = = AaBaccDdte AaBbCcDc AabCcDdE: AaBb No Spacing Heading 1 Heading 2 Title AabhccDE...
I need someone to calculate the 2019 current ratio, quick ratio,
times interest earned ratio, and return on stockholders equity with
the 2 statements i have screenshotted.
WP A.7 WHEELS-4-U CORPORATION CONSOLIDATED BALANCE SHEETS ($000 except share data) 12/31/20x9 12/31/20x8 ASSETS Current Assets: Cash and cash equivalents Accounts and other receivables, net Inventories Deferred income tax assets Prepaid expenses Total current assets Property, plant, and Equipment, at cost: Land and land improvements Buildings and building improvements Machinery and equipment Office...
Ive done all the previous statements.
I need help on how to do the post-closing trial balance for this
question. I've already done the previous statements.
Scenario:
Moonlight Bay Inn is incorporated on January 2, 2017, by its
three owners, each of whom contributes $20,000 in cash in exchange
for shares of stock in the business. In addition to the sale of
stock, the following transactions are entered into during the month
of January:
Requirement #10: Prepare a post-closing trial...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago