I need to calculate the following:
PLEASE SHOW WORK!!
Gross Margin Percentage-
Return on equity- Is not a publicly traded company, so return on equity is not needed
Net Operating Return-
Net Profit Margins-
8:50 PM 08/13/20 Cash Basis Sourdough Lodge Profit & Loss January through December 2001 Jan-Dec 01 Jan Dec 00 $ Change % Change 91,010,97 26.8% 43,816.90 43,816.90 71.798.27 26,790.92 26.790.92 19.212.70 17.025.98 17.025.98 63.6% 63.6% 25.2% 45,805.10 45,805.10 36.590 27 36,590 27 9.214.83 9,21483 25.2% 197,401.13 149,284.16 48,116.97 32.2% 32.2% 197,401.13 149,284.16 48,116.97 32.9% 378,034.10 378,034.10 284,463.52 284,463.62 93,570.48 93,570.48 32.9% 2,864.32 2,885.00 275.28 3,234.47 433.96 1,124 64 494.00 -150.76 1.807,73 1,086.55 39.3% -17.1% -54.8% 56.9% 250.4% Ordinary Income/Expense Income Gasoline Rental Motel Total Rental Restaurant Beverages in Restaur... Total Restaurant Sales Food Total Sales Total Income Gross Profit Expense Advertising Automobile Expense Bad Checks Bank Service Charges Contributions Cost of sales Beverage Food Gasoline Propane Total Cost of sales Depreciation Expense Dues and Subscriptions Insurance Life Insurance P. C. &L Work Comp Total Insurance Interest Expense Finance Charge Loan Interest Mortgage Interest Expense. Oth.. Total Interest Expense Licenses and Permits Miscellaneous Motel Restaurant Cleani... Music and entertainment Office Supplies Payroll Expenses Postage and Delivery Repairs Gasoline Repairs Motel Repairs Restaurant Repair Repairs. Other Total Repairs 3,988.96 2,391.00 124,52 5,042.20 1,520,51 14.222.04 96,192.31 84,001.74 4,07041 198,486.50 41,688.35 488.38 9,458.48 70,565.17 60,749 50 2,823.85 143,597.00 39,073.00 797 48 4.783.56 25.627.14 23.252 24 1.246 56 54,889.50 50.4% 36.3% 38.3% 44.1% 38.2% 2.615.35 -311.10 6.7% -39.0% 935.00 5,249.84 1.117.00 7,301.84 238.50 4,150.00 1.151.00 5,539.50 696.50 1.099.84 -34.00 292.0% 26.5% -3.0% 1,762,34 31.8% 122.89 548.39 18,019.83 108.74 0.00 1,025 26 16,956.90 0.00 17,982.16 122.89 476.87 1,062.93 108 74 100.0% 46.5% 6.3% 100.0% 4.6% 18,799.85 1,342.75 236.22 285.00 0.00 161.24 45,913.40 334,58 640,00 379 20 21.00 450.00 80.24 28.553.02 242.00 817.00 702.75 -14298 264.00 450.00 81.00 17,380 38 92.58 109.8% -37.7% 1.257.1% - 100.0% 101.0% 60.8% 38.3% 168.6% -47.3% -31.7% -100.0% -32.1% 1,418,35 1,325.58 5.882.70 0.00 8,626.58 528.10 2,513.39 8,60655 1,059.72 12,70776 890.25 -1.187.86 -2.723.85 -1.059.72 4,081.18 Page 1 8:50 PM 08/13/20 Cash Basis Sourdough Lodge Profit & Loss January through December 2001 Jan. Dec 01 Jan. Dec 00 5 Change % Change 520.36 1,536.87 0.00 0.00 1,077.42 135.80 1.213.02 520.36 459.45 -135.60 100.0% 42.6% -100.0% 69.6% 2,06723 844 21 250.00 0.00 2,935 44 0.00 575.03 139.27 2,703.34 27.03 3,444.67 2,876.51 325.03 -139 27 232.10 -27 03 -259 23 -212.54 -58.5% - 100.0% 8.6% -100.0% -7.5% 3,185.46 2,663.97 -74% 99.46 519.75 260.68 0.00 -16122 519.75 358.53 -61.9% 100.0% 619.21 137.5% 260.58 0.00 0.00 0.00 0.0% Supplies Motel Restaurant Supplies Other Total Supplies Taxes Alcohol Federal Property State Total Taxes Telephone Travel & Ent Meals Travel Total Travel & Ent Uncategorized Expenses Utilities Electric Garbage Satellite Water Expense Usinities - Other Total Utilities Total Expense Net Ordinary income Other Income Expense Other Income Interest income Other Income Liquor Payment Rental Income Other Income - Other Total Other Income Tips Total Other Income Net Other Income Net Income 1.471.10 507.75 197.19 200 579.00 29.2% 420.5% 13.6% 5,032.73 120.75 1.448.17 54.00 897.75 7,553.40 6,503.83 628.50 1,545.36 58.00 318.75 9.152.44 354,408.17 23,625.93 3.7% 64.5% 21.2% 1,599.04 275,103.67 28.8% 79,304 50 14.265.98 9.359.95 152.4% 2,304.34 371.01 -37.8% 1,433.33 3,051.00 3,732.00 4.502.36 11,285.36 2,216.00 14,934.69 14,934,69 38,560.62 2.835.00 9,999.50 1.455 65 14,290.15 216.00 -6.267.50 3.046.71 3,004.79 7,6% -62.7% 209.3% 21.0% 2,957.00 -741.00 -25.1% 4,616.30 19,551.49 19,551 49 -23.6% -23.6% 4,616.80 9,649.18 28,911.44 33.4%
