Workshop 4 Problem: Stuclent - Excel AutoSave B B 5 Help Formulas Data Review View Page Layout Draw File LO PX Home Insert Calibri BIU-9 12 E - AA -A Wrap Text Merge & Center - General $ -% Conditional Format as Formatting Table Styles Cell Styles La Paste Number Alignment Clipboard Font 1 G11 X - B 1 4.5 Determining the total costs to include to capitalize an asset. Points: 4 items @ 2 pts. each = 18 pts. 2 Directions: Determine the amount to be capitalized in the asset account for the purchase 3 of the truck 5 Background Information: Donald purchased a moving truck to move Micky to Alaska. The truck 6 had a list price of $150,000. Donald was able to negotiate a 3.25% because he was able to pay cash for the purchase 7 The truck needed shipped and the freight cost were $3,000. The specialist fee for the transaction 8 was $1,800. Donald is paying someone $45,000 to load the truck and move Mickey. He also purchased 9 a $10,000 insurance policy. The truck has an expected life of 6 years with a salvage value of $8,000 12 Costs that are to be capitalized: List Price Less: Discount Freight Cost Specialist Fee 17 Total Costs 20 Helpful Resources Problem 4.1 Problem 4.2 Problem 4.3 Problem 4.4 Problem 4,5 Problem 4.6