Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you show the equations for excel to dins lwaa capex and change in Nwc? 5 66629123 File Paste D31 10 11 Clipboard 14 15
can you show the equations for excel to dins lwaa capex and change in Nwc?
5 66629123 File Paste D31 10 11 Clipboard 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 X A 41 42 20 Home Arial B IU. Insert Investment in NWC Initial investment in PP&E Depreciation (5 year life wo salvage) B Assumptions and Predictions Price per unit Market share (%) Market size (Year 1) Growth rate in market size beginning in Year 2 Unit variable cost Fixed cost Tax rate Cost of capital Revenue Variable Cost Fixed cost Depreciation EBT(Net Operating Income) Tax Net Operating Profit after Tax (NOPAT) Plus: Depreciation expense Less: Capex Less: Change in NWC Free Cash Flow Units Sold Net Present Value Internal Rate of Return Draw Page Layout A Breakeven Sensitivity Analysis Price per unit 43 Market share (%) 44 45 Font 10 Market size (Year 1) Growth rate in market size beginning in Year 2 Unit variable cost V fx $ $ S5 $ $ $ v A C Estimates 9,000,000 50.00% 18.00% 0 4,895 15.00% 200,000 units 5.00% 4,250 7,000,000 1,400,000 V 21 Critical value a. If the market share is only 5% then the project's NPV = b. If market share = 15% and the price of the PTV falls to $4,500 the NPV = of the predicted change in firm 5.00% revenues. Formulas == D ESET Free Cash Flow Estimation 1 979,000,000 4,250 9,000,000 1,400,000 $ 968,595,750 484,297,875 $ 484,297,875 1,400,000 ED % Change from base value to critical value Alignment E Data 2 1,027,950,000 Year 4,250 9,000,000 1,400,000 $1,017,545,750 508,772,875 $ 508,772,875 $ 1,400,000 HIH $ F 17 Review Accounting $ % 9 $60-000 V View Number Automate H = Qualitative analysis or Short answer required Complete the "Cash Flow Estimation" Section, including the FCF table a Sensitivity Analysis", and provide your answers to questions a, b, and c Conditional For Format as Table Cell Styles G = Value given in problem - Formula/Calculation/Analysis required 4 1,133,314,875 5 3 1,079,347,500 1,189,980,619 4,250 4,250 4,250 9,000,000 9,000,000 9,000,000 1,400,000 1,400,000 1,400,000 1,068,943,250 $1,122,910,625 $1,179,576,369 534,471,625 561,455,313 589,788,184 534,471,625 $561,455,313 $589,788,184 1,400,000 1,400,000 1,400,000 Styles
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started