Question: Construct the a DCF Cash Flow (use $ millions) using the following assumptions (Use negative for cash outflow and positive for cassh inflow) Years 1-7

Construct the a DCF Cash Flow (use $ millions) using the

Construct the a DCF Cash Flow (use $ millions) using the following assumptions (Use negative for cash outflow and positive for cassh inflow) Years 1-7 Assumptions Sales Growth Company Division #1 Company Division #2 Cost of Goods Sold as % of Sales Operating Expesnes as % of Sales Depreciation as % of Sales Working Capital as % of Sales Capex as % of Sales Tax Rate 5.00% 10.00% 65.00% 15.00% 5.00% 2.00% 7.00% 24.00% OUTPUT CASH FLOW PROJECTIONS FOR DCF Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Sales Company Division #1 Company Division #2 Total Sales Sales Growth 25,000 10,000 35,000 Cost of Sales Gross Profit Operating Expenses EBITDA Depreciation EBIT Taxes Working Capital Capex Equity Cash Flows

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I need Solution of this as soon as possible DuPont Analysis, Forecasting with the Parsimonious Method and Estimating Share Value of Cisco Systems Inc Using the DCF Model Cisco Systems, Inc. is a...

The question is in the word document, please help me with it. 1. Use the following information to answer the following. Cash Holdings ($) Unused Credit Line ($) Next Expected Cash Inflow ($) Stand....

This assignment will be based on the HMS case (pp 381-383). You are expected to use Excel in answering the following questions. 1. Calculate NOPAT, Net Operating Working Capital, Total Operating...

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco...

This appendix explains a parsimonious method to obtain forecast for net operating profit after tax (NOPAT) and for net operating assets (NOA). This method requires three crucial inputs: 1. Sales...

Compute CVS's net operating assets (NOA) as of December 31, 2012. 2012 NOA = $Answer Compute net operating profit after tax (NOPAT) for fiscal year ended December 31, 2012, assuming a federal and...

Hi Can you assist with the attached assignment? Thanks Bayerische Motoren Werke Aktiengesellschaft (DB:BMW) > Financials > Key Stats In Millions of the trading currency, except per share items....

DuPont Analysis. Please include explanations and calculations for each question (A-J). DuPont Analysis. Forecasting with the Parsimonious Method and Estimating Share Value of Cisco Systems Ine Using...

DuPont Analysis, Forecasting with the Parsimonious Method and Estimating Share Value of Cisco Systems Inc Using the DCF Model Cisco Systems, Inc. is a multinational information technology company...

Yellow Company sells hair products. The following information is selected financial information for the most recent year Beginning merchandise inventory on January 1 was $33,900 Ending merchandise...

7 points Save Answer One "shake" is equal to 10 nanoseconds. If the SI prefix system were expanded to other units, there would be such definitions as a "millihour", meaning 1/1000 of an hour. Convert...

Nine descriptions about error checking methods are given in the table below. By ticking () in the appropriate column or columns, indicate whether each description refers to checksum, parity check,...

show that b = 1 + 1 / 2 + 1 / 3 + . . . + 1 / n - logn and a = b - 1 / n both converge to gamma between 1 / 2 and 3 / 5

1. The Federal government establishes its budget to decide what programs to provide and how to pay for them. How does fiscal policy differ from this ordinary fiscal activity of budgeting? LO1

2. What are governments fiscal policy options for moving the economy out of a recession? Speculate on which of these fiscal options might be favored by (a) a person who wants to preserve the size of...

8. Explain: Unemployment can be caused by a decrease of aggregate demand or a decrease of aggregate supply. In each case, specify the price-level outcomes. LO4