Solved Assignments

New – Accounting Information System – Excel Assignment (Simple Contracts Ltd, a public company specialising in contract labour force)

Assessment Information Subject Code:                     CISM4000 Subject Name:                    Accounting Information Systems Assessment Title:               Excel Assignment Learning Outcome 5: Develop practical skills in using excel spreadsheets to collate, manage and present accounting information to users in an acceptable format. Introduction to the individual assignment: This assignment must be completed using Microsoft Excel. These introductory excel skills you learn will be used in later units and in your professional life. Employers expect students to have good worksheet skills.   QUESTION 1 The following employees work for Simple Contracts Ltd, a public company specialising in contract labour force for different projects in construction industry. The employees are paid an hourly rate, based on their Job Classification…

Details

Sky Fly, Inc is a fast growing drone manufacturer

Sky Fly, Inc is a fast growing drone manufacturer. The annual rate of return of Sky Fly’s stock has been 20% over the past few years. Company managers believe 20% is a good estimate for the firms’ cost of capital. Sky Fly’s CEO, Dane Cooper, believes the company needs to continue to invest in projects that offer the highest possible returns. Currently, the company is reviewing two separate projects. Project E involves expanding production capacity. Project I involves introducing one of the firms’ drones into a new market. The following table shows the projected cash flows for each project. Year E I 0 -3,500,000 -500,000 1 1,500,000 250,000 2 2,000,000 350,000 3 2,500,000 375,000 4 2,750,000 425,000   -Calculate the NPV,…

Details

Balanced Funds Comparison

  Assessment Activity 1 Project Balanced Funds Comparison     Activity instructions to candidates This is an open book assessment activity. You are required to read this assessment and answer all 10 questions that follow. Please type your answers in the spaces provided. Please ensure you have read “Important assessment information” at the front of this assessment Estimated time for completion of this assessment activity: 3 hours   Background Your client is considering investing $50,000 in one of 2 funds offered through BCG, a notable investment fund manager.  One fund under consideration is the BCG Balanced Fund which has the following asset allocation. Cash 10% Fixed Interest 15% Listed Property 20% Australian Shares 35% International Shares 20%   The alternative fund…

Details

BUS5IAF – INTRODUCTION TO ACCOUNTING AND FINANCE

Show black on white to print? y BUS5IAF – INTRODUCTION TO ACCOUNTING AND FINANCE PART 2: PREPARING THE FINANCIAL STATEMENTS Thank you for submitting your advice regarding sources of finance.  Your client has carefully considered your advice in setting up the new business.  As you will see below, the client may have acted on all, some or none of your advice.  That is the nature of being a consultant.  Nevertheless, the client is happy with the advice you offered and seeks further assistance from you. As the client looked further into the feasibility of the new business, it soon became clear that there was much more demand than previously realised, and immediate plans were made to increase the size of the…

Details

FINACIAL MANAGEMENT COURSE – ACCT 702_001 W 18

PART A Fluffy Cupcake Company (FCC) is considering expanding by buying a new machine to add to its existing bank of equipment used for the business. Cost of the machine is $42,000 with a 10-yr useful life with expectation of zero terminal disposal value. This investment is expected to increase the cash revenues by $23,000 annually during the life of the asset and will have annual operating expense outlay of $18,000 per annum. FCC cost of capital is 6% and the company has no existing debt and their corporate tax rate is 30% Required: Should the proposal be accepted by FCC?   PART B One of FCC’s competitors Brownie Cake Company (BCC) is also interested in installing the same machine and…

Details

Comprehensive Manufacturing Budget

Question 3         Comprehensive Manufacturing Budget                                                                                 (25 marks) This question specifically addresses all 5 of the subject’s learning outcomes. This question builds on prior studies and relates to learning material and objectives from Online Modules 1, 2 and 3. Links to specific resources provided for this question relating to Manufacturing Budgets and Excel spreadsheets can be found in the Online Topic Modules and are also available in the Resources section of the subject interact site in the Excel Resources folder.   On your manager Deirdre Lynch’s return from China she has asked you to undertake a 3 month secondment to the Mercury Inc. wholly-owned subsidiary AusMilk Ltd where you will be based at their Australian Head Office in Albury Wodonga.…

Details

EX16_XL_COMP_GRADER_CAP_HW – Stock Transactions 1.5

EX16_XL_COMP_GRADER_CAP_HW – Stock Transactions 1.5   Project Description: In this project, you will update a workbook to display bank transactions as a PivotTable. You will filter the PivotTable, format the values, display the values as calculations, and create a PivotChart using this data. Additionally, you will sort and subtotal data, create data tables, and use Goal Seek and Scenario Manager. You will format grouped worksheets, set up validation rules, and create functions. You will also import a text file and XML data and manipulate the imported text. Finally, you will modify the document properties, insert a comment, and mark the workbook as final.   Instructions: For the purpose of grading the project you are required to perform the following tasks: Step…

Details

Automotive Parts Productions (APP) is a manufacturer of motor parts – Budget

Automotive Parts Productions (APP) is a manufacturer of motor parts for family cars based in Bendigo, Australia. These motor parts are sold directly to car manufacturers in Australia for use in making motors. The accountant of APP has compiled information regarding Part-1, one of the parts produced and sold by the company. The forecasted monthly sales units for part of 2018 are presented as follows:   June 30,000 July 40,000 August 50,000 September 54,000 October 60,000 November 64,000     The following part presents data obtained from the budgeting documents of the company:   Inventory balances and the related desired ending inventory policies are stated as follows:   Description July 1 balances Desired ending inventory policy (monthly) Finished Goods 28,000 70%…

Details

Retirement Accounts – One-Stop Finance is a company that works

Retirement Accounts   Project Description: One-Stop Finance is a company that works with Clients in all areas of finance. They assist with banking, financial planning, mortgages, stock, insurance, retirement counseling, and debt consolidation. Cala Hamieh, one of the senior planners for the company, is hoping to extract information from the database. The company has a large database with hundreds of thousands of accounts, but to allow you to rapidly test your queries, you have created a smaller version of the database with a small amount of clients. Once you are confident your queries work, you can import them in to the main Access database.   Instructions: For the purpose of grading the project you are required to perform the following tasks:…

Details

Consolidation – Getswift has acquired 100% of the shares of Pursuit Pty Ltd

Getswift Ltd is an Australian newly listed company which provides a software distribution solution. This is the same company that was used in the Individual assignment. It is expected that students research this company beyond just the financial statements (especially for Part B) Pursuit Pty Ltd has been a target customer of GetSwfit’s for many years. It is a large distribution company which services supermarkets. The acquisition of Pursuit would allow GetSwift to increase its scale and penetration into the market. The actual trading business of Pursuit is much larger than Getswift but it has been operating as a family run private business. The directors are John and Ellen Pursuit who are selling their business to retire. For the last few…

Details

FINANCIAL ACCOUNTING – ACCT1101 – Accounting Practice Set online

Another version of this question is available here INTRODUCTION The objective of this Accounting practice set is to provide students with an insight into the process of recording transactions, completing adjusting and closing entries, and preparing financial statements for a retail business. Company Background Salzbruck Musical Instruments Pty Ltd has been in business in Sydney since July, 2012. The company was started by William Jacques and operates a shop which sells musical instruments on a wholesale basis to other businesses on credit and cash terms. The company’s share capital consists of 1,134,000 ordinary shares, issued at $1 each, that are owned by various members of the Jacques family. The company employs a combination of both sales and administration staff to operate…

Details

FINA2006 Principles of Finance

Case study 1 (Valuation of stocks): (5 + 5 = 10 marks) You are an analyst employed by Vanguard Wealth, a wealth management firm operating in Sydney’s financial district. You have been approached by Mr George Fero who recently inherited $10 million dollars from his late aunt’ estate.  Mr Fero is considering putting all his money in stocks of one of these two Australian mining companies, his friends have told him that these two companies are good investments. Being a first time player on the market, he does not want to invest in more than one company. He thus want expert advice on which of the two to invest in. The following is information that is publicly available which is from…

Details