Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 1 - The Financial Pressure

Authors: Kate Mooney

2nd Edition

0071719237, 9780071719230

More Books

Students also viewed these Accounting questions