Please I need this Thursday......

magicman
FinancialForcasting.xlsm
Home>Business & Finance homework help>Management homework help>Please I need this Thursday......

Sales Projections

Net Income indicator (1,944,599)
Cash Flow indicator
Sales Projections
Year One Year Two Year One Year Two 2-Year Total Year One Year Two
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Total Total 1 2 3 4 5 6 7 8
Ticket Sales slope
Unit Volume 300 300 400 400 500 600 800 1000 1,400 2,900 4,300 $668 $300 $400 $400 $500 $600 $800 $1,000 332 7 47.43
Unit Price $20 $20 $20 $20 $20 $20 $20 $20 - - Q2 vs. Q1 Q3 vs. Q2 Q4 vs. Q3 Q1 vs. Q4 Q2 vs. Q1 Q3 vs. Q2 Q4 vs. Q3
Cost per Unit Sold $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 - - 0% 33% 0% 25% 20% 33% 25%
Gross Sales $6,000 $6,000 $8,000 $8,000 $10,000 $12,000 $16,000 $20,000 $28,000 $58,000 $86,000 LINEST SLOPE L/S
(Cost of Goods Sold) $9.00 $9.00 $12.00 $12.00 $15.00 $18.00 $24.00 $30.00 Sales growing over time? 1 65.7619047619 47 1
(Commission Percentage) 15% 15% 15% 15% 15% 15% 15% 15% - - 233% overall rate
Net Sales $5,092 $5,092 $6,790 $6,790 $8,487 $10,185 $13,580 $16,975 $23,764 $49,226 $72,990 points for this dynamic (allocation) 25%
your growth points 25%
Beverages
Unit Volume 210 210 280 280 350 420 560 700 980 2,030 3,010 Perfectly Exponential L/S = 2
Unit Price - Perfectly Linear L/S = 1
Cost per Unit Sold $1 $1 $1 $1 $1 $1 $1 $1 - This Forecast L/S = 1.39
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 As a proportion out of 100% 69%
(Cost of Goods Sold) $210 $210 $280 $280 $350 $420 $560 $700 points for this dynamic (allocation) 75%
(Commission Percentage) 0% 0% 0% 0% 0% 0% 0% 0% - - - your growth points 52%
Net Sales -$210 -$210 -$280 -$280 -$350 -$420 -$560 -$700 -$980 -$2,030 -$3,010
YOUR TOTAL POINTS % 77%
Merchandise Total Points Possible 20
Unit Volume 90 90 120 120 150 180 240 300 420 870 1,290 Your Total Points 15
Unit Price - - -
Cost per Unit Sold $3.25 $3.25 $3.25 $3.25 $3.25 $3.25 $3.25 $3.25 - - -
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) $293 $293 $390 $390 $488 $585 $780 $975
(Commission Percentage) 50% 50% 50% 50% 50% 50% 50% 50% - - -
Net Sales -$146 -$146 -$195 -$195 -$244 -$293 -$390 -$488 -$683 -$1,414 -$2,096
Total: All Products/Services
Total Unit Volume 600 600 800 800 1,000 1,200 1,600 2,000 2,800 5,800 8,600
Total Gross Sales $6,000 $6,000 $8,000 $8,000 $10,000 $12,000 $16,000 $20,000 $28,000 $58,000 $86,000
(Total Cost of Goods Sold) $512 $512 $682 $682 $853 $1,023 $1,364 $1,705 $2,387 $4,945 $7,332
(Total Commissions Paid) $752 $752 $1,003 $1,003 $1,254 $1,505 $2,006 $2,508 $3,511 $7,273 $10,784
Total Net Sales $4,736 $4,736 $6,315 $6,315 $7,894 $9,472 $12,630 $15,787 $22,102 $45,782 $67,884
Assumptions:
Merchanside (locked) 30% of ticket buyers buy merchandise
Beverages (changeable) 70% of ticket buyers buy an average of 1 beverages
Beverage Industry Average for U.S. Bar & Nightclub (estimate)
65% order drinks most to all the time with males ordering more frequently than females. Surprisingly, Millennials order less frequently than older consumers
http://www.nciaa.com/content.aspx?page_id=22&club_id=160641&module_id=29898
The average consumer order 2.3 drinks per occasion with males ordering more than females and Millennials ordering more than the older consumers.

FORECAST SUMMARY

http://www.nciaa.com/content.aspx?page_id=22&club_id=160641&module_id=29898

Marketing Budget

