AutoSave . Off) - GA 8488597 - Compatibility Mode . Saved to this PC v Search (Alt+Q) Charlie I CI File Home Insert Draw Design Layout References Mailings Review View Help Comments Share X Cut Find Aria 10 ~ A" A Aa Ap AaBbCcDI A. AaBbC AaBbCCD AaBbCCD AaBbCcDo 1. AaBbC 1. AaBbC AaBbCcDdE AaBbCcDdE AaBbCcD AaBbCcI AaBbCcD AaBbCcDdi Paste [A Copy Replace List_Num... Mut_Choi.. Name_Date 1 Normal Points Question_... Question_... Running_.. Running_.. Short_Pas... Student_R... Total_Score Underline Dictate Editor Format Painter B I U~ ab x x A LA Select Clipboard Font Paragraph Styles Editing Voice Editor Name Date: Part 3: Preparing a Stockholders' Equity Statement 1. Prepare a statement of stockholders' equity for Al-Can Products, Inc. Graded Assignment 2. Navigate to the Stockholders' Equity Statement tab in the spreadsheet. Final Project 3 3. Use the following information to prepare your statement: Complete the following activities. a. January 1 balance of capital stock account of 9,000 shares issued at $6.00 per share was $54,000.00. Total score:_ of 60 points b. No other stock was issued during the year. c. January 1 balance of retained earnings account was $29,250.00. (10 points) Part 1: Calculating Maturity Dates and Interest d. Net Income was $41, 106.00. 1. For each note below, calculate and record the maturity date and interest. e. Dividends declared during the year were $19,200.00. 4. Save and close the spreadsheet. No. of Note Date of Note Principal Interest Rate Time of Note | Maturity Date Interest . Submit to your instructor for grading. Mar. 5 $700.00 14% 180 days 2 Mar. 16 $1,500.00 10% 120 days Scoring Guide 3 Apr. 12 $650.00 1% 90 days Criteria Points 4 May 9 $1,800.00 12% 60 days Possible | Earned Part 1: Calculated maturity dates and interest amount accurately. 10 Part 2: Journalized transactions related to notes payable and receivable, (30 points) 30 accrued revenue and expenses, and dividends correctly Part 2: Journalizing Notes Payable and Notes Receivable, Accrued Revenue and Expenses, and Dividend 20 Transactions Part 3: Prepared a statement of stockholders' equity correctly. 60 1. Journalize the following business transactions Total Points a. Start Microsoft Excel, and open the BUS114_15_03.xIsx file from C:\\ACTT2\\Data\\Unit_15. Click the File tab, and click Save As. Save the file to C:\\ACTT2\\Student\\Unit_15. c. Navigate to the appropriate spreadsheet tab for the journal in which you will post. d. Journalize the following transactions i. February 1. Signed a 60-day, 10% note, $5,000.00. R80. ii. April 2. Paid cash for the maturity value of the Feb. 1 note: principal, $5,000.00, plus interest, $83.33. C215. iii. April 20. Received cash for the maturity value of Notes Receivable No. 34: principal $500.00, plus interest, $45.00. R78. iv. June 1. Signed a 90-day, 18% note to True North Toilets Corp. for an extension of time on this account payable, $2,500.00. M44 V. December 15. The board of directors declared a dividend of $5.00 per share; capital stock issued is 3,000 shares. M234. vi. December 31. Paid cash for dividend declared December 15. C345. e. Save your work and close the spreadsheet or continue to Part 3. Page 1 of 2 420 words [ Text Predictions: On Accessibility: Good to go Focus - + 100% 79F Mostly cloudy ~ (>) 9 28 9:42 PM Type here to search O W X 8/19/2022AutoSave Off H 9 8488600 (1) - Protected View v 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 A1 X V fox A B C DE F G H J K L M N P Q R S T U Page 1 GENERAL JOURNAL DOC. POST GENERAL SALES CASH OUT A W N DATE ACCOUNT TITLE NO. REF. DEBIT CREDIT CREDIT DEBIT CREDIT Jun. 1 Accounts Payable/True North Toilets Corp. M44 $ 2,500.00 Notes Payable $ 2,500.00 Dec. 15 Dividend M234 $ 15,000.00 Dividends Payable $ 15,000.00 10 11 12 13 29 30 31 32 33 34 General Journal Cash Payments Journal Cash Receipts Journal Stockholders' Equity Statement Ready 125% Type here to search O W X 79F Mostly cloudy ^ () 91 2 9:42 PM 8/19/2022AutoSave . Off H 9 8488600 (1) - Protected View v 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 B1 X v fx A B C D E F G H J K L M N O P Q R S T U A Page 1 CASH PAYMENTS JOURNAL N ACCOUNTS PURCHASES DATE ACCOUNT TITLE CHECK POST GENERAL PAYABLE DISCOUNT CASH NO. REF . DEBIT CREDIT DEBIT CREDIT CREDIT 21 23 24 25 26 27 28 29 General Journal Cash Payments Journal Cash Receipts Journal Stockholders' Equity Statement D Ready 125% Type here to search O G W X 79F Mostly cloudy ^ () 9 2 9:42 PM 8/19/2022AutoSave . Off H 9 8488600 (1) - Protected View v 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 B1 X v fx A B C D F G H J K L M N 0 P Q R S CASH RECEIPTS JOURNAL N DOC. POST GENERAL ACCOUNTS SALES SALES TAX PAYABLE CASH DATE ACCOUNT TITLE RECEIVABLE NO. REF. DEBIT CREDIT CREDIT CREDIT DEBIT CREDIT DEBIT 21 22 23 24 25 26 27 28 29 General Journal Cash Payments Journal Cash Receipts Journal Stockholders' Equity Statement Ready 125% Type here to search O G W X 79F Mostly cloudy ^ () 9 2 9:42 PM 8/19/2022AutoSave . Off H 9 8488600 (1) - Protected View v 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 Al 1 X fx Al-Can Products, Inc. B D E F G H J K L M N O P Al-Can Products, Inc. Statement of Stockholders' Equity W N For Year Ended December 31, 20xx Total Capital Stock: Retained Earnings: Stockholders' Equity: 21 30 31 32 33 34 35 General Journal Cash Payments Journal Cash Receipts Journal Stockholders' Equity Statement Ready 125% Type here to search O W X 79F Mostly cloudy ^ () 9 2 9:42 PM 8/19/2022