Question: 1 Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Record Stock Entries Student Work Area PROBLEM Required: Provide input into cells shaded in

1 Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Record Stock

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

Step by Step Solution

★★★★★

3.49 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Journalize the issuance of t... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

62612871c2237_92635.xlsx

300 KBs Excel File

Students Have Also Explored These Related 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.

Matching Definitions with Balance SheetRelated Terms Following are terms related to the balance sheet that were discussed in Chapters 2 through 5. Match each definition with its related term by...

U nder Scenario 2, the intrinsic value per share of the equity of Amersheen is closest to: A. R13.29. B. R15.57. C. R16.31. Mangoba Nkomo, CFA, a senior equity analyst with Robertson-Butler...

Recording Transactions (Including Adjusting and Closing Entries), Preparing a Complete Set of Financial Statements, and Performing Ratio Analysis Josh and Kelly McKay began operations of their...

Elam Enterprises is considering the following three actions regarding its equity: Action 1: Declaring a 30% stock dividend. Action 2: Declaring a $12,000 cash dividend. Action 3: Declaring a 2-for-1...

The stockholders equity section of OVear Corporation consists of common stock ($10 par) $2,000,000 and retained earnings $500,000. A 10% stock dividend (20,000 shares) is declared when the market...

The stockholders equity section of Jumes Corporations balance sheet consists of common stock ($8 par) $1,000,000 and retained earnings $300,000. A 10% stock dividend (12,500 shares) is declared when...

The stockholders equity section of Platt Corporations balance sheet consists of common stock ($10 par) $1,000,000 and retained earnings $300,000. A 10% stock dividend (10,000 shares) is declared when...

Labor trends were recently studied using a survey of respondents who were either unemployed (A) or employed (B). The survey results revealed that among those surveyed, 70% of those currently...

Consider the following series (i) Show that the series converges if (a, b), where a = = (ii) For any I in the above interval the sum of the series is 00 (2x+3)" n=2 2n+1

1. If a generator costing $300k is installed in a factory and the cost of preparing the site is $100k, what would be the QE (qualifying expenditure) for the factory? Korea Manufacturing purchased a...

With the communication device pointed toward your home planet, you realize, to your dismay, that the cords have been disconnected from the device. "Computer, how do I plug in these cables", you ask....

Linda intends to adopt the differentiation strategy for her new caf business in Singapore. What actions do you think Linda should take to make the strategy work and why? What do you think are the key...

Rockfest, an annual concert put on by Hard Rock. The concert lasts for 13 hours and is attended by over 100,000 fans. Planning for the event begins nine months ahead of time. Microsoft Project is...

Suppose that today's date is April 15, A bond with a 8% coupon paid semiannually every January 15 and July 15 is listed in The Wall Street Journal as selling at an ask price of 1,012.000. If you buy...

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.

The brine used in an industrial process is 12.5% salt by weight. What is the ratio (by weights) of salt to water in the brine?

A provincial government budget forecasts expenditures of $1.56 billion on education, $1.365 billion on health services, and $975 million on social services. Express the three budget items as a ratio.

Express the following ratios as an equivalent ratio whose smallest term is 1. Maintain three-figure accuracy.