Marketing Budget
Purpose/Strategy Key: (Optional) PB: Personal Branding BA: Brand Awareness/Brand Building SP: Product/Service Sampling, Trial L&R: Brand Loyalty/Customer Rewards Purpose (optonal) Pre-Launch Year One Year Two Total
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Variance - 0
Tangible Marketing Quartile (1st) 1
Brochures, flyers, Mobile signs, bus/metro signs, billboards $1 $1 Quartile (3rd) 1 1
Samples, premiums, logo merchandise, "swag" Difference - 0
Media Advertising
Print: newspaper, magazines Dispersion 0%
Television, radio
Television, radio Greater than or equal to 60%? FALSE
Banner Ads, Paid Search Engine Marketing Percent of 60% 0%
Social Media Marketing Point Multiplier 0%
Paid Facebook promotions, Twitter ads, Linkedin ads Dispersion Total Points 5
Social media contests, Deal-of-the-day: Groupon, Google Offers, LivingSocial Your Dispersion Points 0
Tweetups, Meetups
Guerilla & Viral Marketing Fewer than 6 types? TRUE
Sticker bombing, flyposting, Flashmobs, streetart More than 0 types? TRUE
Street teams, campus promotions, Crowd-sourced ads Point Multiplier 100%
Networking & Client Development Activities Category Focus Total Points ERROR:#REF!
Launch party, Memberships, meetings, Entertaining Clients Your Focus Points Multiplier 100%
Trade Shows, Events, Street Promotions Your Focus Points 0.00
Wrapped vehicles, food trucks, booths, exhibits, signs
Website Total Points / Component 0.0
Design, development, programming
Maintenance, hosting, domains
Professional Assistance & Consultants
Marketing, Public Relations
Branding, Advertising
TOTAL $1 $0 $0 $0 $0 $0 $0 $0 $0 $1 1
Categories of Marketing Utilized 2
Difference from Budget Amount Percent of Budget Spent Component Points Your Deduct Your Points Error Check
$43,199 0% 5 0 0 0
Budget Completed? FALSE 10 0

Capital Expenses (optional)

Capital Expenses
Pre-Launch Year 1 Year 2
Capital Expenses
Office Equipment, Furniture, and Supplies $14,984 $1,500 $1,500
Remodeling Needs $65,000 $2,000 $5,500
Industry Specific Supplies and Technical Equipment $220,000 $15,000 $24,500
Licensing Needs (liquor license etc) $12,500 $975 $1,075
Company Vehicles $24,500 $1,225 $1,225
Research and Development Costs $16,500 $8,800 $8,800
TOTAL $353,484 $29,500 $42,600

Income Statement

Income Statement
2Live Venue
Year 1 Year Two Year One Year Two
Pre-Launch Q1 Q2 Q3 Q4 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Y1 Total Y2 Total 2-Year Total
INCOME (NET SALES) $0 $4,736 $4,736 $6,315 $6,315 $7,894 $9,472 $12,630 $15,787 $22,102 $45,782 $67,884
EXPENSES
Capital expenses $353,484 $29,500 $0 $0 $0 $42,600 $0 $0 $0 $0 $42,600 $42,600
Salaries and wages $84,067 $126,100 $126,100 $126,100 $126,100 $157,625 $157,625 $157,625 $157,625 $504,400 $630,500 $1,134,900
Employee benefits $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll taxes $12,610 $18,915 $18,915 $18,915 $18,915 $23,644 $23,644 $23,644 $23,644 $75,660 $94,575 $170,235
Accounting Services $1,025 $1,025 $1,025 $1,025 $1,025 $1,025 $1,025 $1,025 $4,100 $4,100 $8,200
Rent $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $32,000 $32,000 $64,000
Maintenance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $4,000 $4,000 $8,000
Legal $9,000 $375 $375 $375 $375 $375 $375 $375 $375 $1,500 $1,500 $3,000
Insurance $1,217 $1,825 $1,825 $1,825 $1,825 $1,825 $1,825 $1,825 $1,825 $7,300 $7,300 $14,600
Utilities $1,000 $1,500 $1,700 $1,800 $1,500 $1,500 $1,700 $1,800 $1,500 $6,500 $6,500 $13,000
Internet & public wifi $1,995 $175 $175 $175 $175 $175 $175 $175 $175 $700 $700 $1,400
Telephone service $75 $75 $75 $75 $75 $75 $75 $75 $75 $300 $300 $600
Filing fees $450 $0 $0 $0
Postage and shipping $250 $0 $0 $0
Marketing $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Travel $2,500 $2,500 $2,500 $2,500 $2,500 $10,000 $10,000 $10,000 $300 $10,000 $30,300 $40,300
Entertainment $3,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $6,000 $6,000 $12,000
Bank Fees $0 $0 $0 $0
$0 $0 $0
$0 $0 $0
TOTAL EXPENSES $470,148 $192,490 $163,190 $163,290 $162,990 $249,344 $206,944 $207,044 $197,044 $652,460 $817,775 $1,470,235
Operating Profit (470,148) (187,754) (158,454) (156,975) (156,675) (241,450) (197,472) (194,414) (181,257) (659,858) (814,593) $(1,474,451) Point Deductions
Provision for taxes 0 0 0 0 0 0 0 0 0 0 0 $0 Breakeven? within $100k? Total Deduct Your Points
NET PROFIT (470,148) (187,754) (158,454) (156,975) (156,675) (241,450) (197,472) (194,414) (181,257) (1,130,007) (814,593) (1,944,599) 10 5 15 -15
Is this number positive?

