Create a formula in E$4$ that will calculate $($Purchases minus Payments minus Credits$)$ times $15\%$

Create a formula in $F4$ that will calculate Purchases minus Payments minus Credits plus Interest

Highlight the formulas in E$4$: F$4$ and use the Fill Handle to drag them down to E$8$:F$8$

Use Auto SUM to calculate the totals on B$9$:F$9$

Select A$1$ and under Cell Styles, make it a Title Cell, bold the font.

Select A$2$ and make the font $14$ points, blue $($blue grey text $2$ from the top row$)$ and italic

Select A$1$:A$2$ and apply an outside border and a light peach fill

Select A$3$:F$3$ and apply the Heading $3$ cell style and center the headings

Select A$9$:F$9$ and make it a Total Row cell style, make the font the same blue

Select B$4$:F$8$ and apply the Comma style to the data, select B$9$:F$9$ and apply the Accounting style

Change the Sheet Tab name to $1^{st}$ Quarter and change the tab colour to the same blue

Click on the Page Layout Ribbon, click Print Titles and click the Margins tab, center horizontally

Click the Header$/$Footer tab in the same window and click on Custom Footer. Using the image icons, put the date on the left, file name in the center and sheet tab name on the right.