Excel_chapter_03_student

Excel_Chapter_03_Student
Download Document
Showing pages : 1 - 7 of 14
This preview has blurred sections. Sign up to view the full version! View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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