Embed
Email

Practice Excel Spreadsheet

Document Sample
Practice        Excel Spreadsheet
REVENUE April May June

Catalog Sales 3000 3300 3600

Internet Sales 3500 3900 4300

Total Sales



EXPENSES

COGS 1600 1600 1600

Salaries 1700 1700 1700

Rent and Utilities 1000 1000 1000

Office Supplies 600 600 600

Total Expenses



NET PROFIT

Tax Rate

16.2%



Name Salary Taxes

Mike $ 32,500 $ 5,265

Tony $ 40,000

Tracy $ 55,000

REVENUE July August September

Catalog Sales 3800 4200 4600

Internet Sales 4000 4700 5400

Total Sales 7800 8900 10000



EXPENSES

COGS 1600 1600 1600

Salaries 1700 1700 1700

Rent and Utilities 1000 1000 1000

Office Supplies 600 600 600

Total Expenses 4900 4900 4900



NET PROFIT 2900 4000 5100


Related docs
Other docs by ChrisPotter
.doc[401]
Views: 4  |  Downloads: 0
UPP 507 Computers Topics in Urban Planning
Views: 2  |  Downloads: 0
Overview of the Autonomic Nervous System
Views: 61  |  Downloads: 7
Lease Accounting Separating Myth from Reality
Views: 8  |  Downloads: 0
Recommendation forms
Views: 106  |  Downloads: 0
Graduate Student Council.pdf
Views: 12  |  Downloads: 0
Lail Presentation
Views: 4  |  Downloads: 0
Special Request Only
Views: 1  |  Downloads: 0
CHS New Student Instruction Sheet
Views: 16  |  Downloads: 0
Chapter 28
Views: 2  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!