Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Use Jan. 5, 2018--Jan. 4, 2019) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer.

Only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points.

Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit.

1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions.

b) What the mean and Standard Deviation (SD) of the Close column in your data set?

c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution.

2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $950?
3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year (between 50 below and 50 above the mean)?
4. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $800 per share. Would this be considered unusual? Use the definition of unusual from the course textbook that is measured as a number of standard deviations.
5. At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations.
6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution.
7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number.

Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use these dates. Use the dates that match up with the current term.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer.

This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points.

Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit.

1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions.

b) What the mean and Standard Deviation (SD) of the Close column in your data set?

c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution.

2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $950?
3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year? (between 50 below and 50 above the mean)
4. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $800 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations
5. At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations
6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution.
7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number.

Carla Vista Co. has had 4 years of record earnings. Due to this success, the market price of its 470,000 shares of $4 par value common stock has increased from $15 per share to $54. During this period, paid-in capital remained the same at $5,640,000. Retained earnings increased from $4,230,000 to $28,200,000. CEO Don Ames is considering either (1) a 15% stock dividend or (2) a 2-for-1 stock split. He asks you to show the before-and-after effects of each option on (a) retained earnings, (b) total stockholders’ equity, and (c) par value per share.

(A)

1.      Stock dividend - retained earnings $______

2.      2-for-1 stock split - retained earnings $______

(B)

PAID-IN CAPITAL: Original Balance: ______ After dividend: _____ After Split: _____
RETAINED EARNINGS: Original Balance: _____ After dividend: _____ After Split: _____
TOTAL STOCKHOLDERS EQUITY: Originical Balance: _____ After dividend: _____ After Split: _____
SHARES OUTSTANDING: Original Balance: _____ After dividend: _____ After Split: ______

(C)

Stock dividend - par value per share $______

2-for-1 stock split - par value per share $______

Your company has earnings per share of $ 3.58 . It has 1.1 million shares? outstanding, each of which has a price of $ 43 . You are thinking of buying? TargetCo, which has earnings per share of $ 0.90 ?, 1.1 million shares? outstanding, and a price per share of $ 28 . You will pay for TargetCo by issuing new shares. There are no expected synergies from the transaction.

a. If you pay no premium to buy? TargetCo, what will your earnings per share be after the? merger?

b. Suppose you offer an exchange ratio such? that, at current? pre-announcement share prices for both? firms, the offer represents a 15 % premium to buy TargetCo. What will your earnings per share be after the? merger?

c. What explains the change in earnings per share in part ?(a?)? Are your shareholders any better or worse? off?

d. What will your? price-earnings ratio be after the merger? (if you pay no? premium)? How does this compare to your? P/E ratio before the? merger? How does this compare to? TargetCo's premerger? P/E ratio? a. If you pay no premium to buy? TargetCo, what will your earnings per share be after the? merger? The EPS after the merger is ?$nothing . ? (Round to the nearest? cent.) b. Suppose you offer an exchange ratio such? that, at current? pre-announcement share prices for both? firms, the offer represents a 15 % premium to buy TargetCo. What will your earnings per share be after the? merger? The EPS after the merger is ?$nothing . ? (Round to the nearest? cent.) c. What explains the change in earnings per share in part ?(a?)? ?(Select the best choice? below.) A. EPS always decline if the firm issues new shares to pay for a merger. B. EPS declines because you are over minus paying for TargetCo. C. EPS declines because TargetCo has a higher price dash earnings ratio than your firm. Are your shareholders any better or worse? off????(Select the best choice? below.) A. In this? case, your shareholders are neither worse nor better off. B. In this? case, your shareholders are worse off. C. In this? case, your shareholders are better off. d. What will your? price-earnings ratio be after the merger? (if you pay no? premium)? How does this compare to your? P/E ratio before the? merger? How does this compare to? TargetCo's premerger? P/E ratio? The? P/E ratio after the merger is nothing . ? (Round to two decimal? places.) How does this compare to? TargetCo's premerger? P/E ratio? The? P/E ratio before the merger was nothing . ? (Round to two decimal? places.) ?TargetCo's premerger? P/E ratio was nothing . ? (Round to two decimal? places.)

Fox Ltd has purchased a truck on 1 July 2018. The list price of the truck was $200,000 but Fox Ltd was invoiced and paid only $180,000. Fox Ltd did have to pay for an inspection costing $30,000 on 1 July 2018 before the truck could be used for the first time. In addition, the company purchased an annual insurance policy for the truck costing $24,000 (recorded using the asset approach). The truck will be depreciated using the reducing balance method at a rate of 10% per annum.

On 1 September 2018, the truck broke down and Fox Ltd spent $40,000 to get it back to working condition.

On 1 July 2019, Fox Ltd decided to replace the engine in the truck with a newer model costing $61,000 that uses considerably less petrol and makes the truck more powerful so that it could also haul a trailer. The 10% reducing balance rate of depreciation is still applied.

Required:

Prepare the general journal entries for the years ended 30 June 2019 and 30 June 2020 related to the truck, taking into account the information provided above. Narrations are not required. Justify your entries.

PSA11.2 Prepare the operating activities section — direct and indirect methods.LO2, 3

The statement of profit or loss of Phillips Screwdrivers Ltd is presented here.

Company A started at the beginning of 2019.
They entered into a lease with Jan 1st as both inception and commencement date
The Lease term is as below
- 5 yr non-cancellable
- 5% interest rate
- equal payment of $22916.51 at the end of each year
- $1,000 bargaining purchase option at the end of lease term
The useful life of this asset is 6 years with 0 residual value

Tax rate 25%, 30% and 35% each of the year

Earnings before interest, amortization and taxes for each year
2019         $123,456
2020         $234,567
2021         $345,678

Required:
a) Prepare an amortization table for the lease
b) Record all related Journal entries
c) Complete the balance sheet
d) If instead of lease, company A pays $6,000/year rental to use the same equipment
what impact would this make?

You are planning to buy a residential property of Rs. 5 crores at a desired location. The property is always the one you wanted to have as a new home. Before you start a deal with the broker and the bank, you would like to analyse the current financial position. As you have other obligations to meet, with the current salary you would like to know the loan to be taken and how much can be considered from the personal finances. This process of managing one’s personal finances will help you identify your assets and liabilities and thus a decision whether to buy the residential property or should wait for the near future can be taken. Prepare a financial statement of you as an individual based on your income, expenses, assets and liabilities in a proper format. (Require to provide at least 10 different types of transactions for the purpose of this assignment).

We do not need excel sheet. Answer should be in word format only

a. Identify the transactions that took place in the financial year 2019 – 2020

b. Prepare Profit and Loss Account and Balance Sheet of you as an individual indicating clearly your income, expenses in profit and loss account and assets and liabilities in your balance sheet. (You have been inherited an amount of Rs. 1 crore from your grandfather. Consider this as opening capital for the financial year 2019 – 2020)

Part A: Titration of a weak acid

Calculate the pH during the titration of 10.00 mL of 0.400 M hypochlorous acid with 0.500 M NaOH. First what is the initial pH (before any NaOH is added)?

The Ka for HOCl is 3.0 x 10-8 M.

Part B: How many mL of NaOH are added to reach the equivalence point?

Part C: What is the pH after 3.50 mL of NaOH are added?

Part D: What is the pH after 4.70 mL of NaOH are added?

Part E: What is the pH at the equivalence point? (Notice that the pH of a weak acid at the equivalence point is basic.)

Part F: What is the pH after 9.00 mL of NaOH are added?

Part G: What is the pH when half the acid has been neutralized?

Part H: What is the pH after 20.30 mL of NaOH are added?