70.2K

Verified Solution

Link Copied!

Analyze and explain each vertical analysis ( balance sheet and income statement) give explanation in each data.

Boston Brewin Coffee Co. Balance Sheet For the year ended December 31, 2015 and 2016 Cash Inventory Total Current Assets Long-Term Assets Accumulated Depreciation Total Long-Term Assets Total Assets Accounts Payable Total Current Liabilities Long-Term Debt Total Liabilities Paid-In Capital Retained Earnings Earnings Total Owner's Equity Total Liabilities & Equity 2019 ($) 2018 ($) 2017 (8) 2016 (S) 2015 ($) 2019 2018 2017 2016 2015 2548403 2206433 1900463 1627997 1389872 100.00% 100.00% 100.00% 100.00% 100.00% 131949 131945 129118 126318 123517 5.18% 5.98% 6.79% 7.76% 8.89% 2680352 2338378 2029581 1754315 1513389 105.18% 105.98% 106.79% 107.76% 108.89% 224000 224000 224000 224000 224000 8.79% 10.15% 11.79% 13.76% 16.12% 224000 179200 134400 89600 44800 8.79% 8.12% 7.07% 5.50% 3.22% 0 44800 89600 134400 179200 0.00% 2.03% 4.71% 8.26% 12.89% 2680352 2383178 2119181 1888715 1692589 105.18% 108.01% 111.51% 116.01% 121.78% 10192 10192 10050 9910 9770 0.40% 0.46% 0.53% 0.61% 0.70% 10192 10192 10050 9910 9770 0.40% 0.46% 0.53% 0.61% 0.70% 305099 572433 826755 1068699 1298867 11.97% 25.94% 43,50% 65.65% 93,45% 315291 582625 836805 1078609 1308637 12.37% 26.41% 44.03% 66,25% 94.16% 1500000 1500000 1500000 1500000 1500000 58.86% 67.98% 78 92.14% 107.92% 1605553 1087376 615106 188952 0 63.00% 49.28% 32.37% 11.61% 0.00% 744508 698177 652270 606154 368952 29.21% 31.64% 34.32% 37.23% 26.55% 3850061 3285553 2767376 2295106 1868952 151.08% 148.91% 145.62% 140.98% 134.47% 4165352 3868178 3604181 3373715 3177589 163.45% 175.31% 189.65% 207.23% 228.62% Boston Brewin Coffee Co. Income Statement For the year ended December 31, 2015 and 2016 2019 Revenue Direct Cost Gross Margin Total Operating Expense Operating income Interest incurred Depreciation and Amortization Income Taxes Total Expenses Net Profit 2019 () 2018 (5) 2017 (5) 2016 ($) 2015 ($) 2018 2017 2016 2015 4948000 4842000 4737000 4632000 44547000 194.16% 219.45% 249.26% 284.52% 3205.12% 1583360 1549440 1515840 1482240 1425504 62.13% 70.22% 79.76% 91.05% 102.56% 3364640 3292560 3221160 3149760 3029196 132.03% 149.23% 169.49% 193.47% 217.95% 2389353 2360763 2332969 2306032 2469860 93.76% 106.99% 122.76% 141.65% 177.70% 975287 931797 888191 843728 559336 38.27% 42.23% 46.74% 51.83% 40.24% 22550 35562 47940 59716 64594 0.88% 1.61% 2.52% 3.67% 4,65% 44800 44800 44800 44800 44800 1.76% 2.03% 2.36% 2.75% 3.22% 163429 153258 143181 133058 80990 6,41% 6.95% 7.53% 8.17% 5.83% 4203492 4143823 40847304025846 4085748 164.95% 187.81% 214.93% 247.29% 293,97% 744508 698177 652270 606154 368952 29.21% 31.64% 34.32% 37.23% 26.55% Boston Brewin Coffee Co. Balance Sheet For the year ended December 31, 2015 and 2016 Cash Inventory Total Current Assets Long-Term Assets Accumulated Depreciation Total Long-Term Assets Total Assets Accounts Payable Total Current Liabilities Long-Term Debt Total Liabilities Paid-In Capital Retained Earnings Earnings Total Owner's Equity Total Liabilities & Equity 2019 ($) 2018 ($) 2017 (8) 2016 (S) 2015 ($) 2019 2018 2017 2016 2015 2548403 2206433 1900463 1627997 1389872 100.00% 100.00% 100.00% 100.00% 100.00% 131949 131945 129118 126318 123517 5.18% 5.98% 6.79% 7.76% 8.89% 2680352 2338378 2029581 1754315 1513389 105.18% 105.98% 106.79% 107.76% 108.89% 224000 224000 224000 224000 224000 8.79% 10.15% 11.79% 13.76% 16.12% 224000 179200 134400 89600 44800 8.79% 8.12% 7.07% 5.50% 3.22% 0 44800 89600 134400 179200 0.00% 2.03% 4.71% 8.26% 12.89% 2680352 2383178 2119181 1888715 1692589 105.18% 108.01% 111.51% 116.01% 121.78% 10192 10192 10050 9910 9770 0.40% 0.46% 0.53% 0.61% 0.70% 10192 10192 10050 9910 9770 0.40% 0.46% 0.53% 0.61% 0.70% 305099 572433 826755 1068699 1298867 11.97% 25.94% 43,50% 65.65% 93,45% 315291 582625 836805 1078609 1308637 12.37% 26.41% 44.03% 66,25% 94.16% 1500000 1500000 1500000 1500000 1500000 58.86% 67.98% 78 92.14% 107.92% 1605553 1087376 615106 188952 0 63.00% 49.28% 32.37% 11.61% 0.00% 744508 698177 652270 606154 368952 29.21% 31.64% 34.32% 37.23% 26.55% 3850061 3285553 2767376 2295106 1868952 151.08% 148.91% 145.62% 140.98% 134.47% 4165352 3868178 3604181 3373715 3177589 163.45% 175.31% 189.65% 207.23% 228.62% Boston Brewin Coffee Co. Income Statement For the year ended December 31, 2015 and 2016 2019 Revenue Direct Cost Gross Margin Total Operating Expense Operating income Interest incurred Depreciation and Amortization Income Taxes Total Expenses Net Profit 2019 () 2018 (5) 2017 (5) 2016 ($) 2015 ($) 2018 2017 2016 2015 4948000 4842000 4737000 4632000 44547000 194.16% 219.45% 249.26% 284.52% 3205.12% 1583360 1549440 1515840 1482240 1425504 62.13% 70.22% 79.76% 91.05% 102.56% 3364640 3292560 3221160 3149760 3029196 132.03% 149.23% 169.49% 193.47% 217.95% 2389353 2360763 2332969 2306032 2469860 93.76% 106.99% 122.76% 141.65% 177.70% 975287 931797 888191 843728 559336 38.27% 42.23% 46.74% 51.83% 40.24% 22550 35562 47940 59716 64594 0.88% 1.61% 2.52% 3.67% 4,65% 44800 44800 44800 44800 44800 1.76% 2.03% 2.36% 2.75% 3.22% 163429 153258 143181 133058 80990 6,41% 6.95% 7.53% 8.17% 5.83% 4203492 4143823 40847304025846 4085748 164.95% 187.81% 214.93% 247.29% 293,97% 744508 698177 652270 606154 368952 29.21% 31.64% 34.32% 37.23% 26.55%

Answer & Explanation Solved by verified expert

See Answer