You've been provided with the following information about a businessComplete a horizontal analysis for the "Cost of sales" account. Round the percentage change to one decimal place (1 mark).Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". If your answer is negative - remember to include the minus.Profit and loss statement Current year Prior yearRevenue 14,800 18,500Less Cost of sales 6,000 7,500Gross profit 8,800 11,000Less expenses Wages Expense 5,500 6,500Interest Expense 2,200 2,000Depreciation Expense 1,000 1,200Advertising Expense 900 800Net profit -800 500
Question
You've been provided with the following information about a businessComplete a horizontal analysis for the "Cost of sales" account. Round the percentage change to one decimal place (1 mark).Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". If your answer is negative - remember to include the minus.Profit and loss statement Current year Prior yearRevenue 14,800 18,500Less Cost of sales 6,000 7,500Gross profit 8,800 11,000Less expenses Wages Expense 5,500 6,500Interest Expense 2,200 2,000Depreciation Expense 1,000 1,200Advertising Expense 900 800Net profit -800 500
Solution
To perform a horizontal analysis for the "Cost of Sales" account, you need to calculate the percentage change from the prior year to the current year.
Here are the steps:
-
Subtract the current year's "Cost of Sales" from the prior year's "Cost of Sales". In this case, it would be 6000 - 7500 = -1500.
-
Divide the difference by the "Cost of Sales" of the prior year. So, -1500 / 7500 = -0.2.
-
Multiply the result by 100 to get the percentage change. So, -0.2 * 100 = -20.0.
So, the horizontal analysis for the "Cost of Sales" account shows a decrease of 20.0%. However, since the question asks to not include the "%" symbol and to round to one decimal place, the answer would be -20.0.
Similar Questions
You've been provided with the following information about a businessComplete a horizontal analysis for the "Revenue" account. Round the percentage change to one decimal place (1 mark).Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". Profit and loss statement Current year Prior yearRevenue 15000 10000Less Cost of sales 6500 3000Gross profit 8500 7000Less expenses Marketing Expense 2000 1800Rent Expense 1500 1500Wages Expense 800 1000Utilities Expense 1500 1500Net profit 2700 1200
Using the financial statements below, calculate the profit margin as a percentage for the current year. Please calculate to 1 decimal place. Do not use the % symbol. For example, if it is 3.2%, enter 3.2 into the box. If your answer is a negative, please include the minus symbol before the number (no space in between)Profit and loss statement Current year Prior yearRevenue 14,800 18,500Less Cost of sales 6,000 7,500Gross profit 8,800 11,000Less expenses Wages Expense 5,500 6,500Interest Expense 2,200 2,000Depreciation Expense 1,000 1,200Advertising Expense 900 800Net profit (800) 500BALANCE SHEET Current year Prior yearCurrent assets Cash 14,250 16,700Accounts Receivable 14,000 3,500Inventory 6,000 2,500Prepaid Expenses 650 1,500Non-current assetsProperty Plant Equipment 192,500 193,500Land 210,000 210,000Total assets 437,400 427,700Current liabilitiesAccounts Payable 11,700 4,200Unearned Revenue 3,500 2,000Wages Payable 3,500 2,500Non-current liabilitiesBank Loan 118,000 122,500Total liabilities 136,700 131,200NET ASSETS 300,700 296,500Equity Share Capital 255,000 250,000Retained Earnings 45,700 46,500TOTAL EQUITY 300,700 296,500
Using the financial statements below, calculate the Return on equity for the current year. Please calculate to 2 decimal places. Do not use the % symbol. For example, if it is 3.2%, enter 3.2 into the box. If the number is negative, remember to add a minus symbol before the number Profit and loss statement Current year Prior year Revenue 14,800 18,500 Less Cost of sales 6,000 7,500 Gross profit 8,800 11,000 Less expenses Wages Expense 5,500 6,500 Interest Expense 2,200 2,000 Depreciation Expense 1,000 1,200 Advertising Expense 900 800 Net profit (800) 500 BALANCE SHEET Current year Prior year Current assets Cash 14,250 16,700 Accounts Receivable 14,000 3,500 Inventory 6,000 2,500 Prepaid Expenses 650 1,500 Non-current assets Property Plant Equipment 192,500 193,500 Land 210,000 210,000 Total assets 437,400 427,700 Current liabilities Accounts Payable 11,700 4,200 Unearned Revenue 3,500 2,000 Wages Payable 3,500 2,500 Non-current liabilities Bank Loan 118,000 122,500 Total liabilities 136,700 131,200 NET ASSETS 300,700 296,500 Equity Share Capital 255,000 250,000 Retained Earnings 45,700 46,500 TOTAL EQUITY 300,700 296,500
Using the financial statements below, calculate the current ratio for the current year. Please calculate to 2 decimal places.Profit and loss statement Current year Prior yearRevenue 14,800 18,500Less Cost of sales 6,000 7,500Gross profit 8,800 11,000Less expenses Wages Expense 5,500 6,500Interest Expense 2,200 2,000Depreciation Expense 1,000 1,200Advertising Expense 900 800Net profit (800) 500BALANCE SHEET Current year Prior yearCurrent assets Cash 14,250 16,700Accounts Receivable 14,000 3,500Inventory 6,000 2,500Prepaid Expenses 650 1,500Non-current assetsProperty Plant Equipment 192,500 193,500Land 210,000 210,000Total assets 437,400 427,700Current liabilitiesAccounts Payable 11,700 4,200Unearned Revenue 3,500 2,000Wages Payable 3,500 2,500Non-current liabilitiesBank Loan 118,000 122,500Total liabilities 136,700 131,200NET ASSETS 300,700 296,500Equity Share Capital 255,000 250,000Retained Earnings 45,700 46,500TOTAL EQUITY 300,700 296,500
You've been provided with the following information about a businessComplete a horizontal analysis for the "Cash" account. Round the percentage change to one decimal place (1 mark).Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". If your answer is negative - remember to include the minus.Balance SheetBalance sheet Current year Prior yearCurrent assets Cash 14,250 16,700Accounts Receivable 14,000 3,500Inventory 6,000 2,500Prepaid Expenses 650 1,500Non-current assetsProperty Plant Equipment 192,500 193,500Land 210,000 210,000Total assets 437,400 427,700Current liabilitiesAccounts Payable 11,700 4,200Unearned Revenue 3,500 2,000Wages Payable 3,500 2,500Non-current liabilitiesBank Loan 118,000 122,500Total liabilities 136,700 131,200NET ASSETS 300,700 296,500Equity Share Capital 255,000 250,000Retained Earnings 45,700 46,500TOTAL EQUITY 300,700 296,500
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.