Please answer all questions

Please calculate the Dupont Return on Assets for FY 2015 vs. FY 2014, and FY 2014vs. FY 2013. (30%) Formula is; DuPont ROA = Net Profit Margin x Total Assets Turnover. Net Profit Margin = Net Profit / Net Revenue Total Assets Turnover = Net Revenue / Average Total Assets Please show your calculations for full points, and in 2 decimal places (0.00) Based on your calculations in (1) above, were there any improvements in shareholders 'and 2. 3. 150000 -200000 4. 5. 6. 7. 8. Case 2 Cash Market&le SecurRJes Accounts Receivable inventory Current Assets Land. Buildings. PI-Mt. and Equipment Accumulated Dveceation Net fixed Assets Total Assets LIABILITIES AND EQUITIES Short-Term Bank Loans Accounts payaue Accruals Current Llabmties Long-Term Bank Loans Mortgage Long-Term Debt Total Liabilities Stock (100000 shares) Retained Earnings Total Equity Total Liabilities and Equity Are We Getting TOO Big for Our Boots? Table 1 Gillian Pool & Spa Supplies Balance Sheet 7 8 Case 2 Are We Getting Too Bigfor Our Boots ? Table 2 Gillian Pool & Spa Supplies Income Statements 2011 155.000 10000 250000 $41 s.ooo $250,000 -EOOO $225,000 $640,000 $50,000 10.000 5.000 $65,000 $63,366 17S.ooo $238.366 $303,366 $320,000 16.634 $336.634 "40.000 $309,099 12.000 270.000 $591,099 $250,000 -50.000 $200,000 $145,600 10.S0 s. 100 $160,606 $98,000 173000 $271 .ooo $431.606 $320000 39,493 $3S9,493 $791.099 $75.948 20.000 500.000 "95.94B $500,000 -100000 S400.ooo $995,948 S 140,000 19998 7.33 s 167.329 S' 96.000 271.000 $467,000 $634,329 $320,000 41,619 S361.619 $995,948 2014 $28,826 77.6S3 520.000 "26.480 $500,000 $3S0.ooo $976,480 $148,000 15.995 9,301 $173,296 $190.000 268,000 $458.000 $631,296 $320,000 2S.184 $345.184 $976,480 201S $18,425 90.07B 56Q000 $668,503 ssoo.ooo $300000 $968,503 $148m) 16.795 11,626 5176.421 $183,000 254.000 $447.000 $623,421 "20.000 25.082 $345,082 $958. sos Net Sales Cost Of Goods sold Gross pront Admln and Selling Exp Deprection Miscellaneous Total Operating Exp EBIT Interest on ST Interest on Interest on Mortgage Total Interest Before-Tax Earnings Taxes Net Income DivWends on Stock Additions to Retained Earnings 2011 $900,000 729.000 S17t.ooo $45,000 37,500 3.041 $85,541 SE460 S9.600 5.400 16.000 $31,000 554.460 21.784 $32,676 $32676 2012 $982,500 St. 170.000 investors' value between FY 2015 vs. FY 2014, and between FY 2014 vs. FY 2013? Please answer in more detail and in a minimum of 100 words (10%). Please provide and explain in detail 2 recommendations for improvement, if applicable (10%). Please calculate the Debt Ratio (formula: Total Liabilities / Total Assets) for FY 2015 vs FY 2014, and FY 2014 vs FY 2013. Please show your calculations for full points, and in 2 decimal places Based on the calculations in (4) above and if you were a bank loan officer, would you have approved a loan request in FY 2015? What factors determined how you've arrived at your decision? Please explain in more than 50 words (10%) Please calculate the Inventory Turnover in Times and Days for FY 2015. The formula is: Times = Cost of Goods Sold / Average Inventory Days = 365 days / Times Please show your calculations for full points, and in 2 decimal places (0.00) (10%) Was the inventory turnover in days calculations in (6) above good or bad? Please explain in detail and answer in a minimum of 50 words (10%). Please provide and explain 2 recommendations for improvement, if applicable. (10%) 801.900 S 180.600 $58,950 40,000 3.557 $102,S07 $78,093 $9,600 5400 14340 $2&840 $49,253 19.701 $29,552 962.280 "07.720 $64,350 Sl 19030 $E690 9.600 5.400 12,240 $27.240 SC 1,450 24,580 536.870 $36,870 $1.310.400 1,100.736 $209,664 $72072 so,ooo 14.414 $136,486 $73,178 $17.760 13.500 21.440 $52,700 $20,478 8,191 $12,287 $12,287 $1.520.064 1.305.000 $21s,064 $91.204 50.000 22,801 $164,005 $51.059 S17.760 16,470 21,120 $55,350 ($4,291) -1.716 ($2,574) (S2.574)