08 Mar Part A 15 marks Spreadsheet1. Learning from assi
Part A 15 marks Spreadsheet1. Learning from assignment 1 and from your own experience, describe three spreadsheet functions that you have used and found them useful. In your answers: Describe how each function is designed or formulated Use Excel spreadsheet to provide examples for each function. Show your demonstration in both normal and formula views with row and column headings. Explain why they are useful to you.2. VLOOKUP function: Describe its purposes Demonstrate this function by using Excel spreadsheet. Show your demonstration in both normal and formula views with row and column headings.Part B 25 marks Inventory managementBike World recently opened several stores in New South Wales. The owner is considering whether a perpetual or periodic inventory system should be used. The company also has an inventory of a bike model with details below:Requirements: Explain the essential differences in accounting treatments between perpetual and periodic inventory systems. You have to use journal entries to demonstrate each difference. With the nature of Bike World’s business, which system would you suggest to the owner? Why? (7 marks) Using a spreadsheet, calculate the ending inventory and Cost of Goods Sold for June, using the average cost, LIFO, and FIFO methods. Present your answers in both normal and formula views with rows and column headings. In the spreadsheet, you are required to have a data section separated from a report section. (10 marks) The company is not doing very well and the owner wants to call funds from potential investors. Based on all the above factors, what inventory method would you suggest to the owner, why? (8 marks)Part C 20 marks Bank reconciliationYou are preparing Great Foods’ financial reports for June 2018, and the 30 June 2018 bank statement has just arrived with the balance of $30,800. Currently, Great Foods’ Cash account shows a balance of $31,560.Additional information:Requirements: Suggest one new item that can increase the bank balance, and another new item that can increase the cash balance. The value for both items is the same. (4 marks) With the new bank balances, prepare Great Foods’ Bank Reconciliation at 30 June 2018 from the above data. Provide your handwritten solution scan or use your phone to copy and paste its image into your assignment. You can use a free scanning app such as Camscanner, OfficeLens, or Google Drive. (8 marks) Record any required journal entries from the bank reconciliation. (8 marks)Part D 30 marks Bad debt management and financial decisionFind THE A2 MILK COMPANY LIMITED’s financial report through the link below:https://thea2milkcompany.com/wp-content/uploads/A2ML0029-a2-2016-AR_Spreads.pdfYou are an investment advisor with accounting expertise. Write a business report, addressing issues below: What was the bad debt method that the company used? How much was their bad debt expense for the year 2016? Is there any other method of estimating bad debt? What are their differences? Analyse the company financial information through at least three ratios and two charts. For any ratios used, you have to justify why these ratios are relevant to your analysis. Comment on the company report on sustainability. In your report, you have to provide your advice as to whether your client should invest in the company or not.
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.