Turn this into an execel sheet, also show formulas

P9.6 (LO 1, 2) (Classification of Costs and Interest Capitalization) On January 1, 2025, Blair Corporation purchased for $500,000 a tract of land (site number 101) with a building. Blair paid a real estate broker's commission of $36,000, legal fees of $6,000, and title guarantee insurance of $18,000. The closing statement indicated that the land value was $500,000 and the building value was $100,000. Shortly after acquisition, the building was razed at a cost of $54,000. Blair entered into a $3,000,000 fixed-price contract with Slatkin Builders, Inc. on March 1, 2025, for the construction of an office building on land site number 101. The building was completed and occupied on September 30,2026 . Additional construction costs were incurred as follows. Plans, specifications, and blueprints $21,000 Architects' fees for design and supervision 82,000 The building is estimated to have a 40 -year life from date of completion and will be depreciated using the 150% declining-balance method. To finance construction costs, Blair borrowed $3,000,000 on March 1, 2025. The loan is payable in 10 annual installments of $300,000 starting on March 1, 2026, plus interest at the rate of 10%. Blair's weighted-average amounts of accumulated building construction expenditures were as follows. For the period March 1 to December 31, 2025 $1,300,000 For the period January 1 to September 30, 2026 1,900,000 Instructions a. Prepare a schedule that discloses the individual costs making up the balance in the land account in respect of land site number 101 as of September 30, 2026. b. Prepare a schedule that discloses the individual costs that should be capitalized in the office building account as of September 30, 2026. Show supporting computations in good form. (AICPA adapted) (a) BLAIR CORPORATION Cost of Land (Site 1101 ) As of September 30. 2026 (b) BLAIR CORPORATION Cost of Bullding Schedule 1 Interest Capitalized During 2025 and 2026 *Actual interest: $3,000,000,1010/12=$250,000. 2026 $1,900,000 x .10 =$190,000 "Actual interest: ($3,000,000.102/12)+ ($2,700,000.1010/12) =$275,000. ($3,000,000$300,000)