20 Feb Financial statements, analysing business transacti
Financial statements, analysing business transactions and financial statement analysisSunbay Sales is a small sales consultancy business and began operation on 1 January 2017. It is owned and operated by Karin Nilson and employs one other consultant.Karin has asked her accountant, Megan Gordon to complete financial statements and write a business report on the financial health of Sunbay Sales in its first year of operation.Sunbay Sales has the following account balances as at 31 May 2017;Cash at bank$72,900Accounts payable$17,300Account receivable$26,150Loan$15,000Office equipment$10,700Capital$100,000Prepayments$0Income$40,400Sales solution software$24,500Expenses($38,450)The following transaction occurred in the last month of the financial year- June 2017.JuneTransaction Description1Paid $24,000 for a 12 month business insurance policy.1Paid rent of $1,600 in cash for the month.2Received $9,400 payment for outstanding invoice (sent 12 May) from Delta Start-Up.3Paid $220 to the internet service provider account, outstanding from May.6Purchased $1,050 worth of office stationary for the business on account.4Paid $850 cash for internet advertising during the month of June.8Sent a $6,700 invoice for consultancy services performed during the first week of June for Game Chase Group.9Karin paid $1,080 for an emergency hospital visit from the business bank account.12Received $10,200 in cash from customers for sales consultancy services.16Made a loan repayment of $10,000 (includes $1,000 interest expense).17Paid the business telephone bill $320.18Paid the invoice received on 6 June.20With the exception of one small $530 invoice (which remains outstanding) received payment from all remaining outstanding May invoices.23Sent a $4,320 invoice for services performed in the second week of June for Altitude Fitness.25Karin injected $15,500 of her own cash into the business bank account.26Received $7,820 in cash from a business named Wagga Hat for sales consultant service in June.28Sent a $3,200 invoice for services performed in the third week of June for Glass & Glaze.30An advanced sales software was purchased to improve the quality of consultancy services. The complete cost of the software was $43,500. $20,000 was paid from the business bank account and the balance was financed via a loan.30Paid $5,000 in wages for June.Additional Information The cash flow from operating activities for the period ending 30 June 2017 was $2,700.Required:Part A: Worksheet [5%]You are required to complete the worksheet in the Assignment 2 Template’ for Sunbay Sales. Using the sheet labelled Worksheet’ identify Sunbay Sales’ business transactions for June and construct an accounting worksheet.Note:1. Illustrative example 4.4 on pg. 126 of the text can be used as a guide to the format required for the worksheet. You should not limit yourself to this Illustrative example only. You should also review the tutorial questions we have provided the solutions to, as well as any other subject material available.2. Opening balances as at 31 May 2017 should be used as your starting point in your accounting worksheet.3. In your worksheet, you must demonstrate the use of the following Excel functions: ‘sum’ bordering cell merging wrap text date.4. Ensure that you sum’ each side of your worksheet to prove the accounting equation.Part B: Financial statements [5%]Using the same Excel file that you used for Part A, you need to prepare the following financial statements of Sunbay Sales from the accounting worksheet for the 2017 financial year: Income statement. Statement of changes in equity. Balance sheet.Note:1. Illustrative example 4.5 on pp.126-127 of the text can be used as a guide to the format required for the income statement and balance sheet. Illustrative example 6.8 on the bottom of p. 245 of the text can be used as a guide to the format required for the statement of changes in equity. You should not limit yourself to these illustrative examples only. You should also review the tutorial questions we have provided the solutions to, as well as any other subject material available.2. Each financial statement should be prepared using the named worksheets provided in the Excel template. You are required to use formulas only to transfer the figures from the worksheet into the statements (do not type figures directly into the statements, with the exception of note 4. below).3. In your financial statements, you must demonstrate the use of the following Excel functions: formulas for each subtotal and total bordering cell merging wrap text.4. Assume expenses incurred up to 31 May 2017 consisted of: $350 for supplies, $25,000 for wages, $880 for internet services, $8,000 for rent and $4,220 for advertising.PART C: Ratio analysis [5%]In the same Excel template that you used for Part A and B use the sheet labelled Ratio Analysis’, to complete the following: the table labelled ‘Ratio Figures’. You are required to use formulas only to transfer the figures needed from the statements into this table (do not type answers directly into this table). the column labelled formula’. You are required to provide the written formula for each of the ratio’s provided (first one completed for you as an example). the column labelled 2017′. You are required to use formula only by pulling figures from the table completed above ‘Ratio Figures’ to show the ratio calculation. (Do not type ratio answer directly into the table).Note:In completing the 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 [10%]Write a report to Karin Nilson, on behalf of Megan Gordon, on the financial health of Sunbay Sales for the 2017 financial year. Your report should contain the following details: Executive summary Evaluation and comparison of ratios calculated in Part C for the following areas (a minimum of two ratios for each category below).o Profitabilityo Asset efficiencyo Liquidityo Capital structure Limitations of the analysis Conclusion, including recommendations on areas of improvement for Sunbay Sales.Note: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 600-700 words, excluding the cover page, contents page and references.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.