Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1.pdf FNew 21.pdf 1.pdf X PDF PRE OSearch or enter web address A) Read aloud Add notes Fit to page Page view of 1 EContents
1.pdf FNew 21.pdf 1.pdf X PDF PRE OSearch or enter web address A) Read aloud Add notes Fit to page Page view of 1 EContents Revenue Total Club Sales $161,008.14 $193,105.42 $248,106.33 $309.180.57 S284,835.75 $258,988.22 $229,233.48 $184,928.18 $151,291.97 $156,105.07 Total Off Premise Catering $141,854.02 $175,810.38 $208,800.94 $288,271.28 $248,142.30 $381,937.01 $474,080.17 $395,901.39 $416,818.83 S427,929.18 $234,888.98 Total on Campus Catering Sales $285,098.77 $248,373.49 $320,060.96 S236,570.55 $212,121.32 $210,987.31 $223,879.09 $180,290.02 $222,414.83 $38,325.30 $85,882.76 $104,890.59 Total Catering Sales in Club $34,197.53 $26.148.17 $78,798.41 $91,249.42 $79,423.05 $88,307.50 $103.458.89 Other Revenue Members Dues Sales $57,492.03 $58,232.10 $80,311.22 $37,083.81 $38,109.98 $40,582.43 $39,014.57 S35,019.66 $33,433.71 $33,904.21 Subsidy for Dues Shortfall $10,581.27 S11,370.00 $11,370.00 S- $8,531.98 $11,370.00 se,865.51 $11,370.00 $335.21 $332.09 Liquor Tax Commission $303.06 $228.04 $289.49 $359.88 $393.17 $393.96 $305.97 $340.33 S384.10 $34.11 $ $572.38 $ Other Income $2,803.50 $- Total Other Revenue s80,598.59 $58,480.14 $80,984.81 $45,984.91 $49,839.88 $51,538.88 $49,846.42 $40,695.62 $45,135.81 $45,814.54 Total Revenue $768,875.84 $714,852.32 s925.133.46 S910.440.90 $858,341.13 $933,117.74 $1.021,039.36 $859,870.77 $962.722.35 $955,520.31 $199,751.87 Total Cost of Goods Sold $208,920.11 $230,001.85 S230,585.91 $184,985.83 $214,445.82 $208,807.90 $183,851.73 $216,958.53 $215,505.47 $876,019.04 Gross Income $515,100.65 $581,955.53 s889.131.81 s879.854.99 $873,355.30 $718,871.92 $812,231.46 $745,785.82 $740,014.85 xpenses Total Selling and General Expenses $101,814.14 $104,157.57 $129,375.92 S119.481.77 $127,393.88 $140,960.08 $145,315.42 S90,040.42 $130,133.12 S130,585.89 Total Administration Charges Bonus $406,870.89 $482,463.86 $510,881.09 S585,508.86 $561,647.18 $587,312.31 s624,581.30 824,388.84 $655,985.44 $652,593.08 Total Operating Expenses $783.158.97 $508,284.83 $568,621.23 s840,257.01 S685,060.64 $889,040.83 $728,272.39 $789,878.72 $714,409.25 $788,118.56 $6,815.81 -$4,665.70 $48,874.59 -$5,205.64 -$15,685.53 -$9,600.46 $42,354.74 -$38,390.21 -$40,352.74 -$43,144.12 Net Income 1:11 PM Photos Type here to search New... WDocu... *Untit... New... Down... Docu... Docu... 11/5/2019 1.pdf 1.pdf X PDF PDE OSearch or enter web address A) Read aloud Fit to page Page view Add notes of 1 Contents Current Assets 2007 2008 $31,088.99 $85.93 S78,020.13 2009 2010 2011 2012 2013 2014 2015 2016 Cash S8,852.00 $20,191.39 $88.280.23 $19,883.77 $22,587.28 $88,890.04 $1,413.71 S100,904.43 $25,070.41 G.S.T. Paid S16.88 $58,204.26 $19,775.74 $15,141.45 S88.34 $45.50 $123,343.67 $24,578.30 $17.07 $110,080.57 $24,043.24 -$4.00 $107,439.61 $27,487.93 $14,852.12 $218,485.69 $52.02 S03,001.78 $22,186.18 $51,182.24 $185,835.00 -$52.10 $65,713.22 S22,188.27 $51,182.24 S12.78 $38,968.40 Accounts Receiveable Inventory Others Total Current Assets (including Cash on hand) $96,868.09 $16,700.69 $19,313.54 $22,885.45 $17,807.14 $19,946.88 S4,003.93 S124,424.80 $12,200.62 $14,852.12 $143,307.68 $14,852.12 $182,511.55 $14,852.12 $172.480.25 $51,859.08 S135,857.32 S139,189.81 S111,329.53 S239,938.08 Fixed Assets Total Fumiture Assets S88,104.85 -s06,104.85 S87,288.85 -S67,268.85 $74,805.99 -$71,848.23 $81.385.87 -$77,274.11 $88.135.89 -$82,282.48 $88.135.89 -$84.423.18 $87,342.28 -$88,503.30 S84,727.16 -$84,727.18 $84,727.18 -$84,727.18 $84.727.18 -$84,727.18 Accumulated Depreciation Furniture Assets Total Kitchen Assets (net of Depreciation) $3,078.05 $3,573.01 S8,088.84 S8,361.98 $2,891.27 $5,787.02 $3,541.85 $12,044.14 S13,270.45 $5,802.99 Total OtherEquipment (net of Depreciation) $1,372.75 SO0.05 $552.57 $22,800.35 $24,234.35 $17,330.73 $11,916.48 S4,214.69 $2,392.38 $545.20 S36,018.11 Total Leasehold Improvements (net of Depreciatio $17,779.85 $10,238.13 $17,952.58 $10,405.80 83,145.32 $54,708.01 $46,843.08 $41,155.70 $29,322.46 $7,081.54 S- $47,330.72 $3,409.1 S- S- $98,308.00 Uclub Van (net of Depreciation) $016.95 S S8,787.23 -$202.95 S14,123.45 $10,592.47 S1,033.62 S Inactive Total Fixed Assets S52,597.89 $33,803.70 S31,757.23 $35,135.44 $79,517.38 $82,940.08 $57,414.53 $35,870.85 Total Other Assets $11,007.17 -$541.69 -$1,976.81 -$8,085.78 -$704.58 $8,458.55 $5,541.02 $4,332.53 S10,990.09 $11,359.98 $182.662.83 $169,235.87 S170,405.35 Total Assets $144,488.15 $280,112.97 $258,454.18 $288,948.77 $247,582.96 S303,524.95 $182,887.95 Liabilities Total Current Liabilities $298,053.88 $140,142.03 $168,070.29 S310,082.75 $16,775.24 $58,708.94 $171,880.62 $159,62229 $148,168.43 $244,463.18 $148,188.43 S310,082.75 $16,775.24 $159,822.29 Total Liabilities $296,053.86 $58,708.94 $171.880.62 $149,142.03 $244,463.16 $168,970.29 EQUITY $137,804.74 Total Equity -$130,877.40 -$126,818.18 $127,712.91 $123,955.69 $108,432.35 $08,831.88 e0,414.53 S50,081.78 $15,917.66 Total Liabilities and Equity $258.454.18 $286,946,77 $169,235.87 S170,405.35 $144,488.15 $182,882.83 $280,112.97 $247,582.98 S303,524.95 $182,887.95 1:08 PM e 1.pdf... Type here to search pdf . W Doc... Phot... Dow... W Docu... Unti... Docu... 11/5/2019 O Evalute the financial Pecfermance o a bu siness using finaness Statements I Risks and Oppertunities fed by the Non-Profit orgntzation 2, Cal culate and Interpat financial ratios as an ana ly hical tool For deaision making Liquidity Rtios (urrent & quiek) Activity Ratios (Tohal Ass et Tumover, Recievabes Tunover eyc Aversga eled Invea tory Turnoer Days in Inventery Fhncial Levenye Ratios (Deb+ Rahio, De bt to uty Ratvo In teest fatio Gross Pafit Macgin, Net Rae Mgin Ratfos Preanbildy Provide Finarcial ratcos in an Exce format refeencing itens from the firancn Stahement. Compre the Com pany ratios t the indusy usa atios to Show the Company Compeuco its own previus perfermance Hime Sarves analysis, Include between the gross Profit agin and Net profit Magn cross-Sectional analy srs bench mark, Also Peffermmce Of the non profit in analy sis drs crepency what 3. Using bo th Quantitative and Quatative Info Select the bes + Optin Should the non-prfi+ board do. and dis cusr all three op tHon s 1-Increase membersh ip faa, If the bonrd chosa to optian a fae figue that was SuRcient to covr club's lossS 2-Inerense the number of members, Make it mandatory for all 3 Close the Club, this Purs ue COreFul analys is would be required to come up vith faculty membars Average Ratias two Other Non-efts Curent Ratic &uick RaHO Total As set Turnaver Rectevl le Turnovar Average Co lle cHon ferlocl Javentory Pays in nventery Debt Ratio Debt to uity Rahio oress PoAt Main Net Proftt Marg in 1.17 O.97 1.S8 &.07 45.48 13,10 27,86 a 3/ 0.44 0,67 -0.02 Turnover 1.pdf FNew 21.pdf 1.pdf X PDF PRE OSearch or enter web address A) Read aloud Add notes Fit to page Page view of 1 EContents Revenue Total Club Sales $161,008.14 $193,105.42 $248,106.33 $309.180.57 S284,835.75 $258,988.22 $229,233.48 $184,928.18 $151,291.97 $156,105.07 Total Off Premise Catering $141,854.02 $175,810.38 $208,800.94 $288,271.28 $248,142.30 $381,937.01 $474,080.17 $395,901.39 $416,818.83 S427,929.18 $234,888.98 Total on Campus Catering Sales $285,098.77 $248,373.49 $320,060.96 S236,570.55 $212,121.32 $210,987.31 $223,879.09 $180,290.02 $222,414.83 $38,325.30 $85,882.76 $104,890.59 Total Catering Sales in Club $34,197.53 $26.148.17 $78,798.41 $91,249.42 $79,423.05 $88,307.50 $103.458.89 Other Revenue Members Dues Sales $57,492.03 $58,232.10 $80,311.22 $37,083.81 $38,109.98 $40,582.43 $39,014.57 S35,019.66 $33,433.71 $33,904.21 Subsidy for Dues Shortfall $10,581.27 S11,370.00 $11,370.00 S- $8,531.98 $11,370.00 se,865.51 $11,370.00 $335.21 $332.09 Liquor Tax Commission $303.06 $228.04 $289.49 $359.88 $393.17 $393.96 $305.97 $340.33 S384.10 $34.11 $ $572.38 $ Other Income $2,803.50 $- Total Other Revenue s80,598.59 $58,480.14 $80,984.81 $45,984.91 $49,839.88 $51,538.88 $49,846.42 $40,695.62 $45,135.81 $45,814.54 Total Revenue $768,875.84 $714,852.32 s925.133.46 S910.440.90 $858,341.13 $933,117.74 $1.021,039.36 $859,870.77 $962.722.35 $955,520.31 $199,751.87 Total Cost of Goods Sold $208,920.11 $230,001.85 S230,585.91 $184,985.83 $214,445.82 $208,807.90 $183,851.73 $216,958.53 $215,505.47 $876,019.04 Gross Income $515,100.65 $581,955.53 s889.131.81 s879.854.99 $873,355.30 $718,871.92 $812,231.46 $745,785.82 $740,014.85 xpenses Total Selling and General Expenses $101,814.14 $104,157.57 $129,375.92 S119.481.77 $127,393.88 $140,960.08 $145,315.42 S90,040.42 $130,133.12 S130,585.89 Total Administration Charges Bonus $406,870.89 $482,463.86 $510,881.09 S585,508.86 $561,647.18 $587,312.31 s624,581.30 824,388.84 $655,985.44 $652,593.08 Total Operating Expenses $783.158.97 $508,284.83 $568,621.23 s840,257.01 S685,060.64 $889,040.83 $728,272.39 $789,878.72 $714,409.25 $788,118.56 $6,815.81 -$4,665.70 $48,874.59 -$5,205.64 -$15,685.53 -$9,600.46 $42,354.74 -$38,390.21 -$40,352.74 -$43,144.12 Net Income 1:11 PM Photos Type here to search New... WDocu... *Untit... New... Down... Docu... Docu... 11/5/2019 1.pdf 1.pdf X PDF PDE OSearch or enter web address A) Read aloud Fit to page Page view Add notes of 1 Contents Current Assets 2007 2008 $31,088.99 $85.93 S78,020.13 2009 2010 2011 2012 2013 2014 2015 2016 Cash S8,852.00 $20,191.39 $88.280.23 $19,883.77 $22,587.28 $88,890.04 $1,413.71 S100,904.43 $25,070.41 G.S.T. Paid S16.88 $58,204.26 $19,775.74 $15,141.45 S88.34 $45.50 $123,343.67 $24,578.30 $17.07 $110,080.57 $24,043.24 -$4.00 $107,439.61 $27,487.93 $14,852.12 $218,485.69 $52.02 S03,001.78 $22,186.18 $51,182.24 $185,835.00 -$52.10 $65,713.22 S22,188.27 $51,182.24 S12.78 $38,968.40 Accounts Receiveable Inventory Others Total Current Assets (including Cash on hand) $96,868.09 $16,700.69 $19,313.54 $22,885.45 $17,807.14 $19,946.88 S4,003.93 S124,424.80 $12,200.62 $14,852.12 $143,307.68 $14,852.12 $182,511.55 $14,852.12 $172.480.25 $51,859.08 S135,857.32 S139,189.81 S111,329.53 S239,938.08 Fixed Assets Total Fumiture Assets S88,104.85 -s06,104.85 S87,288.85 -S67,268.85 $74,805.99 -$71,848.23 $81.385.87 -$77,274.11 $88.135.89 -$82,282.48 $88.135.89 -$84.423.18 $87,342.28 -$88,503.30 S84,727.16 -$84,727.18 $84,727.18 -$84,727.18 $84.727.18 -$84,727.18 Accumulated Depreciation Furniture Assets Total Kitchen Assets (net of Depreciation) $3,078.05 $3,573.01 S8,088.84 S8,361.98 $2,891.27 $5,787.02 $3,541.85 $12,044.14 S13,270.45 $5,802.99 Total OtherEquipment (net of Depreciation) $1,372.75 SO0.05 $552.57 $22,800.35 $24,234.35 $17,330.73 $11,916.48 S4,214.69 $2,392.38 $545.20 S36,018.11 Total Leasehold Improvements (net of Depreciatio $17,779.85 $10,238.13 $17,952.58 $10,405.80 83,145.32 $54,708.01 $46,843.08 $41,155.70 $29,322.46 $7,081.54 S- $47,330.72 $3,409.1 S- S- $98,308.00 Uclub Van (net of Depreciation) $016.95 S S8,787.23 -$202.95 S14,123.45 $10,592.47 S1,033.62 S Inactive Total Fixed Assets S52,597.89 $33,803.70 S31,757.23 $35,135.44 $79,517.38 $82,940.08 $57,414.53 $35,870.85 Total Other Assets $11,007.17 -$541.69 -$1,976.81 -$8,085.78 -$704.58 $8,458.55 $5,541.02 $4,332.53 S10,990.09 $11,359.98 $182.662.83 $169,235.87 S170,405.35 Total Assets $144,488.15 $280,112.97 $258,454.18 $288,948.77 $247,582.96 S303,524.95 $182,887.95 Liabilities Total Current Liabilities $298,053.88 $140,142.03 $168,070.29 S310,082.75 $16,775.24 $58,708.94 $171,880.62 $159,62229 $148,168.43 $244,463.18 $148,188.43 S310,082.75 $16,775.24 $159,822.29 Total Liabilities $296,053.86 $58,708.94 $171.880.62 $149,142.03 $244,463.16 $168,970.29 EQUITY $137,804.74 Total Equity -$130,877.40 -$126,818.18 $127,712.91 $123,955.69 $108,432.35 $08,831.88 e0,414.53 S50,081.78 $15,917.66 Total Liabilities and Equity $258.454.18 $286,946,77 $169,235.87 S170,405.35 $144,488.15 $182,882.83 $280,112.97 $247,582.98 S303,524.95 $182,887.95 1:08 PM e 1.pdf... Type here to search pdf . W Doc... Phot... Dow... W Docu... Unti... Docu... 11/5/2019 O Evalute the financial Pecfermance o a bu siness using finaness Statements I Risks and Oppertunities fed by the Non-Profit orgntzation 2, Cal culate and Interpat financial ratios as an ana ly hical tool For deaision making Liquidity Rtios (urrent & quiek) Activity Ratios (Tohal Ass et Tumover, Recievabes Tunover eyc Aversga eled Invea tory Turnoer Days in Inventery Fhncial Levenye Ratios (Deb+ Rahio, De bt to uty Ratvo In teest fatio Gross Pafit Macgin, Net Rae Mgin Ratfos Preanbildy Provide Finarcial ratcos in an Exce format refeencing itens from the firancn Stahement. Compre the Com pany ratios t the indusy usa atios to Show the Company Compeuco its own previus perfermance Hime Sarves analysis, Include between the gross Profit agin and Net profit Magn cross-Sectional analy srs bench mark, Also Peffermmce Of the non profit in analy sis drs crepency what 3. Using bo th Quantitative and Quatative Info Select the bes + Optin Should the non-prfi+ board do. and dis cusr all three op tHon s 1-Increase membersh ip faa, If the bonrd chosa to optian a fae figue that was SuRcient to covr club's lossS 2-Inerense the number of members, Make it mandatory for all 3 Close the Club, this Purs ue COreFul analys is would be required to come up vith faculty membars Average Ratias two Other Non-efts Curent Ratic &uick RaHO Total As set Turnaver Rectevl le Turnovar Average Co lle cHon ferlocl Javentory Pays in nventery Debt Ratio Debt to uity Rahio oress PoAt Main Net Proftt Marg in 1.17 O.97 1.S8 &.07 45.48 13,10 27,86 a 3/ 0.44 0,67 -0.02 Turnover
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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