Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Common size balance sheet and income statement provided to answer Ratio Analysis Spreadsheet. Balance Sheet 2017 Percent Percent Percent Total Ouros 199,111 43.021. Assels CON

Common size balance sheet and income statement provided to answer Ratio Analysis Spreadsheet. image text in transcribed
image text in transcribed
image text in transcribed
Balance Sheet 2017 Percent Percent Percent Total Ouros 199,111 43.021. Assels CON msn cherung_150 0.0087 BOE 1,801,397100]. fash-Saung 19000_0.538% Nerincome Tc. Accounts Receiva 100,000 5.384% VeneSess, 000 short tom net, 10.000 0.541.hos . Pepad melance $1500 0.19%). Heino (61300) Prepar muhoge 18,000 0.9991. e... (8,333) Supples NING 21500 0.1357. bepropuen 151750) Totalcune Otosh, 146,150 1.330] ajoute 27,000) tangible agers 1751000 44227. MO 1 25,000) Land (ned) 1257000 .7301 (500) Bulding (Fixed) 1000,000 64.60TL 15,500) -) Loss anuncke. Bo 125.000) -6.15). K6000) Lehicles delnay 359,247 19:241 199500 ) jess.acum chur 123,000) -1.241. 11086,117 Total assets 1,857,30771001 Luent liab lacct pay $4,000 2.91%. Insurance pay 11,400 0.61]. uages pay 171860 10.96%. Fotal Content 83,280 4.481 Loan payantel 125000 1.131. Ik poyable (107250,000 45.161. Talal liabilities 1,059,280 4.981 Curers equitut H. Jockason opit noob 4.891. Less:H TOC uuth 1151000 0 % Relandd eannunu B6,117 36.94% PO UUTIIULUI Income Statement 2017 Percent Percent 012331,97% Revenue Delivery fees cand/8951000 100% Expenses Advertising exp. 0300 .74% Deprecation exbu. 8,333 Jpeprec. venicie 150 .00 insurance exp_1220DD 2.51%. interest exp 25.000 2.92%. Pental veni, syp 500 2001. Sualles expense 5,500 .647. uninties expense 60.000 - 10% uage expense 89.500 10.47% Total expense 168,883 19.157. net in.com (6055) 686 167 80.25% RATIO ANALYSIS SPREADSHEET 2020 SOLVENCY RATIOS 2010 2020 16,50 83,200 Current Current Assets Current Liabilities Quick Cash + Accounts Receivable Marketable Securities Current abilities SAFETY RATIO 0100 Total Liabilities Equity Debt to Equity PROFITABILITY RATIOS Gross Profit Margin (56) wird Gross Profit Sales Pro-Tax Profit Margin (56) Profit Before Taxes Sales Retum on Assets (%) Profit Before Taxes Total Assets non Equity (%) Profit Before Taxes Total Equity BALANCE SHEET MANAGEMENT RATIOS Sales to Assets Sales Total Assets Inventory Turnover ( Cost of Goods Sold Inventory Inventory Days 365 Inventory Turnover Accts Receivable Turnover Sales Accounts Receivable Collection Period (days) 265 Accounts Receivable Turnover Accounts Payable Turnover X Cost of Goods Sold Accounts Payable Accounts Payable Days Accounts Payable Turnover

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions