Exercise 10.19.22 - Microsoft Excel X @ - X Home Insert Page Layout Formulas Data Review View Cut LA E AutoSum - Helvetica - 11 - A A" Wrap Text General En Copy Fill BIUBLA Conditional Format Cell Sort & Find & Paste Merge & Center 9 % Insert Delete Format Format Painter Formatting as Table * Styles 2 Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing A7 A B C D E F G H K L M N 1 INSTRUCTIONS: 2 Common Size the Income Statement and Balance Sheet to the right of the reports 3 Complete Ratios at Bottom - Make short comment to the right of the trends 4 Complete Problems from Book as indicated at the Bottom of the page 5 6 Exam Question Company Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending 31-03-2018 30-06-2018 30-09-2018 31-12-2018 31-03-2019 30-06-2019 30-09-2019 31-12-2019 0 03/31/2020 06/30/2020 09/30/2020 12/31/2020 03/31/2021 Co 9 10 Revenue 23,93,355 27,44,349 24,53,514 18,23,921 27,06,577 22,76,417 23,46,975 19,07,771 19,57,355 22,57, 193 25,27,281 26, 17, 169 23,92,838 Cost of Revenue 19,34,690 26,54,301 18,92,988 10,88,372 16,50,655 16,92,342 15,17,834 14.54.213 11,92, 177 13,78,868 16,25,481 16,27,025 14,81,677 12 4,58,665 90,048 5,60,526 7,35,549 10,55,922 5,84,075 8,29, 141 4,53,558 7,65, 178 8,78,325 9,01,800 9,90, 144 9, 11, 161 13 Gross Profit 14 15 Operating Expenses 3,84,659 4,14,486 3,44,343 3,34,995 4,78,693 4,73,440 4,60,531 4,46,799 4,48, 149 4,49,931 5,05,236 5,65,099 5,49, 199 Payroll and Related Expenses 2,565 11,501 Manpower Cost 6,390 2,120 10,629 Operating and Maintenance Expenses 13,584 12,953 10,657 10, 166 12,725 13,395 13,333 11,833 9,756 10,121 10,941 25,350 13,588 Professional Services 1,80,452 84,469 94,686 66,401 1,52,603 80,857 98,026 89,343 90,036 1,23,215 92,001 1, 15,299 1,10,465 Bad Debt 15,209 0 3,300 33,336 1.499 190 39 584 43 Utilities and Facilities 59,733 45,774 41,883 42,076 39,797 20, 108 21,067 93,405 8,867 7,623 8,439 1,03,380 30, 184 General and Administrative Expenses 16,691 18,909 25,646 16,849 36,216 39,093 12,237 6,499 14,567 12,568 17,641 14,746 20,398 15,846 13,410 666 284 15,366 8,122 2,551 2,023 945 871 5,533 8,490 11,086 Marketing and Advertising 55,135 46,200 21,436 15,604 54,131 20,600 15,615 (78,045) 18,813 23,313 13,595 8,527 8,672 Taxes and Insurance 98 243 328 438 Port Fees - Other 1,495 1,001 997 781 730 727 579 768 412 48,995 Application Development Cost Total Operating Expenses 7,42,804 6,37,202 6,40,314 4,87,156 7,90,261 6,62,732 6,27,239 6,08,081 5,93,044 6,30,495 6,65,169 8,52,432 7,93,068 28 TOTAL Net Operating Income (2,84,139) (5,47,154) 20,212 2,48,393 2,65,661 (78,657) 2,01,902 (1,54,523) 1,72,134 2,47,830 2,36,631 1,37,712 1, 18,093 29 30 Other Income (Expense) 31 Interest Income 32 Interest Income 20 456 674 676 664 221 oo 33 Total Interest Income 20 456 674 676 664 221 0 14 4 > Statement of Earnings problem 11-1 detailed expl Average: 326475.2934 Count: 325 E + Ready Sum: 79007021Exercise 10.19.22 - Microsoft Excel X Page Layout Formulas Review View @ - X Home Insert Data Cut Helvetica - 11 - A A Wrap Text General LA E AutoSum - En Copy Fill Paste Format Painter BIUBLA Merge & Center - 9 % Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table . Styles 2 Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing A34 Depreciation A B C D E F G H K L M N 1 INSTRUCTIONS: 2 Common Size the Income Statement and Balance Sheet to the right of the reports 3 Complete Ratios at Bottom - Make short comment to the right of the trends 4 Complete Problems from Book as indicated at the Bottom of the page 5 6 Exam Question Company Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending 31-03-2018 30-06-2018 30-09-2018 31-12-2018 31-03-2019 30-06-2019 30-09-2019 31-12-2019 03/31/2020 06/30/2020 09/30/2020 12/31/2020 03/31/2021 8 34 Depreciation (12,243) (2,189) 7,217) 6,318 (25,357) (25,356 25,356) 45,428 (69,716) (46,384) (45,506) , 15,076 (31,152) (2,00,584) 35 Amortization (75,791) (54,366) (54,366) 46,341 (2,25,760) (2,25,760) (2,25,760) (2,08,976) (2,00,584) (2,00,584) (2,00,583) (2,00,583) 36 Interest Expense (13,396) (5,638) (5,065) (6,071) (5,609) (4,981) (4,159) (8,184) (6,592) (5,044) (4,826) (3,496) (2,242 37 Acquisition Costs 38 Aquisition Costs 0 0 20,967 93,986 0 0 0 0 0 O 0 0 0 39 Total Acquisition Costs 0 0 0 20.967 93.986 0 4,281 O Other Income 3,18,257 3,792 14,836 662 2,42,075 81,071 1,073 40 3,01,372 95,775 95.849 46.834 74,000 1,16,837 41 Other Expenses 1,44,474 1,65,010 2,25,960 1,71,435 1,79,188 2,84,968 1,22,653 1,81,490 Total Other Income (Expense) (2,41,623) (2,27,183) 26, 105 (1,53,984) (5,29,224) (5,25,565) (3,77,707) (3,52,559) (71,295) (1,05,786) (2, 16,678) (1,61,930) 3,50,815 42 43 $ 19,953 44 Net Income (Loss) $ (5,25,762) $ (7,74,337) $ 46,317 $ 94,409 $ (2,63,563) $ (6,04,222) $ (1,75,805) $ (5,07,082) $ 1,00,839 $ 1,42,044 $ (24,218) $ (2,32,722) 45 46 47 48 Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Ending Ending Ending Ending 49 Quarter Ending Ending Ending Ending Ending Ending Ending Ending Ending 50 03/31/2018 06/30/2018 09/30/2018 12/31/2018 03/31/2019 06/30/2019 09/30/2019 12/31/2019 03/31/2020 06/30/2020 09/30/2020 12/31/2020 03/31/2021 51 Assets 52 Current Assets 53 Cash and Cash Equivalents 3,62,916 1,47, 191 63,008 56,509 1,99,417 2,01,292 1,39,637 1,91,474 2,27,274 6,37,059 5,88,213 7,15,195 5,69,336 54 Accounts Receivable, Net 8,48,669 10,98,716 11,20,317 10,35,273 9,29,553 8,87,525 8,78,667 3,77,485 3,39,525 4,85,710 4,85,469 4,34,801 4,87,753 55 Inventory, Net 64,425 34,935 5.664 1,085 950 1,859 1,561 4,659 4,959 4,005 4,972 17,785 16,999 56 Prepaid Expenses 2,03,304 2,63,316 3,33,316 7,354 4,843 5,160 3,677 1,743 1,612 1,479 1,348 2,366 1,802 194 164 57 91.667 66,667 41,667 194 Other Current Assets 16.666 0 Statement of Earnings problem 11-1 detailed expl Ready Average: 52702.4011 Count: 269 Sum: 9591837 # 0 1 85% @ +Exercise 10.19.22 - Microsoft Excel X Home Insert Page Layout Formulas Data Review View -OX to Cut E AutoSum - Helvetica - 10 - A A Wrap Text General En Copy Fill Paste Format Painter BIUBLA Merge & Center - 9 % $68 508 Conditional Format Cell Insert Delete Format Sort & Find & Formatting * as Table . Styles 2 Clear Filter - Select Clipboard Font Alignment Number Styles Cells Editing A56 Prepaid Expenses A C D E F G H K L M N 1 INSTRUCTIONS: 2 Common Size the Income Statement and Balance Sheet to the right of the reports 3 Complete Ratios at Bottom - Make short comment to the right of the trends 4 Complete Problems from Book as indicated at the Bottom of the page 5 6 Exam Question Company Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending 8 31-03-2018 30-06-2018 30-09-2018 31-12-2018 31-03-2019 30-06-2019 30-09-2019 31-12-2019 03/31/2020 06/30/2020 09/30/2020 12/31/2020 03/31/2021 56 Prepaid Expenses 2,03,304 2,63,316 3,33,316 7,354 4,843 5,160 3,677 ,743 1,612 1,479 .348 2,366 1,802 57 Other Current Assets 0 91,667 66,667 41,667 16,666 0 194 194 164 58 Total Current Assets 14,79,314 15,44, 158 16,14,972 11,66,888 11,76,430 11,12,502 10,23,542 5,75,361 5,73,370 11,28,253 10,80,196 11,70,341 10,76,054 59 60 Property and Equipment, Net 61 Fixed Assets 4,40,904 4,40,904 4,26,900 4,52,637 4,53,946 4,53,946 4,53,946 4,53,946 4,57,113 4,57,114 4,64,779 4,61,611 4,61,611 62 Accumulated Depreciation 3,11,080 3,13,270 3,18,088 3,20,614 3,45,971 3,71,327 3,96,684 ,24,144 4,77,800 5,24,185 5,69,692 3,82,040 4,13,193 63 Total Property and Equipment, Net 1,29,824 1,27,634 1,08,812 1,32,023 1,07,975 82,619 57.262 29.802 (20,687) (67,071) (1,04,913) 79,571 48,418 64 Other Assets 65 Intangible Assets, Net 1,34,276 83,922 33,569 24,90,923 30,02,449 27,76,689 26,21,124 23,90,389 22,99,810 20,99,227 18,98,644 15,17, 162 14,91, 185 66 Other Assets 16,307 12,295 7,847 6,18,574 2,58,290 2,53,349 2,57,740 2,07,740 1,72,065 1,72,065 1,72,065 1,72,065 1,72,296 67 Investments 0 0 C 68 Total Other Assets 1,50.583 6.217 41.416 31,09,497 32,60,739 30,30.038 28,78,864 25,98, 129 24,71,875 22,71,292 20,70,709 16,89,227 16,63,481 70 Total Assets $ 17,59,721 $ 17,68,009 $ 17,65,200 $ 44,08,408 $ 45,45,144 $ 42,25,159 $ 39,59,668 $ 32,03,292 $ 30,24,558 $ 33,32,474 $ 30,45,992 $ 29,39,139 $ 27,87,953 71 72 Liabilities and Equity 73 Current Liabilities 74 Accounts Payable and Accrued Expenses 11,70,223 17,11,039 15,11,888 13,84,721 13,43,759 15,43,726 15,29,069 12,23, 196 12,09,182 11,44,689 10,37,840 10,42,566 9,80,260 75 Loans Payable, net of origination fees 1,00,000 0 6,000 79,998 94,339 62,743 76 Right of Use Operating Lease Obligation - cu 72,444 60,260 42,271 69,147 1,08,645 1,00,186 69,449 66,323 98,501 Deferred Revenue 61,201 55,099 73,140 69,988 59,834 44,276 42,867 53,075 38,094 38,001 37,748 37,677 77 78 Dividend Payable 54,117 30,000 22,500 79 Notes Payable - Shareholder 3,03,141 2,93,141 2,63,141 1,94,531 3,44,820 2,92,919 2,40,027 1,63,593 1,02,314 99,597 41,693 80 Total Current Liabilities 16.34,565 20.59,279 18.48.169 16.49,240 18,20.857 19,41.181 18.54.234 15,09.011 15.18,352 14.92.471 12.09.230 12.40,905 11.41,504 14 4 Statement of Earnings problem 11-1 detailed expl Ready Average: 687160.1752 Count: 311 Sum: 160795481 # 85% +Exercise 10.19.22 - Microsoft Excel X Layout Formulas Data Review View @ - - X E AutoSum - - 10 A A Wrap Text General Fill U BLA Merge & Center - % Conditional Format Cell Insert Delete Format Sort & Find & Formatting * as Table * Styles 2 Clear Filter . Select Font Alignment Number Styles Cells Editing Long Term Liabilities C D E F G H K M N ment and Balance Sheet to the right of the reports ke short comment to the right of the trends as indicated at the Bottom of the page Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Quarter Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending Ending 31-03-2018 30-06-2018 30-09-2018 31-12-2018 31-03-2019 30-06-2019 3 30-09-2019 31-12-2019 03/31/2020 06/30/2020 09/30/2020 12/31/2020 03/31/2021 3,03,141 2,93,141 2,63,141 1,94,531 3,44,820 2,92,919 2,40,027 1,63,593 1,02,314 99,59 41,693 0 16,34,565 20,59,279 18,48,169 16,49,240 18,20,857 19,41,181 18,54.234 15,09,011 15,18,352 14,92,471 12,09,230 12,40,905 11,41,504 0 0 0 0 23,075 17,508 ,62,992 1,39,450 1,80,953 3,62,993 3,29,542 ,65,400 3,14,992 28,854 28,854 28.854 28.854 28,854 65,273 29,987 31,087 544 0 31,942 32,943 32,943 40,692 40,692 40,693 40,693 40,693 40,692 40,692 40,692 40,692 40,692 37,83,261 41,39,734 43,01,717 70,41,696 72,81,535 74,14,595 73,01,658 73,80,029 73,90,286 74,00,543 74, 10,800 74,60,632 74,91,976 (31,90,874) (37, 18,901) (44,92,801) (44,46,483) (43,86,306) (46,49,869) (52,54,091) (53,89,896) (62,07,108) (61,06,269) (59,64,225) (59,44,272) (59,68,489) (5,25,763 (7,74,338 46,318 94.409 (2,63,563 (6,04,222 (1,75,805) (5,07,082) 1,00,839 1,42,044 19,953 (24,218) 2,32,722 98,566 (3,20,562) (1,11,823) 27,30.314 26,72,358 22,01,197 19,12,455 5,23,74 13,24,709 14,77,010 15,07,220 15,32,834 13,31,457 $ 17,61,985 $ 17,67,571 $ 17,65,200 $ 44,08,408 $ 45,45,144 $ 42,25,159 $ 39,59,668 $ 32,03,292 $ 30,24,558 $ 33,32,474 $ 30,45,992 $ 29,39,139 $ 27,87,953 S problem 11-1 detailed expl Average: 754745.8365 Count: 129 Sum: 78493567 : 0 1 85% +