Please use Excel if possible as I am confused on the formatting.

Capital University recently purchased new computing equipment for its business school on September 1, 2023. Use the following information to determine the dollar amount that Capital will record as the total cost of this equipment. - The purchase price of the equipment was $275,000. - Lynbrook took advantage of the cash payment terms 1/15,n/30, taking a 1% cash discount. - Capital paid sales taxes of $15,000, at the date of purchase. - Freight charges for delivery of the equipment totaled $10,000. - Installation costs related to the equipment amounted to $12,000. - During installation, one of the computer terminals was accidentally damaged by a Capital employee. It cost the university $2,000 to repair this damage. - As soon as the computers were installed, Capital paid $3,000 to print recruiting brochures featuring the new, state-of-the-art computing facilities in the business school. Required: Compute the total cost that will be recorded in Capital's Computing Equipment account. Part 2 (8 points) Lynbrook, Inc. purchased a tooling machine to use for the manufacturing of its new products on August 1,2023 . You have been asked to determine how much depreciation expense would be recognized under the two different methods. The equipment costs $165,000 and is expected to have a value of $15,000 at the end of its four-year life. Required: a) Determine the amount of depreciation expense that will be recognized under each of the following depreciation methods in 2023 and 2024, the first and second years of the equipment's useful life. Lynbrook has a policy to use the partial-years method of depreciation in the year of purchase and sale. (round to the nearest dollar, if needed): 1. Straight-line. 2. Double-declining-balance b) Prepare the Property Plant \& Equipment (PPE) section of the balance sheet on December 31, 2023 (end of fiscal year) under the double-declining-method, assuming the equipment is the only plan asset owned by Lynbrook. c) Fast forward to 2025. Lynbrook sold the equipment on March 1, 2025. Prepare the entry to record the depreciation expense incurring in 2025 and the entry to record the sale of the equipment assuming the following for both Straight-line and Double-Declining-Balance: a. The equipment was sold for $26,000. b. The equipment was sold for $135,000