This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

Spreadsheet Templat Foundations of Financial M MAIN MENU - CHAPTER 3 Problem 3-19 Problem 3-20 Problem 3-33 Problem 3-34 Spreadsheet Templates by Block and Hi Copyright 2008 McGraw-Hill/Irwin and Info-Labs. (www. tes anagement 3 Problem 3-21 irt .info-labs.com) Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-19 Foundations of Financial Management Block and Hirt - Twelfth Edition Problem 3-19 Objective Overall ratio analysis Student Name: Course Name: Student ID: Course Number: The balance sheet for Bryan Corporation is shown below. Sales for the year were $3,040,000, with 75 percent of sales sold on credit. BRYAN CORPORATION Balance Sheet 200X Assets Liabilities and Stockholders' Equity Cash $50,000 Accounts payable $220,000 Accounts receivable 280,000 Accrued taxes 80,000 Inventory 240,000 Bonds payable (long term) 118,000 Plant and equipment 380,000 Common stock 100,000 Paid-in-capital 150,000 Retained earnings 282,000 Total liabilities and Total assets $950,000 stockholders' equity $950,000 Compute the following ratios: a. Current ratio. b. Quick ratio. c. Debt-to-total-assets ratio. d. Asset turnover. e. Average collection period. Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-19 Solution Problem 3-19 Instructions Enter formulas to calculate the following ratios. If possible, use cell references to the balance sheet. a. Current ratio FORMULA b. Quick ratio FORMULA c. Debt-to-total-assets ratio FORMULA d. Asset turnover FORMULA e. Average collection period FORMULA Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt Problem: 3-20 Foundations of Financial Management Block and Hirt - Twelfth Edition Problem 3-20 Objective Debt-utilization ratios Student Name: Course Name: Student ID: Course Number: The Lancaster Corporation's income statement is given below. a. What is the times-interest-earned ratio? b. What would be the fixed-charge-coverage ratio? LANCASTER CORPORATION Sales $200,000 Cost of goods sold 116,000 Gross profit 84,000 Fixed charges (other than interest) 24,000 Income before interest and taxes 60,000 Interest 12,000 Income before taxes 48,000 Taxes (35%) 16,800 Income after taxes $31,200 Copyright 2008 McGrawHill/ Irwin Spreadsheet Template by Block and Hirt... View Full Document

End of Preview

Sign up now to access the rest of the document