1 Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Record Stock Entries Student Work Area...

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

Answer rating: 100% (QA)

Journalize the issuance of t... View the full answer