Assignment 2 COMM 2203 Summer 2021
Suggested Solution Analysis
R Nason NPV
IRR
Payback Period
Discounted Payback Period
Input Variables
Capital Expenditure 450,000 UCC Beg
Salvage Value 50,000 CCA
CCA Rate 0.28 UCC End
Initial NWC 100,000
NWC as Percent of Sales 0.33 Units
Initial Units Large 3,500 Large
Initial Units Gut Buster 5,500 Gut Buster
Initial Price Large 12.00
Initial Price Gut Buster 20.00 Cannibalization
Unit Sales Growth 1st 10 years 0.05 Large
Unit Costs Large 4.00 Gut Buster
Unit Costs Gut Buster 6.00
Cannibalization Large 600 Net Units
Cannibalization Gut Buster 700 Large
Large Beverage 1.0 Gut Buster
Gut Buster Beverage 2.5 Beverages
Beverage Price 2.50
Beverage Unit Cost 0.75 Price
Initial Fixed Costs 100,000 Large
Inflation 0.024 Gut Buster
Tax Rate 0.25 Beverage
Discount Rate 0.11
Unit Costs
Large
Gut Buster
Beverage
Sales
Variable Costs
Fixed Costs
CCA
EBT
Tax
Net Working Capital
Change in NWC
Capital Expenditure
Salvage Value
Net Cash Flows
Discounted Cash Flows
Cumulative Cash Flows
Cumulative Discounted CFs
NPV
IRR
Payback Period
Discounted Payback Period
-62,467 Rick should REJECT the project as it has a negative NPV
0 In addition, the IRR is below the Discount Rate, and the Payback Period is a signficantly long 11 yea
11 On a Discounted Basis, the project does not pay back, even over its entire 17 year life.
N/A Note: Extra analysis on a scenario or sensitivity analysis would add to your grade.
0 1 2 3 4 5 6 7 8 9
450,000 387,000 278,640 200,621 144,447 104,002 74,881 53,915 38,818
63,000 108,360 78,019 56,174 40,445 29,121 20,967 15,096 10,869
387,000 278,640 200,621 144,447 104,002 74,881 53,915 38,818 27,949
3,500 3,675 3,859 4,052 4,254 4,467 4,690 4,925 5,171
5,500 5,775 6,064 6,367 6,685 7,020 7,371 7,739 8,126
600 600 600 600 600 600 600 600 600
700 700 700 700 700 700 700 700 700
2,900 3,075 3,259 3,452 3,654 3,867 4,090 4,325 4,571
4,800 5,075 5,364 5,667 5,985 6,320 6,671 7,039 7,426
14,900 15,763 16,668 17,619 18,617 19,666 20,767 21,922 23,136
12.00 12.29 12.58 12.88 13.19 13.51 13.84 14.17 14.51
20.00 20.48 20.97 21.47 21.99 22.52 23.06 23.61 24.18
2.50 2.56 2.62 2.68 2.75 2.81 2.88 2.95 3.02
4.00 4.10 4.19 4.29 4.40 4.50 4.61 4.72 4.84
6.00 6.14 6.29 6.44 6.60 6.76 6.92 7.08 7.25
0.75 0.77 0.79 0.81 0.82 0.84 0.86 0.89 0.91
168,050 182,074 197,185 213,467 231,008 249,904 270,258 292,179 315,788
51,575 55,882 60,522 65,523 70,910 76,713 82,964 89,696 96,947
100,000 102,400 104,858 107,374 109,951 112,590 115,292 118,059 120,893
63,000 108,360 78,019 56,174 40,445 29,121 20,967 15,096 10,869
-46,525 -84,568 -46,214 -15,604 9,702 31,481 51,035 69,328 87,079
-11,631 -21,142 -11,554 -3,901 2,426 7,870 12,759 17,332 21,770
100,000 55,457 60,084 65,071 70,444 76,233 82,468 89,185 96,419 104,210
100,000 -44,544 4,628 4,987 5,373 5,789 6,236 6,717 7,234 7,791
450,000
-550,000 72,650 40,306 38,372 39,098 41,933 46,495 52,526 59,858 68,388
-550,000 65,450 32,713 28,057 25,755 24,885 24,858 25,300 25,974 26,734
-550,000 -477,350 -437,044 -398,672 -359,574 -317,641 -271,145 -218,619 -158,761 -90,373
-550,000 -484,550 -451,836 -423,779 -398,024 -373,139 -348,280 -322,981 -297,007 -270,272
-62,467
0.09
11
N/A
a signficantly long 11 years
17 year life.
10 11 12 13 14 15 16 17
27,949 20,123 14,489 10,432 7,511 5,408 3,894 2,803
7,826 5,635 4,057 2,921 2,103 1,514 1,090 785
20,123 14,489 10,432 7,511 5,408 3,894 2,803 2,019
5,430 5,430 5,430 5,430 5,430 5,430 5,430 5,430
8,532 8,532 8,532 8,532 8,532 8,532 8,532 8,532
600 600 600 600 600 600 600 600
700 700 700 700 700 700 700 700
4,830 4,830 4,830 4,830 4,830 4,830 4,830 4,830
7,832 7,832 7,832 7,832 7,832 7,832 7,832 7,832
24,410 24,410 24,410 24,410 24,410 24,410 24,410 24,410
14.86 15.21 15.58 15.95 16.33 16.73 17.13 17.54
24.76 25.35 25.96 26.58 27.22 27.88 28.54 29.23
3.09 3.17 3.25 3.32 3.40 3.48 3.57 3.65
4.95 5.07 5.19 5.32 5.44 5.58 5.71 5.85
7.43 7.61 7.79 7.98 8.17 8.36 8.56 8.77
0.93 0.95 0.97 1.00 1.02 1.05 1.07 1.10
341,211 349,400 357,785 366,372 375,165 384,169 393,389 402,831
104,755 107,269 109,843 112,480 115,179 117,943 120,774 123,673
123,794 126,765 129,807 132,923 136,113 139,380 142,725 146,150
7,826 5,635 4,057 2,921 2,103 1,514 1,090 785
104,836 109,731 114,078 118,049 121,770 125,332 128,800 132,223
26,209 27,433 28,519 29,512 30,443 31,333 32,200 33,056
112,600 115,302 118,069 120,903 123,805 126,776 129,818 0
8,390 2,702 2,767 2,834 2,902 2,971 3,043 -129,818
50,000
78,063 85,231 86,848 88,624 90,529 92,542 94,648 279,771
27,493 27,042 24,825 22,822 21,002 19,342 17,821 47,458
-12,310 72,921 159,769 248,393 338,922 431,464 526,112 805,882
-242,779 -215,737 -190,912 -168,091 -147,088 -127,747 -109,925 -62,467