NEED THE SOLUTION ON EXCEL with formula view

Fixed assets are the primary assets of New Hope Corporation. As of December31, 2014 New Hope is having liquidity problems. New Hope's borrowing base is limited to 60% of its net fixed assets. The CFO has been entertaining the idea of changing from GAAP to IFRS for accounting purposes Analyze the accounting for each fixed asset class using GAAP. Assume New Hope uses straight Line depreciation and takes a full year depreciation in year of acquisition Prepare a memo to the CFO formally articulating your analysis and recommendation to New Hope a. b. Asset-Frontier Building 30 year life acquired 10 years ago at a cost of $60,000,000. Fair value at end of 2014 was estimated to be $40,000,000. How would adopting the fair value option affect the valuation of the building