Question: please use excel. Thank you :) Date Assigned: Thursday, May 28, 2020 Date Due: Monday, June 01, 2020 before class. No late homework will be

please use excel. Thank you :) please use excel. Thank you :) Date Assigned: Thursday, May 28, 2020

Date Assigned: Thursday, May 28, 2020 Date Due: Monday, June 01, 2020 before class. No late homework will be accepted. . Homework 3 Please notice that all work must be shown in a professional way with attention to detail No credit will be given for incomplete or disorderly work Please use a cover sheet stating your name, course number, date due, and homework number Unstapled homework will not be collected as this is part of the assignment All work must be individual with emphasis on numerical accuracy This is an Excel based assignment that must be submitted following the stated guidelines Please notice that late homework (after collected by the instructor) will incur into a 25% late fee . . . 1. Problem One: Worldwide Delivery Corporation has recently purchased a brand new truck for $75,000 to upgrade their delivery fleet in New York City. Given past experience, management estimates the salvage value of the truck to be $15,000 after 10 years. As shown in class today, prepare a Depreciation Schedule under the Straight Line Method for the company's new asset. 2. Problem Two: Prats Engineering has acquired a new computerized milling machine at a cost of $225,000. Engineering management estimates that the salvage value of the new equipment to be $35,000 after 20 years. As shown in class today, prepare a Depreciation Schedule under the Straight Line Method for the company's new asset. 3. Problem Three: In an effort to upgrade their transatlantic air fleet, Air France has recently acquired a new Airbus A-380 for $375,000,000. They also estimate the average useful life of this aircraft to be 25 years. In addition, they estimated salvage value to be $10,000,000. As shown in class today, prepare a Depreciation Schedule under the Straight Line Method for Air France's new aircraft

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!