Write a report to andrew baird on behalf of bws accounting

Assignment Help Financial Accounting
Reference no: EM131044757 , Length:

Assignment Task:

Financial statements, analysing business transactions and financial statement analysis

Andrew Baird started a new sole trader business called A1 Outdoor Training in the financial year ending 30 June 2015. The business' focus is on group personal training in local parks and beaches 7 days per week. Andrew has asked his accountant, BWS Accounting, to complete financial statements and write a business report on the financial health of A1 Outdoor Training in its first year of operation.

A1 Outdoor Training has the following account balances in their accounting worksheet as at 31 May 2015.

Assets

 

Liabilities

Equity 

 

Cash at bank

Accounts Receivable

Equipment

Accounts

Payable #

Loan

Income

Expenses #

Description

Opening

balances

7,000

20,000

45,000

2,000

45,000

30,000

- 5,000

# Fuel expenses

The following transactions occurred in the last month of operation June 2015:

June

Transaction Detail

3

Paid cash to a local marketing firm for business cards and advertisement in the local paper $1,450.

5

Sent an invoice for personal training services performed at a team building day for a corporate client Mal's Fast Food $1,500

6

In order to help the business out Andrew Baird, injected $20,000 in cash into the business bank account of A1 Outdoor Training.

7

A van was purchased to transport the personal training equipment to different locations around the region. The complete cost of the motor vehicle was $30,000. $10,000 was paid from the business bank account and the balance was financed via a loan.

11

A large local retailer paid $4,000 in cash for a weeks' worth of personal training with A1 Outdoor Training.

16

Paid $1,000 towards petrol account with Franks Fuel.

19

Andrew is taking a trip to Hawaii with friends and withdrew $4,000 from the business account to pay for his flights.

21

Paid $710 for membership to Personal Trainers Australia organisation.

26

Made loan repayment instalment of $12,000 (Includes $3,000 interest expense)

30

Received a cheque from Mal's Fast Food for $500 towards the invoice sent on the 5th of June. The note contained with the cheque said the balance would be paid in July.

Additional information:

Cash received from personal training fees for 2014-2015 financial year was $14,500

Cash paid for fuel expenses for 2014-2015 financial year was $4,000

Opening cash balance 1 July 2014 was $0

Required

Part A: Worksheet

In the ‘Assignment 2 Template' complete an accounting worksheet for A1 Outdoor Training for the 2015 year. Using the sheet labelled ‘Worksheet' identify A1 Outdoor Training's business transactions for June and construct an accounting worksheet.

Notes

1. Illustrative example 4.4 on pg. 126 of the text should be used as a guide to the format required.

2. Opening balances as at 31 May should be used as your starting point in your accounting worksheet but additional accounts may be required.

3. In your worksheet you must demonstrate the use of the following Excels functions:

- 'sum'
- bordering
- cell merging
- wrap text
4. Ensure that you ‘sum' each side of your worksheet to prove the accounting equation.

5. For guidance on using the Excel functions and features required for this assignment refer to the Armelenos Excel tutorials located in your online study guide on the ACC100 interact site.

Part B: Financial statements

Using the same Excel file that you used for Part A, prepare the following financial statements of A1 Outdoor Training from the accounting worksheet for the 2015 financial year:

- Income statement.
- Statement of changes in equity.
- Balance sheet.
- Cash flow statement.

Notes

1. Illustrative example 4.5 on pp. 126 and 127 of the text should be used as a guide to the format required for the income statement and balance sheet. Illustrative example 6.8 on the bottom of pg. 245 of the text should be used as a guide to the format required for the statement of changes in equity. Illustrative example 7.16 on the bottom of pg. 282 of the text should be used as a guide to the format required for the cash flow statement. I have attached file with images of this book.

2. Use the additional information listed in the question above to assist you in preparing the cash flow statement.

3. Each financial statement should be prepared using the named worksheets provided in the Excel template.

4. In your financial statements you must demonstrate the use of the following Excel functions:
- formula for each subtotal and total.
- bordering
- cell merging
- wrap text

PART C: Ratio analysis

In the same Excel template that you used for PART A and B but on the sheet labelled ‘Ratio Analysis', complete the columns labelled:

- ‘formula' with the written formula for each ratio provided (first one completed for you as an example).

- ‘2014' with the ratio calculation (Strictly use formula only by pulling figures from the financial statements sheets. (Do not type ratio answer directly into the table)
Notes

1. In completing ‘Ratio Analysis' Sheet in the Excel template, you must demonstrate that you have used the following Excel functions:
- '=/+/-'

- bordering
- merging cells
- wrap text

PART D: Business report

Write a report to Andrew Baird on behalf of BWS Accounting on the financial health of A1 Outdoor

Training for the 2015 financial year. Your report should contain the following details:

- Executive summary
- Description of operations
- Evaluation and comparison of ratios calculated in Part C for the following areas (a minimum of two ratios for each category below).
o Profitability
o Asset efficiency
o Liquidity
o Capital structure
- Limitations of the analysis
- Conclusion, including recommendations on areas of improvement for A1 Outdoor Training.

Notes

1. In writing your report, you should refer to the online meeting in week 2, which will focus on a report writing presentation provided by the Academic Literacy Learning and Numeracy (ALLaN) team.

2. Your report should be between 2-3 pages, excluding cover page, contents page and references.

Verified Expert

This report is prepared in MS word File although all the calculation part has been done in MS Excel word File. The report is about 15 pages in length and is in approx. 1600 words. It contains solution to all the question. However for Business report part is contain a cover page, table of content, analysis of the business of A1 Outdoor Training and a reference list which is attached at the end of the report.

Reference no: EM131044757

Questions Cloud

What is his total revenue if the may spot price drops : In March 2014, farmer Will Armstrong projects to harvest 100 tons of orange in May 2014. In March, May orange futures are selling at $1329 per ton. Will wants to lock in this price so he has purchased futures contracts at $1329 per ton. The total cos..
Working on a request to replace an older x-ray machine : As the Regional Director for a California health care company, I was to approve all capital expenditures over $25,000. The director of the clinic and I had been working on a request to replace an older x-ray machine that was in nearly constant need o..
Simplify the comparison of the two approaches : Derive the solution to this problem. How do the criteria differ? Use the SVD of the Lj to simplify the comparison of the two approaches.
Question regarding the probability that the sample mean : The mean number of words per minute read by sixth graders is 89 with a standard deviation of 16. If 66 sixth graders are randomly selected, what is the probability that the sample mean would be greater than 92.25?
Write a report to andrew baird on behalf of bws accounting : Write a report to Andrew Baird on behalf of BWS Accounting on the financial health of A1 Outdoor - analysing business transactions and financial statement analysis
What is the current pe ratio for each company : Consider Pacific Energy Company and U.S. Bluechips, Inc., both of which reported earnings of $962,000. Without new projects, both firms will continue to generate earnings of $962,000 in perpetuity. What is the current PE ratio for each company? Pacif..
Probability that the sample mean : The operation manager at a tire manufacturing company believes that the mean mileage of a tire is 20,138 miles. With a variance of 10,304,100. What is the probability that the sample mean would be less than 19,448 miles in a sample of 171 tires if..
Explain the three key elements of motivation : What is motivation? Explain the three key elements of motivation. What challenges do managers face in motivating today's workforce? What challenges do manager face in managing global teams? How should those challenges be handled.
Identify any other disorders you would want to rule out : Identify any other disorders you would want to rule out. Consider what you could do to assist the client in reducing or removing the stressors. (psychotherapy for intervention, Trauma Focused CBT )

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd