Excel Growth Formulas for Sales Figures -- 2
Budget: $10 – $30 USD
I'm using Microsoft Excel to analyze my sales figures and I'm currently in need of assistance in enhancing this analysis. Specifically, I wish to add formulas which will calculate and clearly visualize a 20% growth over 5 years. Using the following data
Total current sales are $638,000 divided into the following categories:
o Office supplies: $150,000
o Office equipment: $300,000 o Technology classes: $138,000 o Printing: $50,000
• The company desires to increase sales by 20% per year in each category for the next five years.
• NHBP thinks that online sales will result in reaching its intended sales goals over the next five
years.
Here is what I am looking for:
Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.
For current sales, display sales by category and total.
For projected sales, display sales by category and total.
Apply formatting conventions appropriate for a business audience.
Select a consistent font and font size.
Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
Apply labels that identify the values contained in each row and column.
Apply formulas to calculate totals for current sales as well as projected sales.
Embed a bar chart that accurately displays the total sales for the current year.
Embed a bar chart that accurately displays the projected sales for the next five years.
Embed a line graph that accurately displays the projected sales growth over the next five years.
Total current sales are $638,000 divided into the following categories:
o Office supplies: $150,000
o Office equipment: $300,000 o Technology classes: $138,000 o Printing: $50,000
• The company desires to increase sales by 20% per year in each category for the next five years.
• NHBP thinks that online sales will result in reaching its intended sales goals over the next five
years.
Here is what I am looking for:
Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.
For current sales, display sales by category and total.
For projected sales, display sales by category and total.
Apply formatting conventions appropriate for a business audience.
Select a consistent font and font size.
Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
Apply labels that identify the values contained in each row and column.
Apply formulas to calculate totals for current sales as well as projected sales.
Embed a bar chart that accurately displays the total sales for the current year.
Embed a bar chart that accurately displays the projected sales for the next five years.
Embed a line graph that accurately displays the projected sales growth over the next five years.