Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 14, Problem 1R

The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows:

Chapter 14, Problem 1R, The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal

Additional data obtained from the records of Prime Sports Gear are as follows:

  1. a. Net income for 2013 was $121,610.
  2. b. Depreciation reported on income statement for 2013 was $46,500.
  3. c. Purchased $165,000 of new equipment, putting $90,000 cash down and issuing $75,000 of bonds for the balance.
  4. d. Old equipment originally costing $19,500, with accumulated depreciation of $7,950, was sold for $8,000.
  5. e. Retired $60,000 of bonds.
  6. f. Declared cash dividends of $64,000.
  7. g. Issued 1,500 shares of common stock at $27 cash per share.

You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.

Expert Solution & Answer
Check Mark
To determine

Prepare the statement of cash flow for Incorporation PSG and review the worksheet.

Explanation of Solution

Prepare the statement of cash flow for Incorporation PSG and review the worksheet.

Excel Applications for Accounting Principles, Chapter 14, Problem 1R , additional homework tip  1

Excel Applications for Accounting Principles, Chapter 14, Problem 1R , additional homework tip  2

Table (1)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
General account question
Answer??
Provide correct option general accounting
Knowledge Booster
Background pattern image
Accounting
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
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
IAS 29 Financial Reporting in Hyperinflationary Economies: Summary 2021; Author: Silvia of CPDbox;https://www.youtube.com/watch?v=55luVuTYLY8;License: Standard Youtube License