## Financial Spreadsheet Formatting

**Title**

The title should state:

- (who) Company Name
- (what) Statement Name
- (when) Statement Date

Placement of $ signs

Placement of $ signs

- in general, display the currency sign (i.e. ‘$’ ) only at the very top and very bottom of each column of a the financial spreadsheet.
- in some cases, the currency symbol is also at the bottom of major sections.

**Number of Decimal Places**

- when the units involved are dollars ($), often either 2 or no decimal places are used, depending on the situation.
- when percentages are involved, zero to 2 decimal places are used, depending on the situation.

**Normal vs. Bold vs.**

*Italics*You should use

**bold text**for:

- Important section summaries or titles (Total Revenue, Net Income, Total Assets, etc.).
- Dates at the top of your spreadsheet.
- Sometimes, you will use bold for the entire column of the most recent year’s historical financial data

*Italics*are mainly for percentages and changes over time.

**Most the Data will be Normal Text**

Everything else in your financial models should just be set to normal font weight

(i.e.non-bold, non-italicized).

*Source*

## Tips and Suggestions

**Flexibility**

- If possible, enter numbers only once.
- Enter constants in a cell and use
**absolute cell addressing**to reference its value. This will allow you to change the value once and without the need to re-enter the formula on the spreadsheet.

**Layout**

- Minimize the number of empty columns.
- Adjust the column widths to add the spacing you need

**Correctness**

- Enter your formulas once, copy and paste as required
- Make sure your numbers are reasonable.
- Remember the rules of BEDMAS

**Common errors**

- Entering a percent incorrectly.
- Misplaced or forgotten brackets in formulae.
- Not including all values required in the formula.
- Entering formatting characters like % or $

## Format SSCommission

Add formatting to your Panther Boutique spreadsheet, as shown in the spreadsheet below

The new formula in the spreadsheet will

The count function works like the sum function, but only counts the number of non-empty cells in a range.

Hint: a person can only earn commission during a shift.

Also add, as shown:

**count**the number of shifts.The count function works like the sum function, but only counts the number of non-empty cells in a range.

Hint: a person can only earn commission during a shift.

Also add, as shown:

- bold face font
- borders
- format to include $ (currency)
- format to include , (financial)
- adjust the number of decimals

## Task SSChocolate

Use you new skills to complete the following spreadsheet:

You should be able to enter the formulas for

Other Formulas:

Careful, you will need to follow the correct order of operations (BEDMAS) or you formula will not calculate the correct result. This formula will also need to use absolute cell addressing to access the

Format the spreadsheet as shown, all numbers that represent currency, include 2 decimal places.

**Total Units Sold**and the**Total Sold per Wee****k**Other Formulas:

**Sales (in Dollars):****Total Units Sold**times**Unit Selling Price****Profit (in Dollars):**multiply the**(**difference between**Unit Selling price**and**Unit Cost )**by**Total Units Sold**Careful, you will need to follow the correct order of operations (BEDMAS) or you formula will not calculate the correct result. This formula will also need to use absolute cell addressing to access the

**Unit Selling Price**Format the spreadsheet as shown, all numbers that represent currency, include 2 decimal places.