accounting excel document due today at 3 30 pm ms time 495038

P08-01A Given P08-01A Problem 7-4A Instructions Student Name: Class: Cash price for all assets purchased Estimated market values: Building Land Land improvements Schedule Appraised Percentage Apportioned Useful life in years Value of Total Cost Salvage value Building Land Land Improvements Vehicles Totals General Journal Trans. Date Account Titles no. Debit Credit Cash Straight-line depreciation on building = Double-declining-balance depreciation on land improvements = Building: Land improvements useful life in years Part 2: Part 3: Vehicles (4) Check figures: (2) (3) Part 4: Defend or refute this statement: Accelerated depreciation results in payment of less taxes of the asset’s life. Jan. 1 XAVIER CONSTRUCTION To record asset purchases. Given Data P08-01A: Problem 08-01A Part 1 Calculation of the estimated balance of the allowance for uncollectibles Not due: 1 to 30: 31 to 60: 61 to 90: Over 90: Part 2 Dec. 31 Part 3 To record estimated bad debts.* Bad Debts Expense Allowance for Doubtful Accounts Unadjusted balance Required adjustment Problem 7-4A Category A/R Amount Uncollectible GB 518 Unit 04 Assignment Student: Estimated balance * Computations –> The Template is provided to help you complete your assignment successfully. Enter you Name here ======> There are hints and guidance within the templates. For Example, some fields will have a note attached – as designated by the red triangle in the upper right corner of the cell. Some final cell totals or answers will give you a notice if the answer is correct. For example, if you have gotten the right answer, you may see a note “Correct”, or “Good!” appear beneath or to the side of that cell. But, not all exercises or problems will provide feedback. So, be sure you do your best on all of the assignments. And, if you have any questions, please do not hesitate to bring your questions to…