Question

In: Finance

Please find the gain/loss for each week. Total profit gained or loss for all 4 weeks....

Please find the gain/loss for each week.

Total profit gained or loss for all 4 weeks.

summarize the comparison between the 5 investments compared to S&P 500.

Week 1 Week 2 Week 3 Week 4
10-Jun 17-Jun 24-Jun 1-Jul Recap for June
Value/Share Value/Share Value/Share Value/Share
GOOG Google $1,080.38 $1,092.50 $1,115.52 $1,097.95
ORCL Oracle $54.01 $53.13 $56.74 $58.01
PG Procter & Gamble $108.72 $110.99 $112.33 $110.49
AAPL Apple $192.58 $193.89 $198.58 $201.55
AMZN Amazon $1,860.63 $1,886.03 $1,913.90 $1,922.19
Total Amount
DJIA $26,062.00 $26,112.00 $26,719.13 $26,717.00 7.19%
S&P 500 Stock Index $2,886.00 $2,889.00 $2,950.46 $2,964.00 6.89%
Russell 2000 Index - Small $1,523.56 $1,532.75 $1,530.08 $1,569.00 6.86%
Nasdaq $7,823.00 $7,845.00 $8,031.71 $8,091.00 7.42%
Shares Purchased Wk 1 Investment Amount Week 1 Week 2 Gain/Loss Week 3 Gain/Loss Week 4 Gain/Loss Total Profit Gained/Loss
GOOG Google 2 $2,160.74
ORCL Oracle 38 $2,052.38
PG Procter & Gamble 18 $1,956.96
AAPL Apple 10 $1,925.80
AMZN Amazon 1 $1,860.63
$9,956.51

Solutions

Expert Solution

Please see the table below. Please be guided by the second rows to understand the mathematics. Figures in parenthesis, if any, mean negative values. All financials are in $. The columns highlighted in yellow contain your answers.

Week 1 Week 2 Week 3 Week 4
10-Jun 17-Jun 24-Jun 1-Jul
Value/Share Value/Share Value/Share Value/Share
A B C D
GOOG Google $1,080.38 $1,092.50 $1,115.52 $1,097.95
ORCL Oracle $54.01 $53.13 $56.74 $58.01
PG Procter & Gamble $108.72 $110.99 $112.33 $110.49
AAPL Apple $192.58 $193.89 $198.58 $201.55
AMZN Amazon $1,860.63 $1,886.03 $1,913.90 $1,922.19
Shares Purchased Wk 1 Investment Amount Week 1 Week 2 Gain/Loss Week 3 Gain/Loss Week 4 Gain/Loss Total Profit Gained/Loss
N G1 = (B - A) x N G2 = (C - B) x N G3 = (D - C) x N G1 + G2 + G3
GOOG Google                2.00 $2,160.74                   24.24                     46.04                (35.14)               35.14
ORCL Oracle              38.00 $2,052.38                  (33.44)                   137.18                  48.26             152.00
PG Procter & Gamble              18.00 $1,956.96                   40.86                     24.12                (33.12)               31.86
AAPL Apple              10.00 $1,925.80                   13.10                     46.90                  29.70               89.70
AMZN Amazon                1.00 $1,860.63                   25.40                     27.87                    8.29               61.56
Total $9,956.51                   70.16                   282.11                  17.99             370.26

Related Solutions

Comprehensive Income     Total Impact on NI     Realized Gain/Loss     Unrealized Gain/Loss         Total Impact...
Comprehensive Income     Total Impact on NI     Realized Gain/Loss     Unrealized Gain/Loss         Total Impact on CI Section III - Income Taxes (45 points) - XYZ began business on 1/1/18. During that year, they had pre-tax financial accounting income of$96,000 and paid $800 of officer life insurance (company is the beneficiary). The accountant has determined that a truck purchased in 2018 for $25,000 will be depreciated as follows:                                                                 2018                 2019                 2020                 2021                 2022 Financial Statement $5,000...
1. Ignoring trading costs and taxes, what is the total profit or loss on each of...
1. Ignoring trading costs and taxes, what is the total profit or loss on each of the following investments? a) You sold (wrote) three TXA call option contracts with a strike price of $35 when the option was quoted at $2.60. The option expires today when the value of TXA stock is $33.70. b) You sold five put option contracts on QLN stock with an exercise price of $45 and an option price of $2.20. Today, the option expires and...
DISCUSSION WEEK 3 Please write a paragraph for each question (total 3 paragraphs) Answer ALL PARTS...
DISCUSSION WEEK 3 Please write a paragraph for each question (total 3 paragraphs) Answer ALL PARTS of each question to earn a full points. Support your response with the appropriate citation from your textbook. Discussion Topic: How does the ANA’s Code of Ethics address a nurse’s responsibility to health care quality? Describe why the nursing shortage is a major national issue in the United States. How could a nursing shortage in other countries around the world affect the nursing shortage...
determine the total mass gain or loss for the reaction by comparing your initial mass to...
determine the total mass gain or loss for the reaction by comparing your initial mass to your final mass. combined mass of vinegar and baking soda. initial total mass? final total mass? difference? run 1 grams of sodium bicarbonate 1.3 molar mass 84.006 number of moles 0.015475 0.88g acetic acid molar mass 60 number of moles 0.0154 what is the formula? and what Do I use to figure this out? thanks
determine the total mass gain or loss for the reaction by comparing your initial mass to...
determine the total mass gain or loss for the reaction by comparing your initial mass to your final mass. combined mass of vinegar and baking soda. initial total mass? final total mass? difference? run 1 grams of sodium bicarbonate 1.4 molar mass 84.006 number of moles 0.016665 0.92g acetic acid  molar mass 60 number of moles 0.0154 what is the formula? please tell me initial total mass, final mass and the difference between the two
Gain or loss may have to be recognized under the acceleration rule in all of the...
Gain or loss may have to be recognized under the acceleration rule in all of the following situations except which one? A. A sale of 60% of the stock in a subsidiary that purchased property in an intercompany transaction from another group member. B. A tax-free transfer of land purchased in an intercompany transaction to a partnership. C. If a corporation takes a substituted basis in property that it purchased in an intercompany transaction from another group member. D. P,...
For each of the following independent transactions, calculate the recognized gain or loss to the seller...
For each of the following independent transactions, calculate the recognized gain or loss to the seller and the adjusted basis to the buyer. If an amount is zero, enter "0." Seller's Recognized Gain/Loss Buyer's Adjusted Basis a. Bonnie sells Parchment, Inc. stock (adjusted basis $17,000) to Phillip, her brother, for its fair market value of $12,000. $ $ b. Amos sells land (adjusted basis $85,000) to his nephew, Boyd, for its fair market value of $70,000. $ $ c. Susan...
Quantity TFC TVC TC Total Revenue P = $136 Total Profit (+) or Loss (-) AVC...
Quantity TFC TVC TC Total Revenue P = $136 Total Profit (+) or Loss (-) AVC ATC MC MR = P Total Revenue P = $106 Total Profit (+) or Loss (-) Total Revenue P = $100 Total Profit (+) or Loss (-) 0 $0.00 1 $90.00 2 $170.00 3 $240.00 4 $300.00 5 $370.00 6 $450.00 7 $540.00 8 $650.00 9 $785.00 10 $945.00 Scooter the Skater has obtained the right to make and sell custom rollerblades on the...
Please draw each graph clearly labeling P, Q and the areas for TR, TC, profit, loss...
Please draw each graph clearly labeling P, Q and the areas for TR, TC, profit, loss breakeven Draw the MR, MC, AVC, ATC, Demand, supply, MC and MR for the following situations. For each show (as done in class). For each of these situations show the total revenue, total cost area, and shade the profit or loss area, and if the situation is a shut down state why it should shutdown. A monopolist showing a profit A monopolist showing a...
Discuss the three characters of gain or loss. Describe in detail each type. What is the...
Discuss the three characters of gain or loss. Describe in detail each type. What is the recapture provision? Compare and contrast depreciation, amortization, and depletion. Include an explanation of the assets subject to these types of cost recovery. Discuss several examples of itemized deductions. Choose one and describe in detail. Have you had experience utilizing itemized deductions on your tax return?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT