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
The comparative balance sheet of Cromme Inc. for December 31, 2016 and 2015, is shown as follows:  Additional data obtained from an examination of the accounts in the ledger for 2016 are as follows:a. The investments were sold for $280,000 cash.b. Equipment and land were acquired for cash.c. There were no disposals of equipment during the year.d. The common stock was issued for cash.e. There was a $199,540 credit to Retained Earnings for net income.f. There was a $96,000 debit to Retained Earnings for cash dividends declared.InstructionsPrepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities.
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.
Recommended textbooks for you
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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
Text book image
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
IAS 29 Financial Reporting in Hyperinflationary Economies: Summary 2021; Author: Silvia of CPDbox;https://www.youtube.com/watch?v=55luVuTYLY8;License: Standard Youtube License