ABC Excel-Based Assignment #1: Acquisition Costs of Trucks Download and save file with naming convention "EBA1 - Last Name, First Name - Acquisition Costs of Trucks", so mine would be "EBA1 - Viers, Gary - Acquisition Costs of Trucks". This helps me alphabetize and locate your assignment easily. M Complete the following Excel-Based Assignment and submit to viersg@uw.edu no later than 5:30 pm on Tuesday, February 1st. LATE ASSIGNMENTS NOT ACCEPTED. 50 points possible; Perform all tasks as required below, i.e. cell referencing to original data, use of Excel Present Value formula for truck #2, proper account names, etc. EBA1 - Acquisition Costs of Trucks Nerds "R" Us Corporation operates a retail computer store. To improve delivery services to customers, the company purchases four new trucks on April 1, 2020. The terms of acquisition for each truck are described below. 1. Truck #1 List price Cash acquisition cost 2. Truck #2 List price $ 15,000 13,900 $ 16,000 Acquisition cost Cash down payment 2,000 Face amount of zero-interest bearing note assumed 14,000 Note due date April 1, 2021 Normal interest rate for this borrowing 10% Incremental borrowing rate 8% 3. Truck #3 List price $ 16,000 Acquired in exchange for a computer system that Nerds "R" Us carries in inventory Cost of computer system in inventory 12,000 Normal selling price of computer system by Nerds "R" Us 15,200 Inventory system used by Nerds "R" Us Perpetual 4. Truck #4 List price $ 14,000 Acquired in exchange for common stock in Nerds "R" Us Corporation 1,000 shares Par value of common stock per share $ 10.00 Market value of common stock per share $ 13.00