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
Question
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
Solution
To perform a horizontal analysis for the "Revenue" account, you need to calculate the percentage change in revenue from the prior year to the current year. Here's how you do it:
Step 1: Identify the figures for the account in question for the current year and the prior year. In this case, the revenue for the current year is 10,000.
Step 2: Subtract the prior year's figure from the current year's figure. This gives you the change in revenue. In this case, 10,000 = $5,000.
Step 3: Divide the change in revenue by the prior year's revenue. This gives you the proportion of the change. In this case, 10,000 = 0.5.
Step 4: Multiply the proportion by 100 to get the percentage change. In this case, 0.5 * 100 = 50.0.
So, the percentage change in the "Revenue" account is 50.0.
Similar Questions
You've been provided with the following information about a business Complete 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 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
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
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
You've been provided with the following information about a businessComplete a VERTICAL analysis for the "Wages Payable" account for the current year. Round the percentage to one decimal place.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 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.