Slove for C, please

c. Using the excel sheet and by formatting the cells, prepare a table showing the Accretion: Interest Method of Allocation.

World Oil and Gas Corporation completes construction of an offshore oil platform and places it into service on January 1, 2018. World Oil and Gas Corp. is legally required to dismantle and remove the platform at the end of its useful life which is estimated to be 10 years. On January 1, 2018, World Oil and Gas Corp. recognized a liability for an asset retirement obligation and capitalized an amount for an asset retirement cost. It estimated the initial fair value of the liability using an expected present value technique. The significant assumptions used in that estimate of fair value are as follows: a. Labor costs are based on current marketplace wages required to hire contractors to dismantle and remove offshore oil platform. World Oil and Gas Corp. assigns probability assessment to range of cash flows estimates ad follows: Cash Flow Estimate Probability Assessment 10% $250,000 175,000 200,000 60% 30% b. World Oil and Gas Corp. estimated allocated overhead and equipment charge using the rate it applies to labor costs for transfer pricing (60%). The entity has no reason to believe that its overhead and equipment rate differs from that used by contractors in the industry. c. A contractor typically adds a markup on labor, allocated internal costs, and equipment to provide a profit margin on the job. The entity determines the profit that contractors in the industry generally earn to dismantle and remove offshore oil platform is 15%. d. A contractor would typically demand and receive a premium (market risk premium) for bearing the uncertainty and unforeseeable circumstances inherent in locking in today's price for a project that 1 will not occur for 10 years. The entity estimates the amount of that premium to be 5% of the estimated inflation-adjusted cash flows. e. The risk-free rate of interest on January 1, 2015 is 6%. The entity adjusts that rate by 4% to reflect the effect of its credit standing. Therefore, the credit-adjusted risk-free rate used to compute expected present value is 10%. (Round the present value factor to four decimal places.) f. World Oil and Gas Corp. assumes a rate of inflation of 4% over 10-years period. (Round the present value factor to four decimal places.) World Oil and Gas Corporation completes construction of an offshore oil platform and places it into service on January 1, 2018. World Oil and Gas Corp. is legally required to dismantle and remove the platform at the end of its useful life which is estimated to be 10 years. On January 1, 2018, World Oil and Gas Corp. recognized a liability for an asset retirement obligation and capitalized an amount for an asset retirement cost. It estimated the initial fair value of the liability using an expected present value technique. The significant assumptions used in that estimate of fair value are as follows: a. Labor costs are based on current marketplace wages required to hire contractors to dismantle and remove offshore oil platform. World Oil and Gas Corp. assigns probability assessment to range of cash flows estimates ad follows: Cash Flow Estimate Probability Assessment 10% $250,000 175,000 200,000 60% 30% b. World Oil and Gas Corp. estimated allocated overhead and equipment charge using the rate it applies to labor costs for transfer pricing (60%). The entity has no reason to believe that its overhead and equipment rate differs from that used by contractors in the industry. c. A contractor typically adds a markup on labor, allocated internal costs, and equipment to provide a profit margin on the job. The entity determines the profit that contractors in the industry generally earn to dismantle and remove offshore oil platform is 15%. d. A contractor would typically demand and receive a premium (market risk premium) for bearing the uncertainty and unforeseeable circumstances inherent in locking in today's price for a project that 1 will not occur for 10 years. The entity estimates the amount of that premium to be 5% of the estimated inflation-adjusted cash flows. e. The risk-free rate of interest on January 1, 2015 is 6%. The entity adjusts that rate by 4% to reflect the effect of its credit standing. Therefore, the credit-adjusted risk-free rate used to compute expected present value is 10%. (Round the present value factor to four decimal places.) f. World Oil and Gas Corp. assumes a rate of inflation of 4% over 10-years period. (Round the present value factor to four decimal places.)