d. Using the “Income Statement” worksheet, center the financial statement titles across the data below and bold and italicize the company name. e. Complete the formulas in cells provided for revenues* for 2021. 2021 revenues have Increased by 1/2% over 2020 values. f. Complete the formulas in cells provided for expenses for 2021. 2021 expenses have decreased by 1/4% over 2020 values g. Using the correct function or formula calculate the total expenses and losses in the cells provided.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

d. Using the “Income Statement” worksheet, center the financial statement titles
across the data below and bold and italicize the company name.
e. Complete the formulas in cells provided for revenues* for 2021. 2021 revenues have
Increased by 1/2% over 2020 values.
f. Complete the formulas in cells provided for expenses for 2021. 2021 expenses have decreased
by 1/4% over 2020 values
g. Using the correct function or formula calculate the total expenses and losses in the cells
provided.

KPT Enterprises
COMPARITIVE INCOME STATEMENT
for years ended 31 December
Revenues and gains
*Sales revenue
*Interest revenue
*Investment Income
*Other revenue
Total revenue and gains
Expenses and losses
**Cost of goods sold
**Selling and admin administrative
***Computer (operating)
**Depreciation
**Interest expense
Total expenses and losses
Income before taxes
Income tax expense (25%)
Net Income
2020
55,000
125,000
53,500
53,500
35,000
2021
Tax Rate
25%
Transcribed Image Text:KPT Enterprises COMPARITIVE INCOME STATEMENT for years ended 31 December Revenues and gains *Sales revenue *Interest revenue *Investment Income *Other revenue Total revenue and gains Expenses and losses **Cost of goods sold **Selling and admin administrative ***Computer (operating) **Depreciation **Interest expense Total expenses and losses Income before taxes Income tax expense (25%) Net Income 2020 55,000 125,000 53,500 53,500 35,000 2021 Tax Rate 25%
KPT Enterprises
Quarterly Schedule of Revenue
For the year December 31, 2020
QTR1 QTR2 QTR3
Sales
35000
125000
Interest
11400 75000
Investment 18475 14900
- Other
15000 22000
Total
79,875 236,900
1
QTR4
2020
52000 65000
277000
10000
72000
168400
16500
42000
91875
14500
40000
91500
93,000 219,000 628,775
Transcribed Image Text:KPT Enterprises Quarterly Schedule of Revenue For the year December 31, 2020 QTR1 QTR2 QTR3 Sales 35000 125000 Interest 11400 75000 Investment 18475 14900 - Other 15000 22000 Total 79,875 236,900 1 QTR4 2020 52000 65000 277000 10000 72000 168400 16500 42000 91875 14500 40000 91500 93,000 219,000 628,775
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Horizontal 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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education