I have this excel spreadsheet home work I'm not quite sure how to do it

rontr Alignment Number 19 1 DEPRECIATION 2 A machine with a cost of $260,000 has an estimated salvage value of $20,000 and an estimated life of 6 years or 15,000 hours 4 It is to be depreciated by the straight-line method. What is the amount of depreciation for the first full year? a. 6 1) 7 8 9 10 What is the amount of depreciation for the first full year, using the double declining- 11 balance method? (Do not round the rate) 12 1) 13 2) 14 15 Assuming the units-of-production method, what is the amount of depreciation for the first full year during which the machine was used 4,500 hours? 16 C. 17 1) Notes Receivable Depreciation Assets Bank Reconciliation Uncollectible Accounts Select destination and press ENTER or choose Paste Type here to search 2 BANK RECONCILIATION & JOURNAL ENTRIES 1) Use the following information to prepare a bank reconciliation for Handy Company for August 31, 201 6 2) Once you complete the bank reconciliation, prepare any necessary journal entries. 7 a) Balance per bank at August 31 is $10,279.43. b) Balance per book at August 31 is $11,769 21 Outstanding check: 654 for $650 d) Outstanding check 649 for $21 10 11 e) Deposits in transit: 8/30 for $722 f) Deposits in transit 8/31 for $1 435 g) The bank service charge is $25 12 13 14 Interest earned from bank is $3 22 h) 15 A check to Green Software for $896 was recorded as $869 in the journal. i) 16 An insufficient check from Henry Gold, a customer, was charged to our account by the bank in the a k) Cash sales for the month totaled $324 and were recorded incorrectly in the journal at $234. 17 18 19 HANDY COMPANY 20 Bank Reconciliation 21 Depreciation Assets Notes Receivable Bank Reconciliation Uncollectible Accounts Select destination and press ENTER or choose Paste Type here to search A6 wyoming Company received a 90-day, 11 % note for $36,000, dated July 1, from C. Buss Co. on accous PrOCoorTTYOrronTVOTESRECETVDCE H 4 Record the following notes receivable transactions 5 6 Wyoming Company received a 90-day, 11 % note for $36,000, dated July 1, from C. Buss Co on account a. Compute the maturity date of the note. Term of Note 10 11 12 13 Compute the maturity value of the note (use a 360-day year). 14 b 1) Compute the Interest on the note 15 16 Add the interest and the principle 2) 17 18 19 Record the receipt of payment on the note as of the maturity date from C. Buss Co 20 C Depreciation Uncollectible Accounts Notes Receivable Assets Bank Reconciliation Select destination and press ENTER or choose Paste Type here to search. ACCOUNTING FOR UNCOLLECTIBLE ACCOUNTS Present entres in general journal form, to record the folowing for an enterprise that makes advance provisions for uncolectible receivables Record the adusting entry at April 30th 2019 the end of the fiscal vear, to provide for bad debt exper The accounts recewable account has a debit balance of $540,000 and the allowance account, before adustment, has a credit balance of $2,000. The alowance account is figured usin) the percentage of sale method, the curent rate is 1.5% of sales Sales for the year were $1,430,000 On June 15, 2018, the $860 owed by Gantt Company on account is wnitten off as uncolectble On November 15, 2018, S650 of the Gantt Company account is reinstated and payment of that amourt is receved Based on the data above, what is the expecded net realizable value of the accounts recevable as reported on the balance sheet as of December 31,20 JOURNAL ENTRIES Accounts Date DR 019 O Nates Recervable ASsetc Deprecation Uncollectible Accounts Bank Reconcilation estination and press ENTER or choose Paste x O Type here to search CR A patent was acquired for $600,000 on March 1st and expires in 10 years. It is expected to have value G Hi AMORTIZATION/ DEPLETION JOURNAL ENTRIES A patent was acquired for $600,000 on March 1st and expires in 10 years. It is expected to have value for 7 years. Present the adjusting entry to amortize the patent for the first year assuminga calendar year. Round your answer to the nearest dollar. An oil field was discovered and it is estimated that 800,000 barrels are proven. The land was acquired for $1,980,000 and $50,000 in taxes were paid. Present the adjusting entry to record depletion for the current year, during which 70,000 barrels of oil was removed. JOURNAL ENTRIES CR DR Accounts Date a. b Depreciation Assets Uncollectible Accounts Notes Receivable Bank Reconciliation destination and press ENTER or choose Paste Type here to search