Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Financial Management

Authors: Stanley Block

8th Canadian Edition

0070965447, 9780070965447

More Books

Students also viewed these Finance questions

Question

14.5 Describe how accidents at work can be prevented.

Answered: 1 week ago