Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter MB, Problem 4M
To determine
Calculate the value of portfolio that should be disclosed on the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Bartman Industries' and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow 5000 data are adjusted to include dividends.
Calculate the standard deviations of the returns for Bartman, Reynolds, and the Winslow 5000. (Hint: Use the sample standard deviation formula, STDEV function in Excel).
Bartman Industries
Reynolds Inc.
Winslow 5000
Year
Stock Price
Dividend
Holding period return
Stock Price
Dividend
Holding period return
Includes Divs.
Holding period return
2020
$17.25
$1.15
$48.75
$3.00
11,663.98
2019
14.75
1.06
52.30
2.90
8,785.70
2018
16.50
1.00
48.75
2.75
8,679.98
2017
10.75
0.95
57.25
2.50
6,434.03
2016
11.37
0.90
60.00
2.25
5,602.28
2015
7.62
55.75
4,705.97
Presented below is information relating to the purchase of common stock by Jamison Company December 31, 2016.
Cost Fair Value
Investment in Readfield Company common stock $125,000 $115,500
Investment in Lee Company common stock $100,000 $ 80,000
Investment in Stern Company common stock $250,000 $300,000
Investment in Jones Company common stock $180,000 $190,000
$655,000 $685,500
These investments are classified as trading security by Jamison who uses portfolio approach to account for those investments.
During the year 2017, Lee Company’s stock was sold for $102,000. Jamison purchased common…
Using the given data below, (there was a typo error, the date December 31, 2014 should be December 31, 2018). The question is, at December 31, 2019, how many shares were authorized?
Using data in number 23, at December 31, 2019, how many shares are issued?
Using data in number 23, at December 31, 2019, how many shares are outstanding?
Chapter MB Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- Graham Railways Inc. is evaluating its operations and provides the following information: Required: For each of the years 2017 through 2019, calculate Graham Railwayss earnings per share and dividend yield ratio. The company has no preferred stock or other potentially dilutive securities outstanding.arrow_forwardThe attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. On a stand-alone basis which corporation is the least risky?arrow_forwardTreasury stock should be reported Group of answer choices in the Investments and Funds section of the balance sheet. as a deduction from total stockholders’ equity on the balance sheet. as a current asset only if it will be sold within the next year or the operating cycle, whichever is longer. as a current asset only if it will be sold within the next year or the operating cycle, whichever is shorter.arrow_forward
- The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Calculate the standard deviation of the returns for Goodman, Landry, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.)arrow_forwardBased on the following stock price and shares outstanding information, compute the beginning and ending values for a price-weighted index and a market-value-weighted index. December 31, 2018 December 31, 2019 Price Shares Shares Outstanding Price Outstanding Stock K 20 100,000 32 100,000 Stock M 80 2,000 45 4,000* Stock R 40 25,000 42 25,000*Stock split two-for-one during the year. Base index 100a. Compute the percentage change in the value of each index and the new during the year b.…arrow_forwardUsing the given data , (there was a typo error, the date December 31, 2014 should be December 31, 2018). The question is, at December 31, 2019, how many shares were authorized? at December 31, 2019, how many shares are issued?At December 31, 2019, how many shares are outstanding?arrow_forward
- You are given the following information regarding prices for stocks of the followingfirms: PRICE Stock Number of Shares T T+ 1 ScotBank Ltd. 1,000,000 60 80 Jetvan Ltd 10,000,000 20 35 PriceLife Ltd. 30,000,000 18 25 i. Construct a price-weighted index for these three stocks and compute the percentagechange in the series for the period from T to T +1. ii. Construct a market-value-weighted index for these three stocks and compute thepercentage change in the series for the period from T to T +1. iii. Based on your answer above, which of these indexes BEST illustrate the movementon the stock market.arrow_forwardAt December 31, 2018, Charlotte Company has an equity portfolio valued at $160,000. Its cost was $132,000. If the Securities Fair Value Adjustment has a debit balance of $8,000, which of the following journal entries is required at December 31, 2018?arrow_forwardCan you help with the following? Storm, Inc. purchased the following available-for-sale securities during Year 1, its first year of operations: Name Number of Shares Cost Dust Devil, Inc. 1,880 $80,840 Gale Co. 800 64,000 Whirlwind Co. 2,850 111,150 Total $255,990 The market price per share for the available-for-sale security portfolio on December 31, Year 1, was as follows: Market Price per Share, Dec. 31, Year 1 Dust Devil, Inc. $39 Gale Co. 75 Whirlwind Co. 41 Required: A. Provide the journal entry to adjust the available-for-sale security portfolio to fair value on December 31, Year 1. Refer to the Chart of Accounts for exact wording of account titles. B. Describe the income statement impact from the December 31, Year 1, journal entry.arrow_forward
- You are given the following information regarding prices for a sample of stocks. PRICE PER SHARE Stock Number of Shares Jan December Honda 20 000 170 200 Nissan 40 000 130 155 Toyota 90 000 138 145 i.) Construct a price-weighted index for these three stocks for January and December ii.) Construct a value weighted index for the securities above for January and December iii) Construct an equal-weighted index by assuming $1,000 is invested in each stock. What is the percentage change in wealth for this portfolio?arrow_forwardUsing the given data below, (there was a typo error, the date December 31, 2014 should be December 31, 2018). The question is, at December 31, 2019, how many shares were authorized?arrow_forwardBased on the following stock price and shares outstanding information, compute the beginning and ending values for a price-weighted index and a market-value-weighted index. December 31, 2018 December 31, 2019 Price Shares Shares Outstanding Price Outstanding Stock K 20 100,000,000 32 100,000,000 Stock M 80 2,000,000 45 4,000,000* Stock R 40 25,000,000 42 25,000,000*Stock split two-for-one during the year.a. Compute the percentage change in the value of each index during the year.b. Explain the difference in…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning