Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with exercise 10 in excel with graph e. The Marketing Vice President would like some sensitivity analysis done. He asks, What would
I need help with exercise 10 in excel with graph
e. The Marketing Vice President would like some sensitivity analysis done. He asks, "What would be the NPV of the project if annual unit sales vary from 400,000, 450,000, ..., 900,000 and if the unit price per bar varies from $1.20, $1.30, ..., $1.70?" Show the Data Table that answers his question. 10. (Cash-flow analysis) The "Less Is More" company manufactures swimsuits. The company is considering expanding to the bathrobe market. The proposed investment plan includes: Purchase of a new machine: The cost of the machine is $150,000, and its expected life span is 5 years. The machine will be depreci- ated to zero salvage value, but the chief economist of the company estimates that it can be sold for $20,000 at the end of 5 years. Advertising campaign: The head of the marketing department esti- mates that the campaign will cost $80,000 annually. Fixed costs: Incremental fixed costs of the new department will be $40,000 annually. Variable costs: First-year variable costs are estimated at $30 per bathrobe, but due to the expected increase in labor costs, they are expected to rise at 5% per year. Price per bathrobe: Each of the bathrobes will be sold at a price of $45 at the first year. The company estimates that it can raise the price of the bathrobes by 10% in each of the following years. The "Less Is More" discount rate is 10%, and the corporate tax rate is 36%. a. What is the break-even point of the bathrobe department (what is the minimal number of units it needs to sell so the expansion is profitable)? b. Plot a graph in which the NPV is the dependent variable of the annual production *Cash-flow analysis, replacing equipment) The "Car Clean" company oper ales a car wash business. The company's current cleaning machine was bonoht 2 00 Tilin of the machine 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