Please show all work in excel

Amazon has 250,000 shares authorized 225,000 issued and 215,000 shares outstanding of $3 par value Debit Walmart issues $1,500,000 of 20-year bonds on 1/1/20 that pay 2% on a semiannual basis each June Google issues $2.000.000 of 10-year bonds on 1/1/20 that pay 8% on a annual basis each December