Question: 11. The accountant at Canton Manufacturing Company wants you to create an application that calculates an assets annual depreciation using the double-declining balance and sum-of-the-years

11. The accountant at Canton Manufacturing Company wants you to create an application that calculates an asset’s annual depreciation using the double-declining balance and sum-of-the-years’ digits methods. The accountant will enter the asset’s cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). A sample run of the application is shown in Figure 6-54. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 through 20 years. The depreciation amounts are displayed in list boxes. (Hint: You can use the DDB and SYD functions in Microsoft Excel to verify that the amounts shown in Figure 6-54 are correct.) Create the application, using the following names for the solution and project, respectively:

Canton Solution and Canton Project. Save the application in the VB2015\Chap06 folder. You can use Visual Basic’s Financial.DDB method to calculate the doubledeclining balance depreciation, and use its Financial.SYD method to calculate the sum-of-the-years’ digits depreciation. The Financial.DDB method’s syntax is Financial.DDB(cost, salvage, life, period). The Financial.SYD method’s syntax is Financial.SYD(cost, salvage, life, period). In both syntaxes, the cost, salvage, and life arguments are the asset’s cost, salvage value, and useful life, respectively. The period argument is the period for which you want the depreciation amount calculated. Both methods return the depreciation amount as a Double number. Test the application appropriately

Canton Manufacturing Company x Asset cost: Salvage value: Useful life: 5000 100

Canton Manufacturing Company x Asset cost: Salvage value: Useful life: 5000 100 3 6 Display Depreciation Schedules Exit Depreciation schedules Double-declining balance: Year Depreciation 1 2345 Sum-of-the-years' digits: Year Depreciation 2,000.00 1 1,633.33 1,200.00 2 1,306.67 720.00 980.00 432.00 4 653.33 259.20 5 326.67

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