Excel – In Australia, permanent employees get given 20 days holiday pay

Background   The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly.  The ability to build and professionally present a workbook is an important skill.  Please note: that where the assignment states that you must use an expression, we mean a function.   Please Note:   In Australia, permanent employees get given 20 days holiday pay (they get paid at their normal rate while on holiday) and ten days sick pay (they get paid at their normal rate while sick) in each year that they are employed.  This means that they get paid even though they are away from work.  Superannuation is calculated as a percentage of the Gross pay and taxed at 15%. …

Details

Marshell Ltd produces a subassembly used in the production of forklifts

Marshell Ltd produces a subassembly used in the production of forklifts. The assembly is sold to engine manufacturers and forklift maintenance facilities. The company is completing its fifth year of operations and is preparing to build its master budget for the coming year (2018). The master budget will be based on the following information: The finished goods inventory was 64 000 units at 31 December 2017, each costing $332.12. The desired ending inventory for each month is 80% of the next month’s sales. The data on materials used are as follows: Direct material Per-unit usage Unit cost ($) Metal 20 kg 16 Components 12 components 10   Inventory policy dictates that sufficient materials be on hand at the end of the…

Details

AMCOR Limited has a corporate bond outstanding

Question 1: AMCOR Limited has a corporate bond outstanding with a 7% coupon, semi-annual interest, 15 years to maturity and a face value of $1,000. Similar bonds currently yield 13%. By prior agreement, the company will skip the coupon payments in years 6, 7, and 8, (6 payments in total; the payments at time 6 through to 8.5). These payments will be repaid, without interest, at maturity. What is the corporate bond’s value? Question 2: Storico Co. just paid a dividend of $3.85 per share. The company will increase its dividend by 20 percent next year and will then reduce its dividend growth rate by 5 percentage points per year until it reaches the industry average of 5 percent dividend growth,…

Details

Capital Budgeting – NPV, PI, Payback, Scenario and Sensitivity

Part A (40 Marks) The management team of Online Jeans Sales have just received a new proposal from one of the firm’s marketing managers. The proposal outlines a new investment to create a Custom Finish Laboratory. Through the lab, online customers will be able to select an option to personalise their jeans in a range of finishes. This proposal was made following the completion of market research costing $100,000. The capital cost to establish the Custom Finish Lab will be $1,650,000. This cost will depreciated on the straight-line basis to zero over the 8 year productive life of the lab. It is estimated $100,000 will be recovered at the completion of the project as the salvage value of the lab. In…

Details

The following unadjusted trial balance is available

The following unadjusted trial balance is available for Si’s Knitting Service Ltd.:   Si’s Knitting Service Ltd                                                       Unadjusted Trial Balance                                                                30th June, 2015   Cash   54,680   Accounts Receivable   193,000   Prepaid Insurance   36,000   Buildings   80,000   Accumulated Depreciation – Buildings   43,200   Machinery   480,000   Accumulated Depreciation – Machinery   225,000   Land   400,000   Accounts Payable   65,760   Notes Payable   100,000   Interest Payable   9,000   Customer deposits   12,000   Bank Loan   110,000   Ordinary Shares   460,000   Retained Earnings   80,940   Revenue   576,340   Cost of goods sold 245,000   Utilities expense   14,660   Maintenance expense   48,300  …

Details

The Playdough company currently produces 760,000  playdough canisters

T217 ACC202 MANAGEMENT ACCOUNTING ASSIGNMENT    20% Due Week 10 The Playdough company currently produces 760,000  playdough canisters per year  at its local plant  as it sells the product in canisters.The details of the costs in producing the canisters are : Direct materials                                                                                      $ 300,000 Direct labour  12000 hrs at $15 per hr                                                  180,000 Variable overhead  $10 per direct labour hr                                        120,000 Fixed overhead $45 per direct labour hr                                              540,000 Total cost                                                                                             $ 1,140,000 The Playdough company has received an offer from the Cannister company  to supply the cannisters at $1 per canister .The only fixed overhead that would be avoided  would be $80,000 of supervisors salaries and $28,000 machinery depreciation .The remaining fixed overhead would continue  to be incurred. The Playdough…

Details

Project Selection and Portfolio Risk

