AutoSave OFF ACC 211 Case 3 Home Insert Draw Page Layout Formulas Datal Review View Tell me Share Comments X Calibri (Body) v 11 ' ' v Poste I B U v G A v Insert Wras Text General W Delete v Merge & Center $%9 00 Cell Conditional Format Formatting as Table Styles Sort & Format v v Filter Find & Select Analyze Data Sensitivity J19 : x fx A B C D E F G H 1 1 K L M N 0 P Q R S 1 Case 3 2 3 The following selected information is taken from the financial statements of a company for its most recent year of operations: 4 5 Beginning balances: 6 Inventory 7 Accounts Receivable 8 Ending Balances: 9 Inventory 10 Accounts Receivable 11 Cash 12 Marketable securities (short-term) 13 Prepaid Expenses 14 Accounts Payable 15 Taxes Payable 16 Wages Payable 17 Short-term Loans Payable 18 19 During the year, Arnn had: 20 Net Sales 21 COGS 22 23 Example ratio calculation: 24 1. Compute the Times-Interest-Earned ratio. 25 Interest Expense 26 Income Before Taxes 27 28 Calculation label: 29 Calculation: 30 Calculation label: 31 Calculation: 32 Answer label: 33 Answer: 34 35 Required: 36 Ready Sheet1 + $ 200,000 300,000 $ 250,000 400,000 100,000 200,000 50,000 175,000 85,000 90,000 50,000 $ 2,450,000 1,300,000 $ 1,500.00 $ 400,000.00 =Income Before Taxes+Interest Expense $ 401,500.00 -Interest Expense $ 1,500.00 =[Income Before Taxes+Interest Expense)/Interest Expense 267.67 120%