Complete the following problems: Problem 3-1: Working with a Balance Sheet Problem 3-2: Computing Cash Flows Problem 3-3: Working with the Statement of Cash Flows Problem 3-4: Ratio Analysis Problem 3-5: Market-Value Ratios Problem 3-6: Computing Ratios ( Please I need it in Excel sheet ) CHAPTER 3 PROBLEMS UNDERSTANDING FINANCIAL STATEMENTS AND CASH FLOW CT 3 -1 Chapter 3 WORKING WITH BALANCE SHEET DATA Cash 100,000 Account receivables 72,000 Accounts payable 48,000 Short-term notes payable 35,000 Inventories 70,000 Gross fixed assets 1,750,000 Common stock 680,000 Other current assets 10,000 Accumulated depreciation 524,000 Long-term debt 350,000 Other assets 25,000 Retained earnings ? a. Prepare a balance sheet in good form from the information above. b, Calculate net working capital c. Calculate the debt ratio b. Working capital = c. Debt ratio = CT 3 – 2 Chapter 3 & 4 WORKING WITH THE INCOME STATEMENT DATA Sales $525,000 Cost of goods sold $200,000 General and administrative expenses $62,000 Depreciation expenses 8,000 Interest expense 12,000 Income taxes 97,200 Given the information above, please prepare (a) the income statement in good form, and (b) the common-sized income statement.
#UNDERSTANDING #FINANCIAL #STATEMENTS #CASH #FLOW