Module 3: SAM Project 1b

1 00:00:02,100 --> 00:00:08,760 all right what's going on so this is

2 00:00:05,040 --> 00:00:12,240 module 3 Sam project 1B so here it is

3 00:00:08,760 --> 00:00:14,639 saying is a financial analyst with made

4 00:00:12,240 --> 00:00:16,619 site instruments a global so we don't

5 00:00:14,639 --> 00:00:18,900 need this information you can skip up to

6 00:00:16,619 --> 00:00:22,199 here so it is saying switch to the unit

7 00:00:18,900 --> 00:00:25,019 sales projects and worksheet so on the

8 00:00:22,199 --> 00:00:27,240 bottom click on unit sales projection

9 00:00:25,019 --> 00:00:29,820 and then it is saying use the values in

10 00:00:27,240 --> 00:00:35,040 the range C5 through D5 to fill the

11 00:00:29,820 --> 00:00:38,340 range E5 through I5 so let's see C5 C5

12 00:00:35,040 --> 00:00:40,500 through D5 so here is C5 and then here

13 00:00:38,340 --> 00:00:44,460 is D5 and then it is going to fill the

14 00:00:40,500 --> 00:00:46,260 range E5 through I5 so you can just go

15 00:00:44,460 --> 00:00:48,840 to the corner and then this plus sign

16 00:00:46,260 --> 00:00:52,079 will appear and then hold it and drag it

17 00:00:48,840 --> 00:00:53,940 until I5 so it will use those value as a

18 00:00:52,079 --> 00:00:56,460 reference and then increment those other

19 00:00:53,940 --> 00:00:59,100 value so step two it is saying use the

20 00:00:56,460 --> 00:01:03,539 values and formatting in the range B6

21 00:00:59,100 --> 00:01:07,979 through B7 so here is B6 and then B7

22 00:01:03,539 --> 00:01:10,320 oops so let's select B6 and B7 both just

23 00:01:07,979 --> 00:01:12,000 click on this cell and then double tap

24 00:01:10,320 --> 00:01:14,340 and then hold and drag it down so this

25 00:01:12,000 --> 00:01:17,760 way you can select both range or you can

26 00:01:14,340 --> 00:01:19,560 just click on B6 and then hold shift and

27 00:01:17,760 --> 00:01:21,720 then click here so this way also you can

28 00:01:19,560 --> 00:01:23,939 select both CLS

29 00:01:21,720 --> 00:01:26,640 so it is saying select this and extend

30 00:01:23,939 --> 00:01:29,220 to the list of year to the range B8

31 00:01:26,640 --> 00:01:31,700 through B10 so go to the corner plus

32 00:01:29,220 --> 00:01:33,659 sign will appear and then drag it until

33 00:01:31,700 --> 00:01:36,240 B 10

34 00:01:33,659 --> 00:01:38,640 okay and project five years of clothes

35 00:01:36,240 --> 00:01:40,860 so it is showing five years and then it

36 00:01:38,640 --> 00:01:43,500 is saying use autofill to fill the range

37 00:01:40,860 --> 00:01:45,960 and see it through I10 with the

38 00:01:43,500 --> 00:01:48,240 formatting from the range C6 through i7

39 00:01:45,960 --> 00:01:49,619 to apply a consistent formatting in the

40 00:01:48,240 --> 00:01:52,619 projections

41 00:01:49,619 --> 00:01:54,720 so double click and then drag it until I

42 00:01:52,619 --> 00:01:56,579 and then here is seven or you can just

43 00:01:54,720 --> 00:01:59,220 click on this cell and then hold shift

44 00:01:56,579 --> 00:02:02,939 and then click on Cell i7 this way also

45 00:01:59,220 --> 00:02:05,040 you can select cell C6 through i7 so it

46 00:02:02,939 --> 00:02:07,500 is saying use this range to fill the

47 00:02:05,040 --> 00:02:10,319 range C8 through I10

48 00:02:07,500 --> 00:02:12,360 so here is CA through item so autofill

