assignment

profilegoog
last_update_.xls
Home>Business & Finance homework help>Marketing homework help>assignment

Unit

Year 2014
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 0 0 0 10 10 18 18 25 25 30 35 35 206
Tim Hortan 0 0 8 8 13 13 20 20 25 30 30 167
Costa   0 0 0 8 10 10 10 18 18 20 27 27 148
Total 0 0 0 26 28 41 41 63 63 75 92 92 521
Year 2015
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 12 12 17 17 20 25 25 33 33 40 45 45 324
Tim Hortan 12 12 15 15 18 25 25 27 30 35 40 40 294
Costa   8 8 13 13 17 20 23 25 27 30 35 35 254
Total 32 32 45 45 55 70 73 85 90 105 120 120 872
Year 2016
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 20 20 25 25 30 30 35 35 45 45 55 55 420
Tim Hortan 18 18 22 22 27 27 32 32 40 40 45 45 368
Costa   15 15 20 20 23 23 27 27 29 29 37 37 302
Total 53 53 67 67 80 80 94 94 114 114 137 137 1090

Price Canada

Unit Price 120
Year 2014
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks - 0 - 0 - 0 1,200 1,200 2,160 2,160 3,000 3,000 3,600 4,200 4,200 24,720
Tim Hortan - 0 - 0 - 0 960 960 1,560 1,560 2,400 2,400 3,000 3,600 3,600 20,040
Costa   - 0 - 0 - 0 960 1,200 1,200 1,200 2,160 2,160 2,400 3,240 3,240 17,760
Total - 0 - 0 - 0 3,120 3,360 4,920 4,920 7,560 7,560 9,000 11,040 11,040 62,520
Year 2015
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 1,440 1,440 2,040 2,040 2,400 3,000 3,000 3,960 3,960 4,800 5,400 5,400 38,880
Tim Hortan 1,440 1,440 1,800 1,800 2,160 3,000 3,000 3,240 3,600 4,200 4,800 4,800 35,280
Costa   960 960 1,560 1,560 2,040 2,400 2,760 3,000 3,240 3,600 4,200 4,200 30,480
Total 3,840 3,840 5,400 5,400 6,600 8,400 8,760 10,200 10,800 12,600 14,400 14,400 104,640
Year 2016
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 2,400 2,400 3,000 3,000 3,600 3,600 4,200 4,200 5,400 5,400 6,600 6,600 50,400
Tim Hortan 2,160 2,160 2,640 2,640 3,240 3,240 3,840 3,840 4,800 4,800 5,400 5,400 44,160
Costa   1,800 1,800 2,400 2,400 2,760 2,760 3,240 3,240 3,480 3,480 4,440 4,440 36,240
Total 6,360 6,360 8,040 8,040 9,600 9,600 11,280 11,280 13,680 13,680 16,440 16,440 130,800

Price Brazilin Real

1CAD 2.65 BRL
Year 2014
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks - 0 - 0 - 0 3,180 3,180 5,724 5,724 7,950 7,950 9,540 11,130 11,130 65,508
Tim Hortan - 0 - 0 - 0 2,544 2,544 4,134 4,134 6,360 6,360 7,950 9,540 9,540 53,106
Costa   - 0 - 0 - 0 2,544 3,180 3,180 3,180 5,724 5,724 6,360 8,586 8,586 47,064
Total - 0 - 0 - 0 8,268 8,904 13,038 13,038 20,034 20,034 23,850 29,256 29,256 331,356
Year 2015
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 3,816 3,816 5,406 5,406 6,360 7,950 7,950 10,494 10,494 12,720 14,310 14,310 103,032
Tim Hortan 3,816 3,816 4,770 4,770 5,724 7,950 7,950 8,586 9,540 11,130 12,720 12,720 93,492
Costa   2,544 2,544 4,134 4,134 5,406 6,360 7,314 7,950 8,586 9,540 11,130 11,130 80,772
Total 10,176 10,176 14,310 14,310 17,490 22,260 23,214 27,030 28,620 33,390 38,160 38,160 554,592
Year 2016
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 6,360 6,360 7,950 7,950 9,540 9,540 11,130 11,130 14,310 14,310 17,490 17,490 133,560
Tim Hortan 5,724 5,724 6,996 6,996 8,586 8,586 10,176 10,176 12,720 12,720 14,310 14,310 117,024
Costa   4,770 4,770 6,360 6,360 7,314 7,314 8,586 8,586 9,222 9,222 11,766 11,766 96,036
Total 16,854 16,854 21,306 21,306 25,440 25,440 29,892 29,892 36,252 36,252 43,566 43,566 693,240

