Using the figures from the income statement, calculate the net profit margin for last year and...

  

Transcribed Image Text:

Using the figures from the income statement, calculate the net profit margin for last year and this year. To find the net profit margin, use the Excel formula for division:=net income/net sales Use the division formula to calculate the net profit margin: -net income/net sales. Your result should be a decimal value between 0 and 1. A 26 Category 27 Net income 28 Net sales 29 Net profit margin B This Year Last Year $466,670.00 $336,405.00 $3,250,615.00 $2,887,545.00 0.14 0.12 4 Just Running Income Statement 5 Category This Year Last Year 6 Revenue 7 Net sales 8 Cost of goods sold 9 10 Operating expenses $3,250,615.00 $2,887,545.00 $1,989,483.00 $1,876,904.00 Gross profit $1,261,132.00 $1,010,641.00 11 Selling, general, and administrative $657,178.00 $577,118.00 expenses 12 Interest expense $8,755.00 $6,218.00 13 Income tax expense $145,509.00 $103,970.00 14 Total operating expenses $811,442.00 $687,306.00 15 Other income and expenses 16 Other income $12,312.00 $9,399.00 17 Gain on financial instruments $4,668.00 $3,671.00 18 Net income $466,670.00 $336,405.00 Using the figures from the income statement, calculate the net profit margin for last year and this year. To find the net profit margin, use the Excel formula for division:=net income/net sales Use the division formula to calculate the net profit margin: -net income/net sales. Your result should be a decimal value between 0 and 1. A 26 Category 27 Net income 28 Net sales 29 Net profit margin B This Year Last Year $466,670.00 $336,405.00 $3,250,615.00 $2,887,545.00 0.14 0.12 4 Just Running Income Statement 5 Category This Year Last Year 6 Revenue 7 Net sales 8 Cost of goods sold 9 10 Operating expenses $3,250,615.00 $2,887,545.00 $1,989,483.00 $1,876,904.00 Gross profit $1,261,132.00 $1,010,641.00 11 Selling, general, and administrative $657,178.00 $577,118.00 expenses 12 Interest expense $8,755.00 $6,218.00 13 Income tax expense $145,509.00 $103,970.00 14 Total operating expenses $811,442.00 $687,306.00 15 Other income and expenses 16 Other income $12,312.00 $9,399.00 17 Gain on financial instruments $4,668.00 $3,671.00 18 Net income $466,670.00 $336,405.00

Answer rating: 100% (QA)

Net Profit Margin can be computed as ... View the full answer