I need help filling out this worksheet on ratios. I'm having trouble finding the "Debt/Asset= L/A = 1/{1/[1/(L/Net Worth)]}", the "PE" ratio, and the "PEG" ratio.

I've attached the files with a blank ratio worksheet, a worksheet with the answers I got, the financial statements of the firm I'm using to calculate the ratios, the ratios provided by the firm, and the industry ratios given by D&B for the firm (which have SIC 26)

I'm hoping someone could help me calculate these ratios, thanks in advance :)

(the industry ratios are on sheet two of the Sugarmade, Inc ratios doc).

Thanks in advance to anyone who helps :)

Sugarmade, Inc. (NBB: SGMD) Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date Currency Audit Status Consolidated Cash Accounts receivable, gross Allowance for doubtful acccounts Accounts receivable, net Inventory, net Loan receivables Other current assets Total current assets Equipment, net Intangible assets Other assets Total assets Bank overdraf Note payable due to bank Accounts payable & accrued liabilities Customer deposits Unearned revenue Other payable Accrued interest Accrued compensation & personnel related payables Production line of credit Notes payable due to shareholder Notes payable due to others Loans payable Convertible notes payables, net Derivative liabilities Total liabilities Common stock Additional paid-in capital Shares to be issued Shares to be issued, preferred shares Shares to be issued, common shares Retained earnings (accumulated deficit) Total stockholders' equity (deficiency) As Reported Annual Income Statement 06/30/2016 USD 0.0292056181 Qualified 2.9205618105 Yes 06/30/2015 USD Unaudited Yes 911 233126 115260 117866 468262 20000 84505 691543 78453 23281 793277 28377 25982 1481961 248299 93522 296259 272708 58260 156730 70772 85958 617557 144050 52832 958657 119150 1814 33781 1113402 65243 25982 1891152 243087 241513 11403 85666 427581 394167 701000 4066923 178686 17151379 2000000 1246000 -23849712 -3273647 11403 273000 521037 419167 304000 3995584 157746 16389946 1961668 -21391542 -2882182 Report Date Currency Audit Status Consolidated Revenues, net Materials & freight costs Provision for inventory obsolescence Total cost of goods sold Gross profit (loss) Loss on write-off of license & supply agreement Selling, general & administrative expenses Amortization of license & supply agreement Total operating expenses Income (loss) from operations Interest expense Other interest income Interest income Changes in fair value of derivative liabilities Commission Gain (loss) on extinguishment of debt Other income Total non-operating income (expense) Net income (loss) 06/30/2016 06/30/2015 USD Qualified Yes USD Unaudited Yes 4348256 2889754 2889754 1458502 2908407 2045592 2045592 862815 3451862 -446021 3451862 -1993360 18789 -397000 3395 -55498 3082 -464810 -2458170 5192203 5192203 -4329388 64136 -82737 10263 -5765486 960 -5901136 -10230524 Weighted average shares outstanding - basic 172845853 95878436 Weighted average shares outstanding - diluted Year end shares outstanding Net income (loss) per share - basic Net income (loss) per share - diluted Number of full time employees Total number of employees Number of common stockholders 172845853 178685388 -0.01 -0.01 21 253 95878436 157745198 -0.11 -0.11 25 253 As Reported Annual Retained Earnings Report Date 06/30/2016 06/30/2015 USD Qualified Yes USD Unaudited Yes Previous retained earnings (accumulated deficit) Retained earnings (accumulated deficit) -21391542 -23849712 -11161018 -21391542 As Reported Annual Cash Flow Report Date 06/30/2016 06/30/2015 USD Qualified USD Unaudited Currency Audit Status Consolidated Currency Audit Status Consolidated Yes Yes -2458170 44488 55498 397000 1246000 48587 -10230524 104548 5765486 82737 681668 2155000 57549 Loss on write-down of license & supply agreement Provision for inventory obsolescence Allowance for doubtful accounts Accounts receivable & other receivables Accounts receivable Inventory Undeposited funds Employee advance Prepaid expense Other assets Bank overdraf Accounts payable & accrued liabilities Company credit card Customer deposits Unearned revenue Payroll liabilities Sales tax payable -76394 149296 23827 -36866 -595605 5212 93522 - 166615 17050 -7925 -2216 18842 -135000 65243 -576883 -79906 8890 30134 -1358 Accrued compensation & personnel related payables Accrued interest Accrued interest & other payables Net cash flows from operating activities Additions to equipment Loan receivables 524074 -579531 79050 65028 -1815022 39972 -6077 -31558 72973 230000 -93457 -187334 500000 - 209214 217628 290000 12654 -147000 1500000 - - - Net income (loss) Bad debt expense Loss on extinguishment of liability Change in fair value of derivative liability Amortization of license & supply agreement Depreciation expense Stock compensation expense Issuance of common stock for services Issuance of warrants with convertible notes Depreciation & amortization Payment for acquisition of property & equipment Cash acquired from acquisition of SWC Group (SWC) Net cash flows from investing activities Proceeds from issuance of common stock Proceeds from (repayment to) loan Payments for note payable Proceeds from EB-5 investment Note payable due to bank Proceeds from issuances of common stock & warrants Borrowings from note payable to bank Proceeds from production line of credit Repayments of production line Share repurchase from related party - - Proceeds from issuance of convertible notes payable - - Proceeds from issuance of convertible notes payable to related parties Net cash flows from financing activities Net increase (decrease) in cash Cash, beginning of year Cash, end of year Cash paid during the period for interest 449209 -57349 58260 911 - 1655654 58260 58260 - 06/30/201 4 USD Qualified Yes 06/30/201 3 USD Qualified Yes 06/30/201 2 USD Qualified Yes 11487 69319 10500 80806 91306 25982 1042766 206386 159381 70249 28000 42249 159255 20057 380942 3299 4705 388946 150000 390138 87275 192100 18700 88798 45125 344723 5257 3994 353974 150000 221020 - 373454 324000 186000 525000 228237 2911826 10539 8329959 -1E+007 -2820520 527544 274000 186000 525000 326452 2466409 10539 8317406 -1E+007 -2077463 43722 414742 10289 8069581 -8140638 -60768 06/30/201 4 USD Qualified Yes 06/30/201 3 USD Qualified Yes 06/30/201 2 USD Qualified Yes 70751 50630 39306 89936 -19186 241398 188109 69451 257560 -16162 141750 111791 195880 307671 -165921 706845 706845 -726031 120292 50 93662 -29850 -755610 1784490 1784490 -1800652 646566 487 181961 -464118 -2264770 318983 3817320 18403 4154706 -4320627 2156 1376 -780 -4321407 10538526 10504279 10341039 10538526 10538526 -0.07 -0.07 0 158 10504279 10538526 -0.22 -0.22 220 10341039 10288526 -0.42 -0.42 11 900 06/30/201 4 USD Qualified Yes 06/30/201 3 USD Qualified Yes 06/30/201 2 USD Qualified Yes -1E+007 -1E+007 -8140638 -1E+007 -3819231 -8140638 06/30/201 4 USD Qualified 06/30/201 3 USD Qualified 06/30/201 2 USD Qualified Yes Yes Yes -755610 -90662 3299 - -2264770 -181961 1958 49692 98383 508413 - -4321407 18403 1611 204404 1633900 - 30762 89936 14262 657657 - 69451 28000 -51549 -139907 24356 169118 - 318983 195880 1220 -11839 -284678 -45125 77950 - -154089 119112 -85363 - 483822 87275 -1017719 - -1536 -2212234 -6868 - - - - -124018 - -6868 - 50000 284000 659438 150000 - - -10000 - -5000 - 525000 - -74018 -159381 159381 558 186000 985000 -32719 192100 159381 87668 804438 -1414664 1606764 192100 2156 FSA--page 5 RATIO ANALYSIS Ratio Quick Ratio D&B Mergent data: the firm industry 2014 2015 2016 SIC: Evaluation: good-poor and improving - _26 deteriorating _ nor m .03 .24 .17 .90 Poor, deteriorating Current Ratio Current Cash Coverage = Cash from Operations Current Liabilities Interest Coverage = TIE = Return on Sales = Profit Margin = Net income et revenue .24 0.17 -2.9 -45.4 -14.2 2.00 Poor, deteriorating 0.30 Poor, deteriorating -6.28 -159.51 31.89 Debt / Asset = L / A = 1 / {1+[1/ (L / NetWorth)]} Cash Coverage = CFO / Total Liabilities .03 -130.83 4.0 Poor, improving 3.59 5.127 -2.9 -45.4 -14.2 0.20 Poor, improving Poor, improving 1067.9 8 .295 -351.76 -56.53 4.83 4.55 Return On Assets -2.65 -16.88 -2.56 4.00 Poor, improving Return on Equity = Return on Net Worth -30.9 -79.86 9.60 Poor, improving Asset Turnover = 1 / (assets/sales) -385.8 PE = Price per share Earnings per share NA NA PEG = PE / (EPSgrowth%*100) NA NA Revenue Growth % = (2016 - 2015) / 2015 NA NA 0.0 0.0 49.50 % 2.0 20.0 Poor 1.25 poor NA FSA--page 5 RATIO ANALYSIS Ratio D&B Mergent data: the firm industry 201 201 2016 SIC: Evaluation: good-poor and improving - 4 5 ___ deteriorating _ nor m Quick Ratio Current Ratio Current Cash Coverage = Cash from Operations Current Liabilities Interest Coverage = TIE = 0.30 4.0 Debt / Asset = L / A = 1 / {1+[1/ (L / NetWorth)]} Cash Coverage = CFO / Total Liabilities 0.20 Return on Sales = Profit Margin = Net income et revenue Asset Turnover = 1 / (assets/sales) Return On Assets Return on Equity = Return on Net Worth PE = Price per share Earnings per share NA NA 20.0 PEG = PE / (EPSgrowth%*100) NA NA 1.25 Revenue Growth % = (2016 - 2015) / 2015 NA NA NA % Sugarmade, Inc. (NBB: SGMD) Exchange rate used is that of the Year End reported date Profitability Ratios ROA % (Net) ROE % (Net) ROI % (Operating) EBITDA Margin % Calculated Tax Rate % Revenue per Employee 06/30/2016 -257.14 AvgEqty