Prev Layout Views Gridlines Headings Selection Window AR Pane Windo Workbook View Show Zoom Window M21 + X D The following selected information is taken from the financial statements of a company for its most recent year of operations 1 Begining balance Inventory $ 200,000 y Accounts Receivable 300.000 1 Ending Balances entory $ 250.000 10 Account Recewable 400,000 11 Cash 100.000 12 Marketable securities short-term 200.000 11 Prepaid Expen 50,000 16 Accounts Payable 175 000 15 Taxes Payable 85,000 16 Wapes Poble 50,000 1. Short term Loans Pavable 50,000 10 19 During the year, Arnn hade ONS $ 2.450,000 COGS 1.200.000 22 2 temple ratio calculation 24 1. Compute the Times Interested ratio 25 Interest Expen 5 1.500.00 26 confefore Taxes $ 400,000.00 27 2n Calle income forwalterest Expense 29 Cut 5601,500.00 Ju C La L v interest Expense Calculation $ 1.500.00 22 Isbel Uncome Before Tasse interest Espere wer 267,67 Required: Nordi Round altermediary cations and finalwers to two decimal places and format as either a number er der amount (whichever is appropriatel. To receive full points, you must show your work and label the amounts used in your calculations 39 Un postopke the beginning of action label tiep it from thowing HANAM rer. This shows the test you have witneem alleen label in the example above). 0 41.1 Compite the Current wote Sheet1 Ability Good Home Insert D Page Layout Formulas Data Review Owwope Help Power Pivot Tell me what you want to do Domus Que a BE Split www.de No Page Break Preview Page Layout Cast Vis 100% Zoom to Section Gridlines New Window Hide A Freeze Al Panies edias Colles Swich Windows Whion Work w Zoon 024 D M N 36 Note Round intermediary calculations and finalwers to be decimal places and format sethera runner or amount whichever is appropriate To receive full points, you must show your work and label the amounts and in your calculation 3. Un postregheat the beginning of a calculation lahel top it from showing a NAMEThis shows the test you have now calculation label in the sample above 1. Compute the current ratio Clusion label 4 Cabrio 44 Contobel 5 Carti Anwer wel 42 Anw SE 40 30 2. Complete Chai Tev Ratio 11 con label dation Swatch 55 5. Como Ann Helene cu 61 Calm Cons Cli BAN wat in Computer Newsletter w Calm TO COM 22 de Sheet1 bad Formule Bar 5 Normal Page Break Page Preview Layout Custom Views Zoom 100% Zoom to Selection Hide Gridlines Headings New Window Arrange Freeze Al Panes Workbook Views Show Zoom Wii 024 X VA c H M N Calculational 70 Calculation Calculation atel 7 Cato Amweb wer 15 compute theme 75 Conatel Co Calculation otel COR B2 Anwer late 83 55 56 6. Computerwentory Turnover in Days B7 Calon tabeli Calculation wakationsbe 90 Calculation 91 w label 92 Mwer + 04 07 91 100 101 10 100 104 305 02 Sheet1 Godtage