Mazie May is a business which buys cattle and sells to both the domestic and international market. Run by Mazie Arnold the business has been operating for five years on a farm located in south-west Queensland, Australia where operations are conducted. Motor Vehicles comprise two trucks, two motor cars and two motor bikes.
The business has also set up a Producers Group for educational purposes. Members pay an annual fee of $600 including GST with fees payable on 1 May for the following year ($12,000 net of GST was received on 1 st May, 2009 and net $18,000 has been received on 1st May 2010). The business leases a tractor with the lease payments of $4,950 including GST made quarterly in advance. Owner’s Equity
at 30 June 2009 was $395,490. All sales are on credit. Mazie May is registered for GST reporting monthly on an Accrual [non-cash] Basis.
MAZIE MAY FEEDLOT INSTRUCTIONS:
Transactions for July 2009 through to 31st May 2010 have already been entered into the books. The Trial Balances that follow show figures for the Adjusted Trial Balance for the year ended 30th June, 2009 and for the entries for this financial year to 31 st May, 2010.
TRIAL BALANCE OF MAZIE MAY
as at 31st May,
As at 30th June, 2009
Cash at Bank
nts at Cost
Less Accum Dep
Motor Vehicle at
Less Accum Dep
Sales – Cattle
Depreciation Motor Vehicles
MV Expenses Repairs
MV Expenses –
MV Expenses Ins & CTP
MV Expenses –
Lease – Tractor
Schedule of Accounts Receivable and Payable as at 31 st May 2010
Schedule of Accounts Receivable
Schedule of Accounts Payable
State Produce Ltd
Required – Section 2 Project Report
You are required to download the Excel template file and record all of the journal entries, ledger postings, worksheet and other requirements of section 2 in this Excel file.
1. Record the June Journal transactions, post to the Ledgers and prepare the Unadjusted Trial Balance
a) Enter the following transactions for the month of June 2010 to complete the financial year. June 1) Mazie May wrote out a cheque to pay AGC for the lease of the tractor for June, July and August $4,950 including GST. Cheque No 1001
2) Received and banked a cheque from Campbell’s Livestock for $50,000 being part payment of account.
5) Mazie May sold the following cattle on credit to Australian Beef Buyers: 80 @ $836 each including GST
10) Wrote out cheque number 1002 to pay The Chronicle for advertising $275 including GST.
12) Wrote out cheque number 1003 to pay Illawarra Supplies $1,650 including GST for supplies.
15) Mazie May purchased the following cattle from M & M Wrapper on account: 18 head @ $319 each including GST, 45 head @ $418 each including GST.
16) Mazie May Feedlot received an account from Telstra for the telephone $528 including GST.
22) Mazie May sold the following cattle on credit to Australian Beef Buyers: 5 @ $880 each including GST, 15 head @ $704 including GST. 5
25) Received and banked a second cheque from Campbell’s Livestock for $12,500 to reduce the balance owing on their account.
26) Received Agistment Revenue of $5,500 including GST
28) Wrote out cheque number 1004 to pay wages $3,600. Gross Wages $4,500, PAYG withheld $900.
28) Wrote out cheque number 1005 to pay James May Motors for repairs to the truck $1,320 including GST.
28) Wrote out cheque number 1006 to pay State Produce Ltd $55,000 being payment of account.
30) Owner withdrew cash $2,000.
30) Wrote out cheque number 1007 to pay the Telstra account received on 16 th June.
b) Post the entries from the General Journal to accounts in the General Ledger and Subsidiary ledgers and reconcile the subsidiary ledgers with the Accounts Receivable Control and Accounts Payable Control Accounts in the General Ledger.
c) Prepare the Unadjusted Trial Balance in the Worksheet provided
2. Prepare Journal entries for ADJUSTMENTS at 30 June 2010; post adjustment entries to the ledger and prepare the Adjusted Trial Balance
a) Record the following adjustments in the worksheet and record the Journal entries at 30 June 2010
1. Account for Tractor Lease amount for June [GST already accounted for.]
2. Interest owing on loan payable for May and June $1,050 per month.
3. Account for Supplies remaining on hand 30 June, 2010 – $5,200
4. Record Depreciation on Improvements – 10 % on cost of $150,000
5. Record Depreciation on Motor Vehicles – $13,000
6. Interest Revenue owing for six months to 30th June 2010 of $1,250 will be received in July 2010.
7. Membership income to be adjusted for the current year – see note on Business
8. Account for Wages owing at the end of June – $900
9. Incurred bank charges for the month of June $25
10. A stock take of the cattle revealed inventory on hand worth $171,458 at 30th June 2010.
b) Post the adjustment entries in (a) above to the ledger and compare the ledger account balances to the Adjusted Trial Balance values in the worksheet.
3. Prepare Closing entries in the Journal and post to the Ledger; complete the worksheet
4. Prepare Financial Reports – Income Statement and Balance Sheet
5. Calculate Financial Ratios and prepare report
a) Research the methods used for calculating the following ratios for 2010:
? Liquidity – Current Ratio, Quick Ratio
? Operating Capacity – Accounts Receivable Turnover, Inventory Turnover
? Profitability – ROA, ROE, Profit Margin
? Financial Flexibility – Debt Ratio, Equity Ratio, Times Interest Earned.
Prepare a worksheet in your Excel file in which you calculate the required ratios using the figures from the financial reports and where necessary ending balances from the Adjusted Trial Balance for the year ended 30th June 2009 (see Trial Balance on page 3). Please ensure that you clearly show your workings (the figures used for each calculation) – maybe set out a table for each ratio, showing the figures used in the calculation, the formula used and the final calculation (the format for this is up to your group).
Prepare the following table in another Excel worksheet in which you incorporate your findings for 2010. You will need to copy and paste the table into the report in (b) below.
AccountsReceivabl 2.8 times
Inventory Turnover 2.48 times
b) Create a Word document file and copy and paste the completed table from (a) above in this document. Comment on the trends revealed by these ratios in (a) above, using the headings profitability, liquidity, operating capability and financial flexibility. Where possible relate the changes observed in the ratios to events in the business environment in general discussed in (c) below.
c) Discuss two (2) events which have occurred in the business environment during the last 12 months which may have impacted on/or will impact on results of this type of business or businesses in general. Where possible support your argument with newspaper articles or other references e.g. extracts from reports from cattle industry.