Question: PLEASE SHOW STEPS ON EXCEL ON THE DATA TABLE AND FORMULAS Consider a 5-year project with an initial fixed asset investment of $325,000, straight-line depreciation

PLEASE SHOW STEPS ON EXCEL ON THE DATA TABLE AND FORMULAS
PLEASE SHOW STEPS ON EXCEL ON THE DATA TABLE AND FORMULAS Consider

Consider a 5-year project with an initial fixed asset investment of $325,000, straight-line depreciation to zero over the project's life, a zero salvage value, a selling price of $34, variable costs of $17, fixed costs of $199,700, a sales quantity of 94,000 units, and a tax rate of 21 percent. What is the sensitivity of OCF to changes in the sales price? Instruction: You have to use the data table option to solve the problem. Use a range of sales price (hint: use 30% to 30% with 10% gap as a guidance). You should draw the sensitivity graph

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!