a. Using the "2020 Quarterly Revenue" worksheet provide the relevant formulas to complete the worksheet. b. In the same worksheet, dynamically apply the following formats for Qtr1 through Qtr4 for all revenue types: i. Values over $65,000 should be red and bolded

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
KPT Enterprises
Quarterly Schedule of Revenue
For the year December 31, 2020
QTR1
35000
Sales
Interest
11400
Investment Income
18475
Other
15000
Total
QTR2
125000
75000
14900
22000
QTR3
52000
10000
16500
14500
QTR4
65000
72000
42000
40000
2020
Transcribed Image Text:KPT Enterprises Quarterly Schedule of Revenue For the year December 31, 2020 QTR1 35000 Sales Interest 11400 Investment Income 18475 Other 15000 Total QTR2 125000 75000 14900 22000 QTR3 52000 10000 16500 14500 QTR4 65000 72000 42000 40000 2020
assgt_mgmt1000_open_s3_22.xls
complete the questions
Using the Microsoft excel workbook
below to provide solutions for the directors and board members of KPT Enterprises, regarding
their financial reporting requirements:
a.
Using the "2020 Quarterly Revenue" worksheet provide the relevant formulas to
complete the worksheet.
b.
In the same worksheet, dynamically apply the following formats for Qtrl through Qtr4
for all revenue types:
i.
Values over $65,000 should be red and bolded
ii.
Values under or equals to $15,000 should be green and italicized
Transcribed Image Text:assgt_mgmt1000_open_s3_22.xls complete the questions Using the Microsoft excel workbook below to provide solutions for the directors and board members of KPT Enterprises, regarding their financial reporting requirements: a. Using the "2020 Quarterly Revenue" worksheet provide the relevant formulas to complete the worksheet. b. In the same worksheet, dynamically apply the following formats for Qtrl through Qtr4 for all revenue types: i. Values over $65,000 should be red and bolded ii. Values under or equals to $15,000 should be green and italicized
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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