Storme Imports Company (SIC) Tax Rate COMPARITIVE INCOME STATEMENT 30% for years ended 31 December 2018 2019 $ *Sales revenue 1,420,000 *Interest revenue 511,500 *Investment Income 52,500 *Other revenue 89,500 Discuss with CEO and Consulting Team 2,073,500 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 735,200 Income before taxes 1,338,300 Income tax expense (30%) 401,490 Net Income 936,810 1. Complete the formulas in cells provided for revenues* for 2019. 2019 revenues have increased by ¾ % over 2018 2. Using the correct function or formula calculate the total revenue and gains in the cells provided. Insert the comment, “Discuss with CEO and Consulting Team” in the cell containing the words “Total revenues and gains”. 3. Complete the formulas in cells provided for expenses for 2019. 2019 expenses** have increased by ¼% over 2018 values with the exception of computer expenses*** which should be used from the “Green Savings” worksheet. 4.Using the correct function or formula calculate the total expenses and losses in the cells provided.
Storme Imports Company (SIC) Tax Rate COMPARITIVE INCOME STATEMENT 30% for years ended 31 December 2018 2019 $ *Sales revenue 1,420,000 *Interest revenue 511,500 *Investment Income 52,500 *Other revenue 89,500 Discuss with CEO and Consulting Team 2,073,500 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 735,200 Income before taxes 1,338,300 Income tax expense (30%) 401,490 Net Income 936,810 1. Complete the formulas in cells provided for revenues* for 2019. 2019 revenues have increased by ¾ % over 2018 2. Using the correct function or formula calculate the total revenue and gains in the cells provided. Insert the comment, “Discuss with CEO and Consulting Team” in the cell containing the words “Total revenues and gains”. 3. Complete the formulas in cells provided for expenses for 2019. 2019 expenses** have increased by ¼% over 2018 values with the exception of computer expenses*** which should be used from the “Green Savings” worksheet. 4.Using the correct function or formula calculate the total expenses and losses in the cells provided.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Storme Imports Company (SIC) | Tax Rate | ||||||
COMPARITIVE INCOME STATEMENT | 30% | ||||||
for years ended 31 December | |||||||
2018 | 2019 | ||||||
$ | |||||||
*Sales revenue | 1,420,000 | ||||||
*Interest revenue | 511,500 | ||||||
*Investment Income | 52,500 | ||||||
*Other revenue | 89,500 | ||||||
Discuss with CEO and Consulting Team | 2,073,500 | ||||||
Expenses and losses | |||||||
**Cost of goods sold | 460,000 | ||||||
**Selling and admin administrative | 195,000 | ||||||
***Computer (operating) | |||||||
** |
55,000 | ||||||
**Interest expense | 25,200 | ||||||
Total expenses and losses | 735,200 | ||||||
Income before taxes | 1,338,300 | ||||||
Income tax expense (30%) | 401,490 | ||||||
Net Income | 936,810 |
1. Complete the formulas in cells provided for revenues* for 2019. 2019 revenues have increased by ¾ % over 2018
2. Using the correct function or formula calculate the total revenue and gains in the cells provided. Insert the comment, “Discuss with CEO and Consulting Team” in the cell containing the words “Total revenues and gains”.
3. Complete the formulas in cells provided for expenses for 2019. 2019 expenses** have increased by ¼% over 2018 values with the exception of computer expenses*** which should be used from the “Green Savings” worksheet.
4.Using the correct function or formula calculate the total expenses and losses in the cells provided.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 4 images
Knowledge Booster
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education