I need help making total asset turnover. And profitabilty report.

Pivot Aluminium L.L.C Annual Statements 2006-2016 in AED/Dirhams Parameters 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 STATEMENT OF FINANCIAL POSITION Current Assets Due from partners Due from related parties Inventories Work in progress Prepayments and other recievables Accounts Receivable Cash and cash equivalent 180,000 5,670,219 1,141,491 1,016,815 1,042,135 1,081,011 313,687 7,950,385 1,126,002 126,783 1,562,471 1,082,534 1,894,703 313,687 3,181,519 797,477 3,927,304 1,016,584 522,749 277,454 302,157 3,769,419 1,033,466 3,678,150 1,177,152 1,450,203 305,088 305,757 5,132,965 749,116 1,009,910 828,528 2,235,338 52,445.00 322,857 4,458,838 1,249,282 1,341,578 810,186 3,175,896 16,376 3,387,115 1,051,467 1,260,546 900,897 3,870,146 166,489 2,001,008 835,832 373,802 1,106,022 7,389,172 28,623 1,913,856 1,143,104 3,328 751,366 6,331,964 50,708 206,277 1,237,105 345,050 840,579 3,698,134 56,278 1,513,078 1,803,022 109,837 489,283 1,795,014 1,550,961 10,131,671 14,056,565 10,036,774 11,715,635 10,314,059 11,375,013 10,636,660 11,734,459 10,194,326 6,383,423 7,261,195 39,376 127,036 199,222 185,989 40,778 100,591 220,053 375,418 379,409 531,771 517,075 10,171,047 14,183,601 10,235,996 11,901,624 10,354,837 11,475,604 10,856,713 12,109,877 10,573,735 6,915,194 7,778,270 Current Liabilities Due to related parties Accured expenses and other payables Accounts payable Vehicle loan Short term borrowings Due to partners Due to banks 75,783 1,646,321 1,941,201 1,357,143 257,823 159,836 3,926,843 3,382,527 - 168,786 974,753 2,329,435 535,152 159,835 469,355 3,664,514 1,185,305 - 264,896 826,951 1,401,097 1,293,310 - 1,038,617 831,324 1,907,849 1,565,234 - 2,019,957 501,031 1,589,366 52,726 950,627 - 2,384,379 845,649 2,570,217 91,046 1,118,637 - 155,000 1,940,993 3,227,527 69,798 2,081,328 - 758,234 1,817,629 2,139,362 93,876 339,318 363,067 1,258,567 4,345,511 79,320 - Total Current Liabilities 5,278,271 7,469,206 4,008,126 5,479,009 3,786,254 5,343,024 5,113,707 7,009,928 7,465,868 5,148,419 6,046,465 Total Current Asset Non-current assets Property,plant,equipment TOTAL ASSETS - Non-current liability Employee's end of service benefits 525,043 429,554 279,175 262,741 248,430 214,930 226,620 255,606 211,186 156,953 125,981 TOTAL LIABILITIES 5,803,314 7,898,760 4,287,301 5,741,750 4,034,684 5,557,954 5,340,327 7,265,534 7,677,054 5,305,372 6,172,446 PARTNER'S EQUITY AND LIABILITIES Partner's Equity Capital Legal reserve Partners current account Accumalated profits 300,000 150,000 3,917,733 300,000 150,000 5,834,841 300,000 150,000 5,498,695 300,000 150,000 5,709,874 300,000 150,000 5,870,153 300,000 150,000 - 5,467,650 300,000 150,000 480,000 5,546,386 300,000 150,000 540,000 4,886,341 300,000 150,000 540,000 2,916,883 300,000 150,000 1,159,822 300,000 150,000 1,155,824 TOTAL PARTNER'S EQUITY 4,367,733 6,284,841 5,948,695 6,159,874 6,320,153 5,917,650 5,516,386 4,796,341 2,826,883 1,609,822 1,605,824 4,367,733 - 6,284,841 - 5,948,695 - 6,159,874 - 6,320,153 - 5,917,650 - 5,516,386 - 4,844,343 48,002 2,896,681 69,798 1,609,822 - 1,605,824 - 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 Parameters 2016 STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME Contract revenue Contract costs Gross Profit 10,310,928 (6,455,510) 3,855,418 29,232,015 (22,044,810) 7,187,205 15,828,817 (11,781,840) 4,046,977 15,499,256 (12,386,684) 3,112,572 10,567,795 (8,144,249) 2,423,546 11,431,001 (8,760,171) 2,670,830 11,715,961 (8,631,567) 3,084,394 13,510,284 (9,649,423) 3,860,861 17,312,807 (13,466,065) 3,846,742 12,656,634 (10,985,396) 1,671,238 10,150,506 (8,616,396) 1,534,110 General and administrative expenses Finance charges Provision for bad and doubtful depts Other Income Provision for zakat Profit before management fees (2,252,760) (81,605) (452,185) 165,197 (30,852) 1,203,213 (2,569,571) (78,987) (2,033,530) 157,158 (66,557) 2,595,718 (1,979,719) (137,054) (1,435,852) 62,710 (13,927) 543,135 (2,566,781) (148,348) 103,664 (12,528) 488,579 (2,002,949) (122,432) 165,178 (16,117) 447,226 (2,159,335) (167,002) 55,808 (10,008) 390,293 (1,705,938) (231,346) 60,919 (30,201) 1,177,828 (1,681,365) 64,901 (56,110) 2,188,287 (2,042,772) 198,379 (50,059) 1,952,290 (1,379,657) 168,816 (11,510) 448,887 (847,656) 230,813 (22,932) 894,335 (120,321) (259,572) (54,314) (48,858) (44,723) (39,029) (117,783) (218,829) (195,229) (44,889) (89,433) 1,082,892 2,336,146 488,821 439,721 402,503 351,264 1,060,045 1,969,458 1,757,061 403,998 804,902 2016 2015 2010 2009 2008 Management fees Profit for the year Parameters 2014 2013 2012 2011 2007 2006 STATEMENT OF CASH FLOWS Profit of the year 1,082,892 2,336,146 488,821 439,721 402,503 351,264 1,060,045 1,969,458 1,757,061 403,998 804,902 Adjustments For Depreciation Gain on disposal of property and equipment Provision for employee's end of service benefit Operating profit before working capital changes 87,660 95,489 1,266,041 87,186 150,379 2,573,711 82,863 16,434 588,118 93,638 14,311 547,670 63,611 (61,998) 33,500 437,616 119,462 0 (11,690) 459,036 165,535 (28,986) 1,196,594 192,991 44,420 2,206,869 210,408 210,408 2,177,877 199,635 (34,999) 30,972 599,606 189,591 -33798 33,404 994,099 (Increase)/decrease in operating assets Accounts recievable Due from related parties Prepayments and other recievables Work in progress Inventories 1,082,534 2,280,166 520,336 (890,032) (15,489) (559,785) (4,768,866) (545,887) 3,800,521 (328,525) 927,454 587,900 160,568 (249,154) 235,989 785,135 1,363,546 (348,624) (2,668,240) (284,350) 940,558 (674,127) (18,342) 331,668 500,166 694,250 (1,071,723) 90,711 (81,032) (197,815) 3,519,026 (1,386,107) 205,125 (886,744) (215,635) (1,057,208) (87,152) (354,656) (370,474) 307,272 1,157,649 (1,707,579) 89,213 341,722 94,001 (1,903,120) 1,306,801 (351,296) (235,213) 565,917 (1,318,577) 693,775 (54,875) (1,353,559) (1,441,326) (2,280,522) 1,357,143 (84,053) 1,053,092 2,952,090 (8,950) (1,335,079) 505,398 8,951 2,263,417 (357,596) (105,061) (506,752) (115,564) 336,848 318,483 330,293 (981,340) (980,851) (344,618) (364,422) (657,310) (1,095,344) 229,379 1,157,649 192,848 (603,234) (2,209,738) 489,578 461,062 2,826,139 295,980 47,172 1,794,798 4,167,401 1,430,145 1,195,897 1,232,071 (439,137) 742,368 (878,624) 2,900,146 (1,276,403) 2,130,154 CASH FLOW FROM INVESTING ACTIVITIES Purchase of property,plant and equipment Disposal of property,plant and equipment - (15,000) - (96,096) - (238,849) - (3,800) 62,000 - (10,170) - (189,000) - (109,400) 90,000 (214,332) 35,000 (262,564) 83,800 Net cash (used in) / from investing activities - (15,000) (96,096) (238,849) 58,200 - (10,170) (189,000) (19,400) (179,332) (178,764) 257,823 - (650,153) (700,000) (11,530) - (108,005) (600,000) 3,600 - (271,924) (982,278) - 614,607 (52,726) (430,000) 157,143 - (168,010) (86,322) (400,000) 60,000 - (962,691) 8,230 - 1,742,010 (102,026) (540,000) 21,734 339,318 (400,000) 211,110 (365,127) -300000 (Decrease) /Increase in operating liabilities Accounts payable Accured expenses and other payables Due to partners Due to related parties Net Cash flow from operating activities CASH FLOW FROM FINANCING ACTIVITIES Short term borrowing Vehicle loan Due to banks Profit distributed Movement in partner's Current account Divident paid (3,000,000) 133,687 - (535,152) (2,000,000) - Net cash (used in) financing activites (2,608,490) (2,535,152) (1,361,683) (704,405) (1,254,202) 289,024 (594,332) (954,461) 1,099,984 (38,948) (454,017) Net Increase in cash and cash equivalents Cash and cash equivalents at the beginning of year (813,692) 1,894,703 1,617,249 277,454 (27,634) 305,088 252,643 52,445 36,069 16,376 (150,113) 166,489 137,866 28,623 (22,085) 50,708 (5,570) 56,278 (1,494,683) 1,550,961 1,497,373 53,588 CASH AND CASH EQUIVALENT AT THE END OF YEAR 1,081,011 1,894,703 277,454 305,088 52,445 16,376 166,489 28,623 50,708 56,278 1,550,961 Salil Ahuja 20170005480 Sara Mohamad Ali Ghazoghli S1314000855 Ameena Abbas Ali 20170005497 Mohammad 20170005474 Maher 810100 Parameters 2016 2015 2014 2013 2012 2011 STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME Contract revenue Contract costs 100% -63% 100% -75% 100% -74% 100% -80% 100% -77% 100% -77% Gross Profit 37% 25% 26% 20% 23% 23% General and administrative expenses Finance charges Provision for bad and doubtful depts Other Income Provision for zakat Profit before management fees Management fees Total Expense -22% -1% -4% 2% 0% 12% -1% -27% 11% -9% 0% -7% 1% 0% 9% -1% -17% 8% -13% -1% -9% 0% 0% 3% 0% -22% 3% -17% -1% 0% 1% 0% 3% 0% -17% 3% -19% -1% 0% 2% 0% 4% 0% -19% 4% -19% -1% 0% 0% 0% 3% 0% -20% 3% 2016 2015 2014 2013 2012 2011 Profit for the year Short Term Solvency/ Liquidity Current Ratio Quick Ratio Difference Cash Ratio Operating CF to Current Liability Cash Flow Margin Ratio Interval Measure in months Inventory Turnover Account Receivable Turnover Account Payable Turnover 1.92 1.51 0.41 0.20 0.34 0.17 44.46 5.69 #DIV/0! 3.33 2016 1.88 1.71 0.17 0.25 0.56 0.14 35.25 22.92 27.00 6.61 2015 2.50 1.33 1.18 0.07 0.36 0.09 34.32 12.87 30.28 4.96 2014 2.14 1.28 0.86 0.06 0.22 0.08 53.33 13.90 10.69 3.46 2013 2.72 2.26 0.46 0.01 0.33 0.12 62.09 8.15 4.73 5.46 2012 2.13 1.64 0.48 0.00 0.08 0.04 59.66 7.62 3.60 4.70 2011 Long Term Solvency/ Financial Leverage Debt to Equity Ratio Debt Ratio 0.12 1.75 2016 0.07 1.80 2015 0.05 2.39 2014 0.04 2.07 2013 0.04 2.57 2012 0.04 2.06 2011 Proftability Ratios ROA Return on Equity 11% 25% 14% 16% 37% 21% 5% 8% 3% 4% 7% 3% 4% 6% 2% 3% 6% 3% 2010 2009 2008 2007 2006 100% -74% 100% -71% 100% -78% 100% -87% 100% -85% 26% 29% 22% 13% 15% -15% -2% 0% 1% 0% 10% -1% -17% 9% -12% 0% 0% 0% 0% 16% -2% -14% 15% -12% 0% 0% 1% 0% 11% -1% -12% 10% -11% 0% 0% 1% 0% 4% 0% -10% 3% -8% 0% 0% 2% 0% 9% -1% -7% 8% 2010 2009 2008 2007 2006 MPREHENSIVE INCOME COGS have reduced over the years, must see if any permenant strategies General Exp more than doubled, is it one time expense or recurring? Although sales have reduced by 65% in 2016, Company's efficiency has dity 2.08 1.63 0.45 0.03 0.15 0.06 63.93 9.15 3.03 5.57 2010 1.67 1.50 0.17 0.00 0.13 0.07 75.48 9.75 1.83 3.63 2009 1.37 1.21 0.15 0.01 0.39 0.17 59.35 11.32 2.73 4.14 2008 1.24 0.93 0.31 0.01 0.25 0.10 61.29 7.23 3.42 4.87 2007 1.20 0.88 0.32 0.26 0.35 0.21 121.15 9.56 5.65 2.40 Positive working capital throughout, Healthy Current Ratio Healthy Quick Ratio Less liquidity tied up in inventory, high inventory in 2016 to meet high de Cash position has significantly inproved in past 2 year, less cash tied up in Company does not generate sufficient cash from its operation to settle it Indicates company's ability to generate cash out of sales- whichis low if cash inflows began to dry up. How long could the business keep runnin Shows how many times the inventory is sold in a year- to convert invento Shows how effieciently firm collects money in a year- has improved signi Healthy payment cycle, as the company manages to receive cash more n Although Cash position of the company is not healthy, the overall curre Their attempt is to settle all of company's current liabilities without inc 2006 everage 0.04 2.03 2010 10% 19% 9% 0.05 1.67 2009 16% 41% 25% 0.07 1.38 2008 17% 62% 46% 0.10 1.30 2007 6% 25% 19% 0.08 Healthy Debt to Equity ratio- rely on short term borrowings 1.26 downward trend in debt ratio because working capital is increasing, long 2006 10% 50% 40% , must see if any permenant strategies have been implemented to reduce cost it one time expense or recurring? 5% in 2016, Company's efficiency has improved as COGS have reduced and overall profitability has increased t, Healthy Current Ratio high inventory in 2016 to meet high demands in 2017- however stocks were kept at optimum level oved in past 2 year, less cash tied up in inventory, must see what other measures have been taken- has this resulted in higher debts ent cash from its operation to settle its current liabilities erate cash out of sales- whichis low w long could the business keep running? ory is sold in a year- to convert inventory into cash. Has reduced significantly in 2016, due to high inventory and low sales s money in a year- has improved significantly pany manages to receive cash more number of times as compare to what it needs to pay to its creditors mpany is not healthy, the overall current assets are managed well enough which keeps the liquidity high. mpany's current liabilities without increasing long tern debt n short term borrowings use working capital is increasing, long term liability is only 10% of total liabilities ulted in higher debts Corelation between Pivot and Construction Industry o Source: Dubai Chamber Report 2016 Period 2011 2012 2013 2014 2015 Real Value Billion USD- UAE Construction Industry 28.20 29.80 31.00 32.80 34.00 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.8412391797 0.7076833575 0.6102444767 1.4437494722 5 ANOVA df Regression Residual Total 1 3 4 Coefficients Intercept Revenue AED- Pivot LLC 26.8716757796 2.59713068577437E-007 Sales Forecast Model- Construction Indust https://tradingeconomics.com/united-arab-emirates/population https://inflationdata.com/Inflation/Inflation_Rate/Historical_Oil_Prices_Table.asp Period 2011 2012 2013 2014 2015 Real Value Billion USD- UAE Construction Industry 28.20 29.80 31.00 32.80 34.00 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9960402729 0.9920962252 0.9841924504 0.2907555248 5 ANOVA df Regression Residual Total 2 2 4 Coefficients Intercept GDP of UAE- USD Billion Oil Prices Nominal Price-USD 8.2308151597 0.0858321172 -0.1185544417 Sales Forecast Model- PIVOT LLC https://tradingeconomics.com/united-arab-emirates/population https://inflationdata.com/Inflation/Inflation_Rate/Historical_Oil_Prices_Table.asp Period Revenue AED- Pivot LLC 2007 2008 2009 2010 2011 2012 2013 2014 2015 12,656,634 17,312,807 13,510,284 11,715,961 11,431,001 10,567,795 15,499,256 15,828,817 29,232,015 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.7762275028 0.6025291361 0.4700388481 4141122.06131749 9 ANOVA df Regression Residual Total Intercept GDP of UAE- USD Billion Oil Prices Nominal Price-USD 2 6 8 Coefficients 13463494.2062174 65478.7437262216 -266875.964800364 between Pivot and Construction Industry of UAE Revenue AED- Pivot LLC 11,431,001 10,567,795 15,499,256 15,828,817 29,232,015 SS 15.1387623842 6.2532376158 21.392 MS 15.1387623842 2.0844125386 F 7.2628436568 Significance F 0.0741013871 Standard Error 1.7172392559 9.63696886441235E-008 t Stat 15.64818396 2.6949663554 P-value 0.0005671926 0.0741013871 Lower 95% Upper 95% Lower 95.0% 21.4066540551 32.336698 21.406654 -0.000000047 5.664E-007 -4.70E-008 Sales Forecast Model- Construction Industry UAE GDP of UAE- USD Billion 350.91 374.82 390.43 403.20 357.95 Oil Prices Nominal Price-USD 87.04 86.46 91.17 85.60 41.85 SS 21.2229224496 0.1690775504 21.392 MS F 10.6114612248 125.5218235789 0.0845387752 Significance F 0.0079037748 Standard Error t Stat P-value Lower 95% 2.5889239134 3.1792418143 0.0863183248 -2.9084253829 0.0074781135 11.477776767 0.0075053958 0.0536563918 0.0079350559 -14.9405932021 0.004449978 -0.1526962314 Upper 95% 19.370056 0.1180078 -0.0844127 Lower 95.0 -2.9084254 0.0536564 -0.1526962 Sales Forecast Model- PIVOT LLC GDP of UAE- USD Billion 257.92 315.47 253.55 289.88 350.91 374.82 390.43 403.20 357.95 Oil Prices Nominal Price-USD 64.20 91.48 53.48 71.20 87.04 86.46 91.17 85.60 41.85 SS 155976822064176 102893351560382 258870173624558 MS 77988411032087.8 17148891926730.4 Standard Error 9057791.69410088 29956.9728778558 92703.3857346168 t Stat 1.4863991866 2.1857596892 -2.878815727 F 4.5477230462 Significance F 0.0627936744 P-value Lower 95% Upper 95% Lower 95.0% 0.1877257435 -8700123.5926 35627112 -8700124 0.0714914075 -7823.32809187 138780.82 -7823.3281 0.0281012075 -493712.977559 -40038.952 -493713 Upper 95.0% 32.336698 5.664E-007 Upper 95.0% 19.370056 0.1180078 -0.0844127 Upper 95.0% 35627112 138780.82 -40038.952 WEEK 2 Company Name - Pivot Aluminium Co. LLC Background: Specialized in fabrication and installation of aluminium, glass, aluminium cladding, steel & stainelss steel Sister company of Al Arif Group, which started in 1975 Company Size: 2 branches- Pivot Aluminium Co. LLC and Pivot Metal Construction LLC Manpower Strength: Industry Analysis: With a total of 4,000 active projects worth an estimated $313.6 billion (Dh1.15 trillion) underway, Dubai's projects industry tr Private sector companies in Dubai signalled their \"most upbeat\" business outlook for 2017 since June 2015, driven by a reb Construction sector will be 'key driver' of Dubai growth in 2017 (Arabian Business) SWOT Analysis Strength Member company of one of the renowned construction company, Al Arif Highly skilled manpower Positive Cashflow- Good reputation amongst customers and suppliers Weakness Sub-contracting projects, revenue highly dependable on the efficiency of the main contracting project. Can cause delays Require more flexibility in terms of increasing capacity to accommodate boost in demand due to Expo2020 Opportunity Boost in demand due to Expo2020 Requires high capital, hence restricts new competition in the market Threats Exploring new business opportunities to diversify business portfolio, as sales are expected to drop post 2020 High demands can attract strong competition Project Outline stainelss steel erway, Dubai's projects industry trends look set to remain upbeat through 2017 (Khaleej Times) since June 2015, driven by a rebound in construction activities in the run up to Expo 2020, according to Emirates NBD (Arabian Busine ing project. Can cause delays ue to Expo2020 to drop post 2020 o Emirates NBD (Arabian Business