FORECAST SUMMARY

Cash-Flow Statement

Cash Flow
Year 1 Year 2
Pre-Launch Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Starting Balance $0 $(610,148) $(798,919) $(960,757) $(1,122,884) $(1,284,746) $(1,530,448) $(1,785,881) $(1,989,565)
Cash Ins
Net sales $4,736 $4,736 $6,315 $6,315 $7,894 $9,472 $12,630 $15,787
Investments $0
Loans
Interest income $(1,017) $(1,332) $(1,601) $(1,871) $(2,141) $(2,551) $(2,976) $(3,316)
Owner contributions $0
TOTAL CASH INS $0 $3,719 $3,405 $4,714 $4,443 $5,752 $6,921 $9,653 $12,471
Cash Outs
Operating expenses $470,148 $192,490 $163,190 $163,290 $162,990 $249,344 $206,944 $207,044 $197,044
Loan payments
Tax payments $0 $0 $2,052 $3,551 $3,315 $2,110 $5,411 $6,293 $7,457
Contingency fund $140,000
Owner's draw (Entrepreneur) $50,000 $50,000
Investor's draw
Other:
Other:
Other:
Other:
Other:
Other:
TOTAL CASH OUTS $610,148 $192,490 $165,242 $166,841 $166,305 $251,454 $262,355 $213,337 $254,501
CASH AT END OF MONTH (610,148) (798,919) (960,757) (1,122,884) (1,284,746) (1,530,448) (1,785,881) (1,989,565) (2,231,595)
How many periods are negative? Deduction
(610,148) (798,919) (960,757) (1,122,884) (1,284,746) (1,530,448) (1,785,881) (1,989,565) (1,989,565) 9 8
Percentage of periods negative
100% 10
Total Deductions 18
Your Cash Flow Points ERROR:#REF!

Capital Investment

Capital Investment
aka "Shark Tank" Page Acceptable Range, Valuation / Sales Implied Valuation
1 ERROR:#DIV/0!
Investor Name Investment Amount ($) Equity Offered (%) 4 0
Private Investor within range? Year 2 Sales
FALSE 45,782
Owner Name Contribution Amount ($) Equity Retained (%)
Point Deduction, Valuation Valuation based on sales (x)
Owner $0 3 0.00
0
TOTAL INVESTMENTS Total Capital Raised EQUITY OWNERSHIP %
Outside Investors $0 0% Excess Capital Test
Owners $0 0% (610,148)
TOTAL $0 0%
30% of investor capital
$0
More than 30%?
FALSE
Point Deduction for excess capital
2
Your point deduction
0
Reasonable capital raised/valuation Deduction
Valuation 3
Excess Capital Test 0
Total Point Deduction 3
Owner % of total
100%
100%
Owner Contributes at least 5% ?
0
All Ownership Shown?
3 was 0.00%
should be 100.0%
Equity Ownership Totals 100%? off by 100.00%
2 ABS (+/-) 100%
Points possible 2
Total Deduction scaled 0
5 rounded 0

