Is my data and spark line correct 45.5%8.55%31.0%0.8%5.4%1.5%3.9%3.4%100.00%***Add Net IncomeSparkline for themonths of Jan. toMar. in Cell H24. 55 Sales7EspressoDrip CoffeeFood/Beverage390 Merchandise1 Computer23 Expenses4Cost of Goods5 Cost of Merchandise6 Payroll7 Internet8Building9Advertising20Capital Assets21Total SalesMiscellaneousTotal ExpNet IncomeBJAN$$$$$$$$$17,580 $3,710 $$26,400 $ 27,200 $ 26,500 $ 80,100 $26,700$ 14,400 $ 14,500 $ 14,800 $43,700 $14,567$11,100 $11,000 $10,800 $$5,300 $4,400 $4,500 $$ 1,050 $1,165 $$ 58,250 $58,265 $17,750 $3,080 $12,000 $ 12,000 $325 $325 $2,100 $600 $1,500 $1,300 $39,115 $2223 Income2425 Profit Margin2627 Student's Name: Sabrina MehariFEB$ 19,135 $32.85%DMAR1,245 $57,845 $ETOTAL17,545 $3,150 $12,000 $325 $2,100 $2,100 $600 $600 $1,500 $1,500 $1,300 $ 1,300 $38,655 $38,520 $FAVG32,900 $10,96714,200 $4,7333,460 $ 1,153174,360 $58,12052,875 $17,6259,940 $3,31336,000 $12,000975 $ 3256,300 $2,1001,800 $ 6004,500 $1,5003,900 $1,300116,290 $38,76319,610 $ 19,325 $ 58,070 $19,35733.66%33.41%33.30%33%GProportion45.94%25.06%18.87%8.14%1.98%100.00%45.5%8.55%31.0%0.8%5.4%1.5%3.9%3.4%100.00%H

Net income to sales is expressed as a profit margin. It gauges how much income the business makes…

Capital Assets 6 Payroll 7 Internet 8 Building 9 Advertising 0 1 2 3 Income 24 25 Profit Margin 26 27 Student's Name: Sabrina Mehari Miscellaneous Total Exp $ $ $ $ Net Income 12,000 $ 325 $ $ $ $ 12,000 $ 325 $ 2,100 $ 600 $ $ 19,135 $ 32.85% 12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 1,300 $ 38,520 $ 2,100 $ 600 $ 1,500 $ 1,300 $ 39,115 $ 38,655 $ 19,610 $ 19,325 $ 33.66% 33.41% 36,000 $12,000 975 $ 325 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 116,290 $38,763 58,070 $19,357 33.30% 33% 31.0% 0.8% 5.4% 1.5% 3.9% 3.4% 100.00%

