Question

Problem 1. Mr. Omar prepared an Income Statement for the month of January 2013 to analyze...

Problem 1.

Mr. Omar prepared an Income Statement for the month of January 2013 to analyze its purchasing and profit leverage from the income and expense transactions.

Income Statement

Sales RO 2,500
Cost of Goods Sold
Purchases RO 1,800
Operating Expenses 475 2,275__
Profit Before Tax 225
=========

Requirement: Solve for the Profit before Tax after the following assumptions

The sales increased by 12.5% and profit increased to RO 235.

The cost decreases by 8 1/4% and but profit increased by RO 5.

Homework Answers

Answer #1

The analysis of purchasing and profit leverage from the income and expenses transactions is as follows:

A) The sales increased by 12.5% profit increased to RO 235

RO
Sales (RO 2,500 * 112.5%) (A) 2,812.50
Cost of Goods Sold (B) = A - C 2,577.50
Profit Before Tax (Given) (C)   235.00

Analysis:

The due to the increasment of sales by 12.5% and profit increased to RO 235 the total cost of goods sold is increased from the RO 2 ,275 to RO 2,577.50.

B) Cost decreased by 81/4% and but profit increased by RO 5

RO
Sales (A = B + C) 2,317
Cost of Goods Sold (RO 2,275 - (RO 2,275 * 8.25%) (B)   2,087
Profit Before Tax ( RO 225 + RO 5) (C)   230

Analysis:

As cost decreased by 81/4% and but profit increased by RO 5 .The sales revenue of the organisation decreased from RO 2,500 TO RO 2,317.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Preparing a Cash Flow Statement Nikea Inc.’s income statement for the year 2013 is shown below:...
Preparing a Cash Flow Statement Nikea Inc.’s income statement for the year 2013 is shown below: During the year, the balances for the sales account, cost of goods sold, and gross profit increased. This information is provided to you. Prepare the cash flow for operating activities, using both the direct method and the indirect method. Nikea’s income statement for the year 2013 is shown below. Accounts Amount ($) Sales 600,000 Cost of Goods Sold (400,000) Gross Profit 200,000 Operating Expenses...
Common-Size Income Statements Consider the following income statement data from the Ross Company: 2013 2012 Sales...
Common-Size Income Statements Consider the following income statement data from the Ross Company: 2013 2012 Sales revenue $525,000 $450,000 Cost of goods sold 336,000 279,000 Selling expenses 107,000 101,000 Administrative expenses 62,000 56,000 Income tax expense 9,800 7,400 Prepare common-size income statements for each year. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). ROSS COMPANY Common-Size Income Statements (Percent of Sales Revenue) 2013 2012 Sales Revenue Answer Answer Cost of Goods Sold Answer Answer Gross Profit on...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $550,000 $440,000 Cost of goods sold 467,400 380,000 Gross profit $82,600 $60,000 Selling expenses $24,150 $21,000 Administrative expenses 20,910 17,000 Total operating expenses $45,060 $38,000 Income before income tax $37,540 $22,000 Income tax expenses 15,000 8,800 Net income $22,540 $13,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
A recent annual income statement for Stone Creek Roofing is shown below. Net sales $5,000 Cost...
A recent annual income statement for Stone Creek Roofing is shown below. Net sales $5,000 Cost of sales 3,200 Gross profit 1,800 Operating expense 800 Depreciation expense 200 Operating income 800 Interest expense 100 Income before tax 700 Tax 175 Income after tax $ 525 Assume that during the year, Stone Creek spent $180 on new capital equipment and increased current assets net of non-interest-bearing current liabilities by $120. What was Stone Creek’s free cash flow in this year? $425...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $495,121 $437,000 Cost of goods sold 358,400 280,000 Gross profit $136,721 $157,000 Selling expenses $49,950 $37,000 Administrative expenses 28,800 23,000 Total operating expenses $78,750 $60,000 Income from operations $57,971...
please show example through Excel Vertical Analysis of Income Statement For 2014, Othere Technology Company initiated...
please show example through Excel Vertical Analysis of Income Statement For 2014, Othere Technology Company initiated a sales promotion campaign that included the expenditure of an additional $15,000 for advertising. At the end of the year, George Wallace, the president, is presented with the following condensed comparative income statement: Othere Technology Company Comparative Income Statement For the Years Ended December 31, 2014 and 2013 2014 2013 Sales $529,240 $455,510 Sales returns and allowances 5,240 4,510 Net sales $524,000 $451,000 Cost...
Chibi Robo Restaurant has the following simple income statement for the month ended, January 31, 2018:...
Chibi Robo Restaurant has the following simple income statement for the month ended, January 31, 2018: Sales $200,000 Expenses: Cost of Goods Sold $100,000 Wages 30,000 Depreciation 2,000 Rent 5,000 Interest 500 Income Taxes 9,000 Total Expenses $146,500 Net Income $ 53,500 Find the following related to the income statement above: a) What is the company’s Gross Profit? b) What is the company’s Operating Income? c) What is the company’s Income before Taxes? d) What is the company’s Gross Profit...
Income Statement                                       &nbsp
Income Statement                                                              Balance Sheet                              Year Ended 2017                                                                12/31/17             Sales                                               $27,000                Cash                                                    $   500             Cost of Goods Sold                          18,900                Accounts Receivable                             4,500             Gross Profit                                        8,100                Inventory                                              3,150             Expenses                                            6,000                Gross Fixed Assets                 54,000             Earnings Before Tax                          2,100                Accumulated Depreciation      21,600             Tax (.5)                                              1,050                Net Fixed Assets                                32,400             Net Income                                     $  1,050               Total Assets                                      $40,550                                                                                                 Accounts Payable                               $ 1,575                                                                                                 Notes Payable                                    19,175                                                                                                 Accrued Tax                                             263                                                                                                 Common Stock                                   15,787                                                                                                 Retained Earnings                                  3,750                                                                                                 Total Debt & Equity                          $40,550 Based on the 2017 Financial Statements above, compute Pro Forma’s for 2018 using the percent of sales method using the following assumptions: 20% growth rate in sales, and 15% dividend payout
Consider the following condensed financials for Crean and Crimson Foods: INCOME STATEMENT: 2013 Sales $114,750.00 Cost...
Consider the following condensed financials for Crean and Crimson Foods: INCOME STATEMENT: 2013 Sales $114,750.00 Cost of Goods Sold $68,850.00 Gross Margin $45,900.00 Depreciation $19,200.00 Administrative Costs $10,800.00 EBIT $15,900.00 Interest $4,000.00 Pre-tax income $11,900.00 Taxes $4,760.00 Net Income $7,140.00 Dividends $0.00 Addition to Retained Earnings $7,140.00 BALANCE SHEET AS OF 12/31/2013: ASSETS 2013 Cash $6,000.00 Inventory $18,467.00 Accounts Receivable $17,212.50 Current Assets $41,679.50 Net PPE $92,000.00 Total Assets (TA) $133,679.50 LIABILITIES & SHAREHOLDER EQUITY 2013 Accounts Payable $30,000.00 Current...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $756,616 $674,000 Cost of goods sold 541,800 430,000 Gross profit $214,816 $244,000 Selling expenses $75,530 $57,000 Administrative expenses 44,420 36,000 Total operating expenses $119,950 $93,000 Income from operations $94,866...