49 00:02:10,319 --> 00:02:15,180 means same thing just go to the corner

50 00:02:12,360 --> 00:02:16,860 plus sign library and then drag it up to

51 00:02:15,180 --> 00:02:19,379 itin

52 00:02:16,860 --> 00:02:23,099 so it will apply same formatting from CA

53 00:02:19,379 --> 00:02:27,480 to I10 by copying the formatting from C6

54 00:02:23,099 --> 00:02:29,819 through I8 I mean i7 so it is saying

55 00:02:27,480 --> 00:02:31,860 enter formulas as follow to complete the

56 00:02:29,819 --> 00:02:36,060 table of projection in the range C6

57 00:02:31,860 --> 00:02:38,580 through I10 so here is C6 and then a

58 00:02:36,060 --> 00:02:41,280 result this whole thing it is saying in

59 00:02:38,580 --> 00:02:43,140 cell C7 create a formula without using a

60 00:02:41,280 --> 00:02:45,959 function that multiplies the sale flow

61 00:02:43,140 --> 00:02:49,080 section for the first year sales C6 so

62 00:02:45,959 --> 00:02:51,599 click on Cell C7 and then click on this

63 00:02:49,080 --> 00:02:53,519 status bar and then so to enter any

64 00:02:51,599 --> 00:02:56,040 formula we shall begin with equals to

65 00:02:53,519 --> 00:02:58,260 sign and then it is saying without using

66 00:02:56,040 --> 00:03:00,300 any function so we need to enter the

67 00:02:58,260 --> 00:03:02,340 cell number directly so it is saying

68 00:03:00,300 --> 00:03:07,319 multiplies the cell projection for first

69 00:03:02,340 --> 00:03:10,379 year C6 and then multiply symbol by C5

70 00:03:07,319 --> 00:03:13,739 and then it is saying and adds the cell

71 00:03:10,379 --> 00:03:17,519 projection for the first year clc6

72 00:03:13,739 --> 00:03:19,440 so we need to multiply C6 by C5 and then

73 00:03:17,519 --> 00:03:21,300 wrap it in parenthesis and then this

74 00:03:19,440 --> 00:03:26,099 will give a result and then that result

75 00:03:21,300 --> 00:03:28,200 will get added to cell C6 to the result

76 00:03:26,099 --> 00:03:32,640 um and to determine the first first

77 00:03:28,200 --> 00:03:36,000 estimate for 2022 and then hit enter

78 00:03:32,640 --> 00:03:39,180 okay and then step forward is saying use

79 00:03:36,000 --> 00:03:41,940 an absolute reference to row five in and

80 00:03:39,180 --> 00:03:45,900 the reference to the cell C5

81 00:03:41,940 --> 00:03:49,440 okay so in this formula for C5

82 00:03:45,900 --> 00:03:51,299 the row files will be absolute so if we

83 00:03:49,440 --> 00:03:54,360 drag it and then copy and paste this

84 00:03:51,299 --> 00:03:56,940 formula somewhere so C6 and C6 will

85 00:03:54,360 --> 00:03:59,159 change according to its reference but C5

86 00:03:56,940 --> 00:04:03,900 will be constant so this row number will

87 00:03:59,159 --> 00:04:06,120 be constant so what am I saying is

88 00:04:03,900 --> 00:04:09,299 let's see it is saying copy the formula

89 00:04:06,120 --> 00:04:11,819 from cell C7 to the range C8 through C10

90 00:04:09,299 --> 00:04:14,159 so if we copy this so to copy this also

91 00:04:11,819 --> 00:04:16,380 you need to go to the corner and then

92 00:04:14,159 --> 00:04:17,519 plus sign will appear and then drag it

93 00:04:16,380 --> 00:04:20,459 until

94 00:04:17,519 --> 00:04:23,639 C 10 so in bottom C10

95 00:04:20,459 --> 00:04:27,780 okay so if we see the formula so C6 it

