1 Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Record Stock Entries Student Work Area...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Record Stock Entries Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. 4 5 On May 10, Pilar Corporation issues common stock for cash. 6 7 Shares of stock issued 2,500 8 Par value per share 5.00 9 Amount at which stock issued $ 13.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 Cash 32,500 12,500 20,000 13 Common Stock Paid-in Capital in Excess of Par - Common Stock 14 15 1 Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Record Stock Entries Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. 4 5 On May 10, Pilar Corporation issues common stock for cash. 6 7 Shares of stock issued 2,500 8 Par value per share 5.00 9 Amount at which stock issued $ 13.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 Cash 32,500 12,500 20,000 13 Common Stock Paid-in Capital in Excess of Par - Common Stock 14 15
Expert Answer:
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date:
Students also viewed these finance questions
-
Select [ Export ] from the drop down [File] menu to create an Excel worksheet of the General Fund post-closing trial balance as of December 31, 2020. Use Excel to prepare in good form a balance sheet...
-
Choose appropriate phrases from the drop down boxes below to complete the explanation of shifts of an aggregate demand curve and movements along aggregate demand curves. When the price level in the...
-
On May 10, Pilar Corporation issues 2,500 shares of $5 par value common stock for cash at $13 per share. Journalize the issuance of the stock.
-
Samples of size n = 5 are collected from a process every half hour. After 50 samples have been collected, we calculate. x = 20.0 and s 1.5. Assume that both charts exhibit control and that the...
-
What are three tasks of the fixed asset system?
-
Given that x is a hyper geometric random variable, compute p(x) for each of the following cases: a. N = 5, n = 3, r = 3, x = 1 b. N = 9, n = 5, r = 3, x = 3 c. N = 4, n = 2, r = 2, x = 2 d. N = 4, n...
-
Better Health Inc. is a health care provider which has clinics across the U.S. Indicate whether each of the following examples of benchmarking for Better Health is considered (1) internal...
-
1. If the variable cost per unit goes up, Contribution margin Break-even point a. Increases increases. b. Increases decreases. c. Decreases decreases. d. Decreases increases. e. Decreases remains...
-
Required: 1. Prepare a differential analysis at of hily 1 presenting the proposed operation of the warehouse for the 16 years (Alternative 1) as compared with investing in US Treasury bonds...
-
Angela Care Homes Ltd. (Angela) operates 14 care homes for people suffering with mental illness in Western Canada. It hopes to expand to Eastern Canada over the next few years and is considering...
-
You have been hired by a small publisher to create a dictionary to hold their client's name and telephone number. The publisher does not need anything fancy; they just want a dictionary that will...
-
1. (10 pts) Factor out the GCF and simplify the result: 5 3 4x(x+3)-2x(x+3) 2. (10 pts) Simplify completely. 3x 3y y x yx
-
Use what you need of the following set of information to answer questions 1 through 10: S0 = $1.1138/ S0 = 0.7620/$ S0 = $1.3123/ E (S1 (3-months)) = $1.0840/ F3-months = $1.1580/ Where: = euro; =...
-
An investor identifies three factors affecting the share price of company A. The data with regard to the factors are as follows: Risk factorsensitivity to factor X return rate from factor X 10,71,5%...
-
i) Northern Track is developing a special vehicle for Arctic exploration. The development requires investments [outlays] of $50,000 in year 1, $40,000 in year 2, and $30,000 in year 3. Net returns...
-
How will you detect and prevent the frauds related to the embezzlement of cash? Please provide a detailed and outlined/structured answer.
-
The Read-Write disk of a Personal Computer (PC) is "d" cm thick with radius "R" cm, and mass "M" gram. Due to the ball-bearings, the friction coefficient is "B" kg-m/sec, which causes the friction...
-
Write electron configurations for the following ions, and determine which have noble-gas configurations: (a) Cd2+ (b) p3- (c) Zr4+ (d) Ru3+ (e) As3- (f) Ag+
-
How are the data collected in the Required Accounts window used?
-
How can a company improve its average number of days sales in merchandise inventory ratio?
-
Describe the process for deleting a general journal entry.
-
A cost sheet and partial finished goods ledger card for Leather Originals, a manufacturer of leather furniture, are provided in the Working Papers. Work independently to complete the following...
-
Krasnoy Tire, a maker of tires for cars, trucks, and tractors, is trying to determine how to account for various factory costs. The costs include the following: a. Wages earned by a factory...
-
Wilmington, Inc., manufactures heating systems. The company maintains a materials ledger for all direct materials. Instructions: 1. Prepare a materials ledger card for T-5 thermostats. The thermostat...
Study smarter with the SolutionInn App