Capital Assets 6 Payroll 7 Internet 8 Building 9 Advertising 0 1 2 3 Income 24 25 Profit Margin 26 27 Student's Name: Sabrina Mehari Miscellaneous Total Exp $ $ $ $ Net Income 12,000 $ 325 $ $ $ $ 12,000 $ 325 $ 2,100 $ 600 $ $ 19,135 $ 32.85% 12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 1,300 $ 38,520 $ 2,100 $ 600 $ 1,500 $ 1,300 $ 39,115 $ 38,655 $ 19,610 $ 19,325 $ 33.66% 33.41% 36,000 $12,000 975 $ 325 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 116,290 $38,763 58,070 $19,357 33.30% 33% 31.0% 0.8% 5.4% 1.5% 3.9% 3.4% 100.00%

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Indo 37 1 2 B S 0 Clipboard Sales Espresso Drip Coffee A Food/Beverage Merchandise 1 P 3 Expenses Computer Total Sales = First Q alculation Mode: Automatic 74°F Haze $ $ Font fx 26400 B JAN C Downtown Internet Café First Quarter Forecast $ 11,100 $ 5,300 $ $ $ 1,050 $ First Q Goal Seek FEB D 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,000 $ 10,800 $ 4,400 $ 4,500 $ 1,165 $ 1,245 $ Workbook Statistics MAR E Minivan Loan + Alignment TOTAL F AVG Proportion 80,100 $ 26,700 43,700 $14,567 32,900 $10,967 14,200 $ 4,733 3,460 $ 1,153 OL Number H E I
Homework i A company reports the following sales-related information. Sales, gross Sales discounts $295,000 Sales returns and allowances 5,900 Sales salaries expense Prepare the net sales portion only of this company's multiple-step income statement. Net sales Multiple-Step Income Statement (Partial) Saved < Prev. $ 22,000 11,900 10 of 10 HH hp n
Use the following to answer questions 30 – 35 Find the missing amounts: Case 1 Case 2 Case 3 Net Sales S687,000 $922,500 COGS ? 478,500 654,000 Gross profit 324.100 456.000| Operating expense 299,500 354,200 Operating income ? ? 94.500 30. $ sold For case 1, determine cost of goods 31. $ For case 1, determine operating income (include “-“ if needed) 32. $ For case 2, determine gross profit 33. $ (include For case 2, determine operating income “_“ if needed) 34. $ For case 3, determine net sales 35. $ For case 3, determine operating expense
BCengageNOW2 1Online teach x+ Ohttps://v2.cengagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress false Chapter 11 Homework eBook Show Me How Print Item Computing Gross Profit The following data were taken from the accounts of Burnside Bedknobs, a retail business. Sales $119,600 Sales returns and allowances 1,160 Sales discounts 360 Merchandise Iinventory, January 1 28,100 Purchases during the period 93,900 Purchases returns and allowances during the period 1,900 Purchases discounts taken during the period 2,820 Freight-in on merchandise purchased during the period 1,480 Merchandise inventory, December 31 50,000 Determine the gross profit. Previous Next Check My Work 1 more Check My Work uses remaining. Save and Exit Submit Assignment for Grading Assignment Score: 2% All work saved. 225 PM 4/10/2021 Type here to search
100 l 6 2 2_524467555402776... Q1_ The following balances appeared in the trail balance for the year 2020 of AL-Nada co? Accounts Sales Purchases commission Purchases Balance 830 000 18 000 |480 000 90 000 2 000 000 165 00 Accounts Balance 7 000 Repair Interest received 25 000 Revenue 70 000 Purchases return Sales allowance 20 000 Creditors Freight out Loan 3 000 000 Import customs 22 000 Purchases allowance 25 000 Beginning inventory 90 000 Purchases discount Building 10 000 5 000 000 Sales discount 8 000 Sales insurance 20 000 Cars 18 000 000 Purchases insurance 10 000 Sales commission |21 000 Salaries 120 000 ighting Purchases expenses Depreciation cash 14 000 Rent 80 000 |26 000 18 000 Sales return 12 000 Bank 10 000 000 1 200 000 Debtors 2 000 000 Ending inventory 65 000 Capital Ins: 1_ Prepare the trading statement for the year ended in 2020. 2_Prepare the profit and loss statement for the year ended 2020. 3_Prepar a classified balance sheet in a good format (use statement form)
What is the cost of goods sold? O A. $751,700 OB. $364,500 O C. $455,400 O D. $520,600
Net sales OR 156000 Cost of the goods sold OR 99700 Details Debit Credit General expenses 11700 Furniture 5100 Salaries 9300 Depreciation 2000 Account Payable 3575 Dividend Revenue 2500 Calculate net profit Select one: O a. RO 36240 O b. RO 31140 O c. RO 35800 O d. RO 34715
Operating expenses $ 50000 Sales returns and allowances 6000 Sales discounts 5000 Sales revenue 140000 Cost of goods sold 86000 The amount of net sales on the income statement would be $140000. $135000. $129000. $134000.
Sales Sales Returns & Allowances Sales Discount Purchases Freight in Purchase Renurns & Allowances Purchase Discount Beginning Inventory Ending Inventory Operating expenses Other Income Otber Expenses P 780,000 15,000 19,000 420,000 12,000 8,000 2,000 50,000 80,000 120,000 16,000 3,000 How much is the cost of goods available for sale? P 4E0.000 P 472,000 P448,000 P 470,000
Find the commission # Sales Position 8 Real Estate 9 Computers 10 Major Appliances 11 Clothing 12 Computer Supplies 13 Siding Contract 14 Auto Total Sales X Straight Commission $198,000 18,100 X 9,598 X 1,311 X 929 68,417 X X X X Rate 8% 2% 6% 9% 16% 12% = = = = = = Commission 690.48 2,052.51
SIAMSQUARE SAMYAN CBS1 Sales 2,818,700 1,882,000 1,846,000 Trading profit 944,276 682,225 669,175 Operating expenses 968,377 595,161 553,530 Salary 231,000 232,500 223,500 Interest 3,184 499 499 Marketing Rental 328,000 288,000 260,000 Overflow charge warehouse Overflow charge retail 164,340 Penalty charges 120,000 Depreciation charges 60,000 Loss due to asset disposal Claims 61,853 74,162 41,531 Maintenance Customer service Logistic Human resource Net profit 24.101 87,064 115,645 The following are some of PT SIAMSQUARE's financial statements and competitor data. If you are a Management consultant, analyze the financial condition of PT SIAM SQUARE, through the following questions: a) What is Siam Square's return on sales ratio and when compared to its competitors how is Siam Square's performance?
J Gross Sales Sales Return & Allowances Sales Discounts Cost of Merchandise Sold 33,000 O $87,000 O $46,000 100,000 Given the above values, determine Net Sales. O $67,000 10,000 O $54,000 3,000 Need help? Review these concept resources.