Please answer the questions that are on the screenshots
2. In industries that process joint products. the costs of the raw materials inputs and the sales values of intermediate and nal products are otten volatile. Change the data area otyour worksheet to match the following: A B G 1 Chapter 0?: Applylng Excel 2 3 Data 4 Exhibit 7-6 Sanla Maria Wool Cooperative 5 Coat of wool $212,030 6 Cost ofeeparetlcn process $40,000 7 Sales value of Intennedlla products at split-0E point: B Undyed coarse wool 5118.000 9 Undyed ne wool $141,030 10 Undyed superne wool $57,000 11 Costs cffurther processing (dyeing) lntem'ledlate products: 12 Undyed meme wool 550.com 13 Undyed ne wool 360.0(1) 14 Undyed superne wool 510.0(1) 15 Sales value of end products: 18 Dyed (nurse MOI $150,!XJU 1T Dyed ne wool SEDSJXJU 18 Dyed superne won] $94,000 If your formulas are correct. you should get the correct answers to the following questions. a. What is the overall prot it all intem'recliate products are processed into nal products? b. What is the residual income? _lrom further processing undyed coarse wool = 5[l. ODD = from further processing undyedl fine wool - from further processing undyed superne = wool c1. With these new costs and selling prices, what recommendations would you make ccnceming the company's operations\"?' Sell as is or process further the intermediate product undyed coarse wool? Sell as is or process further the intermediate product undyed ne wool? Sell as is or process further the intermediate product undyed superne wool? 2. The company is considenng a project involving the purchase of new equipment. Charge the data area of your worksheet to match the following: A B G 1 Chapter 3: Applylng Excel 2 8 Data Il- Example E 5 Cost of equipment needed $410300 6 Working capital needed 32mm 7 Overhaul of equipment in four years $45,000 a salvage value of me equipment In $20,000 9 Annual revenues and costs: 19 Sales revenues 54915.0(!) 11 Cost of goods sold 52650.0(!) 12 Outvofpooloet operating caste $65.06.) a. What is the net present value ofthe project? (Negative amount should be Indicated by a minus sign. Round all other Immediate calculations to nearest whole dollar.) -:| b. The intemal rate of retum is between what two whole discount rates (e.g.. between 10% and 11%, between 11% and 12%. between 12% and 13%. bebveen 13% and 14%. etc)? _:I:| c. Reset the discount rate to 11 $3. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive present value