Kindly Show the Formulas in an Excel Sheet. Solve this question in 15 mins. Provide accurate Solution.

have decided to have its own plantation by acquiring Company B which is actively looking to sell its rubber plantation business. Both Equity and Debt will be used for the acquisition. You have been hired by the company A as an advisor to the deal. Please Note : 1 You are free to add rows \& columns 2 Keep your formulas dynamic for any change in the inputs provided 3 Formulas should be consistent across the input range i.e. adjacents cells should have the same formulas. .1 Scenario Selection You have collected the rubber prices from 3 sources - World Bank, RBS and Maybank. Further for each source you calculated 3 scenarios for - Best Case, Most Likely and Worst Case Design a dynamic formula to populate the rubber price for scenarios selected from input box? An example output has been provided for World Bank - Best Case