Knowee
Questions
Features
Study Tools

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

Question

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

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

To perform a horizontal analysis for the "Cash" account, you need to calculate the percentage change in the cash balance from the prior year to the current year.

Here's how to do it:

  1. First, find the difference in the cash balance between the current year and the prior year.

    Difference = Current year cash - Prior year cash Difference = 14,25014,250 - 16,700 = -$2,450

  2. Next, divide the difference by the cash balance of the prior year to find the percentage change.

    Percentage change = (Difference / Prior year cash) * 100 Percentage change = (-2,450/2,450 / 16,700) * 100 = -14.7

So, the percentage change in the cash account is -14.7.

This problem has been solved

Similar Questions

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

You've been provided with the following information about a business Complete a VERTICAL analysis for the "Share capital" 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 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

Provided below is a partial balance sheet for Lilac Corporation.   Year 2 Year 1Cash $  500,000 $  540,000Accounts receivable 400,000 460,000Inventory 300,000 350,000Long-term assets 900,000 880,000Total assets $2,100,000 $2,230,000Using horizontal analysis, what percentage is applicable to Accounts Receivable?Multiple Choice13.0%(13.0%)15.0%20.6%

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

Calculate the current ratio assuming that cash = $6,000, land = $105,000, accounts receivable = $19,000, merchandise inventory = $20,000, accounts payable = $15,000, long-term debt = $80,000, and retained earnings = $55,000. (Round your answer to one decimal place, if necessary.)Multiple choice question.0.51.72.03.0

1/3

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.