96 00:04:23,639 --> 00:04:31,280 sends to C7 C8 C9 but this C5 is

97 00:04:27,780 --> 00:04:34,020 constant this 5 is constant and if you

98 00:04:31,280 --> 00:04:37,020 copy this formula to this row this c

99 00:04:34,020 --> 00:04:38,120 will be changed to D but this 5 will be

100 00:04:37,020 --> 00:04:40,380 constant

101 00:04:38,120 --> 00:04:42,419 so let's see

102 00:04:40,380 --> 00:04:46,800 it is saying copy the formula from the

103 00:04:42,419 --> 00:04:49,259 range C7 through C10 so oops did escape

104 00:04:46,800 --> 00:04:53,759 and then select C7 and the Mobile Shift

105 00:04:49,259 --> 00:04:58,020 click C10 C7 old shift key and then

106 00:04:53,759 --> 00:05:02,759 press C10 okay and then it is saying

107 00:04:58,020 --> 00:05:06,419 use this C8 through C10 to the range c d

108 00:05:02,759 --> 00:05:09,120 D7 through I10 so again here is D7 and

109 00:05:06,419 --> 00:05:11,340 the nearest I10 so go to the corner and

110 00:05:09,120 --> 00:05:13,740 then drag it until here

111 00:05:11,340 --> 00:05:17,880 okay now if you see the formula so this

112 00:05:13,740 --> 00:05:21,419 in this case uh C7 here is C6 series C7

113 00:05:17,880 --> 00:05:25,139 C8 C9 body C5 is constant this 5 is

114 00:05:21,419 --> 00:05:28,919 constant but here it should be D9 and

115 00:05:25,139 --> 00:05:32,100 then D5 and then again D9

116 00:05:28,919 --> 00:05:35,220 so look this row number is constant so

117 00:05:32,100 --> 00:05:37,320 again if you look at above anywhere the

118 00:05:35,220 --> 00:05:39,900 row number is always constant because we

119 00:05:37,320 --> 00:05:41,639 put dollar symbol of it this means this

120 00:05:39,900 --> 00:05:43,020 is absolute it will not change no matter

121 00:05:41,639 --> 00:05:47,400 how

122 00:05:43,020 --> 00:05:48,900 okay so let's see in step five it is

123 00:05:47,400 --> 00:05:51,600 saying switch to the cost analysis

124 00:05:48,900 --> 00:05:53,699 worksheet so click here which analyzes

125 00:05:51,600 --> 00:05:56,100 the vendor and saving cost for you need

126 00:05:53,699 --> 00:05:58,380 to select a vendor and C for two c for

127 00:05:56,100 --> 00:06:00,180 the new product in cell B10 find the

128 00:05:58,380 --> 00:06:02,460 average vendor cost for unit by creating

129 00:06:00,180 --> 00:06:04,199 a formula using the average function to

130 00:06:02,460 --> 00:06:07,919 calculate the average of the houses in

131 00:06:04,199 --> 00:06:10,620 the range V5 through B8 okay so in cell

132 00:06:07,919 --> 00:06:12,240 B10 we need to calculate average so

133 00:06:10,620 --> 00:06:14,039 again to enter any formula I'm going to

134 00:06:12,240 --> 00:06:17,340 start with equals to sign and then type

135 00:06:14,039 --> 00:06:20,039 average so and you can double click here

136 00:06:17,340 --> 00:06:22,319 and then it accepts range of number or

137 00:06:20,039 --> 00:06:26,699 you can directly enter the range so you

138 00:06:22,319 --> 00:06:30,539 can it accepts either four comma 5 comma

139 00:06:26,699 --> 00:06:31,919 six uh five any number and then so this

140 00:06:30,539 --> 00:06:34,199 will calculate the average by adding

141 00:06:31,919 --> 00:06:36,720 this and dividing by three or you can

142 00:06:34,199 --> 00:06:38,580 also pass the range so in this case we

143 00:06:36,720 --> 00:06:42,900 are given range

