fe PEAK X D2L 11.05 Graded Assignment: Accol X + X C n & https://fueled.brightspace.com/d21/le/content/1964483/viewContent/107867841/View R To ... Downloads B Q ... 8) A fueleducation" Accounting - SP21-DCHSP4347 (Part 1) ..... ..... CI 8478537.xisx Open file Clans HamA CalAndAN Contant AutoSave @ Of) H 9 0 8478535 (1) - Protected View . Saved to this PC Search (Alt+Q) Charlie I CI utoSave . Off) 8478537 - Protected View O Search (Alt+Q) Charlie I CI X ferences Mailings Review View Help Home Insert Page Layout Formulas Data Review View Help Comments Share iruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X hplete the following activities. X V al score: of 60 points B C D E F G H _points) Account Title Debit Credit Debit Credit Debit 1. Prepare a worksheet for Brown's Plumbing and Heating. Cash $ 21,980.00 Start Microsoft Excel, and open the BUS113_11_05.xisx file from C:\\ACTT1\\Data\\Unit_11. Petty Cash 300.00 Click the File tab, and click Save As. Save the file to C:\\ACTT1\\Student\\Unit_11. C. Navigate to the Worksheet spreadsheet tab. d. Write the heading for the worksheet for the fiscal period ending December 31, 20xx. e. Record the trial balance using the accounts and their balances from the Ledger tab. Some are done for you. f. Calculate and record the Supplies adjustment. There is $5,600.00 in supplies on hand at the end of the fiscal year. g. Calculate and record the Insurance adjustment. There is $900.00 of insurance coverage left at Income Summary the end of the fiscal year. Sales $ 49,000.00 h. Prove the Adjustments columns i. Extend all balance sheet account balances. j. Extend all income statement account balances. k. Calculate and record the net income or loss. 1. Total and rule the Income Statement and Balance Sheet columns. m. Save and close the spreadsheet. n. Submit your file to your instructor for grading- ring Guide Net Income eria Points Points Possible | Earned bared a worksheet correctly 60 I Points 50 Ledger Work Sheet [ Focus 125% Type here to search O X 77OF Clear ^ () 9 2 7 2:55 AM 7/22/2022AutoSave . Off) H 9 8478537 - Protected View Search (Alt+Q) Charlie I CI X File Home Insert Page Layout Formulas Data Review View Help Comments Share 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H69 : X V fx ABCD E F G H K L M N O P Q R S T U V W X ACCOUNT Ray Brown, Capital ACCOUNT NO 310 49 POST. BALANCE 50 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 51 Dec. ######## ######## 53 54 55 ACCOUNT Ray Brown, Drawing ACCOUNT NO 320 57 POS BALANCE 58 DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT 59 60 Dec. ######## #######: 61 62 63 ACCOUNT Income Summary ACCOUNT NO 65 POST BALANCE 66 DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT 67 68 69 70 71 ACCOUNT Sales ACCOUNT NO 410 73 POST BALANCE 74 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 75 76 Dec 31 ######## ######## 77 78 79 ACCOUNT Advertising Expense ACCOUNT NO. 510 81 POST BALANCE 82 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 83 84 Dec 9 ######## ######## 85 86 87 ACCOUNT Insurance Expense ACCOUNT NO 520 89 POST BALANCE an DATE ITEM DEE DERIT CREDIT DEBIT CREDIT Ledger Work Sheet Ready 125% O w X 77.F Clear ~ () 9 2 7 2:55 AM Type here to search 7/22/2022AutoSave . Off H 9 8478537 - Protected View Search (Alt+Q) Charlie I CI X File Home Insert Page Layout Formulas Data Review View Help Comments Share 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H69 X V ABC D E F G H K L M N 0 P Q R S T U V W X 77 78 79 ACCOUNT Advertising Expense ACCOUNT NO 510 81 POST BALANCE 82 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 83 84 Dec 9 ######## ######## 85 86 ACCOUNT Insurance Expense ACCOUNT NO. 520 89 POST BALANCE 90 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 92 93 94 ACCOUNT Miscellaneous Expense ACCOUNT NO. 530 96 POST BALANCE 97 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 98 99 Dec $ 780.00 $ 780.00 100 101 102 ACCOUNT Supplies Expense ACCOUNT NO 540 104 POST BALANCE 105 DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT 106 107 108 109 110 ACCOUNT Utilities Expense ACCOUNT NO 550 112 POST BALANCE 113 DATE ITEM REF DEBIT CREDIT DEBIT CREDIT 114 115 Dec 9 ######## ######## 116 117 118 119 Ledger Work Sheet Ready 125% Type here to search x 77.F Clear ~ () 927 2:55 AM 7/22/2022