3. Sensitivity analysis (S10.1) Otobai's staff (see Section 10-1) has come up with the following revised estimates for the electric scooter project: % change in capital investment % change in working capital % change in units sold % change in price Cost of goods sold as % of sales % change in fixed costs Optimistic -20.00 -50.00 25.00 20.00 40.00 -50.00 Pessimistic 60.00 50.00 -20.00 -25.00 75.00 70.00 Conduct a sensitivity analysis using the spreadsheets (available in Connect). What are the principal uncertainties in the project? Page 293

Using the following data, estimate the new Return on Investment if there is a 10% decrease in variable and fixed costs - with average operating assets as the base. Sales $2,000,000 Variable costs 1.100.000 Contribution margin 900.000 Controllable fıxed costs 300.000 IControllable margin $600,000 Average operating assets $5,000,000 Round to two decimal places. Be sure to enter the answer as a percentage but do not include the % sign.

Consider the following cost and pricing data of ABC Corp. on its Product X:Price: P120.00.per unitProfit Contribution: P90.00Proposed additional Cost: P3 per unit (for quality improvement)Current Profits: P2.4 millionSales: 100,000 units. A. Assuming that average variable costs are constant at all output levels, findABC Corp.’s total cost function before the proposed change.B. Calculate the total cost function if the quality improvement is implemented. UNANSWERED SUB-PARTSC. Calculate ABC Corp.’s break-even output before and after the change, assuming it cannot increase its price.D. Calculate the increase in sales that would be necessary with the quality improvement to increase profits to P2.7 million

I need help with finding the accounting breakeven and cash break even and OCF at financial breakeven with taxes. Also, what excel function to use for NPV calculation in the NPV profile D11 XVfx C TOSK T lapet area: Initial cost Unit sales Price/unit Variable cost/unit B TOYT E Fixed costs Project life 1,000,000 Required return 11% 5,000 Tax rate 21% 7,000 Unit sales uncertainty 8% 6,400 Variable cost uncertainty 270,000 Fixed cost uncertainty 8% 5 Question 1 Base Case Best Case Worst Case Unit sales 5,000 Variable cost/unit 6,400 5,400 1 5,888 4,600 6,912 Fixed costs 270,000 Sales 35,000,000 Variable cost 32,000,000 Fixed cost 270,000 Depreciation 200,000 248,400 37,800,000 31,795,200 248,400 ! 200,000 32,200,000 31,795,200 291,600 291,600 200,000 EBIT 2,530,000 5,556,400 (86,800) Taxes (21%) Net income OCF 531,300 1,166,844 (18,228) 1,998,700 4,389,556 (68,572) 2,138,700 4,589,556 131,428 NPV $7.126.168.77 $15,962,526.33 ($514,255.65) Question 2 fignoring Taxes with Taxes) x…

Peform a sensitivity analysis by answering the following questions: A. What is the break-even point in sales dollars for RBC? B. What is the margin of safety for RBC? C. What sales dollars would be required to achieve an operating profit of $170,000? $440,000?

Using the following data, estimate the new Return on Investment if there is a 11% decrease in variable and fixed costs- with average operating assets as the base. Sales $3,634,424 Contribution margin Controllable fixed costs Average operating assets 49% 278,080 $5,083,234 Round to two decimal places. Be sure to enter the answer as a percentage but do not include the *% sign.

I Question 3: Sohar Company's financial information is given in the table below. Sales (OMR) Fixed Costs 405000 450000 Year Variable Costs 2019 225000 2020 120000 240000 Calculate: a) PV ratio, b) B.E.P. c) Sales required to earn a profit of OMR 40000. d) Margin of safety at a profit of OMR 50000 e) Profit when sales are OMR. 200000.

Question 2 (input refer to picture attached) a) Based on Return of Investment (ROI) evaluation, which unit will you recommend to your management to be purchased and why? b) From Life Cycle Cost (LCC) Analysis, would you Brand X or Brand Y crane? What is your recommendation and why? c) Based on the Minimum Acceptable Rate of Return (MARR), if the company hurdle rate is 20 %, would you choose Brand X or Brand Y and why? – include the cashflow diagram

Question 3: Sohar Company's financial information is given in the table below. Sales (OMR) Fixed Costs 405000 Year Variable Costs 2019 90000 225000 2020 450000 120000 240000 Calculate: a) PV ratio, b) B.E.P in units and Sales c) Sales required to earn a profit of OMR 40000.Each year is separate, you should calculate the required values for both years. d) Margin of safety at a profit of OMR 50000 e) Profit when sales are OMR. 200000.

Question 3: Sohar Company’s financial information is given in the table below. Year Sales (OMR) Fixed Costs Variable Costs 2019 405000 90000 225000 2020 450000 120000 240000   Calculate:   Margin of safety at a profit of OMR 50000 Profit when sales are OMR. 200000.