Auswide case questions

Questions for Auswide:
1.) Record the representative transactions described in the case using the balance sheet equation. Use the tab labelled “BSE Template” in the file labelled ”Auswide Bank Exhibits.xlsx”
2.) Prepare a balance sheet for the fiscal year ended June 30, 2021 assuming that the representative transactions were the only ones that occurred during this fiscal year. Use the tab labelled “Bal Sheet” in the file labelled ”Auswide Bank Exhibits.xlsx”
3.) Calculate fiscal year 2021 net income assuming that the representative transactions were the only ones that occurred during this fiscal year. Hint: use the retained earnings equation.
4.) How much was the total change in cash during for the fiscal year ended June 30, 2021?