SALUDOS

PARA MANANA EL TRABAJO ASIGNADO 1 DE DIC

GRACIAS

EJERCICIO PARA ENTREGAR III B2 SECCION III B EJERCICIO SOBRE ANALISIS FINANCIEROS JERRY SOTO ES EL CONTADOR Y GERENTE DE LAS EMPRESAS APACHE. ACUDE A USTED COMO ANALISTA FINANCIERO PARA ASESORAMIENTO EN CUANTO A LA PROPUESTA DE UN PRESTAMO. ESTA SOLICITANDO UN PRESTAMO CON PLAZO DE CINCO AOS CON SU BANCO. EL PROPSITO ES CANCELAR EL PAGARE (NOTES PAYABLE) DEL 2012, Y PARA FINANCIAR ACTIVOS CORRIENTES ESPECIALEMTE EL INVENTARIO DE MERCADERIA. A CONTINUACION LOS ESTADOS FINANCIEROS PRESENTADOS. INCOME STATEMENTS: SALES COST OF GOODS SOLD GROSS PROFIT OPERATING EXPENSES: FIXED CASH OPERATING EXPENSES VARIABLE OPERATING EXPENSES DEPRECIATION TOTAL OPERATING EXPENSES EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES NET INCOME 20X12 20X11 $1,600,000 960,000 $ 640,000 $1,250,000 750,000 $ 500,000 $ 210,000 160,000 100,000 $ 470,000 $ 170,000 65,000 $ 105,000 42,000 $ 63,000 ======== $ 210,000 125,000 45,000 $ 380,000 $ 120,000 30,000 $ 90,000 36,000 $ 54,000 ======== BALANCE SHEETS: ASSETS 20X12 20X11 CASH ACCOUNTS RECEIVABLE MARKETABLE SECURITIES INVENTORIES TOTAL CURRENT ASSETS $ 50,000 160,000 225,000 255,000 $ 690,000 $ 90,000 125,000 100,000 290,000 $605,000 LAND BUILDING & EQUIPMENT LESS: ALLOWANCE FOR DEPRECIATION TOTAL FIXED ASSETS (NET) $ 260,000 1,000,000 380,000 $ 880,000 $200,000 700,000 280,000 $ 620,000 LICENCES $ 500,000 $550,000 TOTAL ASSETS $2,070,000 ======== $ 1,775000 ======== LIABILITIES ACCOUNTS PAYABLE NOTES PAYABLE MORTGAGE - CURRENT PORTION TOTAL CURRENT LIABILITIES $ 290,000 280,000 60,000 $630,000 $ 105,000 170,000 50,000 $325,000 MORTGAGE DEBT $322,000 $372,000 $952,000 $697,000 COMMON STOCKS PAID IN CAPITAL RETAINED EARNINGS TOTAL STOCKHOLDERS' EQUITY $ 500,000 280,000 338,000 $1,118,000 $500,000 280,000 298,000 $1,078,000 TOTAL LIAB. & STOCKHOLDERS' EQUITY $2,070,000 ========= $1,775,000 ========= TOTAL LIABILITIES STOCKHOLDERS' EQUITY INDUSTRIES RATIOS: INDUSTRIES AVERAGE CURRENT RATIO 1.80 ACID TEST RATIO 0.70 AVERAGE COLLECTION PERIOD 30 DAYS INVENTORY TURN/OVER 2.50 TIME DEBTS TO TOTAL ASSETS 58% LONG TERM DEBTS TO TOTAL CAPITALIZATION 33% TIMES INTEREST EARNED 6.80 TIME GROSS PROFIT MARGIN 45% OPERATING PROFIT MARGIN 17% NET PROFIT MARGIN 7.50% TOTAL ASSETS TURN/OVER 1.14 TIMES FIXED ASSETS TURN/OVER 1.40 TIMES OPERATING EARNINGS RETURN ON INVESTMENT 11.4% RETURN ON TOTAL ASSETS 4.00% RETURN ON COMMON EQUITY 9.50% REQUERIDO: 1. RATIO ANALYSIS: EXCELLENCE, GOOD, AVERAGE, POOR, and DEFICIENT 2. COMMON SIZE ANALYSIS A. INCOME STATEMENTS B. BALANCE SHEETS 3. FUND STATEMENT ANALYSIS 4. HOW THE OBJECTIVES DESCRIBED ON CHAPTER 1 OF THE TEXT BOOKS WERE ACHIEVED BY EMPRESAS APACHE. 5. ANALYZE THE LOAN REQUEST. WOULD YOU GRANT THE LOAN? EXPLAIN