Determination of value of Service tax and Final price:
A | B (Value) | |
4 | Discount in dollars ($) (180×0.2) | 36 |
5 | Net price ($) (180-36) | 144 |
7 | Service tax in dollars ($) (144×0.09) | 12.96 |
8 | Final price ($) (144+12.96) | 156.96 |
Service tax is $ 12.96
Final price is $ 156.96
Wk Qu. 4-13 A student prepared the following.. A student prepared the following spreadsheet model to...
Wk Qu. 4-11 In the spreadsheet model... In the spreadsheet model shown below, an analyst makes the following data entries. Cell Value B3 88,000 B4 86,000 B5 83,000 B6 L 95,000 Revenue 2 Month 3 January 4 February 5 March 6 April Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5/B5 What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Value Cell C4 |
Wk Qu. 4-12 An analyst built the following... An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). TA 1 2 Unit Price 3 Unit Cost 4 Unit Gross Profit 10 5.73 Unit Price - Unit_Cost Quantity Sold 7,500 6 7 8 9 10 11 12 ost Gross Revenue Variable Costs Fixed Costs Net Profit Profit per Unit = Quantity_Sold x Unit Price = Quantity_Sold x...
The management of Zigby Manufacturing prepared the following
estimated balance sheet for March 2019.
ZIGBY MANUFACTURING
Estimated Balance Sheet
March 31, 2019
Assets
Cash
$
42,000
Accounts receivable
364,000
Raw materials inventory
107,200
Finished goods inventory
349,440
Total current assets
862,640
Equipment
604,000
Accumulated depreciation
(152,000
)
Equipment, net
452,000
Total assets
$
1,314,640
Liabilities and Equity
Accounts payable
$
211,300
Short-term notes payable
14,000
Total current liabilities
225,300
Long-term note payable
510,000
Total liabilities
735,300
Common stock
337,000
Retained...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Accounts receivable Ravw materials inventory Finished goods inventory Total cument assets 438.750 Accumulated depreciation 158,000 Total assets Liabilities and Equity Short-tem notes pay able Total current liabilities Long-tem note payable Total stockholders' equity Total liabilities and equity To prepare a master budget for April, May, and June of 2017, management gathers the following information: a. Sales for...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash 58,000 484,640 91,290 Accounts receivable Raw materials inventory Finished goods inventory 393,304 Total current assets 1,027,234 Equipment, gross Accumulated depreciation Equipment, net 636,000 168,000) 468,000 $1,495,234 Total assets Liabilities and Equity Accounts payable Short-term notes payable 206,390 30,000 Total current liabilities 236,390 Long-term note payable Total liabilities 525,000 761,390 Common stock 353,000 Retained earnings 380,844 Total...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity 65,000 437,760 90, 200 308, 028 900,988 630,000 (165,000) 465,000 $...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets 43,ee0 432,900 Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets 86,198 387,168 949,266 606,000 (153,000) 453,000 Equipment Accumulated depreciation Equipment, net Total assets $1,402,266 Liabilities and Equity 194,798 15,000 Accounts payable Short-term notes payable 209,798 s00,e00 Total current liabilities Long-term note payable Total liabilities 709,798 Common stock 338, еее 354,468 692,468 Retained earnings...
I need help on part 9 & 10 and 8
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets $ 65,000 437,760 90,200 Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets 308,028 900,988 630,000 165,00 Equipment, gross Accumulated depreciation Equipment, net 465,000 1,365,988 Total assets Liabilities and Equity $ 204, 500 Accounts payable Short-term notes payable Total current liabilities 27,000 231,500 Long-term...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 44,000 500,000 90,200 444,000 1,078, 200 608,000 (154,000) 454,000 $1,532,200...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2817 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets $44,888 58e,8e 98,288 444,888 1,878,288 688,888 154,888) 454,88e $ 1,532,288 Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity...