just need help finding the ratios. I know the formulas jusy need help purting it all together
FLATRON TO Financials Case 1. Excel File Page Layout Formule Data Review View Help Tell me what you want to do General Normal Home Copy Tomat Paint Clipboard un vii S.A Conditional Neutral Merge Alignment un A37 D USA Soft Consolidated Statements of Financial Position December 31, 2014-2015 2016 2015 2016 2018 Current Assets Cash Cash Equivients Restricted Cash Accounts Receivable 4,22,005 4.396, 322 4,251,185 15. TH,700 7. 125.329 2,712,496 32.149 566,063 1.480.935 302,015 6,121,053 4.154.227 176.256 1.100 119,5 Prepaid Expenses & Other Current Asset Total Care Assets A Property & Equipment Net Sement 6 Beneficial interest Totalets 119,761 SA 3,936,30 100,7 560.265 1,056,619 205,051 6.222.257 3,801.477 164.427 155 195.610 9750262 10.454.141 192, 10,005,50 10.4. O 25197 habits Current abilities Accounts Payable Acredibles Deferred income Total Currenties Deferred Compensation Total abilities 37 Net Totaltabilities & Nets 560,729 17205 555.411 125,171 33365 1.00 23.1 156.057 2735 661 92 75. 8.65 66 027 661,179 406,00 140.230 47113 1.017-975 7456 1,090,43 91117 10.05.30 732,50 3.06.12 9,254, 1,07145 79202 1,112 2,313,155 10,436, SOT 1,546,819 207,322 10454.141 USA Soal Balance Sheet USA Rugby Balance Sheet iB Type here to search o c . L M 1 LG FLATRON Wide Financial Care - Excel File Home Insert Page Layout Formules Data Help Tell me what you want to do General Normal Bacow - Paste Formater Coord an A Merge Center - 5.%. Formatting Font Alignment NA FG - D USA Softball Income Statement Years ended December 31, 2014-15 2017 ES 5.15.25 671,214 6.0 20 Program Support Membership Registrations Sponsorship and Royalties Hall of Fame Stadium Operations National Council Meeting Revenge Training Aids and Publications Other Program Revenues Loss on sale of Assets Contribution Revenue 15 Umpire Merchandises Total Revenues 6.402.187 1952.809 M 10 50.14 775 5472,512 2.072610 1,475 10 44 541, 107 MES SA 1.11.16 150612 . 22.15 25. 1.117.30 ( 211,510 1.54 17. 9. 1,406,00 11,187,205 10 La 1. 41.511 1.254.321 1126 17 7.1 Expenses Program Expenses Umre Merchandise COGS General Administrative Total Expenses 8.832.111 1,05278 1.200,22 LOL, 9,290.16 1024 1.07.09 11.4136 10.151 190 1113,51 9.7112 1. 1.114 11.12 105 15.00 Change in Assets ULAS c LU 5 prehere on LG FLATRON Wide Financials Case 1. bicel Insert File Page Layout Formulas View Home Review Help Tell me what you want to do Xcut General F NO Calibri BIU- Wrap lest Menge a Center & A $ .% Conditional Forma Ne Formatting Table Paste Format Painter Clipboard Font Alignment Number A3 December 31, 2014 - 2018 G H C B 2016 2017 2011 2014 2015 S 3,076,725 1,162,969 1.574,591 1,107,309 183,894 7,901 2.072,942 1,364,642 3,119 2.425 5,10,287 41,401 184,066 2,253,840 734.691 69,006 3,521 6 Assets 7 Current Assets Cash & Cash Equivlients 9 Accounts Receivable 10 Due from Affiliated Organizations 11 Inventory Other Current Receivable Prepaid Expenses & Other Current Asset 14 Total Current Assets Long-Term Investments 16 Property & Equipment Net 17 Other Assets Other Long term Receivable 9 Other Prepaid Expenses o Deposits Total Assets 283,186 3,157,074 150,518 103,716 654,061 4,097,189 140,024 139,098 407,136 4,650,151 19.455 371,672 310. 6,041,52 139,718 542,100 319,500 186,975 3,564,052 166,073 56,555 15,081 1,000,000 60.000 19,99 6,861,427 21,575 1,412.81 19,30 140,000 730,648 7.500,00 21,5 4,397,886 01 3,821,089 956,569 -1,397,794 32.112 208.560 510.263 13 106,478 1,291,613 142,380 59,807 2,302,127 136.938 298,314 99,341 39,868 23 Llabilities 14 Current Liabilities Accounts Payable Due to Affiluted Organisations Accrued abilities Other Current Liabilities Current Portion of Long-term Debt 30 Deferred Income Total Current Liabilities Non Current Liabilities Total abilities Net Assets 15 Total liabilities & Net Assets 2.132.622 3.771,208 2.292,083 2.9.10.200 2,522,837 4,016,637 7,093.23 8,189,071 761,750 2.752,658 6,251,597 2.412 20 8,66 306 (4,541,997) 3.821,809 1,771,200 (325) 3.432.1 2,930,209 1,457,677 4,197 4,016,637 2,844.790 6,861,427 8,189,071 1595,023) 7.594,048 USA Softball Balance Sheet USA Softbal income Statement uf Rugby Balance Sheet USA Rugby income Statement Anyw ... Type here to search LMO LG FLATRON de Financial Case 1. Excel Home Insert Page Layout Formule View Help Tell me what you want to do Xul C. Wrapost General $ Merge Center %. BIU.N.A. Conditional Formats Neutral Formatting Paste Format Point Clipboard Font Alignment 19 G H D 2014 2015 2016 2017 2018 44754 5,364,238 1,972,914 2,200,203 517,286 516,632 645,700 4,681,011 2.120,000 2,2 2.42,753 Revemos Rugby World Cup Membership Registrations Event Revenue High Performance Grants Sponsorship 2 Donations Rugby Development In kind contributions 5 TV roadcast Revenue 16 Licensing Fundraising Event Contributions Other income 19 Merchandise Sales 0 Investment income Loss) Total Revenues 11,3015 5,221,701 2.7711 2,712,034 1,911530 993,927 4,7,129 20 S 191,722 2,289,090 546,524 584 883 855,700 995.858 771159 050 5,037,401 2,141,981 1,953,229 1,866,601 599,022 617,140 528,934 475,411 253,157 129,701 65.200 35,936 (36,012 14,015,88 72,730 1919 441 204,341 24.963 239,57 84,263 73.003 223733 27405 387,770 100.4 40.500 451,00 10.115 3,367 27,365,385 16,257,166 14.50, 372 14,695,417 Expenses 14 Program Expenses Rugby World Cup Events Men's Senior National Team Rugby Development Membership Women's Senior National Team High Performance Total Program Expenses Media Marketing National Offices 15 Fundraising 10 Total penes 5,115,109 2,972,500 2. 164,021 1.406,203 L3730 2,561,584 3.900.154 1,951,250 1.625,190 1. 1941 591,423 12,19,00 1035,867 1,015.926 122.00 14,774,530 2,613,604 2,609 45 2.248412 1,757.95 1,742.44 745,850 12,718,150 12,087,008 3,402,157 4,030,827 1,752,014 1,10873 1.713,593 3.216.312 2,791,390 1923.964 1.809,261 1.194.225 347,614 11,203, 14.421115 559,562 1.030,052 167.588 16,180,317 1.172.181 360,518 18.068,303 1.49.650 275.929 18.455,671 26,088,828 3.373,626 10 316,821 31,612,359 Change in Assets 117009 (1,172,816 (4,429,813) 14.246,976) USA Softball Balance Sheet USA Sobal income Statement USA Rugby Balance Sheet USA Rugby Income Statement Type here to search c L M 0 *L LG FLATRON Wide Financials Case 1 - Excel Page Layout Formulas Data Review View Help Tell me what you want to do File Home Insert Xout Copy Parte Format Paint Calibri V11 Wrap Test 2 Number t
