Homework Help is Here – Start Your Trial Now!
Business
Accounting
Please prepare a statement of cash flows using the following data. Please include any equations or calculations used through excel.

Please prepare a statement of cash flows using the following data. Please include any equations or calculations used through excel.

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

Please prepare a statement of cash flows using the following data. Please include any equations or calculations used through excel.

 

 

Actual Year Projected Year 2022 2021 Revenues - high school students 88,200 110,300 Revenues - adult learners 571,200 745,000 Accounts receivable - high schools 7,400 10,200 Accounts receivable - adult learners 47,600 73,000 Commissions expense 21,400 27,800 Commissions payable 900 1,200 Salaries and benefits expense 638,900 947,000 Rent expense 12,000 12,400 Prepaid rent 1,200 1,200 Prepaid insurance 2,800 3,000 High school expenses (Cost of Sales) 49,400 65,300 Adult learner expenses (Cost of Sales) 68,500 98,700 Long-term debt Depreciation expense 10,000 18,000 Other operating expenses 50,000 55,000 Accounts payable 14,800 15,700 Salaries and benefits payable 26,600 37,500 3,800 Payroll taxes payable Income tax expense 2,700 Fixed assets, net of accumulated depreciation 35,000 45,000 Retained earnings (Accumulated deficit) (96,000) Common and preferred stock 400,000 75,000 400,000 Cash 255,000 Interest expense
Transcribed Image Text:Actual Year Projected Year 2022 2021 Revenues - high school students 88,200 110,300 Revenues - adult learners 571,200 745,000 Accounts receivable - high schools 7,400 10,200 Accounts receivable - adult learners 47,600 73,000 Commissions expense 21,400 27,800 Commissions payable 900 1,200 Salaries and benefits expense 638,900 947,000 Rent expense 12,000 12,400 Prepaid rent 1,200 1,200 Prepaid insurance 2,800 3,000 High school expenses (Cost of Sales) 49,400 65,300 Adult learner expenses (Cost of Sales) 68,500 98,700 Long-term debt Depreciation expense 10,000 18,000 Other operating expenses 50,000 55,000 Accounts payable 14,800 15,700 Salaries and benefits payable 26,600 37,500 3,800 Payroll taxes payable Income tax expense 2,700 Fixed assets, net of accumulated depreciation 35,000 45,000 Retained earnings (Accumulated deficit) (96,000) Common and preferred stock 400,000 75,000 400,000 Cash 255,000 Interest expense
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cash Flow 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.
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
SEE MORE TEXTBOOKS