1 2 3 4 7 30 31 31 32 32 33 59 34 344 35 39...

Transcribed Image Text:

1 2 3 4 7 30 31 31 32 32 33 59 34 344 35 39 36 30 37 57 3.8 30 39 33 40 40 41 41 42 42 43 45 44 44944 45 43 46 40 47 47 48 TO 49 43 50 50 51 51 52 52 53 53 54 34 55 55 56 57 58 * 59 63 64 65 66 67 68 69 70 71 4 2374557 78 79 80 81 76 AutoSave OFF Home Insert Paste C5 A Clipboard X (19 Cash & Equivalents FV-NI Investments Accounts Receivable - Trade Accounts Receivable - Projects Other Accounts Receivable B Interest Receivable A Allowance for Doubtful Accounts Inventory Inventory Inventory on Consignment p Prepaid Insurance EVOC FV-OCI Investments Construction in Process consu Land P Building Paldies Building - Accumulated Depreciation P P Equipment Equipment- Accumulated Depreciation Equipm Intangible Assets mencaristo Intangible Assets- Accumulated Amortization Goodwill Interest Payable Dividends Payable Billings on Contract Wages Payable Notes Payable Notes Payable Bank Loan Danik Loan Accumulated Impairment Loss - Goodwill Accounts Payable Deferred Tax Liability HOT DA HST Payable P Common Stock Common Retained Earnings Revenue from Consignments Sales Revenue Sales Revenue - Equipment Dividend come Dividend Income B Revaluation Surplus - OCI Revenue from Long-term Contract (2019) Revenue from Long-term Contract - Project #1 Revenue from Long-term Contract - Project #2 Interest Income interest mome Gain/ (Loss) on sale of truck Unrealized Gain or Loss - FVNI Unrealized Gain or Loss - OCI onrealized Gain or Cost of Goods Sold Cost Of 9000 sold Construction Expenses (2019) Construction Expenses - Project #1 Construction Expenses- Project #2 Wages Wages Payroll Tax Expense P Interest Expense www.com Utilities Duitics Loss on Impairment Equipment Rental (other expenses) Equipment Repairs (other expenses) Income tax expense mcome.co Insurance Expense wearics Calibri (Body) B I U Bad Debt Expense H Commission Expense Advertising Expense Draw Page Layout TOTALS Net Income (Loss) TOTAL Administration Expenses Amortization Expense (other expense) Depreciation Expense (other expenses) DO NOT WRITE IN THIS AREA C fx 886487 1,895,740 Trial Balance At December 31, Y6 Debit Credit 886487 475,539 V 120,000 655,000 3,195,000 389,105 675,000 3,717,400 2,360,100 501,366 48,786 675,960 81,115 165,900 60,120 wap.co 160,000 68.901 3,150 10,622 173,936 D Revenue Expenses Net Income Font 208,778 104,853 525,000 94,100 100,000 16,500 3,200,000 2,000,000 1,007,407 3,206,449 5,855,690 450 V 11 0 V 0 E | 409,476 394,637 Unadjusted Trial Balance At December 31, Y7 Debit Credit 2,098,249 1,623,000 515,040 142,970 300,000 4,425,000 655,000 3,195,000 505,760 31,400 675,000 4,513,400 476,960 84,660 692,905 86,613 519,980 120,000 Formulas Data 157,610 V 6 208,778 104,853 246,300 370,990 3,845,000 750,000 5,000,000 2,000,000 2,042,640 $16,319,227 $16,319,227 $21,622,661 $21,622,661 $ 7,044,900 9,200 0 STUDENTS FIRST STEP Select destination and press ENTER or choose Paste G Adjustments Debit Grading Summary H Credit Debit Review === Adjusted Trial Balance Credit View Trial Balance ACCT 3036 Project F23.xlsx Automate Developer Alignment K L Income Statement Debit Credit ab Wrap Text v Merge & Center M N Balance Sheet Debit Credit Financial Statements O DO NOT USE THIS AREA General P Read-Only - Saved to my Mac V Tell me % 9 Q Number R S Notes to the Financials T .00 .0 U Conditional Format Formatting as Table Styles V W X Journal Entries Y Z Cell Styles AA AB Insert AC Cash & Equivalents AD Delete Cells D AE AF Format AG AH O | A Al I Comments AJ Sort & Find & Filter Select Editing TradeAccounts Receivable Detail 0. AK AL AM D AN Share Analyze Data Assistance BOD AO + + 50% AP D 2 - C Home Insert Draw Page Layout X 123456 7 8 9 10 11 12 13 14 15 16 F24 17 18 19 20 21 22 23 24 25 26 AutoSave OFF 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 12 Paste Clipboard A DO NOT USE THIS AREA O X B Calibri (Body) B I U v fx C add rows as needed add rows as needed add rows as needed V V Font 11 D Formulas Data Review V V A^ A A Aylmer Industries Inc. Statement of Comprehensive Income For the Year Ended December 31, Y7 Aylmer Industries Inc. Statement of Retained Earnings For the Year Ended December 31, Y7 Aylmer Industries Inc. Statement of Financial Position At December 31, Y7 STUDENTS FIRST STEP Grading Summary Select destination and press ENTER or choose Paste E NOTE F Trial Balance View ACCT 3036 Project F23.xlsx Automate Developer Alignment G Y7 Y7 Y7 Wrap Text v Merge & Center H Y6 Y6 Y6 Financial Statements Read-Only Saved to my Mac Custom | Tell me $ % 9 V Number J 00 K Notes to the Financials .00 0 V Conditional Format Cell Formatting as Table Styles Styles L M Journal Entries N O Insert Cash & Equivalents P Delete Cells Format Q R O Al I Comments S V TradeAccounts Receivable Detail O. Sort & Find & Filter Select Editing T P + U Share Analyze Data Assistance BOD + 100% V D 2 - C Home Insert Draw Page Layout X (19 1 2 3 4 5 6 7 8 9 10 11 12 13 AutoSave OFF G2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A DO NOT USE THIS AREA B Calibri (Body) B I U fx C D Notes to the Financial Statements V Font 1 Cash and Cash Equivalents 4 Inventories (net) V 2 Short-Term Investments 3 Accounts Receivable (net) 8 Goodwill 7 Intangible Assets (net) 11 E 6 Property and Equipment (net) Formulas Data V V A^ A 5 Construction in Process/Billings on Contract A F STUDENTS FIRST STEP Grading Summary Select destination and press ENTER or choose Paste G Review H Please add rows as needed Trial Balance View ACCT 3036 Project F23.xlsx Automate Developer Alignment Wrap Text Merge & Center I Financial Statements J Read-Only - Saved to my Mac Custom K Tell me $ % 9 V Number L 00 Notes to the Financials .00 0 M V Conditional Format Cell Formatting as Table Styles Styles N Journal Entries O P Q Insert Cash & Equivalents Delete R Cells D Format 8 S T O Al TradeAccounts Receivable Detail I Comments O. U V Sort & Find & Filter Select Editing V P W Share Analyze Data Assistance BOD + + 100% X D 2 - C Home Insert Draw Page Layout X AutoSave OFF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Paste B3 Clipboard A DO NOT USE THIS AREA DATE B Calibri (Body) B I U v C fx ACCOUNTS V V Font D 11 Formulas Data V V STUDENTS FIRST STEP Select destination and press ENTER or choose Paste A^ A A Grading Summary E F Review G Trial Balance View ACCT 3036 Project F23.xlsx Automate Developer Alignment H Debit Wrap Text Merge & Center I Credit J POSTED? Yes/No Financial Statements K Read-Only - Saved to my Mac General L Tell me $ % 9 V Number M Notes to the Financials 00 .00 0 N V Conditional Format Cell Formatting as Table Styles Styles O P Journal Entries Q R Insert S Cash & Equivalents Delete T Cells U Format V O Al W Comments O. I V TradeAccounts Receivable Detail Sort & Find & Filter Select Editing X Y D N Share Analyze Data Assistance BOD + + 85% AA D 2 - C Home Insert Draw Page Layout X 1 2 34567 T14 7 8 LO 00 9 AutoSave OFF 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A Xx B Calibri (Body) B I U fx C Petty Cash Bank of Montreal - Chequing Bank of Montreal - Deposit Royal Bank-Chequing Short-term paper (A) Short-term paper (B) Restricted Cash D Short-term paper (A) Short-term paper (B) Restricted Cash V V Font 11 Formulas Data V V E Unadjusted Trial Balance 300 10,326 312,022 67,480 40,000 409,476 A^ A A F Review View G Adjusted Adjustment Trial Balance STUDENTS FIRST STEP Grading Summary Select destination and press ENTER or choose Paste ACCT 3036 Project F23.xlsx Automate Developer Alignment H Trial Balance | Wrap Text v Merge & Center J K 4 month paper @ 10.25% interest with Hilo Investments - Purchased November 1, Y7. Financial Statements General Read-Only - Saved to my Mac $ % 9 V L Tell me Number M 40,000 45 day paper @ 10.80% interest - Purchased December 20, Y7. set aside for bank loan - have to maintain a minimum of 10% of bank loan payable in restricted cash per agreement 00 Notes to the Financials .00 .0 N V Conditional Format Cell Formatting as Table Styles Styles O Journal Entries P Q R Insert Cash & Equivalents S Delete Cells T Format U A V Comments Ou I V TradeAccounts Receivable Detail Sort & Find & Filter Select Editing W X P Share Analyze Data Assistance + BOD Y + 100% 1 2 3 4 2 Home Insert Draw Page Layout X (19 5 6 C3 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 AutoSave OFF 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Paste Clipboard A B Customer Name 4210119 Ont Ltd 43rd Street Place 6 Star Services 9900 International Corp A1 Distributions Aylmer Enterprises Booktime Services Box Top Inc Briar Forest Corp Cavhill Industries Colborne Corp Copper Gallery Dairy Ashford Corp Demilo Inc Dustin Enterprises Greenway Place Grosvenor Limited Houston Consultants Jesse Blackstone Joseph Company Lawrence Brothers Mapleton Express OKC Limited Oxford Distributing Paper Brands Plaid Corp Quality Logistics Calibri (Body) BI U TC Jester Wellington Limited Westella Drive LTD Woodplank Inc. Yellow Street Ltd Zephyr Limited TOTAL Calculations and Notes DO NOT USE THIS AREA For Grading Purposes fx Total Due 116,181 6,625 65,675 100,792 130,734 167,468 100,160 49,049 2,942 74,083 1,313 1,400 17,560 83,336 180,511 94,765 22,843 135,986 22,180 101,407 58,561 19,048 24,219 22,220 146,790 45,126 25,573 100,665 138,144 14,410 23,665 2,018 2,800 2,098,249 Font D V 11 0-30 Days 55,894 6,494 31,310 50,981 65,944 74,586 99,643 13,031 1,443 61,999 1,313 7,960 36,785 64,452 31,548 6,844 56,980 9,846 31,599 18,846 18,936 10,699 11,569 12,636 12,500 2,131 49,666 65,478 6,944 664 1,550 920,271 | E Formulas Data 31-60 days V 50,199 131 30,699 49,811 62,902 89,650 263 13,031 1,499 6,013 9,600 39,941 64,161 31,661 7,033 42,560 9,846 36,510 19,844 9,856 10,651 10,664 12,500 2,236 49,666 72,666 6,411 664 1,250 A^ STUDENTS FIRST STEP Select destination and press ENTER or choose Paste F A 61-90 days 5,094 944 3,232 100 13,031 5,960 6,610 50,344 31,556 8,966 36,446 1,494 32,649 19,460 112 3,664 36,944 12,500 2,066 1,333 1,055 690 741,918 274,250 Grading Summary G 91-120 days 4,994 3,666 944 154 9,956 111 1,400 994 649 411 Review H Over 120 1,554 46,546 40,000 131 7,495 2,699 16,441 12,600 11,065 === 85,255 76,555 I View Trial Balance ACCT 3036 Project F23.xlsx Automate Developer Alignment J ab Wrap Text v K Merge & Center L M Financial Statements N General V Read-Only - Saved to my Mac O Tell me % 9 Number P Q Notes to the Financials .00 .0 R Conditional Format Formatting as Table Styles S T Journal Entries U Cell Styles V W Insert Cash & Equivalents X Delete Cells Y Format 898 Z AA O | "I A AB TradeAccounts Receivable Detail I Comments AC 0. Sort & Find & Filter Select Editing AD AE P Share Analyze Data BOD Assistance AF + + 75% AG 2 Home Insert Draw Page Layout X (19 1234567 B6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 AutoSave OFF 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A Calibri (Body) B I U 6/15/Y7 12/05/Y7 B fx Purchase Date DO NOT USE THIS AREA For Grading Purposes V 11 V Font Formulas Data V Record Calculations here: Grading Summary Trial Balance Select destination and press ENTER or choose Paste C Review Description 17,340 shares of Redemption Corp @ $12.45 per share 8,140 shares of ALM Corp @ $21.96 per share === View Financial Statements ACCT 3036 Project F23.xlsx Automate Developer Alignment D ab Wrap Text v COST 215,883.00 178,754.40 394,637.40 Merge & Center E Notes to the Financials F General V Read-Only - Saved to my Mac G Tell me % 9 Number Journal Entries H .00 .0 I Conditional Format Formatting as Table Styles J Cash & Equivalents K Cell Styles L M Insert Delete Cells N TradeAccounts Receivable Detail Format O 1888 O P | II A FV-NI Investments I Comments Q Sort & Find & Filter Select Editing 0. R S Inver Share Analyze Data Assistance BOD + + 100% T Home Insert 1 2 3 4 5 6 AutoSave OFF 7 8 9 10 11 12 13 14 15 16 17 18 G15 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard X (19 A Item # Draw Page Layout Calibri (Body) BI U fx B C Inventory Items on Hand Description 2 14566SA X205 30 HP Machine 145669A X205 30 HP Machine 147502A X205 30 HP Machine 147503A X205 30 HP Machine 147504A X205 30 HP Machine 360010X G350 60 HP Machine 360011X G350 60 HP Machine 360012X G350 60 HP Machine 360013X G350 60 HP Machine 598750W L500 100HP Machine 598751W L500 100HP Machine 598752W L500 100HP Machine Trial Balance V 11 V Font | D Cost Formulas Data Review V E Selling Price Financial Statements Select destination and press ENTER or choose Paste 13,700.00 49,250.00 12,950.00 13,700.00 12,950.00 13,700.00 12,950.00 13,700.00 12,950.00 13,700.00 12,950.00 37,850.00 37,850.00 49,250.00 37,850.00 49,250.00 37,850.00 49,250.00 99,630.00 102,950.00 99,630.00 102,950.00 99,630.00 102,950.00 515,040.00 F === Selling costs 0.0% of selling price View Notes to the Financials G Market ACCT 3036 Project F23.xlsx Automate Developer Alignment ab Wrap Text v H Merge & Center Journal Entries 1 LCM J Read-Only - Saved to my Mac General V Tell me % 9 K Number Cash & Equivalents L .00 .0 M Conditional Format Formatting as Table Styles N O Cell Styles TradeAccounts Receivable Detail P Insert Delete Q Cells R Format DO NOT USE THIS AREA For Grading Purposes FV-NI Investments O D S "I Comments I Inventory Detail Sort & Find & Filter Select Editing T 0. D U Inver + Share Analyze Data Assistance V BOD + 100% Home Insert D4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 AutoSave OFF 25 26 27 28 Paste 29 30 31 32 33 34 35 36 37 38 39 40 41 42 X (19 Clipboard A D X B Item # Draw Page Layout Calibri (Body) B I U fx C V 2 Description PK0366 X105 15 HP Machine PK0367 X105 15 HP Machine PK0368 X105 15 HP Machine PK0369 X105 15 HP Machine PK0370 X105 15 HP Machine PK0371 X105 15 HP Machine PK0372 X105 15 HP Machine PK0373 X105 15 HP Machine PK0374 X105 15 HP Machine PK0375 X105 15 HP Machine X105 15 HP Machine PK0376 JH14456 J050 5 HP Machine JH14457 J050 5 HP Machine JH14458 J050 5 HP Machine JH14459 J050 5 HP Machine JH14460 JH14461 J050 5 HP Machine J050 5 HP Machine V 11 V Font | D Cost Formulas Data Review V 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 5,770.00 5,770.00 5,770.00 5,770.00 5,770.00 5,770.00 142,970.00 Notes to the Financials Select destination and press ENTER or choose Paste Journal Entries E F === G View Cash & Equivalents ACCT 3036 Project F23.xlsx Automate Developer Alignment H ab Wrap Text v | Merge & Center J K General V Read-Only - Saved to my Mac TradeAccounts Receivable Detail Tell me % 9 L Number M .00 .0 N Conditional Format Formatting as Table Styles OFV-NI Investments O Cell Styles P DO NOT USE THIS AREA For Grading Purposes Inventory Detail Insert Delete Q Cells Format R S Inventory on Consignment O | 61 I Comments T 0. Sort & Find & Filter Select Editing U V Share Analyze Data BOD Assistance Fixed Asset Details + W + 100% Home Insert 1234 15 4 AutoSave OFF Paste 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 X (19 Clipboard B Land Building Asset Category Number Equipment Calibri (Body) BI U C Y4-01 Y5-09 Y5-09 Draw Page Layout Y4-02 Y4-03 Y4-04 Y4-05 Y4-06 Y4-07 Y4-08 Y5-10 Y5-11 Y5-12 Y5-13 Y5-14 Y5-15 Y7-16 Y7-17 Y7-18 fx 2 D 401 Main Street 410 Main Street 406 Main Street 1 wagon Ford F150 TOTAL 1 acre-11th Line 401 Main Street .5 acre 402 Main Street Loader Grader Flat-bed Trailer Grader V 11 Description Journal Entries V Ford F150 Truck Dodge Ram Truck Toro lawn mower John Deere Excavator Cat Backhoe Case Tractor 3 wagons Chev Truck Toyota Tundra Kenworth Font Formulas Data Review V 05/31/Y5 09/01/Y4 09/01/Y4 Acquisition Date 09/01/Y4 02/1/5 08/1/Y5 02/01/Y4 03/31/Y4 06/30/Y4 09/01/Y4 09/01/Y4 10/01/Y4 Cash & Equivalents Select destination and press ENTER or choose Paste 10/01/Y4 03/01/Y5 05/31/Y5 07/31/Y5 08/01/Y5 12/01/Y5 12/01/Y5 05/01/Y7 07/01/Y7 12/31/Y7 E F === Useful Life (Yrs) 30 30 30 View 6 6 5 14 14 14 4 6 6 6 10 10 10 10 4 6 G ACCT 3036 Project F23.xlsx Automate Developer Alignment Cost 285,000.00 250,000.00 120,000.00 655,000.00 1,655,000.00 440,000.00 1,100,000.00 3,195,000.00 8,700.00 15,500.00 2,250.00 41,500.00 12,300.00 9,800.00 3,300.00 35,600.00 18,750.00 220,500.00 98,660.00 8,400.00 12,300.00 16,800.00 1,400.00 505,760.00 $ 4,355,760.00 $ TradeAccounts Receivable Detail ab Wrap Text v Merge & Center H Accumulated Depreciation to 12/31/Y6 128,722.22 28,111.11 51,944.44 208,777.78 4,229.17 7,104.17 1,125.00 6,916.67 2,050.00 1,575.00 1,856.25 10,877.78 4,947.92 52,062.50 9,866.00 910.00 1,332.50 104,852.94 313,630.72 General I Depreciation Expense Y7 FV-NI Investments Read-Only - Saved to my Mac V Tell me % 9 Number J Accumulated Depreciation to 12/31/Y7 .00 .0 K Conditional Format Formatting as Table Styles Adjustments to 12/31/Y7 Inventory Detail L NBV Cell Styles M Inventory on Consignment Insert Delete N Cells O Format P Fixed Asset Details O Al I Comments Q DO NOT USE THIS AREA For Grading Purposes 0. Sort & Find & Filter Select Editing FV-OCI Investments Analyze Data Share R Assistance BOD + + 100% S 2 Home Insert Draw Page Layout X (19 AutoSave OFF Paste D5 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 12 Clipboard A O X B Calibri (Body) BI U Purchase Date 6/15/Y7 V 11 V Font Formulas C Notes and Calculations here: V fx + Trial Balance'!D83*1.8 Description 18,000 shares of Hub Cap Company Cash & Equivalents Select destination and press ENTER or choose Paste Data Review TradeAccounts Receivable Detail D X ACCT 3036 Project F23.xlsx Automate Developer = = = COST View Alignment E ab Wrap Text v Merge & Center F FV-NI Investments (2 G General V H Read-Only - Saved to my Mac Inventory Detail Tell me % 9 Number I .00 .0 J Conditional Format Formatting as Table Styles K L Inventory on Consignment Cell Styles DO NOT USE THIS AREA For Grading Purposes Insert Delete M Fixed Asset Details Cells N Format 1888 O O FV-OCI Investments "I | P I Comments 0. Sort & Find & Filter Select Editing Q R Intangible As + Share Analyze Data Assistance S BOD + 100% 2 Home Insert Draw Page Layout X (19 1 2 3 F5 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 AutoSave OFF 12 Paste Clipboard A X B Item Calibri (Body) B I U Trademark Patent fx C Date Developed Y7-01-01 Y7-01-01 V 11 Font D Cost | Formulas Data 31,400 V 8 Yrs 31,400 5 yrs E Useful Life TradeAccounts Receivable Detail Select destination and press ENTER or choose Paste F Amortization Y7 Review G Accumulated Amortization to 12/31/Y7 FV-NI Investments View === ACCT 3036 Project F23.xlsx Automate Developer Alignment H Carrying Value ab Wrap Text v Merge & Center Inventory Detail I J Read-Only - Saved to my Mac General V Tell me % 9 K Number Inventory on Consignment L .00 .0 M Conditional Format Formatting as Table Styles N Cell Styles Fixed Asset Details O DO NOT USE THIS AREA For Grading Purposes Insert Delete P FV-OCI Investments Cells Q = Format R O Intangible Assets III S I Comments 0. Sort & Find & Filter Select Editing T U Revenue Reco + Share Analyze Data Assistance V BOD + 100% D 2 - C Home Insert Draw Page Layout X (19 1 2 I34567 B2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 AutoSave OFF 50 51 52 53 CA Paste Clipboard A B Calibri (Body) B I U C Other project information Progress Billings: Project #1 Downtown Hotel & Shopping Centre Contract Price Collections Costs incurred in Y7 Estimated total costs to complete Project #2 - Factory & Warehouse Contract Price Font fx Project #1 - Downtown Hotel & Shopping Centre D V 11 Costs incurred in Y7 Estimated costs in Y8 Estimated costs in Y9 Estimated costs in Y10 Other project information Progress Billings: V Collections 31-May 31-Aug 30-Nov 01-Jul 09-Sep 01-Dec Formulas Data Review 25-Dec V V A A Av E $ $ $ F 9,000,000 FV-NI Investments Inventory Detail Select destination and press ENTER or choose Paste 2,800,000 700,000 695,000 750,000 596,500 625,000 $ 18,000,000 $ 1,625,000 $ $ $ 6,000,000 3,140,000 1,700,000 1,000,500 G H View includes costs incurred in Y7 ACCT 3036 Project F23.xlsx Automate Developer Alignment I Inventory on Consignment J Wrap Text v Merge & Center K L General Fixed Asset Details Read-Only Saved to my Mac M Tell me $ % 9 V Number N 00 O .00 .0 P FV-OCI Investments V Conditional Format Cell Formatting as Table Styles Styles Q R S Intangible Assets Insert T DO NOT USE THIS AREA For Grading Purposes Delete Cells U Format Revenue Recognition O V a W I Comments X V Payroll Details Sort & Find & Filter Select Editing O. Y D Z + Share Sale + BOD Analyze Data Assistance AA 82% 2 Home Insert Draw Page Layout X (19 123 G9 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 AutoSave OFF 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A D X Name Calibri (Body) B I U Brian Dennis Jane Ferris Lin Wang B Hannah Carter Jessica Lampman fx Larry Jones Amy Fanshawe-Grad Max Vance John Demilo Kevin St Clair Allison Brubaker Title V 11 Font V Sales Sales C President Controller | Formulas Data Review V Wage D E $ 136,000.00 annually $ 91,000.00 annually $ 78,000.00 annually $ 78,000.00 annually Supervisor $ 62,000.00 annually Supervisor $ 62,000.00 annually Accountant $ 43,000.00 annually Labourer $ Labourer $ $ Labourer Labourer $ 17.25 hourly 17.25 hourly 17.25 hourly 17.25 hourly FV-NI Investments Inventory Detail Select destination and press ENTER or choose Paste F View === ACCT 3036 Project F23.xlsx Automate Developer Alignment G Inventory on Consignment ab Wrap Text H Merge & Center I General Fixed Asset Details J Read-Only - Saved to my Mac V Tell me % 9 Number K L .00 .0 M FV-OCI Investments Conditional Format Formatting as Table Styles N Cell Styles O DO NOT USE THIS AREA For Grading Purposes Intangible Assets Insert Format Delete P Cells Q Revenue Recognition 88 B R II I Comments S Payroll Details Sort & Find & Filter Select Editing 0. T U Sales Share Analyze Data BOD Assistance + + 100% V 2 Home Insert Draw Page Layout X (19 1 2 3 4 5 6 7 8 9 10 AutoSave OFF A1 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Paste Clipboard A Units Sold Calibri (Body) B I U B fx 103 X205 30 HP Machine 43 G350 60 HP Machine 16 L500 100HP Machine C V 11 Selling Price V Font 32,400.00 47,900.00 103,000.00 | Formulas Data Review V D NOTE - For Information ONLY but DO NOT MAKE CHANGES Inventory Detail Select destination and press ENTER or choose Paste E Cost 3,337,200.00 13,500.00 1,390,500.00 2,059,700.00 35,900.00 1,543,700.00 1,648,000.00 98,700.00 1,579,200.00 7,044,900.00 4,513,400.00 Inventory on Consignment === F View ACCT 3036 Project F23.xlsx Automate Developer Alignment G Fixed Asset Details ab Wrap Text v Merge & Center H I J General FV-OCI Investments Read-Only - Saved to my Mac V Tell me % 9 K Number L .00 .0 M Intangible Assets Conditional Format Formatting as Table Styles N O Cell Styles P Revenue Recognition Insert Delete Q Cells R Payroll Details 88 Format S T | Sales Detail A Comments U 0. Sort & Find & Filter Select Editing V W Extra Sheet fo Share Analyze Data BOD Assistance + + 100% X 1 2 3 4 7 30 31 31 32 32 33 59 34 344 35 39 36 30 37 57 3.8 30 39 33 40 40 41 41 42 42 43 45 44 44944 45 43 46 40 47 47 48 TO 49 43 50 50 51 51 52 52 53 53 54 34 55 55 56 57 58 * 59 63 64 65 66 67 68 69 70 71 4 2374557 78 79 80 81 76 AutoSave OFF Home Insert Paste C5 A Clipboard X (19 Cash & Equivalents FV-NI Investments Accounts Receivable - Trade Accounts Receivable - Projects Other Accounts Receivable B Interest Receivable A Allowance for Doubtful Accounts Inventory Inventory Inventory on Consignment p Prepaid Insurance EVOC FV-OCI Investments Construction in Process consu Land P Building Paldies Building - Accumulated Depreciation P P Equipment Equipment- Accumulated Depreciation Equipm Intangible Assets mencaristo Intangible Assets- Accumulated Amortization Goodwill Interest Payable Dividends Payable Billings on Contract Wages Payable Notes Payable Notes Payable Bank Loan Danik Loan Accumulated Impairment Loss - Goodwill Accounts Payable Deferred Tax Liability HOT DA HST Payable P Common Stock Common Retained Earnings Revenue from Consignments Sales Revenue Sales Revenue - Equipment Dividend come Dividend Income B Revaluation Surplus - OCI Revenue from Long-term Contract (2019) Revenue from Long-term Contract - Project #1 Revenue from Long-term Contract - Project #2 Interest Income interest mome Gain/ (Loss) on sale of truck Unrealized Gain or Loss - FVNI Unrealized Gain or Loss - OCI onrealized Gain or Cost of Goods Sold Cost Of 9000 sold Construction Expenses (2019) Construction Expenses - Project #1 Construction Expenses- Project #2 Wages Wages Payroll Tax Expense P Interest Expense www.com Utilities Duitics Loss on Impairment Equipment Rental (other expenses) Equipment Repairs (other expenses) Income tax expense mcome.co Insurance Expense wearics Calibri (Body) B I U Bad Debt Expense H Commission Expense Advertising Expense Draw Page Layout TOTALS Net Income (Loss) TOTAL Administration Expenses Amortization Expense (other expense) Depreciation Expense (other expenses) DO NOT WRITE IN THIS AREA C fx 886487 1,895,740 Trial Balance At December 31, Y6 Debit Credit 886487 475,539 V 120,000 655,000 3,195,000 389,105 675,000 3,717,400 2,360,100 501,366 48,786 675,960 81,115 165,900 60,120 wap.co 160,000 68.901 3,150 10,622 173,936 D Revenue Expenses Net Income Font 208,778 104,853 525,000 94,100 100,000 16,500 3,200,000 2,000,000 1,007,407 3,206,449 5,855,690 450 V 11 0 V 0 E | 409,476 394,637 Unadjusted Trial Balance At December 31, Y7 Debit Credit 2,098,249 1,623,000 515,040 142,970 300,000 4,425,000 655,000 3,195,000 505,760 31,400 675,000 4,513,400 476,960 84,660 692,905 86,613 519,980 120,000 Formulas Data 157,610 V 6 208,778 104,853 246,300 370,990 3,845,000 750,000 5,000,000 2,000,000 2,042,640 $16,319,227 $16,319,227 $21,622,661 $21,622,661 $ 7,044,900 9,200 0 STUDENTS FIRST STEP Select destination and press ENTER or choose Paste G Adjustments Debit Grading Summary H Credit Debit Review === Adjusted Trial Balance Credit View Trial Balance ACCT 3036 Project F23.xlsx Automate Developer Alignment K L Income Statement Debit Credit ab Wrap Text v Merge & Center M N Balance Sheet Debit Credit Financial Statements O DO NOT USE THIS AREA General P Read-Only - Saved to my Mac V Tell me % 9 Q Number R S Notes to the Financials T .00 .0 U Conditional Format Formatting as Table Styles V W X Journal Entries Y Z Cell Styles AA AB Insert AC Cash & Equivalents AD Delete Cells D AE AF Format AG AH O | A Al I Comments AJ Sort & Find & Filter Select Editing TradeAccounts Receivable Detail 0. AK AL AM D AN Share Analyze Data Assistance BOD AO + + 50% AP D 2 - C Home Insert Draw Page Layout X 123456 7 8 9 10 11 12 13 14 15 16 F24 17 18 19 20 21 22 23 24 25 26 AutoSave OFF 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 12 Paste Clipboard A DO NOT USE THIS AREA O X B Calibri (Body) B I U v fx C add rows as needed add rows as needed add rows as needed V V Font 11 D Formulas Data Review V V A^ A A Aylmer Industries Inc. Statement of Comprehensive Income For the Year Ended December 31, Y7 Aylmer Industries Inc. Statement of Retained Earnings For the Year Ended December 31, Y7 Aylmer Industries Inc. Statement of Financial Position At December 31, Y7 STUDENTS FIRST STEP Grading Summary Select destination and press ENTER or choose Paste E NOTE F Trial Balance View ACCT 3036 Project F23.xlsx Automate Developer Alignment G Y7 Y7 Y7 Wrap Text v Merge & Center H Y6 Y6 Y6 Financial Statements Read-Only Saved to my Mac Custom | Tell me $ % 9 V Number J 00 K Notes to the Financials .00 0 V Conditional Format Cell Formatting as Table Styles Styles L M Journal Entries N O Insert Cash & Equivalents P Delete Cells Format Q R O Al I Comments S V TradeAccounts Receivable Detail O. Sort & Find & Filter Select Editing T P + U Share Analyze Data Assistance BOD + 100% V D 2 - C Home Insert Draw Page Layout X (19 1 2 3 4 5 6 7 8 9 10 11 12 13 AutoSave OFF G2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A DO NOT USE THIS AREA B Calibri (Body) B I U fx C D Notes to the Financial Statements V Font 1 Cash and Cash Equivalents 4 Inventories (net) V 2 Short-Term Investments 3 Accounts Receivable (net) 8 Goodwill 7 Intangible Assets (net) 11 E 6 Property and Equipment (net) Formulas Data V V A^ A 5 Construction in Process/Billings on Contract A F STUDENTS FIRST STEP Grading Summary Select destination and press ENTER or choose Paste G Review H Please add rows as needed Trial Balance View ACCT 3036 Project F23.xlsx Automate Developer Alignment Wrap Text Merge & Center I Financial Statements J Read-Only - Saved to my Mac Custom K Tell me $ % 9 V Number L 00 Notes to the Financials .00 0 M V Conditional Format Cell Formatting as Table Styles Styles N Journal Entries O P Q Insert Cash & Equivalents Delete R Cells D Format 8 S T O Al TradeAccounts Receivable Detail I Comments O. U V Sort & Find & Filter Select Editing V P W Share Analyze Data Assistance BOD + + 100% X D 2 - C Home Insert Draw Page Layout X AutoSave OFF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Paste B3 Clipboard A DO NOT USE THIS AREA DATE B Calibri (Body) B I U v C fx ACCOUNTS V V Font D 11 Formulas Data V V STUDENTS FIRST STEP Select destination and press ENTER or choose Paste A^ A A Grading Summary E F Review G Trial Balance View ACCT 3036 Project F23.xlsx Automate Developer Alignment H Debit Wrap Text Merge & Center I Credit J POSTED? Yes/No Financial Statements K Read-Only - Saved to my Mac General L Tell me $ % 9 V Number M Notes to the Financials 00 .00 0 N V Conditional Format Cell Formatting as Table Styles Styles O P Journal Entries Q R Insert S Cash & Equivalents Delete T Cells U Format V O Al W Comments O. I V TradeAccounts Receivable Detail Sort & Find & Filter Select Editing X Y D N Share Analyze Data Assistance BOD + + 85% AA D 2 - C Home Insert Draw Page Layout X 1 2 34567 T14 7 8 LO 00 9 AutoSave OFF 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A Xx B Calibri (Body) B I U fx C Petty Cash Bank of Montreal - Chequing Bank of Montreal - Deposit Royal Bank-Chequing Short-term paper (A) Short-term paper (B) Restricted Cash D Short-term paper (A) Short-term paper (B) Restricted Cash V V Font 11 Formulas Data V V E Unadjusted Trial Balance 300 10,326 312,022 67,480 40,000 409,476 A^ A A F Review View G Adjusted Adjustment Trial Balance STUDENTS FIRST STEP Grading Summary Select destination and press ENTER or choose Paste ACCT 3036 Project F23.xlsx Automate Developer Alignment H Trial Balance | Wrap Text v Merge & Center J K 4 month paper @ 10.25% interest with Hilo Investments - Purchased November 1, Y7. Financial Statements General Read-Only - Saved to my Mac $ % 9 V L Tell me Number M 40,000 45 day paper @ 10.80% interest - Purchased December 20, Y7. set aside for bank loan - have to maintain a minimum of 10% of bank loan payable in restricted cash per agreement 00 Notes to the Financials .00 .0 N V Conditional Format Cell Formatting as Table Styles Styles O Journal Entries P Q R Insert Cash & Equivalents S Delete Cells T Format U A V Comments Ou I V TradeAccounts Receivable Detail Sort & Find & Filter Select Editing W X P Share Analyze Data Assistance + BOD Y + 100% 1 2 3 4 2 Home Insert Draw Page Layout X (19 5 6 C3 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 AutoSave OFF 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Paste Clipboard A B Customer Name 4210119 Ont Ltd 43rd Street Place 6 Star Services 9900 International Corp A1 Distributions Aylmer Enterprises Booktime Services Box Top Inc Briar Forest Corp Cavhill Industries Colborne Corp Copper Gallery Dairy Ashford Corp Demilo Inc Dustin Enterprises Greenway Place Grosvenor Limited Houston Consultants Jesse Blackstone Joseph Company Lawrence Brothers Mapleton Express OKC Limited Oxford Distributing Paper Brands Plaid Corp Quality Logistics Calibri (Body) BI U TC Jester Wellington Limited Westella Drive LTD Woodplank Inc. Yellow Street Ltd Zephyr Limited TOTAL Calculations and Notes DO NOT USE THIS AREA For Grading Purposes fx Total Due 116,181 6,625 65,675 100,792 130,734 167,468 100,160 49,049 2,942 74,083 1,313 1,400 17,560 83,336 180,511 94,765 22,843 135,986 22,180 101,407 58,561 19,048 24,219 22,220 146,790 45,126 25,573 100,665 138,144 14,410 23,665 2,018 2,800 2,098,249 Font D V 11 0-30 Days 55,894 6,494 31,310 50,981 65,944 74,586 99,643 13,031 1,443 61,999 1,313 7,960 36,785 64,452 31,548 6,844 56,980 9,846 31,599 18,846 18,936 10,699 11,569 12,636 12,500 2,131 49,666 65,478 6,944 664 1,550 920,271 | E Formulas Data 31-60 days V 50,199 131 30,699 49,811 62,902 89,650 263 13,031 1,499 6,013 9,600 39,941 64,161 31,661 7,033 42,560 9,846 36,510 19,844 9,856 10,651 10,664 12,500 2,236 49,666 72,666 6,411 664 1,250 A^ STUDENTS FIRST STEP Select destination and press ENTER or choose Paste F A 61-90 days 5,094 944 3,232 100 13,031 5,960 6,610 50,344 31,556 8,966 36,446 1,494 32,649 19,460 112 3,664 36,944 12,500 2,066 1,333 1,055 690 741,918 274,250 Grading Summary G 91-120 days 4,994 3,666 944 154 9,956 111 1,400 994 649 411 Review H Over 120 1,554 46,546 40,000 131 7,495 2,699 16,441 12,600 11,065 === 85,255 76,555 I View Trial Balance ACCT 3036 Project F23.xlsx Automate Developer Alignment J ab Wrap Text v K Merge & Center L M Financial Statements N General V Read-Only - Saved to my Mac O Tell me % 9 Number P Q Notes to the Financials .00 .0 R Conditional Format Formatting as Table Styles S T Journal Entries U Cell Styles V W Insert Cash & Equivalents X Delete Cells Y Format 898 Z AA O | "I A AB TradeAccounts Receivable Detail I Comments AC 0. Sort & Find & Filter Select Editing AD AE P Share Analyze Data BOD Assistance AF + + 75% AG 2 Home Insert Draw Page Layout X (19 1234567 B6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 AutoSave OFF 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A Calibri (Body) B I U 6/15/Y7 12/05/Y7 B fx Purchase Date DO NOT USE THIS AREA For Grading Purposes V 11 V Font Formulas Data V Record Calculations here: Grading Summary Trial Balance Select destination and press ENTER or choose Paste C Review Description 17,340 shares of Redemption Corp @ $12.45 per share 8,140 shares of ALM Corp @ $21.96 per share === View Financial Statements ACCT 3036 Project F23.xlsx Automate Developer Alignment D ab Wrap Text v COST 215,883.00 178,754.40 394,637.40 Merge & Center E Notes to the Financials F General V Read-Only - Saved to my Mac G Tell me % 9 Number Journal Entries H .00 .0 I Conditional Format Formatting as Table Styles J Cash & Equivalents K Cell Styles L M Insert Delete Cells N TradeAccounts Receivable Detail Format O 1888 O P | II A FV-NI Investments I Comments Q Sort & Find & Filter Select Editing 0. R S Inver Share Analyze Data Assistance BOD + + 100% T Home Insert 1 2 3 4 5 6 AutoSave OFF 7 8 9 10 11 12 13 14 15 16 17 18 G15 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard X (19 A Item # Draw Page Layout Calibri (Body) BI U fx B C Inventory Items on Hand Description 2 14566SA X205 30 HP Machine 145669A X205 30 HP Machine 147502A X205 30 HP Machine 147503A X205 30 HP Machine 147504A X205 30 HP Machine 360010X G350 60 HP Machine 360011X G350 60 HP Machine 360012X G350 60 HP Machine 360013X G350 60 HP Machine 598750W L500 100HP Machine 598751W L500 100HP Machine 598752W L500 100HP Machine Trial Balance V 11 V Font | D Cost Formulas Data Review V E Selling Price Financial Statements Select destination and press ENTER or choose Paste 13,700.00 49,250.00 12,950.00 13,700.00 12,950.00 13,700.00 12,950.00 13,700.00 12,950.00 13,700.00 12,950.00 37,850.00 37,850.00 49,250.00 37,850.00 49,250.00 37,850.00 49,250.00 99,630.00 102,950.00 99,630.00 102,950.00 99,630.00 102,950.00 515,040.00 F === Selling costs 0.0% of selling price View Notes to the Financials G Market ACCT 3036 Project F23.xlsx Automate Developer Alignment ab Wrap Text v H Merge & Center Journal Entries 1 LCM J Read-Only - Saved to my Mac General V Tell me % 9 K Number Cash & Equivalents L .00 .0 M Conditional Format Formatting as Table Styles N O Cell Styles TradeAccounts Receivable Detail P Insert Delete Q Cells R Format DO NOT USE THIS AREA For Grading Purposes FV-NI Investments O D S "I Comments I Inventory Detail Sort & Find & Filter Select Editing T 0. D U Inver + Share Analyze Data Assistance V BOD + 100% Home Insert D4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 AutoSave OFF 25 26 27 28 Paste 29 30 31 32 33 34 35 36 37 38 39 40 41 42 X (19 Clipboard A D X B Item # Draw Page Layout Calibri (Body) B I U fx C V 2 Description PK0366 X105 15 HP Machine PK0367 X105 15 HP Machine PK0368 X105 15 HP Machine PK0369 X105 15 HP Machine PK0370 X105 15 HP Machine PK0371 X105 15 HP Machine PK0372 X105 15 HP Machine PK0373 X105 15 HP Machine PK0374 X105 15 HP Machine PK0375 X105 15 HP Machine X105 15 HP Machine PK0376 JH14456 J050 5 HP Machine JH14457 J050 5 HP Machine JH14458 J050 5 HP Machine JH14459 J050 5 HP Machine JH14460 JH14461 J050 5 HP Machine J050 5 HP Machine V 11 V Font | D Cost Formulas Data Review V 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 9,850.00 5,770.00 5,770.00 5,770.00 5,770.00 5,770.00 5,770.00 142,970.00 Notes to the Financials Select destination and press ENTER or choose Paste Journal Entries E F === G View Cash & Equivalents ACCT 3036 Project F23.xlsx Automate Developer Alignment H ab Wrap Text v | Merge & Center J K General V Read-Only - Saved to my Mac TradeAccounts Receivable Detail Tell me % 9 L Number M .00 .0 N Conditional Format Formatting as Table Styles OFV-NI Investments O Cell Styles P DO NOT USE THIS AREA For Grading Purposes Inventory Detail Insert Delete Q Cells Format R S Inventory on Consignment O | 61 I Comments T 0. Sort & Find & Filter Select Editing U V Share Analyze Data BOD Assistance Fixed Asset Details + W + 100% Home Insert 1234 15 4 AutoSave OFF Paste 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 X (19 Clipboard B Land Building Asset Category Number Equipment Calibri (Body) BI U C Y4-01 Y5-09 Y5-09 Draw Page Layout Y4-02 Y4-03 Y4-04 Y4-05 Y4-06 Y4-07 Y4-08 Y5-10 Y5-11 Y5-12 Y5-13 Y5-14 Y5-15 Y7-16 Y7-17 Y7-18 fx 2 D 401 Main Street 410 Main Street 406 Main Street 1 wagon Ford F150 TOTAL 1 acre-11th Line 401 Main Street .5 acre 402 Main Street Loader Grader Flat-bed Trailer Grader V 11 Description Journal Entries V Ford F150 Truck Dodge Ram Truck Toro lawn mower John Deere Excavator Cat Backhoe Case Tractor 3 wagons Chev Truck Toyota Tundra Kenworth Font Formulas Data Review V 05/31/Y5 09/01/Y4 09/01/Y4 Acquisition Date 09/01/Y4 02/1/5 08/1/Y5 02/01/Y4 03/31/Y4 06/30/Y4 09/01/Y4 09/01/Y4 10/01/Y4 Cash & Equivalents Select destination and press ENTER or choose Paste 10/01/Y4 03/01/Y5 05/31/Y5 07/31/Y5 08/01/Y5 12/01/Y5 12/01/Y5 05/01/Y7 07/01/Y7 12/31/Y7 E F === Useful Life (Yrs) 30 30 30 View 6 6 5 14 14 14 4 6 6 6 10 10 10 10 4 6 G ACCT 3036 Project F23.xlsx Automate Developer Alignment Cost 285,000.00 250,000.00 120,000.00 655,000.00 1,655,000.00 440,000.00 1,100,000.00 3,195,000.00 8,700.00 15,500.00 2,250.00 41,500.00 12,300.00 9,800.00 3,300.00 35,600.00 18,750.00 220,500.00 98,660.00 8,400.00 12,300.00 16,800.00 1,400.00 505,760.00 $ 4,355,760.00 $ TradeAccounts Receivable Detail ab Wrap Text v Merge & Center H Accumulated Depreciation to 12/31/Y6 128,722.22 28,111.11 51,944.44 208,777.78 4,229.17 7,104.17 1,125.00 6,916.67 2,050.00 1,575.00 1,856.25 10,877.78 4,947.92 52,062.50 9,866.00 910.00 1,332.50 104,852.94 313,630.72 General I Depreciation Expense Y7 FV-NI Investments Read-Only - Saved to my Mac V Tell me % 9 Number J Accumulated Depreciation to 12/31/Y7 .00 .0 K Conditional Format Formatting as Table Styles Adjustments to 12/31/Y7 Inventory Detail L NBV Cell Styles M Inventory on Consignment Insert Delete N Cells O Format P Fixed Asset Details O Al I Comments Q DO NOT USE THIS AREA For Grading Purposes 0. Sort & Find & Filter Select Editing FV-OCI Investments Analyze Data Share R Assistance BOD + + 100% S 2 Home Insert Draw Page Layout X (19 AutoSave OFF Paste D5 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 12 Clipboard A O X B Calibri (Body) BI U Purchase Date 6/15/Y7 V 11 V Font Formulas C Notes and Calculations here: V fx + Trial Balance'!D83*1.8 Description 18,000 shares of Hub Cap Company Cash & Equivalents Select destination and press ENTER or choose Paste Data Review TradeAccounts Receivable Detail D X ACCT 3036 Project F23.xlsx Automate Developer = = = COST View Alignment E ab Wrap Text v Merge & Center F FV-NI Investments (2 G General V H Read-Only - Saved to my Mac Inventory Detail Tell me % 9 Number I .00 .0 J Conditional Format Formatting as Table Styles K L Inventory on Consignment Cell Styles DO NOT USE THIS AREA For Grading Purposes Insert Delete M Fixed Asset Details Cells N Format 1888 O O FV-OCI Investments "I | P I Comments 0. Sort & Find & Filter Select Editing Q R Intangible As + Share Analyze Data Assistance S BOD + 100% 2 Home Insert Draw Page Layout X (19 1 2 3 F5 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 AutoSave OFF 12 Paste Clipboard A X B Item Calibri (Body) B I U Trademark Patent fx C Date Developed Y7-01-01 Y7-01-01 V 11 Font D Cost | Formulas Data 31,400 V 8 Yrs 31,400 5 yrs E Useful Life TradeAccounts Receivable Detail Select destination and press ENTER or choose Paste F Amortization Y7 Review G Accumulated Amortization to 12/31/Y7 FV-NI Investments View === ACCT 3036 Project F23.xlsx Automate Developer Alignment H Carrying Value ab Wrap Text v Merge & Center Inventory Detail I J Read-Only - Saved to my Mac General V Tell me % 9 K Number Inventory on Consignment L .00 .0 M Conditional Format Formatting as Table Styles N Cell Styles Fixed Asset Details O DO NOT USE THIS AREA For Grading Purposes Insert Delete P FV-OCI Investments Cells Q = Format R O Intangible Assets III S I Comments 0. Sort & Find & Filter Select Editing T U Revenue Reco + Share Analyze Data Assistance V BOD + 100% D 2 - C Home Insert Draw Page Layout X (19 1 2 I34567 B2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 AutoSave OFF 50 51 52 53 CA Paste Clipboard A B Calibri (Body) B I U C Other project information Progress Billings: Project #1 Downtown Hotel & Shopping Centre Contract Price Collections Costs incurred in Y7 Estimated total costs to complete Project #2 - Factory & Warehouse Contract Price Font fx Project #1 - Downtown Hotel & Shopping Centre D V 11 Costs incurred in Y7 Estimated costs in Y8 Estimated costs in Y9 Estimated costs in Y10 Other project information Progress Billings: V Collections 31-May 31-Aug 30-Nov 01-Jul 09-Sep 01-Dec Formulas Data Review 25-Dec V V A A Av E $ $ $ F 9,000,000 FV-NI Investments Inventory Detail Select destination and press ENTER or choose Paste 2,800,000 700,000 695,000 750,000 596,500 625,000 $ 18,000,000 $ 1,625,000 $ $ $ 6,000,000 3,140,000 1,700,000 1,000,500 G H View includes costs incurred in Y7 ACCT 3036 Project F23.xlsx Automate Developer Alignment I Inventory on Consignment J Wrap Text v Merge & Center K L General Fixed Asset Details Read-Only Saved to my Mac M Tell me $ % 9 V Number N 00 O .00 .0 P FV-OCI Investments V Conditional Format Cell Formatting as Table Styles Styles Q R S Intangible Assets Insert T DO NOT USE THIS AREA For Grading Purposes Delete Cells U Format Revenue Recognition O V a W I Comments X V Payroll Details Sort & Find & Filter Select Editing O. Y D Z + Share Sale + BOD Analyze Data Assistance AA 82% 2 Home Insert Draw Page Layout X (19 123 G9 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 AutoSave OFF 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste Clipboard A D X Name Calibri (Body) B I U Brian Dennis Jane Ferris Lin Wang B Hannah Carter Jessica Lampman fx Larry Jones Amy Fanshawe-Grad Max Vance John Demilo Kevin St Clair Allison Brubaker Title V 11 Font V Sales Sales C President Controller | Formulas Data Review V Wage D E $ 136,000.00 annually $ 91,000.00 annually $ 78,000.00 annually $ 78,000.00 annually Supervisor $ 62,000.00 annually Supervisor $ 62,000.00 annually Accountant $ 43,000.00 annually Labourer $ Labourer $ $ Labourer Labourer $ 17.25 hourly 17.25 hourly 17.25 hourly 17.25 hourly FV-NI Investments Inventory Detail Select destination and press ENTER or choose Paste F View === ACCT 3036 Project F23.xlsx Automate Developer Alignment G Inventory on Consignment ab Wrap Text H Merge & Center I General Fixed Asset Details J Read-Only - Saved to my Mac V Tell me % 9 Number K L .00 .0 M FV-OCI Investments Conditional Format Formatting as Table Styles N Cell Styles O DO NOT USE THIS AREA For Grading Purposes Intangible Assets Insert Format Delete P Cells Q Revenue Recognition 88 B R II I Comments S Payroll Details Sort & Find & Filter Select Editing 0. T U Sales Share Analyze Data BOD Assistance + + 100% V 2 Home Insert Draw Page Layout X (19 1 2 3 4 5 6 7 8 9 10 AutoSave OFF A1 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Paste Clipboard A Units Sold Calibri (Body) B I U B fx 103 X205 30 HP Machine 43 G350 60 HP Machine 16 L500 100HP Machine C V 11 Selling Price V Font 32,400.00 47,900.00 103,000.00 | Formulas Data Review V D NOTE - For Information ONLY but DO NOT MAKE CHANGES Inventory Detail Select destination and press ENTER or choose Paste E Cost 3,337,200.00 13,500.00 1,390,500.00 2,059,700.00 35,900.00 1,543,700.00 1,648,000.00 98,700.00 1,579,200.00 7,044,900.00 4,513,400.00 Inventory on Consignment === F View ACCT 3036 Project F23.xlsx Automate Developer Alignment G Fixed Asset Details ab Wrap Text v Merge & Center H I J General FV-OCI Investments Read-Only - Saved to my Mac V Tell me % 9 K Number L .00 .0 M Intangible Assets Conditional Format Formatting as Table Styles N O Cell Styles P Revenue Recognition Insert Delete Q Cells R Payroll Details 88 Format S T | Sales Detail A Comments U 0. Sort & Find & Filter Select Editing V W Extra Sheet fo Share Analyze Data BOD Assistance + + 100% X