Financial Spreadsheet Formatting
Title
The title should state:
Placement of $ signs
Number of Decimal Places
Normal vs. Bold vs. Italics
You should use bold text for:
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
The title should state:
- (who) Company Name
- (what) Statement Name
- (when) Statement Date
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
Layout
Correctness
Common errors
- 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 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:
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 Total Units Sold and the Total Sold per Week
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.
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.