Exercise Equipment Retailer: Financial Statement and Ratio Analysis

This report provides a financial analysis of Exercise Equipment Retailer, covering the period from July 1, 2014, to July 31, 2014. It includes a journal report detailing various financial transactions, followed by a ratio analysis to assess the company's solvency, liquidity, and profitability. The analysis reveals an ideal current ratio, a gross profit margin of 0.830, and an average inventory holding period of 34 days. The report also touches upon the need to accelerate operating activities. The financial statements, ledger balances, and GST considerations are integrated to provide a holistic view of the company's financial health during the specified period.

Excercise Equipment Retailer
103 Botany Street
Sydney, NSW, 2000
All Journals
01-07-2014 To 31-07-2014
23-11-2018
10:57:24
Page 1
ID# Acct# Account Name Debit Credit Job No.
IJ 01-07-2014 Inventory count
IJ000001 1-1300 Inventory Control $48,600.00
IJ000001 1-1300 Inventory Control $18,000.00
IJ000001 1-1300 Inventory Control $30,600.00
PJ 01-07-2014 Purchase; Fittersize
00000003 2-1200 Trade payable $41,000.00
00000003 2-1200 Trade payable $4,100.00
00000003 1-1300 Inventory Control $41,000.00
00000003 2-1330 GST Paid $4,100.00
PJ 05-07-2014 Purchase; Fittersize
00000004 2-1200 Trade payable $66,000.00
00000004 2-1200 Trade payable $6,600.00
00000004 1-1300 Inventory Control $66,000.00
00000004 2-1330 GST Paid $6,600.00
SJ 12-07-2014 Sale; Hotel Co.
00000003 1-1200 Trade Debtors $122,500.00
00000003 1-1200 Trade Debtors $12,250.00
00000003 4-1100 Sales $122,500.00
00000003 2-1310 GST Collected $12,250.00
00000003 5-1100 Purchase $70,203.49
00000003 1-1300 Inventory Control $70,203.49
SJ 12-07-2014 Sale; Cash Sales
00000004 1-1200 Trade Debtors $12,600.00
00000004 1-1200 Trade Debtors $1,260.00
00000004 4-1100 Sales $12,600.00
00000004 2-1310 GST Collected $1,260.00
00000004 5-1100 Purchase $7,500.00
00000004 1-1300 Inventory Control $7,500.00
CR 12-07-2014 Cash Sales for 00000004
CR000001 1-1110 Cheque Account $13,860.00
CR000001 1-1200 Trade Debtors $13,860.00
SJ 15-07-2014 Sale; Hotel Co.
00000005 1-1200 Trade Debtors $490.00
00000005 1-1200 Trade Debtors $49.00
00000005 4-1100 Sales $490.00
00000005 2-1310 GST Collected $49.00
00000005 5-1100 Purchase $280.81
00000005 1-1300 Inventory Control $280.81
SJ 15-07-2014 Hotel Co.: Credit from 00000005
SJ000001 1-1200 Trade Debtors $539.00
SJ000001 1-1200 Trade Debtors $539.00
SJ 16-07-2014 Sale; Cash Sales
00000006 1-1200 Trade Debtors $7,560.00
00000006 1-1200 Trade Debtors $756.00
00000006 4-1100 Sales $7,560.00
00000006 2-1310 GST Collected $756.00
00000006 5-1100 Purchase $4,500.00
00000006 1-1300 Inventory Control $4,500.00
CR 16-07-2014 Cash Sales for 00000006
CR000002 1-1110 Cheque Account $8,316.00
CR000002 1-1200 Trade Debtors $8,316.00

Excercise Equipment Retailer
All Journals
01-07-2014 To 31-07-2014
23-11-2018
10:57:24
Page 2
ID# Acct# Account Name Debit Credit Job No.
SJ 17-07-2014 Sale; Cash Sales
00000007 1-1200 Trade Debtors $71,064.00
00000007 1-1200 Trade Debtors $7,106.40
00000007 4-1100 Sales $71,064.00
00000007 2-1310 GST Collected $7,106.40
00000007 5-1100 Purchase $47,000.00
00000007 1-1300 Inventory Control $47,000.00
CR 17-07-2014 Cash Sales for 00000007
CR000003 1-1110 Cheque Account $88,565.40
CR000003 1-1200 Trade Debtors $88,565.40
CR 24-07-2014 Cash Sales for 00000008
CR000004 1-1110 Cheque Account $46,200.00
CR000004 2-1600 Customer Deposits $46,200.00
SJ 28-07-2014 Sale; Cash Sales
00000009 1-1200 Trade Debtors $46,550.00
00000009 1-1200 Trade Debtors $4,655.00
00000009 4-1100 Sales $46,550.00
00000009 2-1310 GST Collected $4,655.00
00000009 5-1100 Purchase $26,677.32
00000009 1-1300 Inventory Control $26,677.32
CR 28-07-2014 Cash Sales for 00000009
CR000005 1-1110 Cheque Account $53,900.00
CR000005 1-1200 Trade Debtors $53,900.00
CR 04-07-2014 Payment; Unfit To.
CR000006 1-1110 Cheque Account $9,800.00
CR000006 1-1200 Trade Debtors $9,800.00
CR 25-07-2014 Payment; Hotel Co.
CR000007 1-1110 Cheque Account $39,996.00
CR000007 1-1200 Trade Debtors $13,200.00
CR000007 1-1200 Trade Debtors $26,796.00
CR 20-07-2014 Bank Loan Received
CR000008 1-1110 Cheque Account $30,000.00
CR000008 2-2100 Bank Loans $30,000.00
CD 01-07-2014 Adams Co
1 1-1110 Cheque Account $20,000.00
1 2-1200 Trade payable $20,000.00
CD 15-07-2014 Fittersize
2 1-1110 Cheque Account $22,500.00
2 2-1200 Trade payable $22,500.00
CD 27-07-2014 Fittersize
3 1-1110 Cheque Account $50,000.00
3 2-1200 Trade payable $45,100.00
3 2-1200 Trade payable $4,900.00
CD 16-07-2014 Wages Paid
4 1-1110 Cheque Account $30,000.00
4 6-1930 Wages & Salaries $30,000.00
CD 17-07-2014 Rent Paid
5 1-1110 Cheque Account $7,700.00
5 6-2100 Rent $7,000.00
5 2-1330 GST Paid $700.00
CD 18-07-2014 Office Expenses Paid

Excercise Equipment Retailer
All Journals
01-07-2014 To 31-07-2014
23-11-2018
10:57:25
Page 3
ID# Acct# Account Name Debit Credit Job No.
CD 18-07-2014 Office Expenses Paid
6 1-1110 Cheque Account $2,200.00
6 6-2440 Office Expenses $2,000.00
6 2-1330 GST Paid $200.00
CD 19-07-2014 Telephone Expenses Paid
7 1-1110 Cheque Account $4,400.00
7 6-2200 Telephone $4,000.00
7 2-1330 GST Paid $400.00
GJ 31-07-2014 Depreciation on store equipment
GJ000001 6-1100 Depreciation Expense $2,000.00
GJ000001 1-3120 Store Equipment Accum Dep $2,000.00
Grand Total: $1,039,278.42 $1,039,278.42