EXCEL FORMULA:
Use the following information for Taco Swell, Inc., (assume the tax rate is 24 percent): Sales...
Use the following information for Taco Swell, Inc., (assume the tax rate is 30 percent): 2014 2015 Sales Depreciation Cost of goods sold Other expenses interest Cash Accounts receivable Short-term notes payable Long-term debt Net fixed assets Accounts payable Inventory Dividends $19,573 $17.736 1,821 1896 4,779 4,867 904 1,026 875 1.006 6,307 6,946 8,200 9,907 1,307 20,800 25,036 51,240 58,030 4,640 5,124 14,555 15,448 1,750 1,778 1,330 For 2015, calculate the cash flow from assets, cash flow to creditors, and...
Use the following information for Taco Swell, Inc., (assume the tax rate is 22 percent): 2017 2018 Sales $ 14,573 $ 14,736 Depreciation 1,721 1,796 Cost of goods sold 4,279 4,767 Other expenses 976 854 Interest 825 956 Cash 6,157 6,646 Accounts receivable 8,100 9,607 Short-term notes payable 1,230 1,207 Long-term debt 20,500 24,786 Net fixed assets 51,020 54,453 Accounts payable 4,480 4,824 Inventory 14,385 15,348 Dividends 1,250 1,678 Prepare a balance sheet for this company for 2017...
Use the following information for Taco Swell, Inc, (assume the tax rate is 21 percent evi 2017 ."2018-tel Sales Depreciation Cost of goods sold Other expenses Interest $18,073 $16,836 1,791 1,866 4,837 ,011 889 991 6,2626,856 4,629 860 Cash Accounts receivable 8,170 9,817 Short-term notes 1,300 1,277 payable Long-term debt Net fxed assets Accounts payable4,592 5,034 Inventory Dividend:s 20,710 24,961 51174 54,663 14,504 15,418 1,6001,748 Prepare an income statement for this company for 2017 and 2018. (Do not round intermediate...
Use the following information for Taco Swell, Inc., (assume the tax rate is 21 percent): 2017 $ 16,073 1,751 4,429 991 840 6,202 Sales Depreciation Cost of goods sold Other expenses Interest Cash Accounts receivable Short-term notes payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 2018 $ 15,636 1.826 4,797 869 971 6,736 9,697 1,237 24,861 54,543 4,914 15,378 1,708 1,260 20,590 51,086 4,528 14,436 1,400 Prepare a balance sheet for this company for 2017 and 2018. (Do...
Use the following information for Taco Swell, Inc., (assume the tax rate is 23 percent) 2017 2018 Sales Depreciation Cost of goods sold Other expenses Interest Cash Accounts receivable Short-term notes 13,073 $13,836 1,691 1,766 4,129 4,737 839 941 6,112 6,556 9,517 961 810 8,070 1,200 1,177 payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 20,410 24,711 50,954 54,363 4,432 4,734 14,334 15,318 1,648 1,100 intermediate calculations.) TACO SWELL, INC. Balance Sheet as of Dec. 31 2017 2018...
Use the following information for Taco Swe Inc., (assume the tax rate is 21 percent) 2017 2018 16,073 $15,636 1,826 Sales Depreciation Cost of goods sold 4,429 4,797 Other expenses Interest Cash Accounts receivable 8,1309,697 Short-term notes 1,751 991 840 6,202 869 971 6,736 1,260 1,237 payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 20,590 24,861 51,086 54,543 4,914 14,436 15,378 1,708 4,528 1,400 Prepare a balance sheet for this company for 2017 and 2018. (Do not round...
Use the following information for Taco Swel, Inc., (assume the tax rate is 22 percent): 2017 2018 $ 14,573 $ 14,736 1,721 ,796 Sales Depreciation Cost of goods sold 4,279 4,767 Other expenses Interest Cash Accounts receivable 8,100 9,607 Short-term notes 854 956 6,157 6,646 976 825 1,230 1,207 payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 20,500 24,786 51,020 54,453 4,480 4,824 14,385 15,348 ,250 1,678 Prepare a balance sheet for this company for 2017 and 2018....
Use the following information for Taco Swell, Inc., (assume the tax rate is 21 percent): 2017 2018 Sales $ 17,049 $ 18,798 Depreciation 2,386 2,494 Cost of goods sold 5,740 6,741 Other expenses 1,350 1,183 Interest 1,115 1,330 Cash 8,681 9,277 Accounts receivable 11,498 13,512 Short-term notes payable 1,684 1,651 Long-term debt 29,090 35,254 Net fixed assets 72,792 77,640 Accounts payable 6,275 6,670 Inventory 20,441 21,872 Dividends 2,029 2,324 For 2018, calculate the cash flow from assets, cash flow...
Use the following information for Taco Swell, Inc., (assume the tax rate is 21 percent) 2017 2018 $17,049 $ 18,798 Sales Depreciation 2,386 2,494 5,740 6,741 Cost of goods sold Other expenses 1,350 1,183 1,115 1,330 8,681 9,277 Accounts receivable 11,49813,512 Interest Cash Short-term notes 1,684 1,651 payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 29,090 35,254 72,792 77,640 6,2756,670 20,441 21,872 2,0292,324 For 2018, calculate the cash flow from assets, cash flow to creditors, and cash flow...
Use the following Information for Taco Swell, Inc, (assume the tax rate is 21 percent 2017 2018 17049 $ 18,798 2,386 2,494 Sales Depreciation Cost of goods sold5,740 6,741 Other expenses50 1183 Interest Cash Accounts receivable 11,498 13,512 Short-term notes 5 1,330 8,681 9,277 1,684 1,651 29,090 35,254 payable Long-term debt Net fixed assets 72,792 77640 Accounts payable6,2756,670 Inventory Dividends 20,441 21,872 2,029 2,324 For 2018, calculate the cash flow from assets, cash flow to creditors, and cash flow to...