ratio analysis- for the two years and do all possible.
common size analysis-
to. income statements
b. balance sheets
for the two years and do all the possible by section and additional in the rubric
fund statement analysis- do source and usage analysis. Make the reconciled state
Analyze the loan request: would you grand the loan? explain
2019 2018 $ 5,675,000 3,904.000 $ 1,771,000 $ 4,921,250 3,318.800 $ 1,602,450 $ 650,000 345,200 152,000 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 LESS PREFERRED STOCKS DIVIDENDS EARNINGS AVAILABLE FOR COMMON STOCKHOLDER s $ 650,000 376,000 152,000 1,178,000 s 593,000 193,000 400,000 24.000 $ 376,000 30,000 s 346.000 s 1.147.200 455.250 166.000 289,250 15.700 273.550 35,500 238,050 s s 2018 BALANCE SHEETS: ASSETS CASH ACCOUNTS RECEIVABLE MARKETABLE SECURITIES INVENTORIES TOTAL CURRENT ASSETS 2019 $ 250,000 805.556 325,000 475.625 $234,100 763.900 300.000 563.445 $1,856,181 $ 1.861,445 LAND BUILDING & EQUIPMENT LESS. ALLOWANCE FOR DEPRECIATION TOTAL FIXED ASSETS (NET) TOTAL ASSETS $ 2,694,968 $ 1,800,000 500.000 $ 2,281,706 $ 1,400,000 348.000 3,994.968 S5,851.149 3,333,706 $ 5,195,151 s LIABILITIES ACCOUNTS PAYABLE NOTES PAYABLE MORTGAGE - CURRENT PORTION TOTAL CURRENT LIABILITIES $ 330,200 411.000 75,000 400.500 470,000 100.202 $ 816,200 $971.402 2,565.200 $3,381.400 2.100.000 $ 3,071.402 S MORTGAGE DEBT-LONG TERM TOTAL LIABILITIES STOCKHOLDERS' EQUITY COMMON STOCKS PAID IN CAPITAL RETAINED EARNINGS TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDERS' EQUITY $ 650,000 493,749 1.326,000 2.469,749 $5.851.149 650,000 493,749 980.000 $ 2,123,749 $ 5,195,151 OTHER DATA: 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: Siga estas instrucciones y requeridos de este ejercicio y las que aparecen en la Rbrica de Evaluacin del ejercicio. RATIO ANALYSIS 1. Para los dos aos y hacer todas las posibles. Detalles adicionales en la Rbrica de Evaluacin y VC COMMON SIZE ANALYSIS: A. INCOME STATEMENTS B. BALANCE SHEETS 1. Para los dos aos y hacer todas las posibles por seccin y por total. Detalles adicionales en la Rbrica de Evaluacin y VC. FUND STATEMENT ANALYSIS: 1. Hacer el anlisis de fuentes y usos. Hacer el estado reconciliado. Detalles adicionales en Rbrica de Evaluacin; 4. ANALYZE THE LOAN REQUEST. WOULD YOU GRANT THE LOAN? EXPLAIN. 2019 2018 $ 5,675,000 3,904.000 $ 1,771,000 $ 4,921,250 3,318.800 $ 1,602,450 $ 650,000 345,200 152,000 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 LESS PREFERRED STOCKS DIVIDENDS EARNINGS AVAILABLE FOR COMMON STOCKHOLDER s $ 650,000 376,000 152,000 1,178,000 s 593,000 193,000 400,000 24.000 $ 376,000 30,000 s 346.000 s 1.147.200 455.250 166.000 289,250 15.700 273.550 35,500 238,050 s s 2018 BALANCE SHEETS: ASSETS CASH ACCOUNTS RECEIVABLE MARKETABLE SECURITIES INVENTORIES TOTAL CURRENT ASSETS 2019 $ 250,000 805.556 325,000 475.625 $234,100 763.900 300.000 563.445 $1,856,181 $ 1.861,445 LAND BUILDING & EQUIPMENT LESS. ALLOWANCE FOR DEPRECIATION TOTAL FIXED ASSETS (NET) TOTAL ASSETS $ 2,694,968 $ 1,800,000 500.000 $ 2,281,706 $ 1,400,000 348.000 3,994.968 S5,851.149 3,333,706 $ 5,195,151 s LIABILITIES ACCOUNTS PAYABLE NOTES PAYABLE MORTGAGE - CURRENT PORTION TOTAL CURRENT LIABILITIES $ 330,200 411.000 75,000 400.500 470,000 100.202 $ 816,200 $971.402 2,565.200 $3,381.400 2.100.000 $ 3,071.402 S MORTGAGE DEBT-LONG TERM TOTAL LIABILITIES STOCKHOLDERS' EQUITY COMMON STOCKS PAID IN CAPITAL RETAINED EARNINGS TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDERS' EQUITY $ 650,000 493,749 1.326,000 2.469,749 $5.851.149 650,000 493,749 980.000 $ 2,123,749 $ 5,195,151 OTHER DATA: 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: Siga estas instrucciones y requeridos de este ejercicio y las que aparecen en la Rbrica de Evaluacin del ejercicio. RATIO ANALYSIS 1. Para los dos aos y hacer todas las posibles. Detalles adicionales en la Rbrica de Evaluacin y VC COMMON SIZE ANALYSIS: A. INCOME STATEMENTS B. BALANCE SHEETS 1. Para los dos aos y hacer todas las posibles por seccin y por total. Detalles adicionales en la Rbrica de Evaluacin y VC. FUND STATEMENT ANALYSIS: 1. Hacer el anlisis de fuentes y usos. Hacer el estado reconciliado. Detalles adicionales en Rbrica de Evaluacin; 4. ANALYZE THE LOAN REQUEST. WOULD YOU GRANT THE LOAN? EXPLAIN