144 00:06:38,580 --> 00:06:45,900 so enter bf5 through B8 so now it will

145 00:06:42,900 --> 00:06:48,060 take whole this number 47.48 it will add

146 00:06:45,900 --> 00:06:50,460 this number and then divide by 5 and

147 00:06:48,060 --> 00:06:51,600 then give us the result so you can hit

148 00:06:50,460 --> 00:06:55,319 enter

149 00:06:51,600 --> 00:06:57,840 okay and then it is saying uh used copy

150 00:06:55,319 --> 00:07:01,919 this formula to cell E10 and find okay

151 00:06:57,840 --> 00:07:04,620 so just Ctrl C and then go to cell E 10

152 00:07:01,919 --> 00:07:06,900 and then Ctrl d all right and you can

153 00:07:04,620 --> 00:07:10,380 hit escape to remove this dot line

154 00:07:06,900 --> 00:07:13,020 okay in cell steps or in steps six it is

155 00:07:10,380 --> 00:07:15,300 saying in cell b11 find the highest

156 00:07:13,020 --> 00:07:17,520 vendor cost per unit by creating a

157 00:07:15,300 --> 00:07:20,220 formula using the max function to

158 00:07:17,520 --> 00:07:23,039 identify the maximum number in range B5

159 00:07:20,220 --> 00:07:26,400 through B8 okay

160 00:07:23,039 --> 00:07:28,319 so in b11 we need to use max function

161 00:07:26,400 --> 00:07:30,180 again to enter any function or to enter

162 00:07:28,319 --> 00:07:33,539 any formula we need to start with equals

163 00:07:30,180 --> 00:07:35,940 to sign and then Max and parenthesis and

164 00:07:33,539 --> 00:07:38,099 then again it accepts either a series of

165 00:07:35,940 --> 00:07:41,460 numbers separated by comma or it accepts

166 00:07:38,099 --> 00:07:45,599 range of number so we have range

167 00:07:41,460 --> 00:07:48,060 so B 5 through B8 and then close

168 00:07:45,599 --> 00:07:50,099 parenthesis and then enter

169 00:07:48,060 --> 00:07:54,000 and then it is saying copy the formula

170 00:07:50,099 --> 00:07:56,880 to cell 11 and then copy and then go to

171 00:07:54,000 --> 00:07:59,099 11 and then paste Ctrl C control b or

172 00:07:56,880 --> 00:08:00,780 you can just right click and then paste

173 00:07:59,099 --> 00:08:03,419 formulas

174 00:08:00,780 --> 00:08:05,520 okay and then step 7 it is saying in

175 00:08:03,419 --> 00:08:07,440 Excel B12

176 00:08:05,520 --> 00:08:10,560 B12

177 00:08:07,440 --> 00:08:12,599 it is saying use mean function so equals

178 00:08:10,560 --> 00:08:14,940 to sign mean function again this accepts

179 00:08:12,599 --> 00:08:17,280 either number separated by commas or the

180 00:08:14,940 --> 00:08:20,699 range so we are given range we'll use

181 00:08:17,280 --> 00:08:23,879 range B5 through B8 and then close

182 00:08:20,699 --> 00:08:26,580 parenthesis and then copy this and then

183 00:08:23,879 --> 00:08:28,319 paste it to cell E12

184 00:08:26,580 --> 00:08:31,379 and then okay

185 00:08:28,319 --> 00:08:33,479 now in cell C 14 it is saying identify

186 00:08:31,379 --> 00:08:36,000 the vendor with the lowest cost per unit

187 00:08:33,479 --> 00:08:39,719 by creating a formula using the vlookup

188 00:08:36,000 --> 00:08:42,360 function so in cell oops hit Escape key

189 00:08:39,719 --> 00:08:44,339 to remove this and then 14 it is saying

190 00:08:42,360 --> 00:08:46,920 vendor function or look up vlookup

191 00:08:44,339 --> 00:08:48,660 function so equals to sign and then we

