Example.xlsx

proj

New Focus Consulting

Projection Format

Sale % increase: Sale % increase: Sale % increase: Sale % increase: Sale % increase:

Projections 20% 5% 5% 5% 5%

Inflation Factor: Inflation Factor: Inflation Factor: Inflation Factor: Inflation Factor:

4% 5% 6% 6% 6%

Base Period(Budget) Period 1 Period 2 Period 3 Period 4 Period 5

Revenues 3,360,000 4,032,000 4,233,600 4,445,280 4,667,544 4,900,921

3,360,000 4,032,000 4,233,600 4,445,280 4,667,544 4,900,921

Direct Expenses:

cost of goods sold 2,520,000 75% 2,620,800 65% 2,751,840 65% 2,916,950 66% 3,091,967 66% 3,277,485 67%

Gross Margin 840,000 25% 1,411,200 35% 1,481,760 35% 1,528,330 34% 1,575,577 34% 1,623,436 33%

Non-Direct Expenses

non-direct salaries 127,500 132,600 139,230 147,584 156,439 165,825

additional staffing

taxes & benefits – 0 – 0 – 0 – 0 – 0 – 0

insurances – 0 – 0 – 0 – 0 – 0 – 0

occupancy costs 110,000 114,400 120,120 127,327 134,967 143,065

additional space needs

consultants 4,000 4,160 4,368 4,630 4,908 5,202

marketing – 0 – 0 – 0 – 0 – 0 – 0

reproduction – 0 – 0 – 0 – 0 – 0 – 0

supplies 1,200 1,248 1,310 1,389 1,472 1,561

cleaning – 0 – 0 – 0 – 0 – 0 – 0

phones & utilities 11,000 11,440 12,012 12,733 13,497 14,306

auto expense 16,000 16,640 17,472 18,520 19,632 20,809

travel and entertainment – 0 – 0 – 0 – 0 – 0 – 0

dues and subscriptions – 0 – 0 – 0 – 0 – 0 – 0

education/training 7,500 7,800 8,190 8,681 9,202 9,754

computer expense – 0 – 0 – 0 – 0 – 0 – 0

service fees – 0 – 0 – 0 – 0 – 0 – 0

interest expense 8,000 8,320 8,736 9,260 9,816 10,405

corporate allocations – 0 – 0 – 0 – 0 – 0 – 0

depreciation 30,000 31,200 32,760 34,726 36,809 39,018

Total Non-Direct Expenses 315,200 9% 327,808 8% 344,198 8% 364,850 8% 386,741 8% 409,946 8%

Net Income(Loss) 524,800 16% 1,083,392 27% 1,137,562 27% 1,163,479 26% 1,188,835 25% 1,213,490 25%

New Focus Consulting
2006

Budget & cash flow

accountant 65000 New Focus Consulting

HR 60000 Budget

Facilities(cleaning) 45000

no sales staff $ from profit, no staff

Jan Feb March April May June July Aug Sept Oct Nov Dec Total

Revenues – 0 – 0 – 0 – 0 420,000 420,000 420,000 420,000 420,000 420,000 420,000 420,000 3,360,000 0.0

Direct Expenses:

cost of goods sold – 0 – 0 – 0 280,000 280,000 280,000 280,000 280,000 280,000 280,000 280,000 280,000 2,520,000 75%

Gross Margin – 0 – 0 – 0 (280,000) 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 840,000 25%

Non-Direct Expenses

non-direct salaries – 0 – 0 – 0 14,167 14,167 14,167 14,167 14,167 14,167 14,167 14,167 14,167 127,500

taxes & benefits ??? – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

insurances ??? – 0 – 0 – 0 – 0 – 0

occupancy costs – 0 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 110,000

consultants attorney 2,000 2,000 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 4,000

marketing do yourself – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

reproduction – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

supplies 100 100 100 100 100 100 100 100 100 100 100 100 1,200

cleaning – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

phones & utilities – 0 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 11,000

delivery service – 0 – 0 – 0 – 0 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 16,000

travel and entertainment – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

dues and subscriptions – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

education/training – 0 – 0 5,000 2,500 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 7,500

computer expense – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

service fees – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

interest expense 667 667 667 667 667 667 667 667 667 667 667 667 8,000

corporate allocations – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

depreciation 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000

Total Non-Direct Expenses 5,267 16,267 19,267 30,933 30,433 30,433 30,433 30,433 30,433 30,433 30,433 30,433 315,200

Net Income(Loss) (5,267) (16,267) (19,267) (310,933) 109,567 109,567 109,567 109,567 109,567 109,567 109,567 109,567 524,800 16%

New Focus Consulting

Cash Flow

Jan Feb March April May June July Aug Sept Oct Nov Dec

Beginning Cash – 0 447,233 430,467 413,700 80,267 192,333 304,400 416,467 528,533 640,600 752,667 864,733

Net Income (5,267) (16,267) (19,267) (310,933) 109,567 109,567 109,567 109,567 109,567 109,567 109,567 109,567

Co. Investment 400,000

Debt Proceeds 200,000

Fitup Costs (25,000)

truck

Computers/phone (3,000)

Equipment (150,000)

building lease

Debt Payments

Net Operating Adj.

Depr. Add Back 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500

Ending Cash Bal. 447,233 430,467 413,700 80,267 192,333 304,400 416,467 528,533 640,600 752,667 864,733 976,800 – 0

New Focus Consulting
2006

Place your order
(550 words)

Approximate price: $22

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
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
error: Content is protected !!
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 929 473-0077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code GURUH