Investment Analytics on excel

Please complete this excel assignment on Investment Analytics attached is two excel files one is the the question and the other one is an example of the question.
investment_analytics_quiznos_student_2.xls

investment_analytics_quiznos_readonly.xls

Don't use plagiarized sources. Get Your Custom Essay on
Investment Analytics on excel
Just from $13/Page
Order Essay

Unformatted Attachment Preview

Quiznos Franchise Feasibility Estimate
Conservative
Estimate
Optimistic
Estimate
MONTHLY EARNINGS / SALES (GROSS)
7% royalty
1% local ad
3% national ad
20% labor
29% Food cost
3% paper
0.3% Accounting/payroll
10% rent
2.75% insurance
5% repay Small Business loan
4.5% misc bills
0.5% spoilage
1% supplies
1% promo food (give aways)
1% comp food (complimentary)
2.9% credit card fees
.4% coupons (discounts)
.5% food waste
Monthly income (NET)
Yearly income (NET)
*You must get Monthly Earnings / Sales first, before you can do any
Go to ‘Gross Sales’ Tab
(To get this, See Gross Sales Tab for Breakdown)
(Keep Labor Cost at this level, see Labor Cost Tab for Breakdown)
Sales first, before you can do any calculations.
Conservative Estimate
Price
Each
Projected
Sales (Units)
Sandwiches
Steak and Cheddar
Pepercorn Steak
Black Angus Steak
Mesquite Chicken
Carbonara Chicken
Southwest Chicken
Honey Bacon
Turkey Chipotle
6,25
6,25
6,75
6,15
5,75
5,75
6,15
5,75
Soup
Broccolli Cheese
Chicken Noodle
Bean and Tomato Soup
3,75
3,75
3,75
Breakfast Sandwich
Bacon and Cheese
Bacon and Eggs
Ham and Cheese
5,25
4,95
4,95
Drinks
Soft drinks
Coffee
Juice
1,95
2,5
2,25
PROJECTED SALES
Projected
Sales ($)
Optimistic Estimate
Price
Each
Projected
Sales (Units)
Sandwiches
Steak and Cheddar
Pepercorn Steak
Black Angus Steak
Mesquite Chicken
Carbonara Chicken
Southwest Chicken
Honey Bacon
Turkey Chipotle
6,25
6,25
6,75
6,2
5,75
5,75
6,15
5,95
Soup
Broccolli Cheese
Chicken Noodle
Bean and Tomato Soup
3,75
3,75
3,75
Breakfast Sandwich
Bacon and Cheese
Bacon and Eggs
Ham and Cheese
5,25
4,95
4,95
Drinks
Soft drinks
Coffee
Juice
1,95
2,5
2,25
PROJECTED SALES
Projected
Sales ($)
$