192 00:08:46,920 --> 00:08:51,660 look up and then you can double click

193 00:08:48,660 --> 00:08:54,839 and then it accepts lookup lookup value

194 00:08:51,660 --> 00:08:58,260 so lookup value is B12

195 00:08:54,839 --> 00:09:03,180 and then the range is so table array is

196 00:08:58,260 --> 00:09:05,519 our range so range is B5 through C8 and

197 00:09:03,180 --> 00:09:08,580 then let's see return the number of

198 00:09:05,519 --> 00:09:09,980 enter column two so we have given column

199 00:09:08,580 --> 00:09:13,380 2

200 00:09:09,980 --> 00:09:16,980 and then it is it is saying specify an

201 00:09:13,380 --> 00:09:19,620 exact match so again hit comma and then

202 00:09:16,980 --> 00:09:22,800 true is approximate match false is exact

203 00:09:19,620 --> 00:09:25,140 match so double click on false and then

204 00:09:22,800 --> 00:09:29,040 close parenthesis and then enter

205 00:09:25,140 --> 00:09:32,399 okay so laser biomedical now it is

206 00:09:29,040 --> 00:09:35,160 saying copy this to be F14 so just Ctrl

207 00:09:32,399 --> 00:09:38,940 V Ctrl C and the control B

208 00:09:35,160 --> 00:09:40,500 all right and then is in sales c19 so

209 00:09:38,940 --> 00:09:43,800 before that it is saying switch to the

210 00:09:40,500 --> 00:09:46,019 project profit projection worksheet

211 00:09:43,800 --> 00:09:48,300 so let's see here is profit projects and

212 00:09:46,019 --> 00:09:50,220 worksheet and then it is saying which

213 00:09:48,300 --> 00:09:52,980 sets I schedule for developing and

214 00:09:50,220 --> 00:09:55,440 launching a new product and projects EA

215 00:09:52,980 --> 00:09:58,440 it's

216 00:09:55,440 --> 00:10:01,260 which sets I schedule for developing and

217 00:09:58,440 --> 00:10:04,500 launching the new product and projects

218 00:10:01,260 --> 00:10:06,420 its profit for five years in sale I17

219 00:10:04,500 --> 00:10:10,680 use the 2D function to insert the

220 00:10:06,420 --> 00:10:12,540 current date so in cell i7 again to

221 00:10:10,680 --> 00:10:14,220 enter any function or any formula we

222 00:10:12,540 --> 00:10:16,980 need to start with equals to sign and

223 00:10:14,220 --> 00:10:18,899 then enter today and then function will

224 00:10:16,980 --> 00:10:20,760 always have open and close parenthesis

225 00:10:18,899 --> 00:10:23,820 and then hit enter

226 00:10:20,760 --> 00:10:26,399 okay so this is today's date and then in

227 00:10:23,820 --> 00:10:30,660 cell I9 it is going to create a formula

228 00:10:26,399 --> 00:10:32,100 that uses Network days function to

229 00:10:30,660 --> 00:10:35,399 calculate the number of working days

230 00:10:32,100 --> 00:10:38,700 between the dates in cell i7 and I8 lead

231 00:10:35,399 --> 00:10:43,100 the holidays argument blank okay so

232 00:10:38,700 --> 00:10:46,620 total means net and then working this

233 00:10:43,100 --> 00:10:50,220 suitable acid started so start day will

234 00:10:46,620 --> 00:10:52,920 be current date it is given here so it

235 00:10:50,220 --> 00:10:55,620 is I 7

236 00:10:52,920 --> 00:10:58,019 current date is i7 and then product

237 00:10:55,620 --> 00:11:00,779 launches so you can also click the cell

238 00:10:58,019 --> 00:11:03,300 energy lot medical Interiors here and

239 00:11:00,779 --> 00:11:05,040 then close parenthesis and then later so

240 00:11:03,300 --> 00:11:08,399 we will get negative result here because

241 00:11:05,040 --> 00:11:10,079 in this condition current date is after

