1. Using a Excel Spreadsheet, show the effect of each of the transactions during the first year of operations (Items 1-15) on PI's balance sheet. Use the amounts from the pre-launch balance sheet to fill in the "Opening Balances" of the accounts on the worksheet. Note that in the worksheet, the retained earnings account is used to reflect all operating and dividend declarations. Note that in the worksheet, the retained earnings account is used to reflect all operating and dividend declarations