Module 4

profileQueenQuanna
Backspace.xlsx
Home>Education homework help>Module 4

Documentation

Backspace Gear
Author
Date
Purpose To use financial data and charts to summarize the key features of a 10-year business plan for Backspace Gear, a manufacturer of backpacks in Kennewick, Washingon

&F &A &D

Business Loan

Backspace Gear
Business Loan Calculations
Loan Amount (PV)
Annual Interest Rate
Payments per Year
Interest Rate per Period (RATE)
Number of Years
Total Payments (NPER)
Monthly Payment
Annual Payment

&F &A &D

Market Summary

Backspace Gear
Market Summary
Sample Size = 500 interviews
Pack Type Total Men Women
School 178 81 97
Travel 103 42 61
Hiking 55 34 21
Sport 100 54 46
Ext. Frame 20 14 6
Int. Frame 44 34 10

&F &A &D

Financial Summary

Backspace Gear
Financial Summary
Pack Type Production Goal (Year 10) 10-Year Production
School 6,000
Travel 4,000
Hiking 2,000
Sport 3,000
External Frame 1,500
Internal Frame 2,000

&F &A &D

Market Data

Backspace Gear
Market Data
CONSUMER SURVEY Factors When Buying
Pack Prefernce (Will Buy) brand name 64
ID Gender Category Type Annual Income Factors support 97
SID001 Female Urban Travel 80K price price 118
SID002 Female Urban Travel 70K price quality 221
SID003 Female Urban Travel 40K customer support
SID004 Male Urban School 60K quality Breakdown of Preferences
SID005 Male Outdoors Sport 120K brand name Female Camping Ext. Frame 6
SID006 Male Urban Travel 110K quality Female Camping Int. Frame 10
SID007 Female Outdoors Sport 90K quality Female Outdoors Hiking 21
SID008 Male Urban School 80K quality Female Outdoors Sport 46
SID009 Male Camping Int. Frame 100K brand name Female Urban School 97
SID010 Male Urban School 60K price Female Urban Travel 61
SID011 Male Camping Int. Frame 90K quality Male Camping Ext. Frame 14
SID012 Male Outdoors Sport 110K brand name Male Camping Int. Frame 34
SID013 Male Camping Ext. Frame 80K quality Male Outdoors Hiking 34
SID014 Female Outdoors Sport 80K price Male Outdoors Sport 54
SID015 Female Urban School 70K quality Male Urban School 81
SID016 Male Urban School 80K brand name Male Urban Travel 42
SID017 Male Urban School 100K price
SID018 Male Urban Travel 140K quality
SID019 Male Camping Ext. Frame 60K price
SID020 Female Urban Travel 60K quality
SID021 Female Urban School 120K quality
SID022 Female Urban Travel 100K price
SID023 Male Camping Int. Frame 80K price
SID024 Female Urban School 100K customer support
SID025 Male Camping Int. Frame 130K quality
SID026 Male Urban School 100K brand name
SID027 Male Urban School 70K customer support
SID028 Male Urban Travel 120K price
SID029 Male Urban School 60K quality
SID030 Male Urban Travel 70K customer support
SID031 Male Outdoors Hiking 80K customer support
SID032 Male Urban School 60K price
SID033 Male Urban School 80K customer support
SID034 Female Urban Travel 110K quality
SID035 Female Urban School 110K quality
SID036 Male Urban School 90K quality
SID037 Female Urban School 80K quality
SID038 Male Camping Int. Frame 100K quality
SID039 Female Urban School 80K customer support
SID040 Female Urban School 60K quality
SID041 Male Outdoors Sport 90K quality
SID042 Female Urban School 90K customer support
SID043 Female Outdoors Sport 70K price
SID044 Female Outdoors Sport 60K quality
SID045 Male Camping Ext. Frame 100K customer support
SID046 Female Urban School 80K quality
SID047 Male Camping Ext. Frame 80K quality
SID048 Male Urban School 80K quality
SID049 Male Camping Ext. Frame 60K customer support
SID050 Female Outdoors Hiking 80K quality
SID051 Female Outdoors Sport 100K quality
SID052 Male Urban School 120K customer support
SID053 Male Outdoors Hiking 120K price
SID054 Male Outdoors Sport 50K brand name
SID055 Male Outdoors Sport 80K quality
SID056 Male Urban School 110K price
SID057 Male Urban Travel 90K customer support
SID058 Female Outdoors Hiking 100K brand name
SID059 Male Urban School 120K customer support
SID060 Female Outdoors Sport 100K quality
SID061 Female Outdoors Hiking 100K quality
SID062 Male Outdoors Hiking 80K price
SID063 Male Urban School 120K price
SID064 Male Outdoors Hiking 70K price
SID065 Female Urban School 120K price
SID066 Female Urban Travel 80K quality
SID067 Male Urban School 40K price
SID068 Male Outdoors Sport 110K brand name
SID069 Female Urban School 60K price
SID070 Female Urban School 70K customer support
SID071 Female Outdoors Sport 50K quality
SID072 Female Urban Travel 80K price
SID073 Female Urban Travel 80K customer support
SID074 Male Outdoors Sport 60K quality
SID075 Female Camping Int. Frame 100K customer support
SID076 Female Urban Travel 60K brand name
SID077 Female Camping Int. Frame 70K customer support
SID078 Male Outdoors Hiking 90K customer support
SID079 Female Outdoors Hiking 90K quality
SID080 Female Urban Travel 100K price
SID081 Female Urban School 110K brand name
SID082 Female Urban Travel 120K quality
SID083 Male Outdoors Sport 60K customer support
SID084 Male Urban School 100K price
SID085 Male Camping Int. Frame 90K quality
SID086 Female Urban School 70K quality
SID087 Male Urban Travel 80K price
SID088 Male Urban School 90K quality
SID089 Female Urban Travel 90K price
SID090 Female Urban Travel 60K quality
SID091 Male Urban School 80K customer support
SID092 Male Camping Ext. Frame 50K customer support
SID093 Female Outdoors Sport 90K quality
SID094 Male Camping Int. Frame 70K quality
SID095 Female Urban Travel 80K quality
SID096 Male Urban Travel 60K price
SID097 Male Urban School 100K price
SID098 Female Urban Travel 70K quality
SID099 Female Urban School 100K brand name
SID100 Male Outdoors Sport 80K brand name
SID101 Female Urban School 100K price
SID102 Female Urban Travel 130K price
SID103 Male Urban School 100K price
SID104 Male Outdoors Hiking 90K brand name
SID105 Male Camping Int. Frame 70K customer support
SID106 Male Urban Travel 90K customer support
SID107 Male Outdoors Sport 110K quality
SID108 Female Outdoors Sport 70K quality
SID109 Male Urban School 90K quality
SID110 Male Camping Ext. Frame 40K quality
SID111 Female Outdoors Hiking 80K quality
SID112 Male Outdoors Sport 90K price
SID113 Male Urban School 80K quality
SID114 Male Outdoors Sport 100K quality
SID115 Female Urban School 80K price
SID116 Female Urban Travel 120K price
SID117 Female Urban School 70K quality
SID118 Male Camping Ext. Frame 100K quality
SID119 Male Outdoors Hiking 100K quality
SID120 Male Camping Ext. Frame 100K quality
SID121 Female Urban Travel 80K quality
SID122 Female Urban Travel 70K customer support
SID123 Female Urban School 70K quality
SID124 Female Urban Travel 100K quality
SID125 Female Urban School 70K quality
SID126 Male Urban Travel 100K customer support
SID127 Female Outdoors Sport 60K quality
SID128 Female Urban Travel 80K price
SID129 Male Outdoors Sport 100K brand name
SID130 Male Urban School 80K customer support
SID131 Male Outdoors Sport 80K quality
SID132 Female Urban Travel 90K customer support
SID133 Male Urban School 60K price
SID134 Female Urban School 90K customer support
SID135 Male Urban School 90K quality
SID136 Female Urban School 60K quality
SID137 Female Outdoors Sport 40K price
SID138 Male Urban Travel 80K quality
SID139 Male Urban School 130K quality
SID140 Female Camping Int. Frame 100K price
SID141 Female Urban School 90K price
SID142 Female Outdoors Sport 90K quality
SID143 Male Outdoors Sport 90K price
SID144 Male Urban School 80K brand name
SID145 Female Urban School 120K price
SID146 Female Outdoors Hiking 80K quality
SID147 Male Camping Int. Frame 100K price
SID148 Female Outdoors Sport 40K brand name
SID149 Female Urban School 60K quality
SID150 Female Outdoors Hiking 100K price
SID151 Male Outdoors Sport 90K quality
SID152 Female Camping Int. Frame 80K quality
SID153 Male Camping Int. Frame 50K quality
SID154 Male Outdoors Sport 80K brand name
SID155 Male Urban School 90K quality
SID156 Male Urban Travel 110K customer support
SID157 Female Outdoors Sport 110K price
SID158 Female Urban School 70K price
SID159 Male Urban School 80K price
SID160 Female Outdoors Sport 90K price
SID161 Female Outdoors Hiking 70K customer support
SID162 Male Outdoors Hiking 60K quality
SID163 Male Urban Travel 70K quality
SID164 Female Urban School 80K price
SID165 Female Urban School 120K customer support
SID166 Male Urban School 40K price
SID167 Female Urban Travel 90K quality
SID168 Female Urban School 80K quality
SID169 Male Outdoors Sport 110K price
SID170 Female Urban Travel 90K quality
SID171 Male Urban Travel 70K price
SID172 Male Camping Int. Frame 80K brand name
SID173 Female Camping Ext. Frame 130K quality
SID174 Male Outdoors Sport 100K customer support
SID175 Male Urban Travel 120K brand name
SID176 Female Urban Travel 80K customer support
SID177 Male Urban Travel 110K customer support
SID178 Male Urban School 100K brand name
SID179 Female Urban Travel 100K brand name
SID180 Male Urban Travel 70K quality
SID181 Female Urban School 120K quality
SID182 Female Urban School 80K quality
SID183 Female Urban Travel 90K price
SID184 Male Outdoors Hiking 80K quality
SID185 Female Outdoors Sport 80K quality
SID186 Male Outdoors Sport 80K quality
SID187 Male Urban School 20K customer support
SID188 Female Outdoors Hiking 90K quality
SID189 Male Urban School 50K quality
SID190 Male Outdoors Sport 100K price
SID191 Female Urban School 70K quality
SID192 Female Outdoors Sport 80K quality
SID193 Female Urban Travel 110K customer support
SID194 Female Outdoors Sport 80K brand name
SID195 Male Urban Travel 100K price
SID196 Female Outdoors Hiking 80K customer support
SID197 Female Urban School 100K customer support
SID198 Male Outdoors Sport 50K customer support
SID199 Male Urban Travel 70K price
SID200 Female Urban Travel 110K brand name
SID201 Male Outdoors Sport 100K quality
SID202 Male Urban School 50K customer support
SID203 Female Outdoors Sport 120K price
SID204 Female Urban School 90K brand name
SID205 Female Urban School 100K customer support
SID206 Female Urban School 90K quality
SID207 Male Urban School 110K quality
SID208 Female Outdoors Hiking 40K customer support
SID209 Male Urban School 60K quality
SID210 Female Outdoors Sport 60K quality
SID211 Female Urban Travel 90K price
SID212 Male Urban School 80K brand name
SID213 Female Urban School 90K customer support
SID214 Female Urban School 80K quality
SID215 Male Urban Travel 70K price
SID216 Female Outdoors Sport 60K brand name
SID217 Female Outdoors Sport 100K quality
SID218 Male Urban Travel 90K quality
SID219 Female Urban School 90K brand name
SID220 Male Urban School 60K customer support
SID221 Male Outdoors Sport 70K quality
SID222 Female Urban Travel 80K customer support
SID223 Male Outdoors Sport 50K quality
SID224 Male Urban School 60K price
SID225 Female Urban Travel 80K brand name
SID226 Male Urban School 90K price
SID227 Female Urban School 70K quality
SID228 Male Urban School 50K price
SID229 Female Urban Travel 80K price
SID230 Female Urban School 100K price
SID231 Female Outdoors Sport 90K brand name
SID232 Female Urban School 110K customer support
SID233 Male Outdoors Hiking 50K quality
SID234 Female Urban School 100K brand name
SID235 Female Urban School 90K quality
SID236 Male Camping Int. Frame 80K price
SID237 Female Urban School 100K price
SID238 Female Urban Travel 90K customer support
SID239 Female Urban School 100K quality
SID240 Male Urban Travel 60K quality
SID241 Male Urban Travel 70K customer support
SID242 Male Urban School 50K brand name
SID243 Male Outdoors Sport 110K customer support
SID244 Female Outdoors Sport 120K price
SID245 Male Outdoors Hiking 90K price
SID246 Female Outdoors Hiking 80K brand name
SID247 Male Outdoors Sport 40K quality
SID248 Male Camping Int. Frame 100K brand name
SID249 Female Outdoors Sport 80K quality
SID250 Female Outdoors Sport 120K quality
SID251 Male Camping Int. Frame 40K quality
SID252 Male Outdoors Sport 110K customer support
SID253 Male Outdoors Hiking 60K quality
SID254 Male Urban Travel 100K customer support
SID255 Male Outdoors Sport 80K quality
SID256 Female Urban School 80K customer support
SID257 Male Urban School 70K customer support
SID258 Male Urban Travel 70K quality
SID259 Male Outdoors Sport 110K quality
SID260 Male Outdoors Hiking 100K price
SID261 Female Outdoors Sport 110K quality
SID262 Male Camping Ext. Frame 60K quality
SID263 Male Urban School 80K customer support
SID264 Male Outdoors Sport 20K customer support
SID265 Male Camping Int. Frame 100K customer support
SID266 Male Outdoors Sport 100K customer support
SID267 Female Urban School 90K quality
SID268 Male Urban School 110K price
SID269 Female Urban Travel 60K quality
SID270 Male Outdoors Hiking 30K customer support
SID271 Female Urban School 90K brand name
SID272 Female Urban Travel 110K quality
SID273 Male Camping Ext. Frame 110K price
SID274 Male Camping Int. Frame 80K quality
SID275 Male Urban School 60K price
SID276 Female Urban Travel 50K quality
SID277 Male Outdoors Hiking 100K quality
SID278 Male Urban Travel 100K quality
SID279 Male Urban School 120K price
SID280 Female Outdoors Sport 60K quality
SID281 Male Urban School 90K quality
SID282 Female Outdoors Sport 90K quality
SID283 Male Outdoors Sport 80K price
SID284 Female Urban School 80K price
SID285 Female Urban School 50K quality
SID286 Female Outdoors Sport 60K price
SID287 Female Urban School 70K price
SID288 Male Outdoors Sport 90K quality
SID289 Male Outdoors Sport 90K price
SID290 Female Urban School 70K quality
SID291 Male Camping Int. Frame 110K brand name
SID292 Female Urban School 90K quality
SID293 Male Urban School 120K quality
SID294 Male Urban Travel 100K quality
SID295 Male Camping Int. Frame 80K quality
SID296 Female Urban School 80K quality
SID297 Male Urban School 80K quality
SID298 Female Urban Travel 90K quality
SID299 Male Urban School 100K quality
SID300 Male Urban School 100K quality
SID301 Male Outdoors Hiking 90K quality
SID302 Male Urban School 110K customer support
SID303 Female Urban School 90K quality
SID304 Female Urban School 90K quality
SID305 Male Urban Travel 70K brand name
SID306 Male Urban School 80K brand name
SID307 Female Outdoors Hiking 90K quality
SID308 Female Urban Travel 60K quality
SID309 Male Camping Int. Frame 90K quality
SID310 Female Urban School 60K quality
SID311 Female Urban School 70K customer support
SID312 Male Urban Travel 100K customer support
SID313 Male Outdoors Hiking 110K quality
SID314 Female Urban School 80K quality
SID315 Male Outdoors Sport 110K customer support
SID316 Male Outdoors Hiking 120K quality
SID317 Female Camping Ext. Frame 70K quality
SID318 Male Urban School 90K quality
SID319 Female Urban School 120K customer support
SID320 Male Outdoors Sport 80K brand name
SID321 Male Outdoors Sport 80K quality
SID322 Male Urban Travel 60K customer support
SID323 Female Urban School 110K customer support
SID324 Male Outdoors Sport 40K brand name
SID325 Male Camping Int. Frame 90K brand name
SID326 Female Camping Int. Frame 100K quality
SID327 Female Outdoors Hiking 120K brand name
SID328 Male Outdoors Sport 110K customer support
SID329 Female Urban School 50K quality
SID330 Female Urban Travel 90K price
SID331 Male Outdoors Sport 60K quality
SID332 Female Urban Travel 90K quality
SID333 Female Urban School 70K quality
SID334 Female Urban School 60K price
SID335 Female Urban School 100K quality
SID336 Male Outdoors Hiking 100K quality
SID337 Female Urban School 60K price
SID338 Male Camping Int. Frame 110K price
SID339 Male Outdoors Sport 110K price
SID340 Male Camping Int. Frame 130K quality
SID341 Male Outdoors Hiking 180K customer support
SID342 Male Outdoors Hiking 110K customer support
SID343 Male Urban School 80K quality
SID344 Female Urban Travel 80K quality
SID345 Female Outdoors Sport 70K brand name
SID346 Male Camping Int. Frame 70K quality
SID347 Male Urban Travel 110K quality
SID348 Male Urban School 100K quality
SID349 Female Camping Int. Frame 100K brand name
SID350 Male Camping Ext. Frame 60K price
SID351 Female Urban School 70K brand name
SID352 Male Outdoors Sport 30K brand name
SID353 Male Outdoors Sport 90K quality
SID354 Male Urban School 110K price
SID355 Male Urban School 70K customer support
SID356 Male Camping Ext. Frame 90K customer support
SID357 Female Outdoors Sport 50K customer support
SID358 Female Outdoors Sport 50K quality
SID359 Female Outdoors Sport 110K customer support
SID360 Male Urban School 80K price
SID361 Female Urban Travel 70K price
SID362 Female Urban School 70K quality
SID363 Male Urban School 60K customer support
SID364 Female Outdoors Sport 100K customer support
SID365 Male Camping Int. Frame 80K price
SID366 Female Urban Travel 80K quality
SID367 Male Camping Int. Frame 120K quality
SID368 Male Outdoors Hiking 100K quality
SID369 Male Outdoors Hiking 80K brand name
SID370 Male Urban School 90K brand name
SID371 Female Urban School 70K price
SID372 Female Camping Int. Frame 80K brand name
SID373 Male Urban Travel 100K price
SID374 Female Urban School 90K quality
SID375 Male Urban Travel 80K customer support
SID376 Male Camping Int. Frame 100K brand name
SID377 Female Urban School 70K brand name
SID378 Female Outdoors Sport 70K quality
SID379 Male Urban School 60K customer support
SID380 Male Camping Int. Frame 90K quality
SID381 Male Camping Ext. Frame 70K quality
SID382 Female Urban School 80K customer support
SID383 Female Urban School 110K quality
SID384 Female Urban Travel 60K brand name
SID385 Male Outdoors Hiking 80K quality
SID386 Female Urban School 110K brand name
SID387 Male Urban School 90K price
SID388 Female Camping Ext. Frame 110K customer support
SID389 Female Urban School 80K quality
SID390 Female Outdoors Hiking 80K customer support
SID391 Female Urban School 60K price
SID392 Female Outdoors Hiking 90K price
SID393 Female Urban School 100K customer support
SID394 Female Urban School 70K quality
SID395 Female Urban School 100K price
SID396 Female Urban School 120K quality
SID397 Female Urban Travel 110K price
SID398 Male Urban School 100K quality
SID399 Female Outdoors Hiking 90K quality
SID400 Male Outdoors Hiking 120K brand name
SID401 Female Urban School 110K price
SID402 Male Outdoors Sport 110K price
SID403 Female Urban Travel 70K customer support
SID404 Female Urban School 110K quality
SID405 Female Urban School 70K quality
SID406 Female Urban School 100K quality
SID407 Female Camping Ext. Frame 60K quality
SID408 Male Camping Int. Frame 60K brand name
SID409 Female Urban School 90K quality
SID410 Female Outdoors Sport 90K customer support
SID411 Male Urban School 40K price
SID412 Male Urban Travel 90K quality
SID413 Male Outdoors Hiking 60K customer support
SID414 Male Camping Int. Frame 70K quality
SID415 Female Camping Int. Frame 90K customer support
SID416 Male Urban School 130K quality
SID417 Male Outdoors Sport 140K quality
SID418 Male Outdoors Hiking 110K price
SID419 Male Outdoors Hiking 170K price
SID420 Female Urban Travel 110K quality
SID421 Female Outdoors Hiking 60K quality
SID422 Female Outdoors Sport 110K price
SID423 Male Camping Int. Frame 70K quality
SID424 Male Outdoors Sport 130K quality
SID425 Female Urban School 120K quality
SID426 Male Camping Int. Frame 80K customer support
SID427 Male Urban Travel 80K customer support
SID428 Female Camping Int. Frame 60K customer support
SID429 Female Urban School 90K price
SID430 Female Outdoors Sport 80K quality
SID431 Male Outdoors Hiking 60K customer support
SID432 Female Outdoors Hiking 90K price
SID433 Male Outdoors Hiking 90K customer support
SID434 Female Urban School 80K quality
SID435 Male Urban Travel 100K price
SID436 Male Urban Travel 40K quality
SID437 Male Outdoors Sport 100K quality
SID438 Male Outdoors Hiking 100K quality
SID439 Male Camping Int. Frame 50K customer support
SID440 Male Urban School 50K price
SID441 Male Outdoors Sport 100K price
SID442 Female Camping Int. Frame 90K quality
SID443 Female Outdoors Sport 70K quality
SID444 Female Camping Ext. Frame 80K price
SID445 Male Urban Travel 90K quality
SID446 Female Outdoors Sport 70K quality
SID447 Female Outdoors Sport 80K quality
SID448 Female Urban Travel 70K brand name
SID449 Female Urban School 80K quality
SID450 Female Urban School 70K price
SID451 Female Urban School 110K quality
SID452 Female Urban Travel 90K quality
SID453 Female Urban School 100K price
SID454 Male Urban School 110K price
SID455 Male Urban Travel 60K quality
SID456 Male Urban School 90K price
SID457 Female Outdoors Sport 70K quality
SID458 Male Urban School 80K price
SID459 Female Urban Travel 130K price
SID460 Male Urban School 50K quality
SID461 Female Urban School 100K quality
SID462 Female Urban Travel 100K brand name
SID463 Female Outdoors Sport 70K brand name
SID464 Female Urban Travel 100K customer support
SID465 Male Camping Int. Frame 70K quality
SID466 Female Urban Travel 70K price
SID467 Male Urban Travel 100K price
SID468 Female Outdoors Sport 90K price
SID469 Male Urban School 80K customer support
SID470 Male Outdoors Sport 120K customer support
SID471 Female Outdoors Hiking 80K quality
SID472 Male Urban School 100K quality
SID473 Female Urban Travel 80K price
SID474 Male Urban School 120K brand name
SID475 Female Urban Travel 80K price
SID476 Female Urban Travel 100K brand name
SID477 Female Urban School 70K quality
SID478 Female Urban School 100K quality
SID479 Male Outdoors Sport 90K brand name
SID480 Male Urban School 120K brand name
SID481 Male Urban Travel 90K brand name
SID482 Male Camping Int. Frame 100K brand name
SID483 Female Urban Travel 70K customer support
SID484 Male Outdoors Sport 110K price
SID485 Male Outdoors Sport 40K price
SID486 Female Outdoors Sport 60K quality
SID487 Male Outdoors Hiking 120K quality
SID488 Male Urban Travel 90K quality
SID489 Male Urban Travel 100K quality
SID490 Male Outdoors Hiking 70K customer support
SID491 Female Urban School 90K quality
SID492 Male Urban School 100K quality
SID493 Male Outdoors Sport 100K customer support
SID494 Male Urban School 110K price
SID495 Male Urban School 70K quality
SID496 Female Camping Ext. Frame 90K quality
SID497 Female Urban Travel 100K quality
SID498 Female Outdoors Hiking 60K customer support
SID499 Female Urban Travel 80K brand name
SID500 Male Outdoors Hiking 120K quality