242 00:11:08,399 --> 00:11:13,380 the product launch date which is

243 00:11:10,079 --> 00:11:15,660 impossible uh so uh current it is after

244 00:11:13,380 --> 00:11:18,600 the product launch date because same

245 00:11:15,660 --> 00:11:20,940 guess has written 2021 in here but here

246 00:11:18,600 --> 00:11:24,180 it is saying to use today function so

247 00:11:20,940 --> 00:11:27,060 today is uh after this date so it will

248 00:11:24,180 --> 00:11:28,440 give us negative value so don't worry

249 00:11:27,060 --> 00:11:31,920 about this

250 00:11:28,440 --> 00:11:34,800 okay so let's go to Step 11 it is saying

251 00:11:31,920 --> 00:11:38,040 use the value in the range C 14 through

252 00:11:34,800 --> 00:11:40,320 D14 to fill the range e 14 through i14

253 00:11:38,040 --> 00:11:41,519 with a series of income incremented

254 00:11:40,320 --> 00:11:45,060 percentage

255 00:11:41,519 --> 00:11:47,220 so select C 14 oops

256 00:11:45,060 --> 00:11:51,540 let's see c14

257 00:11:47,220 --> 00:11:54,360 and D14 and then go to the corner plus

258 00:11:51,540 --> 00:11:56,760 sign up here and extend it up to i14

259 00:11:54,360 --> 00:11:59,940 up here so it will automatically

260 00:11:56,760 --> 00:12:01,860 increase those percentages all right so

261 00:11:59,940 --> 00:12:04,820 step two already saying use the values

262 00:12:01,860 --> 00:12:08,220 in the range B15 through B16 so again

263 00:12:04,820 --> 00:12:10,140 select these and then extend up to b19

264 00:12:08,220 --> 00:12:12,899 so go to the corner plus sign will

265 00:12:10,140 --> 00:12:16,140 appear and extend up to P 19 and it will

266 00:12:12,899 --> 00:12:18,060 automatically fill those years okay and

267 00:12:16,140 --> 00:12:21,000 in Step 13 it is saying estimate the

268 00:12:18,060 --> 00:12:23,579 gross profit for 2021 as follows in

269 00:12:21,000 --> 00:12:26,160 sales C15 create a formula without using

270 00:12:23,579 --> 00:12:29,160 a function that subtracts the vendor

271 00:12:26,160 --> 00:12:33,180 cost and the shipping cost from the sale

272 00:12:29,160 --> 00:12:36,300 price okay so in cell 50 15

273 00:12:33,180 --> 00:12:39,540 it is saying that subtracts the vendor

274 00:12:36,300 --> 00:12:42,420 cost and shipping cost from sales from

275 00:12:39,540 --> 00:12:44,700 the sales price so when it says from the

276 00:12:42,420 --> 00:12:47,820 sale price we need to enter C8 at first

277 00:12:44,700 --> 00:12:51,000 because we need to subtract those C7 and

278 00:12:47,820 --> 00:12:53,160 C9 from not to the sales price it is

279 00:12:51,000 --> 00:12:56,519 saying from the sales price so when it

280 00:12:53,160 --> 00:13:02,160 says from it will be at ahead

281 00:12:56,519 --> 00:13:07,440 okay and C7 minus C9 so it will subtract

282 00:13:02,160 --> 00:13:10,139 C7 and C9 from C8 or you can do C8 and

283 00:13:07,440 --> 00:13:12,959 then subtract and then parenthesis and

284 00:13:10,139 --> 00:13:14,279 then plus and then this so this is same

285 00:13:12,959 --> 00:13:17,940 thing

286 00:13:14,279 --> 00:13:21,180 so it will subtract this value from C8

287 00:13:17,940 --> 00:13:22,500 so C8 minus this the total value of C7

288 00:13:21,180 --> 00:13:24,899 and C9

289 00:13:22,500 --> 00:13:26,820 okay and then and then multiply the

290 00:13:24,899 --> 00:13:32,220 result by the projected number of unit