Cash budget

2014
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Initial Cash - 0 58,100 51,200 44,300 41,190 38,371 37,446 36,522 38,804 41,087 45,118 51,627
Bank Note 65,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Incoming Cash revenue - 0 - 0 - 0 8,268 8,904 13,038 13,038 20,034 20,034 23,850 29,256 29,256 165,678
Total Cash Availiable 65,000 58,100 51,200 52,568 50,094 51,409 50,484 56,556 58,838 64,937 74,374 80,883
expenses
COGS - 0 - 0 - 0 4,479 4,823 7,062 7,062 10,852 10,852 12,919 15,847 15,847 89,742
Salaries 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200
Utilities 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200
Taxes
Rent 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Transportation 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Total Cash Out 6,900 6,900 6,900 11,379 11,723 13,962 13,962 17,752 17,752 19,819 22,747 22,747 172,542
Ending Cash 58,100 51,200 44,300 41,190 38,371 37,446 36,522 38,804 41,087 45,118 51,627 58,136
2015
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Initial Cash 58,136 55,700 53,264 52,723 52,181 53,098 56,200 59,740 65,029 71,046 79,250 89,640
Bank Note - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Incoming Cash revenue 10,176 10,176 14,310 14,310 17,490 22,260 23,214 27,030 28,620 33,390 38,160 38,160 277,296
Total Cash Availiable 68,312 65,876 67,574 67,033 69,671 75,358 79,414 86,770 93,649 104,436 117,410 127,800
expenses
COGS 5,512 5,512 7,751 7,751 9,474 12,058 12,574 14,641 15,503 18,086 20,670 20,670 150,202
Salaries 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500
Utilities 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200
Taxes
Rent 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400
Transportation 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Total Cash Out 12,612 12,612 14,851 14,851 16,574 19,158 19,674 21,741 22,603 25,186 27,770 27,770 235,402
Ending Cash 55,700 53,264 52,723 52,181 53,098 56,200 59,740 65,029 71,046 79,250 89,640 100,030
2016
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Initial Cash 100,030 99,250 98,470 99,360 100,250 102,690 105,130 109,239 113,349 119,843 126,338 135,575
Bank Note - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Incoming Cash revenue 16,854 16,854 21,306 21,306 25,440 25,440 29,892 29,892 36,252 36,252 43,566 43,566 346,620
Total Cash Availiable 116,884 116,104 119,776 120,666 125,690 128,130 135,022 139,131 149,601 156,095 169,904 179,141
expenses
COGS 10,534 10,534 13,316 13,316 15,900 15,900 18,683 18,683 22,658 22,658 27,229 27,229 216,638
Salaries 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700
Utilities 900 900 900 900 900 900 900 900 900 900 900 900
Taxes
Rent 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Transportation 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Total Cash Out 17,634 17,634 20,416 20,416 23,000 23,000 25,783 25,783 29,758 29,758 34,329 34,329 301,838
Ending Cash 99,250 98,470 99,360 100,250 102,690 105,130 109,239 113,349 119,843 126,338 135,575 144,812

income statement

2014 2015 2016
sales 165,678 277,296 346,620
COGS 89,742 150,202 216,638
Gross Margin 75,936 127,094 129,983
SG&A cost 82,800 85,200 85,200
EBITDA (6,864) 41,894 44,783
Interest Expenses 22,967 22,967 22,967
Icome tax (25%) (1,716) 10,474 11,196
Net Icome/Loss (28,115) 8,454 10,620