The Total Investment Amount (Capital) should be the amount of the largest negative number on your Cash Flow Statement (the amount of cash you need to eliminate any and all negative cash balances throughout the two years while your business is breaking even.

Are you raising capital from an investor? If so, enter the amount you'll need from them here. Then enter the percentage of your company you're willing to give up in exchange.

If you choose to raise smaller amounts of capital with crowdfunding donations, remember that the $ is donated and no equity % is given away.

START HERE and decide how much of the total will come from your own money. This sends a positive psychological signal to investors that you believe in your idea. In addition, these sharks assume that the more money you invested, the harder you will work to make the business a success. COME BACK LATER and enter the amount of equity you own, after you've decided how much equity you'll be giving up to an investor.

copyright

Financial Forecasting Assignment
OVERALL POINTS BY CATEGORY Your Score Possible
Marketing 0 20
Sales Projections 20 20
Income Statement 5 20
Cash Flow Statement ERROR:#REF! 20
Capital Investments 12 20
Your Score / Total Possible ERROR:#REF! 100
1
POINTS BY OBJECTIVE Your Score Possible
Goal #1: Profitable within two years 5 20
Goal #2: Cash flow positive ERROR:#REF! 20
Sales projections calculated correctly 5 10
Realistic growth pattern in sales 15 10
Marketing budget was completed 0 10
Marketing budget spent entirely 0 5
Marketing is targeted 0 5
All ownership shown 5 10
Reasonable capital raised/valuation 7 10
Your Score / Total Possible ERROR:#REF! 100
1 2 3 4 5 6 7 8
300 300 400 400 500 600 800 1000

Your Sales Forecast

300 300 400 400 500 600 800 1000

Click to Fix ERROR in Sales Projections

HTML

<div class="editor-embedded-media"><img src="https://fso-lms4-mortal-assets.s3.amazonaws.com/public/599/201810/efc58c09-4f2a-4570-8871-ad4c7f97819b-cc014bb1-f05a-42af-b165-d4828e762f24/financial_plan_thought_bubble.jpg" style="width: 290px; class=" inline-media"="">
<h1>Financial Forecasting Assignment </h1><br>
Thanks for submitting your forecast and for your patience as all the students'&nbsp;forward-looking financial statements were reviewed.&nbsp;<strong><em>Keep in mind...this was a challenging assignment.</strong></em>&nbsp;</div>
<p><strong style="color:#0063a1">Please review the following info </strong>regarding the grade you received, which has been <strong style="color:#0063a1">fully customized </strong>to address the strengths & weaknesses of your submission.&nbsp;Feel free to contact me with any questions!
<br><br><table><tr><td><strong> OVERALL POINTS BY CATEGORY <td style="text-align: center;"><strong> ERROR:#REF! <td style="text-align: center;"><strong> ERROR:#REF! </strong></td>
<tr><td><b style="color:#0063a1"> Marketing <td style="text-align: center;"> 0 <td style="text-align: center;"> 20 </td>
<tr><td><b style="color:#0063a1"> Sales Projections <td style="text-align: center;"> 20 <td style="text-align: center;"> 20 </td>
<tr><td><b style="color:#0063a1"> Income Statement <td style="text-align: center;"> 5 <td style="text-align: center;"> 20 </td>
<tr><td><b style="color:#0063a1"> Cash Flow Statement <td style="text-align: center;"> ERROR:#REF! <td style="text-align: center;"> 20 </td>
<tr><td><b style="color:#0063a1"> Capital Investments <td style="text-align: center;"> 12 <td style="text-align: center;"> 20 </td>
<tr><td> ------------------------------------------------------- <td style="text-align: center;"> ---------- <td style="text-align: center;"> ---------- </td>
<tr><td><strong><mark> Your Score / Total Possible <td style="text-align: center;"><strong><mark> ERROR:#REF! <td style="text-align: center;"><strong><mark> 100 </td></strong></table>
<br><br><br>
<table><tr><td><strong> ERROR:#REF! </td><td><strong> ERROR:#REF! </td><td><strong> ERROR:#REF! </b></strong></td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 5 <td style="text-align: center;"> 20 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> ERROR:#REF! <td style="text-align: center;"> 20 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 5 <td style="text-align: center;"> 10 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 15 <td style="text-align: center;"> 10 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 0 <td style="text-align: center;"> 10 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 0 <td style="text-align: center;"> 5 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 0 <td style="text-align: center;"> 5 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 5 <td style="text-align: center;"> 10 </td>
<tr><td><b style="color:#0063a1"> ERROR:#REF! <td style="text-align: center;"> 7 <td style="text-align: center;"> 10 </td>
<tr><td> ------------------------------------------------------- <td style="text-align: center;"> ---------- <td style="text-align: center;"> ---------- </td>
<tr><td><strong> ERROR:#REF! <td style="text-align: center;"><strong> ERROR:#REF! <td style="text-align: center;"><strong> 100 </strong></td></b></table>
<div class="editor-embedded-media"><img src="https://fso-lms4-mortal-assets.s3.amazonaws.com/public/599/20178/7dec8ec0-6c85-4a65-9bf8-fb6b8241edea-7a92413e-4ebc-44ac-9822-b4144ba57630/inside-the-shark-tank-fight-that-caused-3-investors-to-storm-off-the-set.jpg" class="inline-media"></div><p><br></p>