Excel Project

Create a pivot table to summarize the long-term portion of the (a) capital lease liability, (b) the finance lease liability, and (c) the operating lease liability over the 10-year period 2012-2021 on a separate worksheet. Label the worksheet LeaseLiability.

Please provide me steps

File Home Insert Page Layout Formulas Data Review View Help 3 Share Comments X Insert Calibri 11 AF == ab Wrap Text General ITH 28 O FO LA Paste B I U CA 3 Merge & Center $ % ti. 3X Delete Format Sort & Find & Filter Select Conditional Format as Cell Formatting Table Styles Styles Analyze Data Sensitivity Clipboard Font Alignment Number Cells Editing Analysis Sensitivity F14 X B D E F H 1 K M N 1 Company Year 2 Caswell Company 2012 3 Caswell Company 2013 4 Caswell Company 2014 5 Caswell Company 2015 6 Caswell Company 2016 7 Caswell Company 2017 8 Caswell Company 2018 well Company 20 10 Caswell Company 2020 11 Caswell Company 2021 12 13 14 15 16 17 Sheet2 Sheet1 Cash and cash equivalents 7,257 4,871 7,727 10,122 9,359 9,929 11,501 8,906 9,145 10,922 Assets of Prepaid Total Receivables, discontinued expenses current net Inventory operations and other assets Land 3,907 36,929 307 4,889 53,289 27,138 6,294 45,044 1,431 5,160 62,800 27,222 3,438 37,724 5,924 7,796 62,609 27,231 1,042 28,604 3,524 8,143 51,436 27,302 3,206 35,124 18,280 8,267 72,836 27,582 2,135 26,343 27,555 8,044 73,107 27,209 6,263 27,347 30,204 7,787 76,502 26,347 ,258 31,907 29,573 9,240 81.8 5,747 7,246 32,517 46,730 7,158 97,295 31,267 9,464 42,335 18,540 6,464 78,225 22,949 Buildings and Fixtures and improvements equipment 117,116 24,458 113,701 23,764 115,719 23,760 135,179 23,107 122,624 23,831 141,383 22,849 102,810 21,951 95,400 21,080 84,228 34,105 87,447 24,829 Computer Property hardware Less and and accumulated equipment, software depreciation net 11,782 (55,391) 125,103 11,631 (56,613) 119,705 11,347 (58,813) 119,244 10,644 (69,516) 126,716 11,409 (60,050) 125,396 10,969 (55,031) 147,379 11.258 (51,356) 111,010 11,444 (46 107,071 12,406 (65,861) 96,145 9,504 (45,057) 99,672 Goody 4, 5, 7,4 5,2 10,4 8,8 6,9 6,0 3,4 3,1 Sheet1 + Ready 1009 File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 = - A a Wrap Text General I Insert 9X Delete 2 O FO Paste BIU ara- $ %) Merge & Center 8 Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis Sensitivity F14 X fa N o P R s T U V w X Y Z Property and Right of use Right of asset - use asset operating finance, net, net 1 Investments in equity securities 102 1,231 2 3 Property under capital lease 5,498 5,330 2,256 2,340 2,504 4 equipment, net 125,103 119,705 119,244 126,716 125,396 147,379 111,010 107,071 96,145 99,672 309 Goodwill 4,369 5,160 7,275 5,285 10,214 8,867 6,960 6,015 3,466 3,754 - Current portion capital lease 396 384 172 184 200 199 208 AA AB AC Current Current portion of portion of lease lease Curr liability - liability portid finance operating long-t lease lease del 1 2. 3 2 4 1 2 301 602 2 392 583 4 400 533 2 Total noncurrent Total assets assets 135,072 188,361 131,426 194,226 129,084 191,693 136,577 188,013 140,333 213,169 159,192 232,299 122,742 199,244 124,484 206,368 107,966 205,261 110,913 189,138 o covou Current Accrued liabilities of income discontinued taxes operations 810 458 898 850 1,946 65 1,024 102 1,341 188 1,185 81 214 87 866 90 Accounts payable 24,651 17,929 22,319 15,835 16,813 17,158 20,019 20.724 22, 172 20,521 2,236 2,219 Accrued liabilities 16,609 22,189 14,544 19,822 20,913 23,116 6,997 8,977 7,130 5,522 2,612 334 2,502 5,030 4,022 3,875 10 2,270 1,556 1,322 578 4,812 3,011 3,034 11 12 13 14 15 16 17 Sheet2 Sheet1 Ready A L 100% File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert v Calibri 11 ~ A == ab Wrap Text General 47 0 @ La 9X Delete Paste MA + E Merge & Center $ % 98 99 Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Sort & Find & Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity F14 X U V W X Y Z AD AE AF AG AH AI AJ A Current Accrued liabilities of income discontinued taxes operations 810 458 Total 1 assets 2 188,361 3 194,226 4 191,693 5 188,013 6 213,169 7 232,299 8 199,244 9 206,3 10 205,261 11 189,138 12 13 14 Current portion capital lease 396 384 172 184 200 199 208 Accounts payable 24,651 17,929 22,319 15,835 16,813 17,158 20,019 20,724 22,172 20,521 - AA AB AC Current Current portion of portion of lease lease Current liability liability portion of finance operating long-term lease lease debt 1,931 2,253 3,435 2,970 4,001 1,529 2,977 301 2,966 392 583 4,113 400 533 2,357 Accrued liabilities 16,609 22,189 14,544 19,822 20,913 23,116 6,997 8,97 7,130 5,522 - 898 850 1,946 1,024 1,341 1,18 214 866 Lease Lease Capital liability - liability - Deferred Long-term lease operatin finance income debt liability g lease lease taxes 56,906 5,283 8,223 63,269 5,118 6,443 65,914 2,293 7,748 61,904 2,453 8,367 73,270 2,660 7,511 64,429 2,648 7,410 71,134 2,772 4,308 88,438 3,971 2,929 4,379 83,192 3,807 2,993 3,806 Total current liabilities 45,385 44,349 43,466 41,259 44,947 45,172 32,928 36,507 35,620 31,728 Short-term borrowings 988 1,136 2,098 1,598 1,009 2,044 1,198 1,671 929 1,439 5,483 65 102 188 81 87 90 15 16 17 Sheet2 Sheet1 # + Ready 1 100% File Home Insert Page Layout Formulas Data Review View Help 3 Share Comments X Insert Calibri 11 AF == ab Wrap Text General ITH 28 O FO LA Paste B I U CA 3 Merge & Center $ % ti. 3X Delete Format Sort & Find & Filter Select Conditional Format as Cell Formatting Table Styles Styles Analyze Data Sensitivity Clipboard Font Alignment Number Cells Editing Analysis Sensitivity F14 X B D E F H 1 K M N 1 Company Year 2 Caswell Company 2012 3 Caswell Company 2013 4 Caswell Company 2014 5 Caswell Company 2015 6 Caswell Company 2016 7 Caswell Company 2017 8 Caswell Company 2018 well Company 20 10 Caswell Company 2020 11 Caswell Company 2021 12 13 14 15 16 17 Sheet2 Sheet1 Cash and cash equivalents 7,257 4,871 7,727 10,122 9,359 9,929 11,501 8,906 9,145 10,922 Assets of Prepaid Total Receivables, discontinued expenses current net Inventory operations and other assets Land 3,907 36,929 307 4,889 53,289 27,138 6,294 45,044 1,431 5,160 62,800 27,222 3,438 37,724 5,924 7,796 62,609 27,231 1,042 28,604 3,524 8,143 51,436 27,302 3,206 35,124 18,280 8,267 72,836 27,582 2,135 26,343 27,555 8,044 73,107 27,209 6,263 27,347 30,204 7,787 76,502 26,347 ,258 31,907 29,573 9,240 81.8 5,747 7,246 32,517 46,730 7,158 97,295 31,267 9,464 42,335 18,540 6,464 78,225 22,949 Buildings and Fixtures and improvements equipment 117,116 24,458 113,701 23,764 115,719 23,760 135,179 23,107 122,624 23,831 141,383 22,849 102,810 21,951 95,400 21,080 84,228 34,105 87,447 24,829 Computer Property hardware Less and and accumulated equipment, software depreciation net 11,782 (55,391) 125,103 11,631 (56,613) 119,705 11,347 (58,813) 119,244 10,644 (69,516) 126,716 11,409 (60,050) 125,396 10,969 (55,031) 147,379 11.258 (51,356) 111,010 11,444 (46 107,071 12,406 (65,861) 96,145 9,504 (45,057) 99,672 Goody 4, 5, 7,4 5,2 10,4 8,8 6,9 6,0 3,4 3,1 Sheet1 + Ready 1009 File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 = - A a Wrap Text General I Insert 9X Delete 2 O FO Paste BIU ara- $ %) Merge & Center 8 Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis Sensitivity F14 X fa N o P R s T U V w X Y Z Property and Right of use Right of asset - use asset operating finance, net, net 1 Investments in equity securities 102 1,231 2 3 Property under capital lease 5,498 5,330 2,256 2,340 2,504 4 equipment, net 125,103 119,705 119,244 126,716 125,396 147,379 111,010 107,071 96,145 99,672 309 Goodwill 4,369 5,160 7,275 5,285 10,214 8,867 6,960 6,015 3,466 3,754 - Current portion capital lease 396 384 172 184 200 199 208 AA AB AC Current Current portion of portion of lease lease Curr liability - liability portid finance operating long-t lease lease del 1 2. 3 2 4 1 2 301 602 2 392 583 4 400 533 2 Total noncurrent Total assets assets 135,072 188,361 131,426 194,226 129,084 191,693 136,577 188,013 140,333 213,169 159,192 232,299 122,742 199,244 124,484 206,368 107,966 205,261 110,913 189,138 o covou Current Accrued liabilities of income discontinued taxes operations 810 458 898 850 1,946 65 1,024 102 1,341 188 1,185 81 214 87 866 90 Accounts payable 24,651 17,929 22,319 15,835 16,813 17,158 20,019 20.724 22, 172 20,521 2,236 2,219 Accrued liabilities 16,609 22,189 14,544 19,822 20,913 23,116 6,997 8,977 7,130 5,522 2,612 334 2,502 5,030 4,022 3,875 10 2,270 1,556 1,322 578 4,812 3,011 3,034 11 12 13 14 15 16 17 Sheet2 Sheet1 Ready A L 100% File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert v Calibri 11 ~ A == ab Wrap Text General 47 0 @ La 9X Delete Paste MA + E Merge & Center $ % 98 99 Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Sort & Find & Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity F14 X U V W X Y Z AD AE AF AG AH AI AJ A Current Accrued liabilities of income discontinued taxes operations 810 458 Total 1 assets 2 188,361 3 194,226 4 191,693 5 188,013 6 213,169 7 232,299 8 199,244 9 206,3 10 205,261 11 189,138 12 13 14 Current portion capital lease 396 384 172 184 200 199 208 Accounts payable 24,651 17,929 22,319 15,835 16,813 17,158 20,019 20,724 22,172 20,521 - AA AB AC Current Current portion of portion of lease lease Current liability liability portion of finance operating long-term lease lease debt 1,931 2,253 3,435 2,970 4,001 1,529 2,977 301 2,966 392 583 4,113 400 533 2,357 Accrued liabilities 16,609 22,189 14,544 19,822 20,913 23,116 6,997 8,97 7,130 5,522 - 898 850 1,946 1,024 1,341 1,18 214 866 Lease Lease Capital liability - liability - Deferred Long-term lease operatin finance income debt liability g lease lease taxes 56,906 5,283 8,223 63,269 5,118 6,443 65,914 2,293 7,748 61,904 2,453 8,367 73,270 2,660 7,511 64,429 2,648 7,410 71,134 2,772 4,308 88,438 3,971 2,929 4,379 83,192 3,807 2,993 3,806 Total current liabilities 45,385 44,349 43,466 41,259 44,947 45,172 32,928 36,507 35,620 31,728 Short-term borrowings 988 1,136 2,098 1,598 1,009 2,044 1,198 1,671 929 1,439 5,483 65 102 188 81 87 90 15 16 17 Sheet2 Sheet1 # + Ready 1 100%