Insert a pie chart with a 2-D visual effect for 2018 using all expense items in a new worksheet called, “Comparing Expenses”. Include all relevant labels, titles (not shown) and legends while changing the default colors. Thom-Pierre Consultants (TPC)       Tax Rate COMPARITIVE INCOME STATEMENT     30% for years ended 31 December               2018 2019     Revenues and gains           *Sales revenue           *Interest revenue           *Investment Income         *Other revenue           Total revenue and gains                       Expenses and losses         **Cost of goods sold          460,000       **Selling and admin administrative          195,000       ***Computer (operating)         **Depreciation             55,000       **Interest expense             25,200       Total expenses and losses         Income before taxes           Income tax expense (30%)         Net Income

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter5: Sales And Receivables
Section: Chapter Questions
Problem 77E: Ratio Analysis The following information was taken from Logsden Manufacturings trial balances as of...
icon
Related questions
Question

Insert a pie chart with a 2-D visual effect for 2018 using all expense items in a new worksheet called, “Comparing Expenses”. Include all relevant labels, titles (not shown) and legends while changing the default colors.

Thom-Pierre Consultants (TPC)       Tax Rate
COMPARITIVE INCOME STATEMENT     30%
for years ended 31 December        
      2018 2019    
Revenues and gains          
*Sales revenue          
*Interest revenue          
*Investment Income        
*Other revenue          
Total revenue and gains        
             
Expenses and losses        
**Cost of goods sold          460,000      
**Selling and admin administrative          195,000      
***Computer (operating)        
**Depreciation             55,000      
**Interest expense             25,200      
Total expenses and losses        
Income before taxes          
Income tax expense (30%)        
Net Income          
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage