Variance-covariance matrix

Instructions: You are given the following data below. Calculate in YELLOW

1. Calculate mean, variance, standard deviation, covariance, correlation
2. Create a chart of the mean and standard deviation of combinations of the portfolios.
3. Add the individual asset returns to the chart—are the two portfolios on the efficient frontier?

	Variance-covariance matrix				Means
	0.40	0.03	-0.04		10%
	0.03	0.50	0.05		15%
	-0.07	0.07	0.70		12%
	Portfolio1	Portfolio2
Asset1	20%	10%
Asset2	30%	50%
Asset3	50%	40%

Grace Park has recently graduated with a Masters of Health and Human Services

QUESTION 1 Grace Park has recently graduated with a Masters of Health and Human Services and has decided to set up her own business as a health policy and research consultant. From her past medical experience Grace is confident she can succeed with her business Park Health. Grace has provided the transactions for Park Health for the first quarter ending 3oth June 2018. a) You are required to record the following transactions into the transaction analysis chart (template provided). April 1 Invested $160,000 of her own funds into a business bank account. 2 Purchased a self-contained office space in Richmond for $360,000. Grace paid a 10% deposit and the balance was financed through a mortgage with Gotcha Banking Corporation. 3 Grace…

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…

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…

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…

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

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…

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…

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…

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…

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  …

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…