&F &A &D

Projected Production

Backspace Gear
Projected Production
Pack Type Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
School 500 750 1,000 1,200 1,500 2,000 2,500 3,000 4,000 6,000
Travel 600 800 1,200 1,500 1,800 2,500 3,000 3,500 3,500 4,000
Hiking - 0 - 0 100 300 500 750 1,000 1,250 1,500 2,000
Sport - 0 50 100 500 800 1,000 1,500 2,000 2,500 3,000
External Frame 50 250 500 750 1,000 1,500
Internal Frame - 0 - 0 - 0 - 0 50 500 800 1,000 1,500 2,000
Total Cases 1,100 1,600 2,400 3,500 4,700 7,000 9,300 11,500 14,000 18,500

&F &A &D

Projected Cash Flow

Backspace Gear
Projected Cash Flow
Category Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
Packs Produced and Sold 1,100 1,600 2,400 3,500 4,700 7,000 9,300 11,500 14,000 18,500
Revenue
School $ 50,000 $ 60,000 $ 75,000 $ 85,000 $ 100,000 $ 150,000 $ 175,000 $ 225,000 $ 300,000 $ 400,000
Travel 50,000 75,000 100,000 125,000 175,000 250,000 300,000 350,000 450,000 600,000
Hiking - 0 - 0 25,000 50,000 75,000 100,000 100,000 120,000 150,000 175,000
Sport 25,000 50,000 85,000 100,000 125,000 175,000 200,000 250,000
External Frame - 0 - 0 - 0 - 0 50,000 75,000 125,000 150,000 200,000 300,000
Internal Frame - 0 - 0 - 0 - 0 50,000 75,000 125,000 175,000 250,000 350,000
Total Revenue $ 100,000 $ 135,000 $ 225,000 $ 310,000 $ 535,000 $ 750,000 $ 950,000 $ 1,195,000 $ 1,550,000 $ 2,075,000
Expenses
Raw Material $ 17,000 $ 20,000 $ 30,000 $ 50,000 $ 75,000 $ 150,000 $ 200,000 $ 250,000 $ 400,000 $ 500,000
Labor 200,000 250,000 300,000 350,000 400,000 400,000 450,000 500,000 500,000 600,000
Infrastructure 25,000 25,000 35,000 35,000 45,000 45,000 50,000 55,000 60,000 60,000
Miscellaneous 75,000 35,000 25,000 25,000 35,000 50,000 50,000 50,000 75,000 75,000
Loan Repayment
Total Expenses $ 317,000 $ 330,000 $ 390,000 $ 460,000 $ 555,000 $ 645,000 $ 750,000 $ 855,000 $ 1,035,000 $ 1,235,000
Gross Income $ (217,000) $ (195,000) $ (165,000) $ (150,000) $ (20,000) $ 105,000 $ 200,000 $ 340,000 $ 515,000 $ 840,000
Loss Carry Forward (217,000) (412,000) (577,000) (727,000) (747,000) (642,000) (442,000) (102,000) - 0 - 0
Income Tax @32% - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 (164,800) (268,800)
Net Income $ (217,000) $ (195,000) $ (165,000) $ (150,000) $ (20,000) $ 105,000 $ 200,000 $ 340,000 $ 350,200 $ 571,200
Capital Purchases $ (150,000) $ (50,000) $ (50,000) $ (50,000) $ (50,000) $ (50,000) $ (50,000) $ (70,000) $ (75,000) $ (85,000)
Depreciation 30,000 75,000 72,000 70,000 65,000 65,000 60,000 50,000 25,000 25,000
Cash Flow $ (337,000) $ (170,000) $ (143,000) $ (130,000) $ (5,000) $ 120,000 $ 210,000 $ 320,000 $ 300,200 $ 511,200

&F &A &D

Projected Gross Income

Backspace Gear
Projected Gross Income
Year Gross Income
2017 $ (237,000)
2018 (215,000)
2019 (185,000)
2020 (170,000)
2021 (40,000)
2022 85,000
2023 180,000
2024 320,000
2025 495,000
2026 820,000

&F &A &D

image1.png