PART A. THE “AMORTISATION SCHEDULE” SPREADSHEET Download the Excel Assignment Template file from ‘Assessment Tasks’ section under the ‘Excel Assignment’ label in iLearn. Save it with the name: [Student family name_ID number].xlsx (Eg. Wong_43567859.xlsx (a penalty applies for the wrong file name convention) Input your student number digit by digit in cells F2 to M2. You must input your own student ID otherwise a penalty of 7.5 marks will apply. Enter your name into the cells shown at cells O2 and O3. In cell C2, calculate the number of years for the loan as the sum of the first four digits in your student number using the =SUM() function and referencing cell locations. Marks will be deducted if you have +…

Accounting for Managers (ACC00724) QUESTION 1 Top Cake shop was established on 1 April 2019 with an initial investment of $100,000 by the owner (Jack Claff). During the first few weeks of business, the owner employed a part-time book-keeper who recorded the following list of accounts: Accounts payable                                           $37,100 Buildings                                                           100,000 Cash at bank                                                    31,000 Furniture                                                           12,000 Jack Claff – Capital                                         150,000 Baking Supplies                                               5,600 Loan payable                                                   20,700 Accounts receivable                                       20,000 Land                                                                  43,200 Mortgage payable                                          40,000 Cash drawings by Jack Claff                         36,000   Required:                                                         Assuming that the amounts above are correct, prepare a statement of financial position in vertical format (show your calculations) Prepare a statement of changes in equity for the period and determine the amount of profit (loss)…

Question 1 Jenny Ltd’s equity at 30 June 2019 was as follows: 200 000 ordinary shares, issued at $3.20, fully paid 250 000 ordinary shares, issued at $4, called to $2.40 180 000 redeemable preference shares, issued at $1, fully paid Calls in advance (5 000 ordinary shares) Share issue costs General reserve Retained earnings $640 000 600 000 180 000 8 000 (7 000) 60 000 310 000         The following events occurred during the year ended 30 June 2019: 2018 July 15 The final call, due 31 August, was made on the partly paid shares. Aug. 31 All call money was received, except for that due on 12 000 shares. Sept. 10 In accordance with the constitution, the shares on which the call was unpaid were forfeited. The…

QUESTION 1: Balance Day Adjustments Jacque Mercedes owns and operates a successful tour business specialising in mountain e-bike adventure holidays. The business also sells a range of cycling products but its main item is a custom made mountain e-bike, “Vampex”. The “Vampex” is made only for The E-Bike Tour Company and has recently featured in a number of bike touring / holiday magazines. As a result of this recent positive media coverage, Jacque has been too busy to undertake any record keeping for the company and has handed the record keeping over to the accounting practice where you work as a graduate accountant.   The E-Bike Tour Company Trial Balance 30 June 2019 $ $ Cash 3,060 Accounts Receivable 3,500 Inventory…

Question 1 Morning Star Ltd was registered on 1 July 2018, as a company with a constitution limiting the shares that could be offered to 7 000 000 Ordinary shares (including all classes) and 2 000 000 preference shares. The company issued a prospectus dated 1 July 2018 inviting the public to apply for 4 000 000 Ordinary A class shares at $3.00 per share. The terms of the shares on issue are $1.50 on application, $1.00 on allotment and $0.50 to be called within six months of allotment before 31 December 2018. If the issue is oversubscribed the directors will make a pro-rata issue of shares and the excess application money will be applied to allotment and calls before any…

Scenario Futura robotics manufacture custom made robotic components.  Each job is unique and costed individually. You are required to create a spreadsheet that records a list of completed jobs and allows the company to cost up new jobs.   Start by downloading the assessment workbook from iLearn and copying/moving it to an appropriate folder. When you open the workbook it is very important that you Enable Macros/Content. You will then be asked to enter your Student Number (you will not be able to edit it afterwards, so type it in carefully) and then enter your Student Name.   General Guidelines With the exception of the Journal Accounts, which are to be selected from the drop-down list, all the light blue cells…

Question 1 On 1 July 2017, Bolan Ltd purchased 40% of the shares of Rex Ltd for $151 680 and signed a joint venture agreement with the two other shareholders in Rex Ltd. At that date, equity of Rex Ltd consisted of: Share capital                                   $300 000 Retained earnings                               26 400   At 1 July 2017, the identifiable assets and liabilities of Rex Ltd were recorded at amounts equal to their fair values.   Information about income and changes in equity for both companies for the year ended 30 June 2020 was as shown. Bolan Ltd Rex Ltd Profit before tax Income tax expense Profit Retained earnings (1/7/19)   Dividend paid Dividend declared   Retained earnings (30/6/20) $ 62…

Newsurf Ltd, has been manufacturing and selling surfboards for the last two years. Newsurf Ltd commenced operations on 1 July, 2017 by issuing 500 000 $3.50 shares, payable in full on application. There were no share issue costs.   For the year ending 30 June 2019, the company recorded the following aggregate transactions:   Accounts $ Sales 5 385 000 Interest income 11 000 Cost of Sales 3 409 000 Gain on sale of plant 25 000 Employee benefit expenses - Admin 136 000 Depreciation expense- Admin 54 000 Selling & Distribution Expenses 932 000 Insurance expense - Admin 60 000 Doubtful debts expense 5 000 Interest expense 38 000 Other borrowing expenses 4 000 Income tax expense 268 000  …

*It has been assumed that interest is payable Annually and given interest rates are p.a. compounded annually. Today is 1 January 2019. Lucy is planning to purchase a 10-year 4.15% p.a. Treasury bond with a face value of $100. The maturity date of the treasury bond is 1 January 2029 The bond is redeemable at par. Use Goal Seek to find Lucy’s yield to maturity (express your answer as a j2), if the purchase price is $96.5. Use Goal Seek to find Lucy’s net yield to maturity, that is after tax rate, (express your answer as a j2), if the purchase price is $95.5. Given that Lucy needs to pay 30% tax on coupon payment (interest payment) only. Use Goal Seek…