Develop a one-page financial analysis using the below information of the financial performance for Mr. Z. Using at least 5-7 ratios.

Income Statement

Consolidated Income Statement

Balance Sheet

 

Transcribed Image Text:

A B S003 Store Revenues cogs S001 231,213.71 110661.8246 120,551.89 0.521387272 S002 229,437.74 109578.0243 119,859.72 0.522406278 226,042.75 108566.1429 117,476.61 0.519709688 231,085.71 110620.4327 120,465.28 0.521301284 233,443.90 111525.6378 121,918.26 0.522259362 232,530.58 111475.0277 121,055.55 0.520600569 229,262.93 109399.2657 119,863.66 0.522821829 229,125.34 108962.7467 120,162.59 0.524440436 235,814.86 112517.0047 123,297.86 0.522858718 229,830.98 109820.3316 120,010.65 0.522169154 59,478.02 31400.9161 28,077.10 0.472058483 1,232,739.17 S004 S005 S006 S007 S008 S009 S010 S101 D E F I J K L M N Gross Profit Gross Profit % employee pay expense administrative expense Promotions expense credit card expense quarterly van depreciation Store depreciation Total Expenses Net Profit Net profit % 524.2 42,809.18 39,773.45 7,163.00 8,328.00 169.545 6,570.84 6,330.39 6,386.41 6,581.00 180.605 39,813.81 39,800.36 6,276.00 6,486.58 7,523.00 6,042.17 39,840.73 39,773.45 39,813.81 7,514.00 57,067.22 63,484.67 0.274571389 54,601.38 65,258.33 0.284427204 52,961.83 64,514.78 0.285409629 52,743.97 67,721.30 0.293057082 53,620.62 68,297.64 0.292565537 54,043.93 67,011.63 0.288184145 54,824.92 65,038.74 0.283686266 55,267.12 64,895.47 0.283231325 57,316.25 65,981.61 0.279802593 52,030.46 67,980.19 0.295783411 108,981.00 -80,903.90 -1.360231828 8,653.00 9,138.00 39,544.69 41,603.50 9,141.00 37,956.85 7,629.00 95,122.77 6,696.25 G H 181.035 214.725 207.13 163.385 220.16 188.49 165.685 0 6,549.35 6,194.72 6,364.27 6,383.26 6,278.92 836.98 0 0 0 0 0 0 0 0 0 0 5075 0 0 0 0 0 0 0 0 0 0 1250 A B S003 Store Revenues cogs S001 231,213.71 110661.8246 120,551.89 0.521387272 S002 229,437.74 109578.0243 119,859.72 0.522406278 226,042.75 108566.1429 117,476.61 0.519709688 231,085.71 110620.4327 120,465.28 0.521301284 233,443.90 111525.6378 121,918.26 0.522259362 232,530.58 111475.0277 121,055.55 0.520600569 229,262.93 109399.2657 119,863.66 0.522821829 229,125.34 108962.7467 120,162.59 0.524440436 235,814.86 112517.0047 123,297.86 0.522858718 229,830.98 109820.3316 120,010.65 0.522169154 59,478.02 31400.9161 28,077.10 0.472058483 1,232,739.17 S004 S005 S006 S007 S008 S009 S010 S101 D E F I J K L M N Gross Profit Gross Profit % employee pay expense administrative expense Promotions expense credit card expense quarterly van depreciation Store depreciation Total Expenses Net Profit Net profit % 524.2 42,809.18 39,773.45 7,163.00 8,328.00 169.545 6,570.84 6,330.39 6,386.41 6,581.00 180.605 39,813.81 39,800.36 6,276.00 6,486.58 7,523.00 6,042.17 39,840.73 39,773.45 39,813.81 7,514.00 57,067.22 63,484.67 0.274571389 54,601.38 65,258.33 0.284427204 52,961.83 64,514.78 0.285409629 52,743.97 67,721.30 0.293057082 53,620.62 68,297.64 0.292565537 54,043.93 67,011.63 0.288184145 54,824.92 65,038.74 0.283686266 55,267.12 64,895.47 0.283231325 57,316.25 65,981.61 0.279802593 52,030.46 67,980.19 0.295783411 108,981.00 -80,903.90 -1.360231828 8,653.00 9,138.00 39,544.69 41,603.50 9,141.00 37,956.85 7,629.00 95,122.77 6,696.25 G H 181.035 214.725 207.13 163.385 220.16 188.49 165.685 0 6,549.35 6,194.72 6,364.27 6,383.26 6,278.92 836.98 0 0 0 0 0 0 0 0 0 0 5075 0 0 0 0 0 0 0 0 0 0 1250