Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help fo calculate the ratios for drowlinf mountain for the following ratios: debt:equity operating peofit/fixed assets revenue/assets and break even point thank you!
I need help fo calculate the ratios for drowlinf mountain for the following ratios:
EXHIBIT 4: DATA ON DROWLING MOUNTAIN'S COMPETITORS Visits Revenue Expenses Net Income Competitive Intelligence Company A Company B 11,205 67,000 $ 358,094 $1,573,468 $ (398,988) $ (1,389,488) $ (40,894) $ 183,980 Company C 9,400 $ 104,614 $ (83,143) $ 21,471 N/A 39% Net Working Capital Debt: Equity Labour/Revenue Profit Margin Operating Profit/Fixed Assets Revenue/Assets Return on Assets 12% 0.22 19% -11% -4% 32% -4% 0.10 30% 21% 14% 2% 32% 44% -9% Company files EXHIBIT 4: DATA ON DROWLING MOUNTAIN'S COMPETITORS in these parar murse MGMT 3180 at University of Competitive Intelligence Company A Company B 11,205 67,000 $ 358,094 $ 1,573,468 $ (398,988) $ (1,389,488) $ (40,894) $ 183,980 Visits Revenue Expenses Net Income Company C 9,400 $ 104,614 $ (83,143) $ 21,471 $ $ 934,315 0.22 Net Working Capital Debt: Equity Labour/Revenue Profit Margin Operating Profit/Fixed Assets Revenue/Assets Return on Assets $ 2,155,487 N/A 39% 12% 213,946 0.10 30% 21% 14% 44% -9% -11% -4% 32% -4% 2% 32% 4% Source: Company files, How do you calculate operating Profit | Fixed Assets? Revenuel Assets? Debt: Equity ? Page 7 9811M100 EXHIBIT 1: DROWLING MOUNTAIN INCOME STATEMENTS, 2009-2010 Income Statement 2010 2009 $ Revenue: SU Revenue Supporting Revenue Grant and Ad Revenue Miscellaneous Income 1,139,080 1.213,188 484,940 7,125 2,844,841 $ 1,119,633 1,109,525 355,078 11025 2,585,361 Total $ $ Direct Expenses: Food & Beverage Materials & Supplies Variable Salaries & Benefits Variable Utilities Programs & Events $ 234,178 145,090 432,067 38,468 45,434 895,837 1,949,105 249,049 150,322 425 449 33,479 11,004 870,303 1.725,058 sity of Lothbridge taught by Dave Adams from Jan 01, 2020 10 Apr 25, 2000 Total $ $ 803.525 222.666 266,544 153,871 791 977 108,713 37,165 133,916 125,441 111,669 47,981 Gross Earings Expenses: Fixed Salaries & Benefits Repairs & Maintenance Interest & Bank Charges Fixed Utilities Insurance Advertising Office & Administration Realty Taxes Entertainment Telephone? Travel Professional Fees? Vehicles ? Licensing Training Bad Debts 84,655 44,532 45,731 21,085 26,820 16,562 15,072 15,966 3,727 7,630 2006 1,828,441 120,662 46,181 25,073 19,339 4,009 14,164 3,114 2,389 Total $ 1,518,260 206,798 EBITDA Amortization Interest on LT Debt Earnings 395,243 85.177 359,758 475,201 79 210 347,613 Skier Visits 46,463 16,463 49,059 Source: Company files. Page 8 9B11M100 EXHIBIT 2: DROWLING MOUNTAIN BALANCE SHEETS, 2009-2010 2009 Balance Sheet as at year ending April 30 2010 Assets Current Assets: Cash Accounts Receivable 71,542 Inventory 24,382 Prepaid Expenses 91.703 S Total $ 187,627 $ 27,701 42,510 19,934 67,898 158,043 Capital Assets Less Amortization 3,551,019 (1.191,745) 2,359,274 $ $ $ 3,497,051 (796,502) 2,700,549 Lethbridge taught by Dave Adams from Jan 01, 2020 10 Apr 25, 2020 Total $ Total Assets 2,546,901 $ 2,858,592 hi violation Liabilities and Net Equity Current Liabilities: Bank indebtedness 97,833 609,840 84,265 $ $ $ Liabilities Deferred Revenue Advances from Director Current Portion of LT Debt Current Portion of capital Leases Total 2,140,000 86,106 3,041,114 $ $ 465,588 136,852 6,144 2.140,000 68,432 2,817,016 $ $ $ Obligations Under Capital Leases $ 7,164 $ 77.641 Net Equity: Invested Capital Unrestricted (Retained Earnings) Total $ $ 126,080 (627,456) (501,376) $ $ $ 414,552 (450,616) (36,064) Total Liabilities and Net Equity $ 2,546,902 $ 2,858,593 Source: Company files How Break do Ever you calculate Point ? EXHIBIT 4: DATA ON DROWLING MOUNTAIN'S COMPETITORS Visits Revenue Expenses Net Income Competitive Intelligence Company A Company B 11,205 67,000 $ 358,094 $1,573,468 $ (398,988) $ (1,389,488) $ (40,894) $ 183,980 Company C 9,400 $ 104,614 $ (83,143) $ 21,471 N/A 39% Net Working Capital Debt: Equity Labour/Revenue Profit Margin Operating Profit/Fixed Assets Revenue/Assets Return on Assets 12% 0.22 19% -11% -4% 32% -4% 0.10 30% 21% 14% 2% 32% 44% -9% Company files EXHIBIT 4: DATA ON DROWLING MOUNTAIN'S COMPETITORS in these parar murse MGMT 3180 at University of Competitive Intelligence Company A Company B 11,205 67,000 $ 358,094 $ 1,573,468 $ (398,988) $ (1,389,488) $ (40,894) $ 183,980 Visits Revenue Expenses Net Income Company C 9,400 $ 104,614 $ (83,143) $ 21,471 $ $ 934,315 0.22 Net Working Capital Debt: Equity Labour/Revenue Profit Margin Operating Profit/Fixed Assets Revenue/Assets Return on Assets $ 2,155,487 N/A 39% 12% 213,946 0.10 30% 21% 14% 44% -9% -11% -4% 32% -4% 2% 32% 4% Source: Company files, How do you calculate operating Profit | Fixed Assets? Revenuel Assets? Debt: Equity ? Page 7 9811M100 EXHIBIT 1: DROWLING MOUNTAIN INCOME STATEMENTS, 2009-2010 Income Statement 2010 2009 $ Revenue: SU Revenue Supporting Revenue Grant and Ad Revenue Miscellaneous Income 1,139,080 1.213,188 484,940 7,125 2,844,841 $ 1,119,633 1,109,525 355,078 11025 2,585,361 Total $ $ Direct Expenses: Food & Beverage Materials & Supplies Variable Salaries & Benefits Variable Utilities Programs & Events $ 234,178 145,090 432,067 38,468 45,434 895,837 1,949,105 249,049 150,322 425 449 33,479 11,004 870,303 1.725,058 sity of Lothbridge taught by Dave Adams from Jan 01, 2020 10 Apr 25, 2000 Total $ $ 803.525 222.666 266,544 153,871 791 977 108,713 37,165 133,916 125,441 111,669 47,981 Gross Earings Expenses: Fixed Salaries & Benefits Repairs & Maintenance Interest & Bank Charges Fixed Utilities Insurance Advertising Office & Administration Realty Taxes Entertainment Telephone? Travel Professional Fees? Vehicles ? Licensing Training Bad Debts 84,655 44,532 45,731 21,085 26,820 16,562 15,072 15,966 3,727 7,630 2006 1,828,441 120,662 46,181 25,073 19,339 4,009 14,164 3,114 2,389 Total $ 1,518,260 206,798 EBITDA Amortization Interest on LT Debt Earnings 395,243 85.177 359,758 475,201 79 210 347,613 Skier Visits 46,463 16,463 49,059 Source: Company files. Page 8 9B11M100 EXHIBIT 2: DROWLING MOUNTAIN BALANCE SHEETS, 2009-2010 2009 Balance Sheet as at year ending April 30 2010 Assets Current Assets: Cash Accounts Receivable 71,542 Inventory 24,382 Prepaid Expenses 91.703 S Total $ 187,627 $ 27,701 42,510 19,934 67,898 158,043 Capital Assets Less Amortization 3,551,019 (1.191,745) 2,359,274 $ $ $ 3,497,051 (796,502) 2,700,549 Lethbridge taught by Dave Adams from Jan 01, 2020 10 Apr 25, 2020 Total $ Total Assets 2,546,901 $ 2,858,592 hi violation Liabilities and Net Equity Current Liabilities: Bank indebtedness 97,833 609,840 84,265 $ $ $ Liabilities Deferred Revenue Advances from Director Current Portion of LT Debt Current Portion of capital Leases Total 2,140,000 86,106 3,041,114 $ $ 465,588 136,852 6,144 2.140,000 68,432 2,817,016 $ $ $ Obligations Under Capital Leases $ 7,164 $ 77.641 Net Equity: Invested Capital Unrestricted (Retained Earnings) Total $ $ 126,080 (627,456) (501,376) $ $ $ 414,552 (450,616) (36,064) Total Liabilities and Net Equity $ 2,546,902 $ 2,858,593 Source: Company files How Break do Ever you calculate Point debt:equity
operating peofit/fixed assets
revenue/assets
and break even point
thank you!
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