Homework Excel

Excel Assignment 1
1.
Create a projected profits worksheet using the template available in D2L under the content tab entitled Excel 
Assignment 1 Template.
2.
Bold all text in column A.
3.
Under the Assumptions
table enter:
10% for Gross Sales Increase
5% for Wages Increase
5% for Cost of Goods 
2% for Advertising Increase
in column B next to each category and format as percent with 1 decimal place.
4.
This projected profits worksheet 
covers a 
5 year
period
so 
in
cell C10 enter the year 2021.
Then
copy cells B10 
and C10 to cells
D10, E10, and F10 respectively.
Used what you learned in the Excel tutorials so you end up with 
the years 2020 

2024 as column headings in row 10.
5.
In cell B15, calculate Total Income (use the sum function).
F
o
r
m
a
t
a
s
c
u
r
r
e
n
c
y
w
i
t
h
2
d
e
c
i
m
a
l
p
l
a
c
e
s
6.
In cell B24, calculate Total Expenses (use the sum function).
Format as currency with 2 decimal places
7.
In cell B26 calculate Net profit which is Total income minus Total expenses.
Format as currency with 2 decima

places
8.
Gross Sales are predicted to increase by 10% per year for the next 4 year
s
.
In cell C12
c
alculate projected Gross 
Sales
.
Use absolute cell referencing and the percentage Gross Sales Increase from the Assumptions Table to 
calculate the project
ed Gross Sales for 2022.  Do not use the actual percentage (10
%
)
in the formula.  Instead 
use the cell address where the Gross Sales Increase is stored in the table.  
T
hen copy the formula to the 
remaining year columns.
Adjust column widths as necessary to properly display data.
9.
Sales incentives are not expected to increase so just copy the 5,000 in
cell B13 to the remaining year
columns
.
10
.
Similar to what you did in #8 above, calculate projected Wages, Cost of Goods Sold, and Advertising for the years 
2021, 2022, 2023, and 2024.  
Format as number with commas and 2 decimal points.
Use absolute cell 
referencing and percent increase 
from the Assumptions Table.
11.
Rent and Supplies are not expected to increase so just copy to 2020 numbers to the remaining year columns.
1
2
.
Copy the formulas for Total Income, Total Expenses, and Net Profit to the columns for the years 2021, 2022, 
202
3, and 2024.  
Format as currency with 2 decimal places.
1
3
.
Create a line chart that graphs Total Income, Total Expenses, and Net Profit for the years 2020 

2024.
Place the 
chart just below the Net Profit row.  
Add a chart title “Projected Profits” and make sure the legend correctly 
identifies
the chart lines as Total Income, Total Expenses, and Net Profit.
1
4
.
Put your name 
at the top of the spreadsheet
.
1
5
.
Save the file with your last name and first name as the file name.  Using the name John Smith as an example, the 
Excel file name would 
be SmithJohn.xlsx.  
Upload your Excel file to the 
D2L 
Dropbox for Excel assignment 1 by 
the due date listed in your calendar and the dropbox

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Order your essay today and save 25% with the discount code: COCONUTPlace Order
+