Question 1: (marks 6) 
Your company has 4 projects A, B, C and D. The returns generating by these projects are as follows: .          Project(s) Interest (return) earnings A 11.56% per annum compounding annually B 12% per annum compounding monthly C 5% per semi-annual compounding monthly D 3.26% per quarter compounding annually 
Each of the project has 10 years of life. The initial investment for each of the project is also same $100,000 each. (i)  Your company management has asked you to select only one out of the four projects available, which one would you select? Show your calculation and justification of selection. (ii)  Consider an alternative situation. Your company management has setup a minimum acceptance criteria for any new project…

Details

Debenture and non-current assets

Question 1 The following questions are unrelated except that they all apply to non-current assets and intangible assets: 1. The manager of Golf Gear often debits the cost of repair or maintenance of equipment to Plant and equipment. Is this a violation of accounting standards and accepted good practice? Why would the manager do that? (4 marks) 2. The manager of Castle Industries often buys plant and equipment and debits the cost to Repairs and maintenance expense. Does this action violates accounting standards and accepted good practice? Why would he do that? (4 marks) 3. Some people suggest that, since many intangible assets have no value except to the business that owns them, e.g. the website, they should be valued at $1.00…

Details

General Journal, General Ledger, Trial Balance

QUESTION 1: General Journal, General Ledger, Trial Balance (35 marks) Paul is the sole proprietor of Auldana Custom Concrete Foundations (ACCF), a specialist construction company.  The following is a list of transactions that took place during the month of May 2016.     May 1                    The business purchased additional equipment costing $22,400 by increasing the loan with the bank.   May 5                    The construction of a housefoundation was completed and the client was invoiced. The client paid $8,500 in cash and agreed to pay the remaining $33,500 over the following ten months.   May 10                                 Paul withdrew $1,200 cash for personal use.   May 15                                 An Advertising Bill for $1,680 was paid for in cash.   May 17                 Paul hurt his wrist at work and visited his local…

Details

Hillar Ltd produces a variety of chemicals. One division makes reagents for laboratories

Part A:  Cost-Volume-Profit Analysis                                                                    [10 Marks] Hillar Ltd produces a variety of chemicals. One division makes reagents for laboratories. The division’s projected income statement for the coming year is: Sales (203 000 Units @ $70) $ 14 210 000 Total variable cost      8 120 000 Contribution margin $ 6 090 000 Total fixed cost    4 945 500 Operating income $ 1 144 500 Required:   Compute the contribution margin per unit and calculate the break-even point in units. Calculate the contribution margin ratio and the break-even sales revenue.      [2 Marks] The divisional manager has decided to increase the advertising budget by $250 000. This will increase sales revenues by $1 million. By how much will operating income increase…

Details

Okinawa Company uses job-order costing

Okinawa Company uses job-order costing. They worked on three jobs in July. Data are as follows:   Job 2106 $ Job 2107 $ Job 2108 Direct materials $10 450 $12 300 $16 150 Direct labour $16 000 $12 200 $24 000 Machine hours 500 300 1 000 Balance, 1 July $21 310 $6 250 $0   Overhead is applied to jobs at the rate of $16 per machine hour. By 31 July, Jobs 2106 and 2108 were completed. Jobs 2102 and 2106 were sold. Job 2107 remained n process. On 1 July, the balance in Finished Goods was $49 000 (consisting of Job 2102 for $25 600 and Job 2104 for $23 400). Okinawa prices its jobs at cost plus 30%.…

Details

Consolidation: Principles, accounting requirements and intra-group transactions

Question 1 [100 marks]  Topics 1 & 2: Consolidation: Principles, accounting requirements and intra-group transactions   On 1 July 2015, Peace Ltd acquired all the shares of Sublime Ltd. At this date, the equity and liability sections of Sublime Ltd’s statement of financial position comprised of the following items:   $ Share capital (30 000 shares) 30 000 Retained earnings 10 500 General reserve 15 000 Other reserves 3 000   At acquisition date, all the identifiable assets and liabilities of Sublime Ltd were recorded at amounts equal to fair value except for:   Carrying amount Fair value $ $ Inventory 25 000 28 000 Equipment (cost $15 000) 12 000 16 000 Machinery (cost $8 500) 7 500 8 000 Land 9 240 12 240   The inventory on hand…

Details