A.
Income Statement | ||
Particulars | Amount $ | |
Revenue | 330,000.00 | |
Less: | COGS(330000*55/100) | 181,500.00 |
Less: | Salaries & Wages (26% of 330000) | 85,800.00 |
Less: | Operating Cost | 12,300.00 |
Gross Profit | 50,400.00 | |
Less: | Depreciation | 2,160.00 |
Bad Debt Exp (330000*0.6*0.02) | 3,960.00 | |
Profit before Interest | 44,280.00 | |
Less: | Interest Expense | 875.00 |
Profit after Interest | 43,405.00 |
B.
Income Statement | Situation1 | % to Revenue | Situation2 | % to Revenue | Situation3 | % to Revenue | |
Particulars | Amount $ | Amount $ | Amount $ | ||||
Revenue | 330,000.00 | 330,000.00 | 330,000.00 | ||||
Less: | COGS | 164,905.00 | 49.97% | 149,905.00 | 45.43% | 181,500.00 | |
Less: | Salaries & Wages | 85,800.00 | 85,800.00 | 54,205.00 | 16.43% | ||
Less: | Operating Cost | 12,300.00 | 12,300.00 | 12,300.00 | |||
Gross Profit | 66,995.00 | 81,995.00 | 81,995.00 | ||||
Less: | Depreciation | 2,160.00 | 2,160.00 | 2,160.00 | |||
Bad Debt Exp | 3,960.00 | 3,960.00 | 3,960.00 | ||||
Profit before Interest | 60,875.00 | 75,875.00 | 75,875.00 | ||||
Less: | Interest Expense | 875.00 | 875.00 | 875.00 | |||
Profit after Interest | 60,000.00 | 75,000.00 | 75,000.00 |
C.
Income Statement | Situation1 | % to Revenue | Situation2 | % to Revenue | Situation3 | % to Revenue | Situation 4 | % to Revenue | |
Particulars | Amount $ | Amount $ | Amount $ | Amount $ | |||||
Revenue | 330,000.00 | 330,000.00 | 330,000.00 | 330,000.00 | |||||
Less: | COGS | 178,202.50 | 54.00% | 165,702.50 | 50.21% | 132,000.00 | 40.00% | 198,000.00 | 60.00% |
Less: | Salaries & Wages | 82,502.50 | 25.00% | 70,002.50 | 21.21% | 33,000.00 | 10.00% | 99,000.00 | 30.00% |
Less: | Operating Cost | 12,300.00 | 12,300.00 | 12,300.00 | 12,300.00 | ||||
Gross Profit | 56,995.00 | 81,995.00 | 152,700.00 | 20,700.00 | |||||
Less: | Depreciation | 2,160.00 | 2,160.00 | 2,160.00 | 2,160.00 | ||||
Bad Debt Exp | 3,960.00 | 3,960.00 | 3,960.00 | 3,960.00 | |||||
Profit before Interest | 50,875.00 | 75,875.00 | 146,580.00 | 14,580.00 | |||||
Less: | Interest Expense | 875.00 | 875.00 | 875.00 | 875.00 | ||||
Profit after Interest | 50,000.00 | 75,000.00 | 145,705.00 | 13,705.00 |
D.
Income Statement | Situation1 | % to Revenue | Situation2 | % to Revenue | Situation3 | % to Revenue | Situation4 | % to Revenue | Situation5 | % to Revenue | |
Particulars | Amount $ | Amount $ | Amount $ | Amount $ | Amount $ | ||||||
Revenue | 364,710.53 | 389,710.53 | 375,122.11 | 353,239.47 | 356,886.58 | ||||||
Less: | COGS | 200,590.79 | 55.00% | 200,590.79 | 55.00% | 182,355.26 | 50.00% | 164,119.74 | 45.00% | 164,119.74 | 45.00% |
Less: | Salaries & Wages | 94,824.74 | 26.00% | 94,824.74 | 26.00% | 98,471.84 | 27.00% | 94,824.74 | 26.00% | 98,471.84 | 27.00% |
Less: | Operating Cost | 12,300.00 | 12,300.00 | 12,300.00 | 12,300.00 | 12,300.00 | |||||
Gross Profit | 56,995.00 | 81,995.00 | 81,995.00 | 81,995.00 | 81,995.00 | ||||||
Less: | Depreciation | 2,160.00 | 2,160.00 | 2,160.00 | 2,160.00 | 2,160.00 | |||||
Bad Debt Exp | 3,960.00 | 3,960.00 | 3,960.00 | 3,960.00 | 3,960.00 | ||||||
Profit before Interest | 50,875.00 | 75,875.00 | 75,875.00 | 75,875.00 | 75,875.00 | ||||||
Less: | Interest Expense | 875.00 | 875.00 | 875.00 | 875.00 | 875.00 | |||||
Profit after Interest | 50,000.00 | 75,000.00 | 75,000.00 | 75,000.00 | 75,000.00 |
Revenues - $330,000 Cost of goods sold 55 % of revenues Salaries and wages 26% of...
Use the following estimated information for Super Shirts, Inc. to perform the analyses: Revenues s215,000 Cost of goods sold-20% of revenues Salaries and wages-20% of revenues Additional costs Operating Costs-$39,000 Depreciation $2,400 Bad debts expense-1% of 70% of revenues Interest expense - $525 REQUIRED: On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package: A. Super Shirts would like to be more profitable. Use Goal Seek in Excel to determine the following...
Use the following estimated information for the Barkery to perform the analyses: Revenues $300,000 Cost of goods sold 60% of revenues Salaries and wages 22% of revenues Additional costs: Operating Costs - $12,600 Depreciation -$2,100 Bad debts expense-3 % of 70 % of revenues Interest expense - $1,125 . REQUIRED; On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package: A. Prepare an income statement based on the information above. B. The...
Year 2 Year 1 Sales $ 529,000 $ 420,000 Cost of goods sold 330,000 268,000 Gross profit $ 199,000 $ 152,000 Operating expenses 130,000 116,000 Net income $ 69,000 $ 36,000 a. Prepare common size income statements for Price Company, a sole proprietorship, for the two years shown as above by converting the dollar amounts into percentages. For each year, sales will appear as 100 percent and other items will be expressed as a percentage of sales. (Income taxes...
Year 2 Year 1 Sales $ 489,000 $ 393,000 Cost of goods sold 330,000 268,000 Gross profit $ 159,000 $ 125,000 Operating expenses 130,000 116,000 Net income $ 29,000 $ 9,000 a. Prepare common size income statements for Price Company, a sole proprietorship, for the two years shown as above by converting the dollar amounts into percentages. For each year, sales will appear as 100 percent and other items will be expressed as a percentage of sales. (Income taxes are...
0 Income statement 2016 2015 Sales revenues Less: Cost of goods sold Gross profit Less: Operating expenses Operating income Less: Interest expense Income before income taxes (amounts in thousands) 2017 211,400 $ 182,910 105,000 96,000 106,400 $ 86,910 53,000 46,000 53.400 $ 40,910 5.385 6,459 48,015 $ 34,451 22.617 16. 160 Print Done i Income statement JJUJ 0,435 LESS. Merest expense Income before income taxes 48,015 $ 22,647 25,368 $ 34,451 16,160 Less: Income tax expense Net income 18,291 Additional...
9. Your pro forma income statement shows sales of $2.300,000, cost of goods sold as $980,000, depreciation expense of $600,000, and taxes of $216,000 due to a of 30%. What are your pro forma earnings? What is your pro tax rate forma free cash flow? 10. You are forecasting incremental free cash flows for Daily Enterprises. Based on the associated information in Problems 1 and 2, what are the incremental free cash flows with the new machine? software for video...
resented below is information for Swifty Company for the month
of March 2020.
Cost of goods sold
$218,520
Rent expense
$30,370
Freight-out
6,450
Sales discounts
7,050
Insurance expense
5,410
Sales returns and allowances
12,910
Salaries and wages expense
58,680
Sales revenue
386,090
(a)
Prepare a multiple-step income statement. (Enter
negative amounts using either a negative sign preceding the number
e.g. -45 or parentheses e.g. (45).)
SWIFTY COMPANY
Income Statement
March 31, 2020For the Year Ended March 31, 2020For the Month...
Common-size financial statements are often used by auditors in a
process called “analytical procedures” or “analytical review.”
Unusual relationships or patterns can be identified because of the
percentages—these would be harder to see if the amounts were just
kept as dollars. You will be looking for percentages that seem very
unstable over the times periods (the percentages jump around too
much).
What are some of the unusual relationships you see? Please
identify and discuss at least two unusual relationships. Please...
Show me the formulas and steps, please!!
$ Younge Company provided the following data for the year ended September 30. Figures are all in $1,000. Younge closes any under-or over-applied overhead costs to cost of goods sold at the end of the year. SG&A expense $ 370 Manufacturing overhead applied to WIP $ 339 Actual manufacturing overhead cost 358 Total manufacturing cost for the year $ 675 Cost of goods available for sale during the year $ 730 Cost of...
Paragraph IS Styles Profit and Loss Statement Revenues Cost of Goods Sold GROSS PROFIT March April $11,685 $11,801 2,415 2,608 ID May $12,391 2,634 1 Selling and General expenses Rent, Lease, Depreciation Other Operating Expenses OPERATING EXPENSES 901 753 1,119 1 1,000 768 1,287 1,129 837 1,377 OPERATING INCOME Interest Expense Other Expenses EARNINGS BEFORE TAXES 161 1,146 TO 169 1,260 1 190 1,272 Income Taxes 1,029 1,163 1,186 NET EARNINGS 10 TO 1. What is the percentage change for...