Solved Assignments

EX16_XL_CH08_GRADER_ML1_HW – Investment Banking 1.2

Project Description: You are an investment banker and you would like to put together a brief statistical report of the most-viewed stock quotes for the day. To complete this task, you will enter stock prices and create a report using the Analysis ToolPak. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open exploring_e08_grader_m1_Stocks.xlsx. 0.000 2 Type Symbol in cell B2, type Last Sale Price in cell C2, and type Rank in cell D2. 12.000 3 Enter the following stock information beginning in cell B3: Click cell B3 and type CTIC. Click cell C3 and type 1.92. Click cell B4 and type AAPL. Click cell C4 and type 130.96. Click cell B5 and type C. Click cell C5 and…

Details

ACC5000 – Consider the information provided for Legal Eagle Law Services

ACC5000  Assignment 1  Due: 20th August 2018 Assignment Requirements: Consider the information provided for Legal Eagle Law Services and use Excel to: Record the journal entries for June transactions. Record adjusting entries. Construct the “T” formatted leger accounts. Prepare the profit and loss statement. Prepare the classified narrative formatted balance sheet   You must use formula to construct the leger accounts, profit and loss statement, and balance sheet.    Legal Eagle Law Services Unadjusted Trial Balance as at 31 May 2019   Debit   Credit Cash at bank $11,670 Accounts receivable 32,550 GST receivable 3,900 Prepaid rent 3,150 Prepaid insurance 4,095 Office supplies 6,030 Office equipment 18,300 Accumulated depreciation — office equipment $3,705 Accounts payable 4,200 Unearned fees 1,650 Loan payable…

Details

Capital Structure – The year is 2030, and the world has run out of oil

The year is 2030, and the world has run out of oil.  Fortunately, a crop called Extrophia (which can be regrown) has emerged to meet humanity’s needs, as it can be processed into a type of fuel which can run the new breed of Extro-cars and Extro-trains.   Kobol Processing Inc began its life 12 years ago when it started purchasing land to rent out to farmers for growing Extrophia.  The company has shown a profit in all of its years of existence, and the shareholders simply adore the company’s management. Prior to founding Kobol, its CEO, Shang Tsung, was the founder and CEO of a failed crude oil refining operation. The bankruptcy and the resulting Companies’ Creditors Arrangement Act (CCAA)-driven…

Details

Dividend Policy – AMC Corporation currently has an enterprise value

AMC Corporation currently has an enterprise value of $400 million and $100 million in excess cash. The firm has 10 million shares outstanding and no debt. Suppose AMC uses its excess cash to repurchase shares. After the share repurchase, news will come out that will change AMC’s enterprise value to either $600 million or $200 million. What is AMC’s share price prior to the share repurchase? What is AMC’s share price after the repurchase if its enterprise value goes up? What is AMC’s share price after the repurchase if its enterprise value declines? Suppose AMC waits until after the news comes out to do the share repurchase. What is AMC’s share price after the repurchase if its enterprise value goes up?…

Details

ACC101 – Fundamentals of Accounting I

PART B Making general journal entries（10%） Company XYZ has appointed you as an Accountant and you are asked to review the following transactions as at 30 June 2018, which is the current year before any adjusting entries have been made.   (a) 08/09/2017 Purchase equipment for cash $5000 (b) 18/10/2017 Provide services to a client A for $500 on account (c) 20/10/2018 pay the bank loan for $10000 (d) 11/12/2018 Invest additional $30000 cash into the business by the owner (e) 01/18/2018 Collect an account receivable in cash from client A (f) 31/01/2018 Pay wages to employees for $5000 (g) 04/02/2018 Paid the electricity bill for $100 (h) 06/04/2018 Sell a piece of equipment for $3000 in cash (i) 05/05/2018 Withdraw…

Details

Consolidation: Non – controlling interests, Investment in associates and Accounting for foreign currency transactions

Assignment 2 Value: 10%  Due Date: 10-Sep-2018 Return Date: 04-Oct-2018 Length: Submission method options: Alternative submission method Task You are required to complete all three questions below. A total of 60 marks are allocated to these questions, which will be converted to a final mark out of 20%. All workings, when appropriate, must be shown to substantiate your answers.   Question 1 [43 marks]  Topic 3: Consolidation: Non-controlling interests Pepsi Ltd acquired 80% of the shares of Soda Ltd on 1 July 2015 for $115 000. At this date the equity of Soda Ltd consisted of:       $ Share capital (100,000 shares) 80,000 Retained earnings 29,600 General reserve 2,400     All the identifiable assets and liabilities of Soda…

Details

Corporate Finance – Assume that you will deposit $4000 at the end of each of the next