291 00:13:26,820 --> 00:13:35,220 files for sale in 2021 CLC 10 so let's

292 00:13:32,220 --> 00:13:36,779 again wrap this result and then this

293 00:13:35,220 --> 00:13:40,320 result will be

294 00:13:36,779 --> 00:13:42,120 multiplied to cell C 10. so again if you

295 00:13:40,320 --> 00:13:44,160 are confused it is saying create a

296 00:13:42,120 --> 00:13:47,279 formula using a function that subtracts

297 00:13:44,160 --> 00:13:49,860 the vendor cost this and this from this

298 00:13:47,279 --> 00:13:53,760 it is saying subtract this and this from

299 00:13:49,860 --> 00:13:58,440 this so it will be C8 minus C7 minus C9

300 00:13:53,760 --> 00:14:01,440 or C8 minus the addition of C7 and C9

301 00:13:58,440 --> 00:14:03,360 that's the same thing and then this will

302 00:14:01,440 --> 00:14:07,380 give us one result and then that result

303 00:14:03,360 --> 00:14:09,839 will be multiplied to sell City so hit

304 00:14:07,380 --> 00:14:12,480 enter all right and then it is saying

305 00:14:09,839 --> 00:14:14,700 use absolute reference to each cell in

306 00:14:12,480 --> 00:14:16,740 the formula so in every cell we need to

307 00:14:14,700 --> 00:14:18,000 enter absolute reference so just click

308 00:14:16,740 --> 00:14:20,279 here and then

309 00:14:18,000 --> 00:14:23,160 wrap it with dollar sign or you can

310 00:14:20,279 --> 00:14:27,480 enter F4 if you are using Windows

311 00:14:23,160 --> 00:14:30,120 and then here then F4 and then again F4

312 00:14:27,480 --> 00:14:31,139 all right hand and enter so same same

313 00:14:30,120 --> 00:14:33,240 value

314 00:14:31,139 --> 00:14:38,940 okay now it is saying copy the formula

315 00:14:33,240 --> 00:14:41,760 from CLC 15 to range D15 I15 okay

316 00:14:38,940 --> 00:14:43,560 so here is C15 again go to the kernel

317 00:14:41,760 --> 00:14:47,940 plus sign will appear and then drag it

318 00:14:43,560 --> 00:14:49,740 until D15 and then up to I15

319 00:14:47,940 --> 00:14:52,380 okay

320 00:14:49,740 --> 00:14:56,279 now step 14 recent complete the growth

321 00:14:52,380 --> 00:14:59,940 estimate for the years 2022 2025 in cell

322 00:14:56,279 --> 00:15:03,899 C15 copy the formula that adds 1 to the

323 00:14:59,940 --> 00:15:05,699 growth rate CLC 14 so in cell c16 again

324 00:15:03,899 --> 00:15:07,519 already start with equals to sign and

325 00:15:05,699 --> 00:15:11,220 then it is saying add for

326 00:15:07,519 --> 00:15:13,860 one two CLC 14 all right

327 00:15:11,220 --> 00:15:16,380 and multiply the result so this will

328 00:15:13,860 --> 00:15:18,899 give one result so I did see it will be

329 00:15:16,380 --> 00:15:22,620 it's only one so this will give one

330 00:15:18,899 --> 00:15:25,980 result so this result will be multiplied

331 00:15:22,620 --> 00:15:30,300 to sell C15 so it is saying and multiply

332 00:15:25,980 --> 00:15:34,860 the result by estimated profit from 2021

333 00:15:30,300 --> 00:15:37,440 all right so this is C15 and then enter

334 00:15:34,860 --> 00:15:42,000 and it is saying use an absolute row

335 00:15:37,440 --> 00:15:44,399 reference to cell c14 okay so for c14 we

336 00:15:42,000 --> 00:15:47,220 need to use absolute row reference so

337 00:15:44,399 --> 00:15:50,220 only the row will be absolute so c means

