Please help with completing this spreadsheet. If someone has excel, I am having a hard time with this. I could use an explanation to how its done as well to help me understand this assignment as well

PART A: Strand Corp has 200,000 shares of $5 par Common Stock authorized and 100,000 shares of $15 par Prefreed Stock authorized Using the Balance Sheet Equation below, account for the folloiwng transactions: LIABILITIES ASSETS Cash EQUITY- Common Stock APIC-Comm Stk. Preferred Stock APIC-Pref Stk Retained Earnings revenues exps) (dividends) on Jan 5, Strand sells 10,000 shares of its Preferred Stock for $55/share On March 10, Strand sells 25,000 shares of its Common Stock for $17/share On June 15, Strand sells 30,000 shares of its Common Stock for $22/share On Aug 29, Strand issues 32,000 shares of its Preferred Stock for $63/share On Dec 2, Strand issues 50,000 shares of its Common Stock for $31/share Totals $0 $0 $0 $0 $0 $0 $0 $0 $0 Assets $0 Labs - $0 Equity $0 PART B: Prepare Strand's Stockholders' Equity section: STOCKHOLDERS' EQUITY #2 PART A: Using the Balance Sheet Equation below, account for the folloiwng transactions: ASSETS Cash Example Balances $500 000 Lisbilities + -EQUITY..... Common Stock APIC-Comm Stk Preferred Stock APIC-Pref Stk Treasury Stock APIC-treas stk Retained Earnings $100,000 $125,000 $200,000 $75,000 revenues exps) dividends Assume Strand decides to Buy Back 1,500 shares of its Common Stock for $8./share Strand later re-issues 1,000 shares of the stock it bought back at $9/share TOTALS $500,000 $100,000 $125,000 $200,000 $75,000 $0 $0 $0 $0 $0 Assets $500.000 Lisbs - $0 Equity $500,000 PART B: Prepare Strand's Stockholders' Equity section: STOCKHOLDERS' EQUITY