Question: Using the template, you will insert your sales, and then you will subtract your major expenses (remember, these are all just guesses, or projections). The

Using the template, you will insert your sales, and then you will subtract your major expenses (remember, these are all just guesses, or projections). The template will do the math for you by subtracting the expenses from the sales for a net profit before taxes. This is a simple profit and loss statement. There is more to a real one than can be seen in your work here, but it is a start to being able to understand one of the ways to analyze your finances for a months time. You do not need to submit or share your spreadsheet, but make sure to refer to it as you respond to the following:

  • What are some of the main discoveries you made about your businesss monthly profit and loss potential as you completed the spreadsheet?
  • What questions do financial ratios help answer about a firms financial performance? What ratios might be of more interest to certain stakeholders and why?
 Using the template, you will insert your sales, and then you

Unit 9 Assignment Spreadsheet Month 1 Revenue Number of customers Average price Total Revenue | Expenses Inventory costs Advertising Bad Debt Expense Bank Charges Depreciation & Amortization Dues & Subscriptions Insurance Licenses & Fees Marketing & Promotion Meals & Entertainment Miscellaneous Office Expense Office Supplies Outside Services Payroll Expenses Salaries & Wages Payroll Taxes Benefits Professional Fees Property Taxes Rent Repairs & Maintenance Shipping & Delivery Telephone Training & Development Travel Utilities Vehicle Other Other Other Total Expenses Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!