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…

$15.00 – Buy Solution

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…

$30.00 – Buy Solution

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…

$10.00 – Buy Solution

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?…

$10.00 – Buy Solution

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…

$20.00 – Buy Solution

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…

$60.00 – Buy Solution

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…

$30.00 – Buy Solution

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…

$30.00 – Buy Solution

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  …

$50.00 – Buy Solution