80.2K

Verified Solution

Link Copied!

The following financial statements are taken from the records of Jade Inc.

a$)$ Use horizontal analysis techniques to compare the changes between $2022$ and $2021$ balance sheet items.

Do not enter dollar signs or commas in the input boxes.

Use the negative sign for negative values.

Round all answers to $2$ decimal places.

Jade Inc.

Balance Sheet

As at September $30$

$20222021\%$ Change

Current Assets

Cash $$314,000$ $$327,900$ Answer

$-4\mathrm{.}24$

$\%$

Accounts Receivable $$125,800$ $$167,200$ Answer

$-24\mathrm{.}76$

$\%$

Inventory $$426,200$ $$393,500$ Answer

$8\mathrm{.}31$

$\%$

Short$-$Term Investments $$88,700$ $$111,400$ Answer

$-20\mathrm{.}35$

$\%$

Total Current Assets $$954,700$ $$1,000,000$ Answer

$-4\mathrm{.}53$

$\%$

Other Assets $$149,500$ $$264,500$ Answer

$-43\mathrm{.}47$

$\%$

Total Assets $$1,104,200$ $$1,264,500$ Answer

$-12\mathrm{.}67$

$\%$

Current Liabilities $$265,700$ $$226,400$ Answer

$17\mathrm{.}36$

$\%$

Long$-$Term Debt $$128,200$ $$92,300$ Answer

$-38\mathrm{.}88$

$\%$

Total Liabilities $$393,900$ $$318,700$ Answer

$-23\mathrm{.}61$

$\%$

Shareholders$$ Equity $$710,300$ $$945,800$ Answer

$-24\mathrm{.}91$

$\%$

Total Liabilities and Equity $$1,104,200$ $$1,264,500$ Answer

$-12\mathrm{.}67$

$\%$

b$)$ Perform a vertical analysis of the income statement for $2022,$ stating all income statement items as a percentage of net sales.

Jade Inc.

Income Statement

For the Year Ended September $30$

$2022$

Sales $$702,000$ Answer

$100$

$\%$

Cost of Goods Sold $$245,700$ Answer

$35$

$\%$

Gross Profit $$456,300$ Answer

$65$

$\%$

Operating Expenses

Advertising Expense $$4,700$ Answer

$0\mathrm{.}67$

$\%$

Bank Charges Expense $$5,900$ Answer

$0\mathrm{.}84$

$\%$

Communication Expense $$6,800$ Answer

$0\mathrm{.}97$

$\%$

Depreciation Expense $$5,600$ Answer

$0\mathrm{.}80$

$\%$

Professional Fees Expense $$7,800$ Answer

$1\mathrm{.}11$

$\%$

Rent Expense $$6,200$ Answer

$0\mathrm{.}88$

$\%$

Repairs and Maintenance Expense $$7,100$ Answer

$1\mathrm{.}01$

$\%$

Salaries and Wages Expense $$79,000$ Answer

$11\mathrm{.}25$

$\%$

Transportation Expense $$6,900$ Answer

$0\mathrm{.}98$

$\%$

Utilities Expense $$4,700$ Answer

$0\mathrm{.}67$

$\%$

Total Operating Expenses $$134,700$ Answer

$19\mathrm{.}18$

$\%$

Net Income $$321,600$ Answer

$45\mathrm{.}81$

$\%$

Answer & Explanation Solved by verified expert

See Answer