Assessment 1 – Assignment   Corporate Finance   Each of the following question worth 10 marks, please answer all of them. If needed please use Harvard referencing style. There is no word limit, but it is necessary that you provide answers with explanations.   Question 1: Assume that you will deposit $4000 at the end of each of the next three years in a St. George bank account paying 8% interest. You currently have $7000 in the account. How much will you have in three years? In four years? You are looking into an investment that will pay you $12,000 per year for the next 10 years. If you require a 15% return, what is the most you would pay for…

Details

John’s boat hire business generates

Question 1 John’s boat hire business generates $200,000 per annum for the next 10 years. Given an interest rate of 10% per year, would he be willing to sell the business today for $1,800,000? While Andy was a student at Albury University, he borrowed $25,000 in student loan at an annual interest rate of 7%. If he repays $2,000 per year, calculate the period required (to the nearest year) to pay off his debt. Benjamin receives a payment of $120,000 from his grandmother’s estate. The entire amount is invested today at an interest rate of 8% per year. He expects to receive 100 equal monthly payments from the investment; the first payment is expected in one year. Find the size of…

Details

Consolidation: Principles, accounting requirements & Intra-group transactions

Assignment 1 Value: 10% Due Date: 13-Aug-2018 Return Date: 03-Sep-2018 Length: Submission method options: Alternative submission method Task You are required to complete the following question. A total of 55 marks are allocated to these questions, which will be converted to a final mark out of 10%. All workings, when appropriate, must be shown to substantiate your answers. Question 1 [20 marks] Topic 1: Consolidation: Principles, accounting requirements On 1 July 2017, Panda Ltd acquired all the issued shares of Smarty Ltd. Panda Ltd paid $250,000 more than the equity it acquired in the fair value of Smarty Ltd’s net assets. At the date of acquisition, the shareholder’s equity of Smarty Ltd was as follows. $ Share capital 100,000 Retained earnings 175,000 Total 275,000  …

Details

ACCT2000 – Financial Accounting (Prepare statements of cash flows Differentiate between shares and debentures and apply appropriate accounting procedures)

    Question 1                                                                                                           (48 marks) The following information relates to Gem’s Jewels Ltd: Gem’s Jewels Ltd Statement of Financial Position As at 30 June 2015 2016 $ $ $ $ Current Assets Cash at bank 20,000 39,500 Inventory 80,000 150,000 Accounts Receivable 120,000 309,500 Non-current Assets Buildings 330,000 430,000 Acc. Depreciation – buildings (80,000) 250,000 (110,000) 320,000 Office Equipment 110,000 75,000 Acc. Depreciation – office equipment (30,000) (20,000) Total assets 507,000 684,500 Current liabilities Accounts Payable 60,000 120,000 Current tax liability 7,500 17,000 Wages payable 20,000 87,500 Non-current liabilities NAB Loan Payable – 80,000 Total liabilities 87,500 247,000 Equity Share capital 400,000 420,000 Retained earnings Total liabilities plus equity 507,000 684,500     Gem’s Jewels Ltd Income Statement For the…

Details

Sun Worship Leisure Wear Budget Assumptions 2018

Sun Worship Leisure Wear manufactures swimwear and accessories for men and women.  They operate out of rented premises in Burleigh Heads where the factory is split into a manufacturing and storage area and a retail space. The business produces 4 products: Bikinis for women Board shorts for men Beach Towels Beach Bags   You, as the management accountant for the firm, prepared the budgets for the 2018 year based on the following information that had been gathered:   Sales Bikini Board short Towel Beach Bag January 2018 1,600 1,200 200 400 February 2018 1,400 1,100 180 300 March 2018 1,300 1,160 160 260 April 2018 1,000 1,000 120 140 May 2018 400 600 60 80 June 2018 500 700 40 40…

Details

Financial statement presentation – ACC 514 ( Financial Accounting) assignment

Financial statement presentation   Appliances Ltd, a manufacturing company, commenced operations on 1 July 2017. The draft trial balance for the year ended 30 June 2018 has been prepared as follows:   Appliances Ltd Draft trial balance as at 30 June 2018 DATA DR ($) CR ($) Sales of goods 12,230,000 Interest income 7,000 Cost of sales 4,685,000 Marketing expense 623,000 Salaries and wages 2,740,000 Administration expenses 143,000 Annual leave expense 210,000 Doubtful debts expense 62,000 Depreciation expense 0 Interest expense 64,000 Other borrowing expenses 6,000 Other expenses 95,000 Warranty expense 64,000 Income tax expense 0 Cash on hand 41,000 Cash management account 193,000 Trade debtors 3,276,000 Allowance for doubtful debts 219,000 Raw material inventory 624,000 Finished goods inventory 1,250,000 Land…

Details