Transcribed Image Text
A project under consideration costs $600,000, has a five-yearlife and has no salvage value. Depreciation is straight-line tozero. The firm has made the following projections related to thisproject:BaseCaseLowerBoundUpperBoundUnit Sales3,0002,8503,150Price Per Unit$300$285$315Variable Cost Per Unit$170$160$180Fixed Costs$150,000$135,000$165,000The required return is 16 percent and the tax rate is 40 percent.No additional investment in net working capital is required.Requirement 1:What are the worst-case and best-case scenarios for thisproject? (Input unit sales as number of units. Round allother answers to the nearest whole dollar (e.g.,32).) Worst CaseBest CaseUnit SalesPrice Per Unit$$Variable Cost Per Unit$$Fixed Costs$$ Requirement 2:Your analysis of the project's NPV in the "base case" shows aNPV of $28,664. However, your boss has asked you to determine thesensitivity of the project's NPV to potential changes in fixedcosts. Using the firm's estimate of the highest possible level offixed costs, complete the table below and use your results toassess the sensitivity of the project's NPV to changes in fixedcosts. (Round all answers except your sensitivity estimateto the nearest whole dollar (e.g., 32). Round the sensitivityestimate to 2 decimal places (e.g., 32.16). Negative amounts shouldbe indicated by a minus sign.) Sales$Variable Costs$Fixed Costs$Depreciation$EBIT$Taxes$Net Income$Operating Cash Flow$Net Present Value (NPV)$ Sensitivity (?NPV/?FC)$
Other questions asked by students
How to do survival analysis in excel with this data Life expectancy of males in years...
3. The atmosphere is in constant motion. Why? What is the general pattern of airflow? Explain...
As body size decreases in animals there is greater variability in metabolic rate Oit becomes...
luid flows from point P to Q BAD A large tank of height h 4m...
you are dealt 4 cards from a shuffled deck of 52 cards find the probabil...
Identify the sampling technique used Based on 12 500 responses from 48 000 questionnaires sent...
estmating snare varue using the kurT wouer Following are forecasts of sales, net operating...
need this answer asap. its very urgent . Last date of Submission: September...
1. Bowl Bi contains 2 white chips, bowl B2 contains 2 red chips, bowl Ba...