338 00:15:47,220 --> 00:15:53,220 this c means this is column but 14 is

339 00:15:50,220 --> 00:15:56,279 rho so we need to add dollar symbol

340 00:15:53,220 --> 00:15:59,100 ahead of 14. so this will so this way if

341 00:15:56,279 --> 00:16:01,320 we copy this formula to it any place she

342 00:15:59,100 --> 00:16:03,480 will get chance see 15 will get changed

343 00:16:01,320 --> 00:16:04,800 but this 14 this row number will never

344 00:16:03,480 --> 00:16:07,800 change

345 00:16:04,800 --> 00:16:10,920 okay now hit enter and then it is then

346 00:16:07,800 --> 00:16:15,600 copy the formula from CLC 16 to range

347 00:16:10,920 --> 00:16:18,959 c17 c19 okay so oops you can

348 00:16:15,600 --> 00:16:20,519 cancel this so click c16 and then go to

349 00:16:18,959 --> 00:16:23,519 the corner plus sign up here and then

350 00:16:20,519 --> 00:16:29,120 drag it until C 19 let's see it is

351 00:16:23,519 --> 00:16:29,120 saying c16 to the range scene 19.

352 00:16:30,180 --> 00:16:35,880 and then it is saying copy the formulas

353 00:16:32,579 --> 00:16:38,399 from the range c16 through c19 to the

354 00:16:35,880 --> 00:16:40,500 range D16 through d19 so this is already

355 00:16:38,399 --> 00:16:42,120 selected we need to just go to the

356 00:16:40,500 --> 00:16:43,220 corner plus sign in library and then it

357 00:16:42,120 --> 00:16:47,220 is saying

358 00:16:43,220 --> 00:16:49,920 D16 through i19 all the way to here and

359 00:16:47,220 --> 00:16:52,860 then release okay and then it will

360 00:16:49,920 --> 00:16:56,220 automatically fill the data so it is

361 00:16:52,860 --> 00:16:59,339 saying delayed row delete row 21 since

362 00:16:56,220 --> 00:17:01,680 the worksheet is now complete so row 21

363 00:16:59,339 --> 00:17:04,919 click click on this 21 and then right

364 00:17:01,680 --> 00:17:07,679 click and then click until it all right

365 00:17:04,919 --> 00:17:09,660 so it is saying your workbook looks uh

366 00:17:07,679 --> 00:17:12,600 should look like the final figure on the

367 00:17:09,660 --> 00:17:15,540 following Pages the value inclusive sale

368 00:17:12,600 --> 00:17:17,400 i7 and I9 of I have been international

369 00:17:15,540 --> 00:17:20,100 keyboard as they will never be constant

370 00:17:17,400 --> 00:17:21,959 so okay so this and this value will not

371 00:17:20,100 --> 00:17:26,400 be same as a feature

372 00:17:21,959 --> 00:17:31,320 and then let's see how result okay

373 00:17:26,400 --> 00:17:34,380 so here 10 000 Yep this is good and then

374 00:17:31,320 --> 00:17:37,500 cost analyzes this this

375 00:17:34,380 --> 00:17:38,880 Yep this is also good and then the final

376 00:17:37,500 --> 00:17:41,700 worksheet

377 00:17:38,880 --> 00:17:44,280 profit projection so these two are

378 00:17:41,700 --> 00:17:46,020 blurred so this will never be same so

379 00:17:44,280 --> 00:17:48,000 this is okay

380 00:17:46,020 --> 00:17:51,179 because the current date is different

381 00:17:48,000 --> 00:17:53,820 and then here this must be same let's

382 00:17:51,179 --> 00:17:56,100 see yep all value are same and then you

383 00:17:53,820 --> 00:17:58,080 are also all values are same all right

384 00:17:56,100 --> 00:18:00,660 so if you feel any difficulties while

385 00:17:58,080 --> 00:18:04,280 doing it feel free to comment down below

386 00:18:00,660 --> 00:18:04,280 all right thank you for watching