Answered step by step
Verified Expert Solution
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. 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
Common size balance sheet and income statement provided to answer Ratio Analysis Spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started