Does anyone know where to get the year 5 solutions to the Hydromaint, Inc. financials? This is year 4 but I need year 5 to compare to my workbook and see if I'm inline with my numbers. Thanks.

Academic Honesty Pledge for Year 4 of the BAM: Note that this pledge applies to all assignments completed for Year 4 of Hydromaint, regard asked to submit a signed statement with each assignment or not. Pledge: By signing my name below (submitting this work from my e-mail account), I am promising 1) The work I submit is my own, 2) I did not and will not give aid to others, 3) I will not share any information about the assignment with those who are completing it l 4) I will report any others that I observe violating these rules. By typing my name in the box below, I acknowledge my responsibilities as stated above an academically dishonest manner I will receive a failing grade in this class. Type your name in the above box as evidence of your agreement to the academic honesty pledge. Instructions for saving this docment under a new name: This document is read only. You will need to save it under a new name that identifies you and you financial statements that you are submitting, and the date of your submission; i.e. Team3Year2No the excel documents that you are submitting to be graded. 4 of Hydromaint, regardless of whether or not you are l account), I am promising that: se who are completing it later, in subsequent BAM classes, ibilities as stated above and I understand that if I act in an honesty pledge. e that identifies you and your teammates, the year of the Hydromaint mission; i.e. Team3Year2Nov122012. Also, please type your names on 147-02576 HYDROMAINT, INC. ADJUSTING JOURNAL ENTRIES DECEMBER 31, 20X4 A/J/E # DATE 1 12/31/X4 ACCT # ACCOUNT NAME 524 COST OF GOODS SOLD-PMME WARRANTY EXPENSE 422 WARRANTY LIABILITY To record warranty expense. 2 511 126 105 581 127 CONSTRUCTION REVENUE CONSTRUCTION WORK IN PROGRESS ACCOUNTS RECEIVABLE COST OF CONSTRUCTION REVENUE EARNED CONSTRUCTION WIP-PROGRESS BILLINGS To record construction contract costs and billings. 3 202 805 EQUITY SECURITIES-EQUIT INTEREST INVESTMENT INCOME-EQUITY METHOD INVEST To record share of PVCO net income. 4 805 202 INVESTMENT INCOME-EQUITY METHOD INVEST EQUITY SECURITIES-EQUIT INTEREST To record dividend received from PVCO. 5 213 PATENT 202 EQUITY SECURITIES-EQUIT INTEREST 805 INVESTMENT INCOME-EQUITY METHOD INVEST 202 EQUITY SECURITIES-EQUIT INTEREST To record amortization of excess paid over book value. 6 #N/A 491 RETAINED EARNINGS #N/A #N/A #N/A #N/A 7 402 CAPITAL LEASES--L-T LIABILITY 322 SHORT-TERM PORTION OF L-T LEASE LIABILITY To reclassify short term portion of long term lease 8 414 ACCRUED PENSION LIABILITY 475 OCI-PRIOR SERVICE COST-PENSIONS 604 SELLING & ADMIN-PENSION EXPENSE To record pension liability #N/A 9 121 MERCHANDISE INVENTORY 301 ACCTS PAY-INVENTORIABLE COSTS To record inventory in transit #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A S DEBIT 16,704 CREDIT 16,704 115,000 146,558 40,000 186,558 115,000 26,268 26,268 3,800 3,800 40,360 40,360 10,090 How does this look? -- AJ 10,090 980,038 ? 980,038 814 814 28,325 19,525 8,800 28,760 28,760 I think we put here the INCOME SUMMARY account. JG I agree with Jose -- AJ w does this look? -- AJ nk we put here the INCOME SUMMARY account. JG ee with Jose -- AJ This page is automated. Do not add data directly to this page. HYDROMAINT , INC. CHART OF ACCOUNTS DECEMBER 31, 20X4 ACCOUNT NAME 101 CASH 105 ACCOUNTS RECEIVABLE 106 ACCOUNTS RECEIVABLE- PROG BILLINGS 108 ALLOWANCE FOR BAD DEBTS 111 EQUITY SECURITIES-SHORT TERM 121 MERCHANDISE INVENTORY 122 RAW MATERIALS 123 WORK IN PROGRESS 124 MANUFACTURING COSTS-VARIABLE 125 MANUFACTURING COSTS-FIXED 126 CONSTRUCTION WORK IN PROGRESS 127 CONSTRUCTION WIP-PROGRESS BILLINGS 129 SUPPLIES ON HAND 132 PREPAID INSURANCE 141 DEFERRED INCOME TAX-CURRENT 142 NOL TAX BENEFIT 143 NOL VALUATION ALLOWANCE 151 LAND 161 BUILDINGS 162 BUILDINGS-ACCUMULATED DEPN 171 EQUIPMENT 172 EQUIPMENT-ACCUMULATED DEPN 181 VEHICLES 182 VEHICLES-ACCUMULATED DEPN 191 LEASED ASSETS 192 LEASED ASSETS-ACCUMULATED DEPN 201 EQUITY SECURITIES-LONG TERM MARKETABLE 202 EQUITY SECURITIES-EQUIT INTEREST 203 EQUITY SECURITIES-LONG TERM COST METHOD 211 LICENSE 212 GOODWILL 213 PATENT 214 PENSION ASSET 215 DEFERRED INCOME TAX-LONG TERM 217 START-UP COSTS 221 DEFERRED R&D COSTS ACCOUNT # 101 105 106 108 111 121 122 123 124 125 126 127 129 132 141 142 143 151 161 162 171 172 181 182 191 192 201 202 203 211 212 213 214 215 217 221 Beginning Balance DR CR 233,625 251,832 38,000 41,040 108,050 16,574 258 54,438 42,000 18,000 389,000 125,267 502,000 25,100 210,685 36,000 35,878 - 301 ACCTS PAY-INVENTORIABLE COSTS 302 ACCTS PAY-SUPPLIERS-OTHER COSTS 303 ACCTS PAY-EQUIPMENT ACQ 305 WAGES PAYABLE 311 INTEREST PAYABLE-NOTES 312 INTEREST PAYABLE-LEASE LIABILITY 313 INTEREST PAYABLE-BONDS 314 INCOME TAX PAYABLE 315 DEFERRED INCOME TAXES-CURRENT 321 SHORT-TERM PORTION OF L-T NOTES 322 SHORT-TERM PORTION OF L-T LEASE LIABILITY 323 SHORT-TERM PORTION OF L-T BONDS 335 UNEARNED REVENUE 350 DIVIDENDS PAYABLE 401 LONG-TERM DEBT-NOTES 402 CAPITAL LEASES--L-T LIABILITY 403 LONG-TERM DEBT-BONDS 404 DISCOUNT ON BOND PAYABLE 405 PREMIUM ON BOND PAYABLE 406 DEBT ISSUE COSTS 414 ACCRUED PENSION LIABILITY 420 STOCK COMPENSATION LIABILITY 421 DEFERRED INCOME TAX-LONG TERM 422 WARRANTY LIABILITY 451 CAPITAL STOCK-PREFERRED 452 PAID-IN CAPITAL-PREFERRED 461 CAPITAL STOCK-COMMON 462 PAID-IN CAPITAL-COMMON 466 PAID-IN CAPITAL-STOCK APPREC RIGHTS 467 PAID-IN CAPITAL-STOCK OPTIONS 468 PAID-IN CAPITAL-FORFEITED STOCK OPTIONS 469 PAID-IN CAPITAL-TREASURY 471 OCI-MARKET GAIN/LOSS-LT EQUITY SECURITES 472 OCI-MKT GAIN/LOSS TAX (BENEFIT) EXPENSE 475 OCI-PRIOR SERVICE COST-PENSIONS 476 OCI-DEFD PENSION TAX (BENEFIT) EXPENSE 491 RETAINED EARNINGS 301 302 303 305 311 312 313 314 315 321 322 323 335 350 401 402 403 404 405 406 414 420 421 422 451 452 461 462 466 467 468 469 471 472 475 476 491 492 RETAINED EARNINGS-CASH DIVIDENDS 493 RETAINED EARNINGS-STOCK DIVIDENDS 494 RET EARNINGS-ERROR CORRECTION 495 RET EARNINGS-CUMULATIVE EFFECT 499 TREASURY STOCK 492 493 494 495 499 501 SALES REVENUE 501 26,268 19,918 14,372 18,140 100,654 75,395 13,791 144,000 165,811 447,209 - 806 175,728 70,503 2,728 140,000 2,685 52,719 597,354 - 505 SERVICE REVENUE 511 CONSTRUCTION REVENUE 521 COST OF GOODS SOLD-INVENTORY 522 COST OF GOODS SOLD-AIR FREIGHT 523 COST OF GOODS SOLD-WAREHOUSE RENT 524 COST OF GOODS SOLD-PMME WARRANTY EXPENSE 525 COST OF GOODS SOLD-LS PUMP WARRANTY EXPENSE 551 SERVICE COSTS- DIRECT- CREW WAGES 552 SERVICE COSTS- DIRECT- TRUCK RENTAL 553 SERVICE COSTS-DIRECT-FUEL 554 SERVICE COSTS-DIRECT-R AND M 561 SERVICE COSTS-INDIRECT-SHOP WAGES 562 SERVICE COSTS-INDIRECT-SHOP UTILITIES 563 SERVICE COSTS-INDIRECT-SHOP RENT 564 SERVICE COSTS-INDIRECT-SUPPLIES 581 COST OF CONSTRUCTION REVENUE EARNED 505 511 521 522 523 524 525 551 552 553 554 561 562 563 564 581 601 SELLING & ADMIN-UTILITIES 602 SELLING & ADMIN-BUILDING RENTAL 603 SELLING & ADMIN-MEDICAL BENEFITS 604 SELLING & ADMIN-PENSION EXPENSE 605 SELLING & ADMIN-OFFICERS SALARIES 606 SELLING & ADMIN-RENT-EQUIPMENT 607 SELLING & ADMIN-SUPPLIES 608 SELLING & ADMIN-OTHER SALARIES 609 SELLING & ADMIN-PROFESSIONAL FEES 610 SELLING & ADMIN-INSURANCE 614 SELLING & ADMIN-PAYROLL AND OTHER TAXES 615 SELLING & ADMINISTRATIVE-OTHER 620 SELLING & ADMINISTRATIVE-STOCK COMPENSATION 631 SELLING & ADMIN-SALES SAL & COMM 632 SELLING & ADMIN- WAREHOUSE WAGES 651 SELLING & ADMIN- BAD DEBTS 601 602 603 604 605 606 607 608 609 610 614 615 620 631 632 651 680 START UP-CREW TRAINING 680 701 TRUCK DEPRECIATION 704 SHOP EQUIPMENT DEPRECIATION 706 WAREHOUSE DEPRECIATION 710 AMORTIZATION OF LICENSING COSTS 711 AMORTIZATION OF START-UP COSTS 712 AMORTIZATION OF CAPITAL LEASES 713 AMORTIZATION OF R&D COSTS 714 AMORTIZATION OF PATENT 720 IMPAIRMENT LOSS 701 704 706 710 711 712 713 714 720 751 INTEREST EXPENSE-NOTE PAYABLE 752 INTEREST EXPENSE-CAPITAL LEASE 753 INTEREST EXPENSE-BONDS 771 DEBT ISSUE EXPENSE 801 MARKET GAIN (LOSS)-ST EQ SEC 802 REALIZED GAIN-MKT EQ SEC 803 INVESTMENT INCOME-MKT EQ SEC-ST 804 INVESTMENT INCOME-MKT EQ SEC-LT 805 INVESTMENT INCOME-EQUITY METHOD INVEST 808 INVENTORY OVER/SHORT 809 MARKET LOSS ON INVENTORY 811 R&D EXPENSE 751 752 753 771 801 802 803 804 805 808 809 811 821 INCOME TAX EXPENSE 821 860 DISCONTINUED OPERATIONS 860 2,097,914 2,097,914 HYDROMAINT, INC. TRIAL BALANCE DECEMBER 31, 20X4 Transactions DR CR 4,938,184 4,025,000 52,000 989,720 890 155 160,000 370,000 154,000 1,500 445,000 - 4,415,070 3,824,880 57,000 18,930 835,200 9,250 31,667 65,933 25,100 3,000 - Unadjusted Balance DR CR 756,739 451,952 22,110 262,570 17,464 413 54,438 160,000 370,000 196,000 389,000 502,000 212,185 445,000 33,000 35,878 - 43,000 9,250 49,667 191,200 50,200 - Adjusting/Correcting Entries DR CR 40,000 28,760 146,558 26,268 40,360 - 115,000 54,250 - Adjusted Balance DR 756,739 491,952 22,110 291,330 146,558 17,464 413 54,438 160,000 370,000 196,000 389,000 502,000 212,185 417,018 33,000 40,360 35,878 - 836,740 60,574 19,918 15,678 27,209 274,886 80,296 13,791 13,476 120,000 2,103 - 989,720 54,986 36,800 11,186 26,667 407,574 4,901 96,000 640,000 96,249 - 13,476 806 175,728 - 152,980 20,680 36,800 9,880 17,597 233,342 80,296 13,791 240,000 85,515 433,418 640,000 46,752 625 140,000 2,685 52,719 597,354 814 28,325 - 28,760 814 16,704 19,525 980,038 13,476 806 156,203 - - - - - - - - - 1,392,000 - 1,392,000 - - - 835,200 68,700 6,500 540,540 84,672 16,200 204,750 42,840 54,096 146,558 2,937,000 115,000 - 835,200 68,700 6,500 540,540 84,672 16,200 204,750 42,840 54,096 146,558 2,937,000 115,000 - 115,000 16,704 - 186,558 835,200 68,700 6,500 16,704 540,540 84,672 16,200 204,750 42,840 54,096 - 8,568 49,400 166,249 137,280 5,000 13,440 61,020 7,128 4,805 98,635 13,885 41,760 235,540 57,000 - 8,568 49,400 166,249 137,280 5,000 13,440 61,020 7,128 4,805 98,635 13,885 41,760 235,540 57,000 - - 8,800 - 8,568 49,400 157,449 137,280 5,000 13,440 61,020 7,128 4,805 98,635 13,885 41,760 235,540 57,000 - - - - - - - 65,933 31,667 9,250 3,000 25,100 - - 65,933 31,667 9,250 3,000 25,100 - - - - 65,933 31,667 9,250 3,000 25,100 - 11,186 26,667 19,200 1,800 1,430 - 1,500 1,100 1,180 2,000 3,800 - 11,186 26,667 19,200 1,800 - 70 1,100 1,180 2,000 3,800 - 13,890 - 26,268 - 11,186 26,667 19,200 1,800 - 407,574 - 407,574 - - - 407,574 - - - - - - - 16,103,694 16,103,694 7,599,902 7,599,902 456,679 1,436,717 7,669,419 sted Balance CR 43,000 115,000 9,250 49,667 191,200 50,200 - 52000 181,740 20,680 36,800 9,880 17,597 233,342 80,296 14,605 240,000 85,515 432,604 640,000 18,427 17,329 140,000 2,685 52,719 1,577,392 1,392,000 2,937,000 40,000 - 70 1,100 1,180 2,000 16,178 - 8,649,457 HYDROMAINT, INC BALANCE SHEET 12/31/20x4 ASSETS CURRENT ASSETS Cash Investments in equity securities Accounts receivable Allowance for doubful accounts Merchandise Inventory Construction costs net of billings Supplies on hand Prepaid insurance Deferred income tax - current Total current assets 20X4 756,738.77 22,110.00 491,952.00 (43,000.00) 291,330.00 31,558.00 17,464.00 413.00 89,367.00 1,657,932.77 20X3 233,625.00 41,040.00 251,832.00 (38,000.00) 108,050.00 PROPERTY, PLANT, AND EQUIPMENT Equipment Equipment Accumulated Depreciation Vehicles Vehicles Accumulated Depreciation Leased Asset Leased Accumulated Depreciation Land Building Building Accumulated Depreciation Total property, plant, and equipment 196,000.00 (49,666.67) 389,000.00 (191,200.33) 502,000.00 (50,200.00) 160,000.00 370,000.00 (9,250.00) 1,316,683.00 42,000.00 (18,000.00) 389,000.00 (125,267.00) 502,000.00 (25,100.00) 33,000.00 35,878.00 212,185.00 417,018.00 40,360.00 738,441.00 36,000.00 OTHER ASSETS License agreement Deferred pension assets Deferred income tax - long term Equity Securities - Long term marketable Equity Securities - Equity method interest Patent Total other assets TOTAL ASSETS 3,713,056.77 16,574.00 258.00 54,438.00 667,817.00 764,633.00 35,878.00 210,685.00 71,878.00 1,504,328.00 LIABILITIES AND STOCKHOLDERS' EQUITY CURRENT LIABILITIES Accounts payable Wages payable 202,420.00 36,800.00 26,268.00 19,918.00 Interest payable -note payable Interest payable - capital lease Interest payable - bond Income tax payable Short term portion of long term debt Short term portion of long term lease Short term portion of long term bond Unearned revenue Total current liabilities 9,879.70 17,597.36 277,665.00 80,295.69 14,605.00 240,000.00 879,262.75 LONG TERM LIABILITIES Note payable Capital lease payable Bond payable Discount on bonds payable Warranty liability Pension liability Deferred income tax - long term Total long term liabilities 85,515.07 432,604.29 640,000.00 (13,475.79) 17,329.00 18,427.42 1,180,399.98 165,811.00 447,209.00 2,059,662.73 1,098,789.00 140,000.00 1,577,392.00 (106,413.00) 1,610,979.00 140,000.00 597,354.00 (121,130.00) 616,224.00 3,670,641.73 1,715,013.00 TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common stock Retained earnings Accumulated other comprehensive income Total stockholder's equity TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY 14,372.00 18,140.00 100,654.00 75,395.00 13,791.00 144,000.00 412,538.00 2,728.00 70,503.00 686,251.00 20X2 355,687.00 122,000.00 (22,500.00) 10,330.00 192.00 24,150.00 489,859.00 42,000.00 (12,000.00) 356,000.00 (59,333.00) - 326,667.00 39,000.00 - 39,000.00 855,526.00 25,333.00 9,380.00 18,590.00 99,726.00 70,794.00 58,000.00 281,823.00 241,206.00 - 4,846.00 246,052.00 527,875.00 140,000.00 187,650.00 327,650.00 855,525.00 Sales Revenue Service revenue (Note 1) Construction Revenue Hydromaint, Inc. Statement of Comprehensive Income for the Years Ending December 31, 20X4 20X3 1,392,000.00 $ 255,200 2,937,000.00 1,841,000 - Cost of goods sold 1,851,976.00 Gross profit 2,477,024.00 Operating expenses Selling and administrative expenses Start up crew training Depreciation and amortization Total operating expenses 890,910.32 134,950.00 1,025,860.32 528,347 100,033 628,380 Operating income 1,451,163.68 607,219 (1,800.00) (20,528.00) (57,052.76) (4,107) (16,062) 1,371,782.92 587,050 (407,574.28) (177,347) 980,038.00 $ 409,703 (106,403.00) (121,130) 873,635 $ 288,573 Other income (expense) Debt issue expense Investment (income) loss Interest expense (Note 2) Income (loss) before income taxes Income tax (expense) benefit (Note 4) Net income (loss) Other comprehensive income Total comprehensive income (loss) Earnings (loss) per share (Note 1) Notes are an integral part of the financial statements $ 70.00 860,601 - 1,235,599 $ 29.26 20X2 $ 1,172,000 20X1 ### 693,000 544,786 445,050 627,214 247,950 262,965 68,333 331,298 207,738 43,000 9,000 259,738 295,915 (11,788) (16,055) - 279,860 (11,788) (82,720) 2,299 $ 197,140 $ (9,490) - ### $ 197,140 $ (9,490) $ $ 14.08 (0.75) Hydromaint, Inc. Statement of Cash Flows for the Years Ending December 31, 20X4 Operating Activities: Cash received from customers Cash paid to suppliers Cash paid for selling and administrative expenses Cash paid for start-up costs Net cash used by operations Investing Activities: Purchase of license agreement Purchase of equipment Purchase of vehicles Purchase of land Purchase of buildings Purchase of PVCO stock Dividends from PVCO stock Net cash used by investing activities Financing Activities: Proceeds (payment) from note payable Payment on capital lease liability Proceeds from issue of common stock Proceeds from note Proceeds from convertible bond issue Payment of interest to bond issuers Proceeds from sale of short-term investments Proceeds from dividends Net cash provided by financing activities 3,772,880.00 (897,314.00) (1,086,466.00) 1,789,100.00 (154,000.00) (160,000.00) (370,000.00) (445,000.00) 3800.00 (1,129,000.00) (91,074.00) (41,000.00) 624,724.00 (19,200.00) 18,600.00 3,180.00 495,230.00 Net increase in cash Cash at beginning of year 233,625.00 Cash at end of year 233,625.00 Significant non-cash transactions: Capitalized interest payable for vehicles Common stock issued for license agreement Notes are an integral part of the financial statements ws mber 31, 20X3 20X2 20X1 1,966,368.00 (1,306,754.00) (426,347.00) 233,267.00 $ 1,181,000 (547,853) (238,165) 394,982 $ 620,000 (425,600) (202,230) (43,000) (50,830) (42,000.00) - (353,465) (10,000) (42,000) - (42,000.00) (353,465) (52,000) (70,794.00) (41,000.00) - 312,000 ### ### 105,000 - (111,794.00) 312,000 105,000 (122,062.00) 353,517 2,170 355,687.00 2,170 233,625.00 $ 355,687 $ 2,535 $ 2,170 $ 35,000 Hydromaint, Inc. Statement of Changes in Stockholders' Equity for the Years Ending December 31, 20X3, 20X2, and 20X1 Beginning balance, January 1, 20X2 Common Stock Shares Common Stock 14,000 $ 140,000 Net income (loss) Ending balance, December 31, 20X2 14,000 $ 140,000 14,000 $ 140,000 Net income (loss) Other Comprehensive Income Ending balance, December 31, 20X3 Net income (loss) Other Comprehensive Income Ending balance, December 31, 20X4 Notes are an integral part of the financial statements. dromaint, Inc. nges in Stockholders' Equity cember 31, 20X3, 20X2, and 20X1 Retained Earnings Accumulated Other Comprehensive Income (9,490) $ 197,140 187,650 $ 409,703 $ $ - Total $ (9,490) $ 197,140 $ 327,650 $ 409,703 (121,130) $ (121,130) 597,353 $ (121,130) 980,038 ### (108,291) $ (108,291) $ 1,577,391 616,223 $ 1,487,970