Required: Prepare a complete statement of cash flows using a spreadsheet using the indirect method. (Enter all amounts as positive values.)

Financial Accounting Intro Concepts Meth/Uses
14th Edition
ISBN:9781285595047
Author:Weil
Publisher:Weil
Chapter3: The Basics Of Record Keeping And Financial Statement Preparation: Income Statement
Section: Chapter Questions
Problem 36P
icon
Related questions
icon
Concept explainers
Topic Video
Question

 
Forten Company's current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) Other Expenses are paid in advance and are initially debited to Prepaid Expenses.

 

FORTEN COMPANY
Comparative Balance Sheets
December 31
  Current Year   Prior Year
Assets                      
Cash   $ 49,800         $ 73,500    
Accounts receivable     65,810           50,625    
Inventory     275,656           251,800    
Prepaid expenses     1,250           1,875    
Total current assets     392,516           377,800    
Equipment     157,500           108,000    
Accum. depreciation—Equipment     (36,625 )         (46,000 )  
Total assets   $ 513,391         $ 439,800    
Liabilities and Equity                      
Accounts payable   $ 53,141         $ 114,675    
Short-term notes payable     10,000           6,000    
Total current liabilities     63,141           120,675    
Long-term notes payable     65,000           48,750    
Total liabilities     128,141           169,425    
Equity                      
Common stock, $5 par value     162,750           150,250    
Paid-in capital in excess of par, common stock     37,500           0    
Retained earnings     185,000           120,125    
Total liabilities and equity   $ 513,391         $ 439,800    
 

  

FORTEN COMPANY
Income Statement
For Current Year Ended December 31
Sales       $ 582,500    
Cost of goods sold         285,000    
Gross profit         297,500    
Operating expenses              
Depreciation expense $ 20,750          
Other expenses   132,400     153,150    
Other gains (losses)              
Loss on sale of equipment         (5,125 )  
Income before taxes         139,225    
Income taxes expense         24,250    
Net income       $ 114,975    
 

 
Additional Information on Current Year Transactions

  1. The loss on the cash sale of equipment was $5,125 (details in b).
  2. Sold equipment costing $46,875, with accumulated depreciation of $30,125, for $11,625 cash.
  3. Purchased equipment costing $96,375 by paying $30,000 cash and signing a long-term note payable for the balance.
  4. Borrowed $4,000 cash by signing a short-term note payable.
  5. Paid $50,125 cash to reduce the long-term notes payable.
  6. Issued 2,500 shares of common stock for $20 cash per share.
  7. Declared and paid cash dividends of $50,100.

 

Required:
Prepare a complete statement of cash flows using a spreadsheet using the indirect method(Enter all amounts as positive values.)
 

 
 
FORTEN COMPANY
Spreadsheet for Statement of Cash Flows
For Current Year Ended December 31
    Analysis of Changes  
  December 31, Prior Year Debit Credit December 31, Current Year
Balance sheet—debit        
Cash $73,500     $49,800
Accounts receivable 50,625      
Inventory 251,800      
Prepaid expenses 1,875      
Equipment 108,000      
  $485,800     $49,800
Balance sheet—credit        
Accumulated depreciation—Equipment $46,000      
Accounts payable 114,675      
Short-term notes payable 6,000      
Long-term notes payable 48,750      
Common stock, $5 par value 150,250      
Paid-in capital in excess of par value, common stock 0      
Retained earnings 120,125      
  $485,800     $0
Statement of cash flows        
Operating activities        
Net income        
         
Depreciation expense        
Loss on sale of equipment        
Increase in accounts receivable        
Increase in inventory        
Decrease in prepaid expenses        
Decrease in accounts payable        
Investing activities        
Receipt from sale of equipment        
Payment to purchase equipment        
         
Financing activities        
Payment on long-term note        
Issued common stock for cash        
Issued common stock for cash        
         
         
Non cash investing and financing activities        
Purchase of equipment financed by long-term note payable        
    $0 $0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Statements
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 Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College