Prepare an income statement for the year ended December 31, 20xx. Remember, you referencing/functions to enter...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare an income statement for the year ended December 31, 20xx. Remember, you referencing/functions to enter the values on financial statements (no direct should use typing of numbers). NOTE: not all of these accounts are for items that go on the income statement. Accounts Payable Accounts Receivable Accumulated Depreciation-Equipment Cash Common Stock Cost of Goods Sold Shipping Expense Equipment Depreciation Expense Dividends Gain on Sale of Equipment Income Tax Expense Insurance Expense interest Expense Inventory Notes Payable Prepaid Insurance Advertising Expense Rent Expense Retained Earnings Salaries and Wages Expense Sales Revenue Salaries and Wages Payable Utilities Expense $52,400 34,100 136,000 16,000 70,000 1,219,920 13,020 318,020 27,700 24,000 4,000 20,000 18,000 10,000 52,100 87,000 12,000 67,000 68,000 28,100 237,340 1,765,000 12,000 20,300 The company had no returns or other items that would reduce sales revenue when determining net sales, so net sales is equal to sales revenue in this case. Calculate the gross profit rate and profit margin for the Phoenix Rising FC below. Profit Margin Gross Profit Rate The vice president of marketing and the director of human resources have developed a proposal whereby Phoenix Rising FC would compensate the sales force on a strictly commission basis. Given the increased incentive, they expect net sales to increase by 15%. As a result, they estimate that gross profit will increase by $94,395 and expenses by $128,905. Compute the expected new net income. (Hint: You do not need to prepare an income statement.) Then, compute the revised profit margin and gross profit rate. Comment on the effect that this plan would have on net income and on the ratios, and evaluate the merit of this proposal. (ignore income tax effects) Revised Net Income Revised Net Sales Revised Profit Margin Revised Gross Profit Rate What effect will this change have on the profit margin? What effect will this change have on the gross profit rate Prepare an income statement for the year ended December 31, 20xx. Remember, you referencing/functions to enter the values on financial statements (no direct should use typing of numbers). NOTE: not all of these accounts are for items that go on the income statement. Accounts Payable Accounts Receivable Accumulated Depreciation-Equipment Cash Common Stock Cost of Goods Sold Shipping Expense Equipment Depreciation Expense Dividends Gain on Sale of Equipment Income Tax Expense Insurance Expense interest Expense Inventory Notes Payable Prepaid Insurance Advertising Expense Rent Expense Retained Earnings Salaries and Wages Expense Sales Revenue Salaries and Wages Payable Utilities Expense $52,400 34,100 136,000 16,000 70,000 1,219,920 13,020 318,020 27,700 24,000 4,000 20,000 18,000 10,000 52,100 87,000 12,000 67,000 68,000 28,100 237,340 1,765,000 12,000 20,300 The company had no returns or other items that would reduce sales revenue when determining net sales, so net sales is equal to sales revenue in this case. Calculate the gross profit rate and profit margin for the Phoenix Rising FC below. Profit Margin Gross Profit Rate The vice president of marketing and the director of human resources have developed a proposal whereby Phoenix Rising FC would compensate the sales force on a strictly commission basis. Given the increased incentive, they expect net sales to increase by 15%. As a result, they estimate that gross profit will increase by $94,395 and expenses by $128,905. Compute the expected new net income. (Hint: You do not need to prepare an income statement.) Then, compute the revised profit margin and gross profit rate. Comment on the effect that this plan would have on net income and on the ratios, and evaluate the merit of this proposal. (ignore income tax effects) Revised Net Income Revised Net Sales Revised Profit Margin Revised Gross Profit Rate What effect will this change have on the profit margin? What effect will this change have on the gross profit rate
Expert Answer:
Answer rating: 100% (QA)
To prepare the income statement for the year ended December 31 20XX well use the information provided Income Statement for the Year Ended December 31 ... View the full answer
Related Book For
Advanced Financial Accounting
ISBN: 978-0132928939
7th edition
Authors: Thomas H. Beechy, V. Umashanker Trivedi, Kenneth E. MacAulay
Posted Date:
Students also viewed these accounting questions
-
The following financial information is for Caravelli Company. Of the total raw materials placed in production for the year, $36,000 was for indirect materials. The company had $3,795,000 in sales for...
-
The following pretax amounts were obtained from the financial records of Watson Company for 2018: The companys tax rate is 35 percent. a. Prepare an income statement for the year ended December 31,...
-
Assume that the first six months of 2021 have passed, and the Board requested that their accountant prepare an income statement for the first six months of 2021 showing how actual performance...
-
EG Corporation redeemed 200 shares of stock from one of its shareholders in exchange for $200,000. The redemption represented 20% of the corporation's outstanding stock. The redemption was treated as...
-
Under what section should accounts receivable be reported on the balance sheet?
-
As of December 31, 2019, Reed Company has assets of $3,500 and stockholders' equity of $1,500. What are the liabilities for Reed Company as of December 31, 2019? (a) $1,500. (b) $1,000. (c) $2,500....
-
1. Read the text materials on feedforward, concurrent, and feedback control. 2. Read the Control Problem Situation and be prepared to resolve those control problems in a group setting. 3. Your...
-
The vice president of operations of I4 Computers Inc. is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past...
-
Map the EER model of the following databases, to a relational model. Show all integrity types(Clarify your answer by underline the Primary key, and dotted line the Foreign Key. ( Member SSN {PK}...
-
Selected financial data for Amberjack Corporation follows. Year 1 ($ thousands). 342,297 268, 276 (174,129) (61,247) Sales Cost of goods sold Net income Cash flow from operations Cash Marketable...
-
A system at constant pressure undergoes the following three processes at 25 oC. I. 5 kJ of heat is released into the surroundings II. 10 kJ of work is done on the surroundings III. 15 kJ of heat...
-
A brief introduction of Tomorrowland 2018 and Identification of leveraging techniques and strategies used by event planners and organisers of Tomorrowland 2018
-
Leo's Markets has sales of $684,000, costs of $437,000, interest paid of $13,800, total assets of $712,000, and depreciation of $109,400. The tax rate is 21 percent and the equity multiplier is 1.6....
-
Assimo owns several pieces of land He decided to sell some of it in the current year Lot 1 is his personal investment in Pangasinan Lot 2 is a beach property in Anilao Batangas Lot 3 is the principal...
-
The cost for Tamiflu this flu season is normally distributed with a mean of $162 with a standard deviation of $12. A random sample of 18 pharmacies is selected and the price of Tamiflu is recorded....
-
The magnetic field tic of an OEM responds to the expression nB ( r , t ) = ( 1 , 8 x 1 0 ^ - 7 ) sin ( ( 1 4 x 1 0 ^ 6 ) x - wt ) , where the campomagn Attic is measured in Teslas, distance in meters...
-
The Dragonfly Inn is bed and breakfast located in the country. The Inn offer's a variety of outdoor and leisure activities for guests. Market research shows guests in prior year's enjoyed the remote...
-
The ultimate goal of Google, Bing, and other consumer search engines is to provide users with search listings that contain useful information on the topic of their search. What recommendations would...
-
What type of company is required to provide segmented reporting?
-
On October 1, 20X5, XYZ Ltd. sold its 80% interest in the subsidiary, Sub Ltd., for $2,430,000. Prior to the date of sale, XYZ Ltd. had recorded the investment in a subsidiary account on the cost...
-
Under what circumstances is push-down accounting most likely to be used?
-
A diffraction grating is a closely spaced array of apertures or obstacles forming a series of closely spaced slits. The simplest type in which an incoming wave front meets alternating opaque and...
-
Find the position of the first minimum for a single slit of width 0.04 \(\mathrm{mm}\) on a screen of \(2 \mathrm{~m}\) distance, when light from a He-Ne laser \(\lambda=\) 6328 is shone on the slit.
-
A GaAs p-n junction has a \(100 \mu \mathrm{m} \times 100 \mathrm{~m}\) cross section and a width of the depletion layer \(W=440 \mathrm{~nm}\). Consider the junction in thermal equilibrium without...
Study smarter with the SolutionInn App