Labor Budget (Conservative)
1)
2)
3)
4)
5)
Get this number from the Quiznos B
Manager
Food Preparer
Food Preparer
Merchandizer
Delivery Man
5 Person Staff
Benefits:
Pay 50% of Health Insurance ($250/person)
TOTAL
Budget Excess
Labor Budget (Optimistic)
1)
2)
3)
4)
5)
6)
Manager
Food Preparer 1
Food Preparer 2
Merchandizer
Delivery Man 2
Delivery Man 2
6 Person Staff
Benefits:
10% Retirement Contribution
Pay 50% Health Insurance ($250/person)
TOTAL
Budget Excess
Get this number from the Quiznos B
umber from the Quiznos Budget Tab (use a formula, don’t just type in a number)
umber from the Quiznos Budget Tab (use a formula, don’t just type in a number)
Quiznos Franchise Feasibility Estimate
MONTHLY EARNINGS / SALES (GROSS)
7% royalty
1% local ad
3% national ad
20% labor
29% Food cost
3% paper
0.3% Accounting/payroll
10% rent
2.75% insurance
5% repay Small Business loan
4.5% misc bills
0.5% spoilage
1% supplies
1% promo food (give aways)
1% comp food (complimentary)
2.9% credit card fees
.4% coupons (discounts)
.5% food waste
Monthly income (NET)
Yearly income (NET)
Conservative
Estimate
$
67.732,50
$
(4.741,28)
$
(677,33)
$
(2.031,98)
$
(13.546,50)
$
(19.642,43)
$
(2.031,98)
$
(203,20)
$
(6.773,25)
$
(1.862,64)
$
(3.386,63)
$
(3.047,96)
$
(338,66)
$
(677,33)
$
(677,33)
$
(677,33)
$
(1.964,24)
$
(270,93)
$
(338,66)
$
4.842,87
$
58.114,49
Optimistic
Estimate
$
81.800,00
$
(5.726,00)
$
(818,00)
$
(2.454,00)
$
(16.360,00)
$
(23.722,00)
$
(2.454,00)
$
(245,40)
$
(8.180,00)
$
(2.249,50)
$
(4.090,00)
$
(3.681,00)
$
(409,00)
$
(818,00)
$
(818,00)
$
(818,00)
$
(2.372,20)
$
(327,20)
$
(409,00)
$
5.848,70
$
70.184,40
*You must get Monthly Earnings / Sales first, before you can do any
Go to ‘Gross Sales’ Tab
(To get this, See Gross Sales Tab for Breakdown)
(Keep Labor Cost at this level, see Labor Cost Tab for Breakdown)
Sales first, before you can do any calculations.
Conservative Estimate
Price
Each
Projected
Sales (Units)
Projected
Sales ($)
Sandwiches
Steak and Cheddar
Pepercorn Steak
Black Angus Steak
Mesquite Chicken
Carbonara Chicken
Southwest Chicken
Honey Bacon
Turkey Chipotle
6,25
6,25
6,75
6,15
5,75
5,75
6,15
5,75
1000
800
700
800
500
800
800
700
6250
5000
4725
4920
2875
4600
4920
4025
Soup
Broccolli Cheese
Chicken Noodle
Bean and Tomato Soup
3,75
3,75
3,75
600
700
500
2250
2625
1875
Breakfast Sandwich
Bacon and Cheese
Bacon and Eggs
Ham and Cheese
5,25
4,95
4,95
500
600
550
2625
2970
2722,5
Drinks
Soft drinks
Coffee
Juice
1,95
2,5
2,25
3000
2000
2000
5850
5000
4500
PROJECTED SALES
$ 67.732,50
Optimistic Estimate
Price
Each
Projected
Sales (Units)
Projected
Sales ($)
Sandwiches
Steak and Cheddar
Pepercorn Steak
Black Angus Steak
Mesquite Chicken
Carbonara Chicken
Southwest Chicken
Honey Bacon
Turkey Chipotle
6,25
6,25
6,75
6,2
5,75
5,75
6,15
5,95
1200
1000
900
700
700
800
1000
600
7500
6250
6075
4340
4025
4600
6150
3570
Soup
Broccolli Cheese
Chicken Noodle
Bean and Tomato Soup
3,75
3,75
3,75
800
800
700
3000
3000
2625
Breakfast Sandwich
Bacon and Cheese
Bacon and Eggs
Ham and Cheese
5,25
4,95
4,95
700
500
700
3675
2475
3465
Drinks
Soft drinks
Coffee
Juice
1,95
2,5
2,25
4000
3500
2000
7800
8750
4500
PROJECTED SALES
$
81.800,00
Labor Budget (Conservative)
1)
2)
3)
4)
5)
$ 13.546,50
Manager
Food Preparer
Food Preparer
Merchandizer
Delivery Man
2500
2000
2000
1800
1200
9500
5 Person Staff
Benefits:
Pay 50% of Health Insurance ($250/person)
TOTAL
Budget Excess
$
Labor Budget (Optimistic)
$ 16.360,00
1)
2)
3)
4)
5)
6)
Manager
Food Preparer 1
Food Preparer 2
Merchandizer
Delivery Man 2
Delivery Man 2
1250
10750
2.796,50
2500
2000
2000
1800
1200
1200
10700
6 Person Staff
Benefits:
10% Retirement Contribution
Pay 50% Health Insurance ($250/person)
TOTAL
Budget Excess
Get this number from the Quiznos B
$
1070
1500
13270
3.090,00
Get this number from the Quiznos B
umber from the Quiznos Budget Tab
umber from the Quiznos Budget Tab

Purchase answer to see full
attachment

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 15% with the discount code ESSAYHELP