Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sales determine your profitability and whether or not youll stay in business. Sales are also your estimate of how much youll have available to spend.

Sales determine your profitability and whether or not youll stay in business. Sales are also your estimate of how much youll have available to spend. Most products and services will require softer estimates. The sales forecast will also help you assess your capacity needed (and help you chose adequate space, etc.).

The projected sales number is going to be entered in LivePlan as the base for your financial projections.

Review the example provided with this assignment. This is just an example and is very specific to the assumptions for this business (Spirit Spa). Your projections should reflect your business and your assumptions and may look completely different than the example provided.

Make sure you use formulas and do not use a calculator to do this assignment. The whole point of using Excel is to have it do the work for you and allows you to easily change assumptions which will change all other related calculations on your sales projections. Also, your instructor can tell whether your calculations are correct just by looking at the formula, thereby eliminating the need to recalculate all of your numbers.

Directions:

1) Prepare your sales projections for three to five years in Excel. Before submitting your Excel spreadsheet for grading make sure you:

  • Check to see that you are not missing any formulas.
  • Format each cell with numbers to round up to the nearest dollar
  • Format all cells properly - $, %, column width, etc.
  • Format page layout properly for orientation, footers, gridlines, etc.
  • Format to print should not be more than two pages, one is more likely.

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

Step: 3

blur-text-image

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

Financial Accounting The Impact On Decision Makers

Authors: Gary A Porter, Curtis L Norton

7th Edition

1439080526, 9781439080528

More Books

Students also viewed these Finance questions

Question

=+7. Compare Walmarts new and old logos:

Answered: 1 week ago

Question

=+1. Why is it important to view CSR from a strategic context?

Answered: 1 week ago