Accounting excel: See uploaded attachments.

User Generated

pelfgnyjm8q

Business Finance

Description

See uploaded attachments. The attachments should be in the correct order, however, they are labeled and numbered.

Unformatted Attachment Preview

Problem - A Merchandise the month of November 2010. In addition, you will complete In this problem will put ons involving fixed assets for have already been entered and posted into the computer and are included in the the monthly conscycle. The monthly transactions not related to fixed this problemi. Display reports as necessary to answer the questions. Remember to opening balance file. Answer Audit Questions 6-A on page 283 as you complete click Info on the toolbar for helpful check figures to audit your work. Step 1: Start Integrated Accounting 7e. Load the opening balances template file, IA7 Problem 06-A, Enter your name in the Your Name text box and click OK. Step 2: Step 4: Save the data to your disk as 06-A Your Name. Step 5: Delete asset no. 200, CP85 Ink Jet Printer. Step 6: Change the name of asset no. 280 to Facsimile Machine. Step 7: Enter the fixed asset data in Account Maintenance. Fixed Assets Transactions Nov. 04, 2010 Purchased a Binding Machine for $495.95; asset number, 215; depreciation method, double-declining balance; useful life, 6 years; salvage value, $50.00; accumulated depreciation, account number 1521; depreciation expense, account number 6520. Nov. 10, 2010 Purchased a K6 Telephone System for $5,175.00; asset number, 290; depreciation method, straight-line; useful life, 7 years; salvage value, $500.00; accumulated depreciation, account number 1521; depreciation expense, account number 6520. Nov. 12, 2010 Purchased a File Cabinet for $385.00; asset number, 370; depreciation method, MACRS; useful life, 7 years; salvage value, $45.00; accumulated depreciation, account number 1531; depreciation expense, account number 6525. Nov. 14, 2010 Purchased Shelving for $615.50; asset number 380; depreciation method, straight-line; useful life, 10 years; salvage value, $75.00; accumulated depreciation, account number 1531; depreciation expense, account number 6525. Nov. 20, 2010 Purchased a Pickup Truck for $11,995.00; asset number, 140; depreciation method, straight-line; useful life, 5 years; salvage value, $1,175.00; accumulated depreciation, account number 1511; depreciation expense, account number 6130. An Purchased a HC-2530 Computer for $2,865.00; asset number, 225; depreciation method, double-declining- balance; useful life, 5 years; salvage value, $250.00; accumulated depreciation, account number 1521; depreciation expense, account number 6520. Use the general Journal to enter and post the following assets to the general ledger. Discarded asset no. 200, CP85 Ink Jet Printer (Office Equipment) bought in January, 2004: cost, $375.00; total accumulated depreciation recorded to December 31, 2008, $375.00. Memo No. 113. Paid cash for Binding Machine, $495.95; Check No. 3839. Nov. 10, 2010 Paid cash for K6 Telephone System, $5,175.00; Check No. 3840. Nov. 12, 2010 Paid cash for File Cabinet, $385.00; Check No. 3841. Nov. 14, 2010 Paid cash for Shelving, $615.50; Check No. 3842. Nov. 20/2010 Paid cash for Pickup Truck, $11,995.00; Check No. 3843. Nov. 25, 2070 Paid cash for HC-2530 Computer, $2,865.00; Check No. 3844. Step 9: Display a General Journal report. (Make sure the date on the Report Selection menu is set to 11/30/10.) Step 10; Display a fixed assets list. Step 11: Display a depreciation schedule for each of the new assets pur- chased in November. Step 12: Display the trial balance. End-of-Month Activities The depreciation adjusting entries are automatically generated from the fixed assets information. The rest of the adjusting entries must be entered separately into the computer. Savoy Merchandise Co., had the following adjustment data for November Insurance expired during November .......... $345.00 Inventory of supplies on November 30 ..... $2,065.50 81450 Step 1: Enter the adjusting entries. . Step 2: Generate and post the depreciation adjusting entries. Step 3: Display the adjusting entries (use 11/30/10 as both the start and end dates). per the check on the toolbar to check your work Step 5 Display the income statement. Step : Display the statement of owner's equity. Step 7: Display the balance sheet. Generate Depreciation Comparison graphs for the K6 Tele- Truck. Step 9: Save your data to disk. Step 10: Optional spreadsheet Integration activity. of the three depreciation methods discussed in this chapter. Copy and Generate depreciation schedules for asset 140-Pickup Truck using each paste each schedule into a spreadsheet template to obtain comparison information. a. Display and copy the depreciation schedule for asset 140-Pickup Truck to the clipboard in spreadsheet format. b. Start your spreadsheet software and load template file IA7 Spread- sheet 06-S. c. Select cell Al as the current cell and paste the Pickup Truck depre- ciation schedule into the spreadsheet. d. Copy the year from cells B10-B15 to cells B29-B34. Copy the annual depreciation from cells C10-C15 to the appropriate column (i.e., copy to cells C29-C34 if the depreciation schedule uses the straight-line method, copy to cells D29-D34 if the double-declining- balance method is used, and so on). e. Return to Integrated Accounting 7e, click Accts on the toolbar, and change the depreciation method for asset 140-Pickup Truck. Repeat steps c and d for each of the remaining depreciation methods. f. Print the comparison report (cells A22-F34). g. Save the spreadsheet data to your disk with a file name of 06-A Your Name. Do not save the changed Integrated Accounting 7e data. Step 11: Optional word processing integration activity. Prepare a memorandum to the manager of the accounting department that shows depreciation comparison information from the preceding spreadsheet activity. a. Start your word processing software application and create a new document. (If your software has templates, load a memorandum format.) 6 PM 10/2/2018 FA Chape Enter the memorandum heading information using Figure 6.26 as a guide. Copy and paste the spreadsheet comparison report (cells A26-F34) into the body of the memorandum. c. Print the memorandum. d. Save the memorandum to your disk with a file name of 06-A Your Name. End your word processing and spreadsheet sessions. If you have access to the Internet, use your browser to find fixed asset management software. Hint. Use Depreciation as a search argument. Report your findings. Be sure to indicate the sources, including the URLS (Web addresses), of your reported findings. INTERNET ACTIVITY Step 12: End the Integrated Accounting 7e session. (Do not save the data.)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Th...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags