Now, using only the data for the last day of each year (2016, 2017, 2018, and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Now, using only the data for the last day of each year (2016, 2017, 2018, and 2019) and create a new table that shows the value of your investment of 100,000 shares on each of these dates. Create a column or bar chart with this table and insert it in a new worksheet. Finally, in a worksheet that you label Journal Entries in your Excel file, create the following journal entries: • What is the journal entry that your company would use to record investment in this company's stock? • What adjusting entries would you need to make on December 31, 2017, 2018, and 2019 to record the change in the value of this investment? A 1 Date 2 12/30/2016 3 12/29/2017 4 12/31/2018 5 12/31/2019 6 9/28/2020 7 8 9 10 B C Adj Close Investment T 110.91 11090869.10 160.87 16087336.70 170.17 17017042.50 193.95 19394575.50 220.26 22025999.50 D +25 410 LL E Now, using only the data for the last day of each year (2016, 2017, 2018, and 2019) and create a new table that shows the value of your investment of 100,000 shares on each of these dates. Create a column or bar chart with this table and insert it in a new worksheet. Finally, in a worksheet that you label Journal Entries in your Excel file, create the following journal entries: • What is the journal entry that your company would use to record investment in this company's stock? • What adjusting entries would you need to make on December 31, 2017, 2018, and 2019 to record the change in the value of this investment? A 1 Date 2 12/30/2016 3 12/29/2017 4 12/31/2018 5 12/31/2019 6 9/28/2020 7 8 9 10 B C Adj Close Investment T 110.91 11090869.10 160.87 16087336.70 170.17 17017042.50 193.95 19394575.50 220.26 22025999.50 D +25 410 LL E
Expert Answer:
Answer rating: 100% (QA)
The company has made investment in 100000 shares on December 30th 2016 at Rs 11091 per share The in... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Create a new table that contains only the last three columns of the table in exercise 5. This time, instead of reporting the numbers relative to the U.S. value, report the inverse of these numbers....
-
Create a new table that contains only the last three columns of the table in exercise 5. This time, instead of reporting the numbers relative to the U.S. value, report the inverse of these numbers....
-
Using only the data given in the text, what is the maximum number of telephones that the existing U.S. system can support without changing the numbering plan or adding additional equipment? Could...
-
The rigid bar AB is supported by a pin at B and by two the cables AC (perpendicular to the beam) and AD (inclined with respect to the beam) attached at A as shown in Fig. 3. A C 30 in D B 80 in...
-
Even though genetically engineered mosquitoes might be developed that do not allow the reproduction of malaria protozoa, these mosquitoes would have little, if any, immediate effect on the spread of...
-
Prepare double column cash book from the following information for July 2017: 01 03 05 10 15 20 25 30 Cash In hand Bank overdraft Paid wages Cash sales Cash deposited into bank Goods purchased and...
-
Determine the Mach number of a car moving in standard air at a speed of (a) \(25 \mathrm{mph}\), (b) \(55 \mathrm{mph}\), (c) \(100 \mathrm{mph}\).
-
Consider the following research questions or hypotheses. What variables need to be measured in each? a. Do consumers who spend more time and are more committed to Facebook spend more money at...
-
Two individuals, Catherine and Annabelle, wish to make exchanges. Catherine has three pencils and Annabelle also has three. Catherine values successive units of pencil as follows: $6, $5, $4, $3, $2,...
-
Here are some diagnostic plots for the final exam data from Exercise 13. These were generated by a computer package and may look different from the plots generated by the packages you use. (In...
-
1.) Using the design that you created using SQL. You must use SQL in this assignment. DO NOT CREATE THESE TABLES WITH MS ACCESS DATABASE DESIGN VIEW!!! we are now going to build the tables 5 Part I:...
-
Can you elucidate the process of germ cell specification and primordial germ cell development during embryogenesis, including the molecular cues and epigenetic modifications that govern germ cell...
-
What is 'the principle of legality' and how does it operate in Australian constitutional law?
-
explain why, as a matter of constitutional law, no civil liberty or right is absolute?
-
How do endocrine glands, such as the pituitary, thyroid, and adrenal glands, orchestrate complex physiological processes through the secretion of hormones, and what are the molecular mechanisms...
-
explain the relationship and significances of the constitutional law of Canada to Jean -Jacques Rousseau the origin and the foundation of the inequality among mankind?
-
- Let (X) be a random walk such that Xo = 0, and for all n, P(Xn+1 - Xn= 1)=1/3 and P(Xn+1 - Xn = -1) = 2/3. (a) Define Mn = 2x. Prove that (Mn) is a martingale. == = (b) Define 7 = min{n: n > 1, |X|...
-
Find the radius of convergence in two ways: (a) Directly by the CauchyHadamard formula in Sec. 15.2. (b) From a series of simpler terms by using Theorem 3 or Theorem 4.
-
Choose two financial institutions and look up their balance sheets online. (For example, Yahoo! Finance provides these data in an easily accessible form at finance.yahoo.com/q/bs?s=GS.) What is the...
-
Suppose xt = (1.04)t and yt = (1.02)t. Calculate the growth rate of zt in each of the following cases: (a) z = xy (b) z = x/y (c) z = y/x (d) z = x1/2y1/2 (e) z = (x/y)2 (f) z = x-1/3y2/3
-
What are some examples of changes in the economy that would lead to movements along the IS curve? What are some changes that would shift the IS curve?
-
In Example 2 with equal taxes, did the outcome of the vote make anyone worse off? If so, whom and by how much?
-
Why is rent-seeking activity socially wasteful?
-
Ocean views (from a house) are not free. Do you agree or disagree? Explain your answer.
Study smarter with the SolutionInn App