Question: Task 2: Depreciation Depreciation is to be calculated using the diminishing value method The depreciationrateis 20%. Depreciation calculations and charges will be enteredon the Asset

Task 2: Depreciation Depreciation is to be calculated using the diminishing value method The depreciationrateis 20%. Depreciation calculations and charges will be enteredon the Asset Register Card found on the excel spreadsheet BSBFIA401_AE_Appx_Templates .xIsx REQUIRED I. Open the excel file BSBFIA401_AE_Appx_Templates .xIsand open the worksheet called 'PART 1 Asset register, where you enteredthe details of the purchase of the Bromic cool room. Il . Enter formulae on the asset register card to calculate the depreciation charge for the cool room Ill . Calculate the depreciationcharge for the financial year ended30 th June 20X1 . IV. Calculate the depreciationcharge for the financial year ended 30th June 20X2 . V. Calculate the depreciationcharge for the financial year ended 30th June 20X3 . VI. On the excel file BSBFIA401_AE_Appx_Templates .xIsyou will find a worksheet called 'PART 1 General Journal'. On this general journal templaterecord the journal entries for the depreciation charge for: o 20X 1 o 20X 2

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 Accounting Questions!

Bradfields Landing Fresh Food has purchased a new Bromic cool room for its warehouse. The invoice is shown below. Tarrawana Refrigeration Supplies 127 Bent Street Invoice Tarrawana NSW 2999 DATE:...

Rubric N D- C B - A

Scenario You work as a financial analyst in the Finance division of the Rural Services Ltd an Australian agribusiness company. Rural Services Ltd provides a range of products and services, across...

Depreciation is to be calculated using the diminishing value method. The depreciation rate is 20%. Depreciation calculations and charges will be entered on the Asset Register Card found on the excel...

Q18 (Disposal of depreciating assets) Required: The following are all resident taxpayers. In each case, calculate the deduction available for decline in value as well as any assessable income (if...

Rubric N D - C B - A

Rubric N D- C B - A

Rubric N D - C B - A

Rubric D-C B-A

Explain the meaning of highest and best use. What is the purpose of identifying highest and best use?

Fill in the blanks. a. The mean of all possible sample proportions is equal to the_______. b. For large samples, the possible sample proportions have approximately a distribution. c. A rule of thumb...

The IRS must follow certain rules called deficiency procedures when they assess additional tax. However, an exception applies when the: Taxpayer does not respond to a 3 0 - day letter. Amount...

i will pay 30 looking for i. The consolidation journal entries (10 marks) ii. The consolidation worksheet (10 marks) answer Q 2. Consolidation (40 marks) Financial information at 30 June 2016 of...