1. Stock Watcher Mark Martin has created a basic stock watcher worksheet that he uses to report on gains or losses from when he purchased the stock and the last recorded date and price. Mark has given you a snapshot of his spreadsheet (see Figure T2.20) that you can use to re- create this spreadsheet for yourself. Here are some basic steps to follow: 1. Create a new workbook. 2 . Enter all the information provided in Figure T2.20 . 3. Apply the Currency format to the respective columns. 4. The date should be entered as a function. Hint: Use the NOW function. 5. Enter a formula for the Gain/Loss (%) column. Hint: You should subtract the Last column from the Purchase column, and then divide by the Purchase column. 6 . Format for percent in the Gain/Loss (%) column.
1. Stock Watcher Mark Martin has created a basic stock watcher worksheet that he uses to report on gains or losses from when he purchased the stock and the last recorded date and price. Mark has given you a snapshot of his spreadsheet (see Figure T2.20) that you can use to re- create this spreadsheet for yourself. Here are some basic steps to follow: 1. Create a new workbook. 2 . Enter all the information provided in Figure T2.20 . 3. Apply the Currency format to the respective columns. 4. The date should be entered as a function. Hint: Use the NOW function. 5. Enter a formula for the Gain/Loss (%) column. Hint: You should subtract the Last column from the Purchase column, and then divide by the Purchase column. 6 . Format for percent in the Gain/Loss (%) column.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
1. Stock Watcher
Mark Martin has created a basic stock watcher worksheet that he uses to report on gains
or losses from when he purchased the stock and the last recorded date and price. Mark
has given you a snapshot of his spreadsheet (see Figure T2.20) that you can use to re-
create this spreadsheet for yourself. Here are some basic steps to follow:
1. Create a new workbook.
2 . Enter all the information provided in Figure T2.20 .
3. Apply the Currency format to the respective columns.
4. The date should be entered as a function. Hint: Use the NOW function.
5. Enter a formula for the Gain/Loss (%) column. Hint: You should subtract the Last column
from the Purchase column, and then divide by the Purchase column.
6 . Format for percent in the Gain/Loss (%) column.
Transcribed Image Text:FIGURE T2.20
Stock Watcher Data
欧日 S
FILE
Paste
C16
HOME
10
11
Cut
Copy
Format Painter
Clipboard
12
13
INSERT
#
T
X
8
9 XYZ Steel
Arial
PAGE LAYOUT
A
1 Stock Watcher
✓ fx
2
3
Company
4
ABC Truck Parts
5 Tasty Juice, Inc.
6 FastChips Memory
7 Internet Celebration
Bouncy Balls, Ltd
BIU---A-
Font
FORMULAS DATA
10A A
B
T
Ticker
abct
juce
fchp
webc
bbbb
xstl
==
REVIEW VIEW
2.
Alignment
C
Wrap Text
Merge & Center -
D
15
General
$%9
Purchase
Last
$ 25.00 $ 27.50
$
$
7.50 $ 7.50
67.00 $ 39.50
12.50 $ 75.00
$
$
$
18.00 $ 19.50
38.00 $ 47.00
Number
EZ Normal
€0.00 Conditional Format as Check Cell
Formatting Table
E
Г
T2 StockWatcher_Solution - Excel
Date
1/29/2014
1/29/2014
1/29/2014
1/29/2014
1/29/2014
1/29/2014
F
Gain/Loss (%)
10.0%
0.0%
-41.0%
500.0%
8.3%
23.7%
Bad
Explai
G
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education