Copy of T7 DQ1 - Jailene Espinoza
.xlsx
keyboard_arrow_up
School
Grand Canyon University *
*We aren’t endorsed by this school
Course
144
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
4
Uploaded by MasterComputerQuetzal22
Purchase Date
Stock
Shares
Price per Share
Fees
1 year ago
6-Jun
ACOR
100
$6.19 $5.00 1 year ago
6-Jun
AAPL
200
$148.71 $10.00 1 year ago
6-Jun
DKNG
300
$12.95 $15.00 Total
600
Date
Stock
Shares
Closing Price per Share
Value
1 year ago
6-Jun
ACOR
100
$6.19 $619.00 9 months ago
6-Sep
ACOR
100
$7.45
$745.00 6 months ago
6-Dec
ACOR
100
$11.76
$1,175.80 3 months ago
6-Mar
ACOR
100
$17.80
$1,780.00 today
6-Jun
ACOR
100
$10.67
$1,067.00 Enter the information in columns B, C, D and E for each of your three stocks. E
G2 and use the fill-down feature to complete cells G3 and G4 (don't forget to in
formula). Then enter a formula in cell G5 to compute the total of your three st
Initial Investment
$624.00 $29,752.00 $3,900.00 $34,276.00 Gain/Loss
Date
Stock
Shares
Closing Price per Share
Value
$5.00 6-Jun
AAPL
200
$148.71
$29,742.00
($121.00)
6-Sep
AAPL
200
$154.53
$30,906.00
($551.80)
6-Dec
AAPL
200
$142.91
$28,582.00
($1,156.00)
6-Mar
AAPL
200
$153.83
$30,766.00
($443.00)
6-Jun
AAPL
200
$179.58
$35,916.00
- Enter the date and closing price of each stock for each date you track afte
enter the initial price, ticker symbol and number of shares, that informatio
- Enter a formula in cells F14, M14, and T14 to calculate the value of each s
these columns.
- Enter a formula in cells G14, N14, and U14 to calculate the gain/loss of va
to complete these columns. This formula should compare the value as of e
You will need to use $ to lock the cell where the initial investment for each
Enter a formula in cell nclude the fees in this tock purchases.
Enter a formula in cell W14 to calculate the total gain/loss for all three stoc
date. This will be done by adding the results in the gain/loss column for ea
the fill-down feature to complete this column.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Acquirer Shares Outstanding
Target Shares Outstanding
Acquirer Share Price
Target Share Price
Stock Consideration
Cash Consideration
Share Issuance Discount
Tax Rate
917,712
991,813
1,000,000
25,000
$5.00
$10.00
Given the following data, calculate the pro forma number of shares outstanding (Rounding to the
closest whole number).
1,081,633
1,261,613
$400,000
$200,000
2%
25%
arrow_forward
Help
Save & Exit
Su
Check y
Dublin Inc. had the following common stock record during the current calendar year.
Outstanding, beginning of year
Additional shares issued 6/30
Additional shares issued 9/30
2,000,000
100,000
100,000
A 10% stock dividend was paid on December 1. What is the number of shares to be used in computing basic EPS?
Multiple Choice
2,075,000.
2.620.000.
2,475,000.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Determine the Basic and Diluted Earnings Per Share for Company X.
Company X information for Diluted Shares calculations for period 201X: Earnings for Year 201X - $20 million Average Basic shares outstanding for Company X in 201X – 10 million Average Stock Price for year 201X - $6.00 Warrants to purchase common shares: - Warrants A to purchase 2 million shares ex @ $2.00 - Warrants B to purchase 3 million shares ex @ $5.00.
Assume the A and B Warrants are the only additional securities outstanding (besides the basic shares) for Company X in 201X.
arrow_forward
Information for Sabas Company
# Shares
Par Value
Cumulative
Preferred Stock
20,000
$100.00
1.5%
Common Stock
100,000
$50.00
N/A
Year 1
Year 2
Year 3
Total dividends paid
$12,000.00
$18,000.00
$90,000.00
Determine the dividends for each class of stock for each year and the dividends per
share for each class of stock for each year.
Description
Year 1
Year 2
Year 3
Total Distribution
Preferred Stock
Common Stock
Preferred dividends in Arrears
Dividends Per share
Preferred Stock
Common Stock
arrow_forward
Omniponent company had 100 000 ordinary shares issued and outstanding at January 1. During the current year, the entity also had the ordinary share transactions listed below:Apr 1 Issued 30 000 previously unissued sharesMay 1 Split the share 2-for-1Jun 30 Purchased 10 000 shares for the treasuryJul 30 Distributed a 20% bonus issueDec 31 Split the stock 3-for-1what is the weighted average number of shares for EPS purposes?a.288,000b.864,000c.882,000d.972,000
arrow_forward
a. P128.00
b. P129.70
c. P130.00
d. P131.70
e. answer not given
arrow_forward
Question 1
Car Co. reacquires for P15 per share, 1,000 of its P5 par value ordinary shares
previously issued at P12 per share. Subsequently, Car Co. reissued half of the
reacquired shares at P18 per share. What is the effect of the reacquisition of the
treasury shares on the following accounts?
Share premium - Decrease / Retained Earnings - Decrease
Share premium - Decrease / Retained Earnings - No effect
Share premium - No effect / Retained Earnings - No effect
Share premium - No effect / Retained Earnings - Decrease
Question 2
Share premium maybe increased in all f the following transaction except
retirement of shares below original issuance price
issuance of preference shares with detachable warrants
reissuance of treasury shares for more than the cost
issuance of stock rights to existing shareholders
Question 3
Which of the following statements is least likely to be correct when shares are
subscribed but not yet paid?
Share premium maybe increased
Total shareholder's equity may not…
arrow_forward
Answer with computation and explanation
X Company sold 1,000 ordinary shares at par of P20 per share for P50,000. The journal entry to record the transaction would have a
a credit to ordinary shares for P50,000.
b credit to share premium for P20,000
C. credit to ordinary shares of P20,000.
d. debit to share premium of P30,000
arrow_forward
Net Income Tk.25,00,000Preferred stock:50,000 shares outstanding Tk.100 par, 8%cumulative ,non-convertible
Tk.50,00,000Common stock; share outstanding, January 1, 7,50,000 sharesIssue for cash May,1 3,00,000 sharesAcquired treasury stock for cash, August,1 1,50,000 shares2 for 1 stock split, November,1Required: Compute earnings per share.
arrow_forward
Please help me
arrow_forward
Earnings Per Share Calculati ons
Informatlon Provlded:
Common Shares
Balance at the beginning of the ye ar
On July 1, the company sold an additional
5,000,000 shares
8,000,000 shares
Each share sold for
$3.00 and had a par value of $ 0.10
Preferrred Shares
Beginning of the Year
End of the Year
50,000
150,000
Dividends pald to Preferred Shareholders
Dividends pald to Common Sharehol ders
650, 000
1,000, 000
Ex ce pt from Income Statement
Income from Continuing Operations
22,000, 000
Income from Discontinued Ope rations (aftertaxImpact)
2,100, 000
Net Income
24,100, 000
Requlred:
Based on the Information provided above:
1 Prepare the Joumal entry to record the July 1 sale of shares
2 Calculate the welghted average common shares outstandi ng
3 Calculate e arnings pershare (as required).
Note: Show your detal led calaulatlons.
arrow_forward
Saved
Help
E11-22 (Algo) Analyzing Stock Dividends and Comparing to Stock Splits LO11-6
At the beginning of the year, the stockholders' equity section of the balance sheet of Solutions Corporation reflected the following
Common stock ($14 par value; 67,000 shares
authorized, 40,000 shares outstanding)
Additional paid-in capital
Retained earnings
$ 560,000
135,000
755,000
On February 1, the board of directors declared a 65 percent stock dividend to be issued April 30. The market value of the stock on
February 1 was $17 per share. The market value of the stock on April 30 was $18 per share.
Required:
1. For comparative purposes, prepare the Stockholders' Equity section of the balance sheet immediately before the stock dividend
immediately after the stock dividend.
SOLUTIONS CORPORATION
Balance Sheet (Partial)
At February 1, This Year
Stockholders' Equity
Before Stock Dividend After Stock Dividend
Cantrik..nd nital
10 of 10
Next
< Prey
arrow_forward
Problem 1. The stockholders' equity section of Kookie Co. revealed the following
information on December 31, 2022.
Preference stock, P50 par
Share premium – preference
Ordinary stock, P15 par
Share premium – ordinary
Subscribed ordinary stock
Retained earnings
2,300,000
805,000
5,250,000
2,750,000
150,000
1,900,000
400,000
Subscriptions receivable – ordinary (collectible next month)
Required: Answer the following questions with supporting computations:
1. How much is the legal capital?
2. How much is the total paid in capital?
3. What is the amount of the stockholders' equity on 12/31/2022?
4. How many preference shares were issued?
5. How many ordinary shares were subscribed?
arrow_forward
a. P25.00
b. P26.40
c. P27.20
d. P29.00
e. answer not given
arrow_forward
View Policies
Current Attempt in Progress
On January 1, Swifty Corporation had 71000 shares of $10 par value common stock outstanding. On June 17, the company declared
a 15% stock dividend to stockholders of record on June 20. Market value of the stock was $14 on June 17. The stock was distributed
on June 30. The entry to record the transaction of June 30 would include a
O debit to Common Stock Dividends Distributable for $149100.
O debit to Stock Dividends for $42600.
O credit to Paid-in Capital in Excess of Par for $42600.
O credit to Common Stock for $106500.
Save for Later
Attempts: 0 of 1 used
Submit Answer
arrow_forward
Beginning of the year is January 01, 2020
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- Acquirer Shares Outstanding Target Shares Outstanding Acquirer Share Price Target Share Price Stock Consideration Cash Consideration Share Issuance Discount Tax Rate 917,712 991,813 1,000,000 25,000 $5.00 $10.00 Given the following data, calculate the pro forma number of shares outstanding (Rounding to the closest whole number). 1,081,633 1,261,613 $400,000 $200,000 2% 25%arrow_forwardHelp Save & Exit Su Check y Dublin Inc. had the following common stock record during the current calendar year. Outstanding, beginning of year Additional shares issued 6/30 Additional shares issued 9/30 2,000,000 100,000 100,000 A 10% stock dividend was paid on December 1. What is the number of shares to be used in computing basic EPS? Multiple Choice 2,075,000. 2.620.000. 2,475,000.arrow_forwardPlease do not give solution in image format thankuarrow_forward
- Determine the Basic and Diluted Earnings Per Share for Company X. Company X information for Diluted Shares calculations for period 201X: Earnings for Year 201X - $20 million Average Basic shares outstanding for Company X in 201X – 10 million Average Stock Price for year 201X - $6.00 Warrants to purchase common shares: - Warrants A to purchase 2 million shares ex @ $2.00 - Warrants B to purchase 3 million shares ex @ $5.00. Assume the A and B Warrants are the only additional securities outstanding (besides the basic shares) for Company X in 201X.arrow_forwardInformation for Sabas Company # Shares Par Value Cumulative Preferred Stock 20,000 $100.00 1.5% Common Stock 100,000 $50.00 N/A Year 1 Year 2 Year 3 Total dividends paid $12,000.00 $18,000.00 $90,000.00 Determine the dividends for each class of stock for each year and the dividends per share for each class of stock for each year. Description Year 1 Year 2 Year 3 Total Distribution Preferred Stock Common Stock Preferred dividends in Arrears Dividends Per share Preferred Stock Common Stockarrow_forwardOmniponent company had 100 000 ordinary shares issued and outstanding at January 1. During the current year, the entity also had the ordinary share transactions listed below:Apr 1 Issued 30 000 previously unissued sharesMay 1 Split the share 2-for-1Jun 30 Purchased 10 000 shares for the treasuryJul 30 Distributed a 20% bonus issueDec 31 Split the stock 3-for-1what is the weighted average number of shares for EPS purposes?a.288,000b.864,000c.882,000d.972,000arrow_forward
- a. P128.00 b. P129.70 c. P130.00 d. P131.70 e. answer not givenarrow_forwardQuestion 1 Car Co. reacquires for P15 per share, 1,000 of its P5 par value ordinary shares previously issued at P12 per share. Subsequently, Car Co. reissued half of the reacquired shares at P18 per share. What is the effect of the reacquisition of the treasury shares on the following accounts? Share premium - Decrease / Retained Earnings - Decrease Share premium - Decrease / Retained Earnings - No effect Share premium - No effect / Retained Earnings - No effect Share premium - No effect / Retained Earnings - Decrease Question 2 Share premium maybe increased in all f the following transaction except retirement of shares below original issuance price issuance of preference shares with detachable warrants reissuance of treasury shares for more than the cost issuance of stock rights to existing shareholders Question 3 Which of the following statements is least likely to be correct when shares are subscribed but not yet paid? Share premium maybe increased Total shareholder's equity may not…arrow_forwardAnswer with computation and explanation X Company sold 1,000 ordinary shares at par of P20 per share for P50,000. The journal entry to record the transaction would have a a credit to ordinary shares for P50,000. b credit to share premium for P20,000 C. credit to ordinary shares of P20,000. d. debit to share premium of P30,000arrow_forward
- Net Income Tk.25,00,000Preferred stock:50,000 shares outstanding Tk.100 par, 8%cumulative ,non-convertible Tk.50,00,000Common stock; share outstanding, January 1, 7,50,000 sharesIssue for cash May,1 3,00,000 sharesAcquired treasury stock for cash, August,1 1,50,000 shares2 for 1 stock split, November,1Required: Compute earnings per share.arrow_forwardPlease help mearrow_forwardEarnings Per Share Calculati ons Informatlon Provlded: Common Shares Balance at the beginning of the ye ar On July 1, the company sold an additional 5,000,000 shares 8,000,000 shares Each share sold for $3.00 and had a par value of $ 0.10 Preferrred Shares Beginning of the Year End of the Year 50,000 150,000 Dividends pald to Preferred Shareholders Dividends pald to Common Sharehol ders 650, 000 1,000, 000 Ex ce pt from Income Statement Income from Continuing Operations 22,000, 000 Income from Discontinued Ope rations (aftertaxImpact) 2,100, 000 Net Income 24,100, 000 Requlred: Based on the Information provided above: 1 Prepare the Joumal entry to record the July 1 sale of shares 2 Calculate the welghted average common shares outstandi ng 3 Calculate e arnings pershare (as required). Note: Show your detal led calaulatlons.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning