Sunshine Travel, Inc. is a producer of upright suitcases. Its current line of upright suitcases are selling excellently. However, in order to cope with the foreseeable competition from other similar products, ST spent $6,200,000 to develop a new line of smart upright suitcases (new model development cost) that enable users to track easily the location of their suitcases using an app on their cell phones. The smart suitcase model has a built-in global tracker which applies the state-of-the-art micro-electronics and ground-based cellular telephone technologies to track and report its location. In addition, its digital self scale weighs itself automatically once it is filled with contents. The sensors in the side studs of the suitcase will send the information on the measured weight to the accompanying app on the user's cell phone for his/her review so as to avoid unnecessary overweight charges by the airlines when flying. The suitcase's shell is made of polycarbonate that will certainly provide extra strength and durability to protect the contents inside it. Its fine wheels and lightweight handle make the suitcase super easy to use by travelers. The suitcase's TSA friendly locks provide convenience and its multidirectional 360 degree dual wheels enable its user to move the suitcase more smoothly and in a more stable way at the same time. The company had also spent a further $1,000,000 to study the marketability of this new line of smart upright suitcases (marketability studying cost).

ST is able to produce the smart upright suitcases at a variable cost of $60 each. The total fixed costs for the operation are expected to be $10,000,000 per year. ST expects to sell 3,500,000 suitcases, 4,300,000 suitcases, 3,200,000 suitcases, 1,800,000 suitcases and 1,200,000 suitcases of the new model per year over the next five years respectively. The new smart upright suitcases will be selling at a price of $150 each. To launch this new line of production, ST needs to invest $35,000,000 in equipment which will be depreciated on a seven-year MACRS schedule. The value of the used equipment is expected to be worth $3,800,000 as at the end of the 5 year project life.

ST is planning to stop producing the existing suitcase model entirely in two years. Should ST not introduce the smart upright suitcases, sales per year of the existing model will be 1,800,000 suitcases and 1,400,000 suitcases for the next two years respectively. The existing model can be produced at variable costs of $50 each and total fixed costs of $7,500,000 per year. The existing suitcases are selling for $115 each. If ST produces the smart upright model, sales of existing model will be eroded by 1,080,000 suitcases for next year and 1,190,000 suitcases for the year after next. In addition, to promote sales of the existing model alongside with the smart upright model, ST has to reduce the price of the existing model to $85 each. Net working capital for the smart upright suitcase project will be 20 percent of sales and will vary with the occurrence of the cash flows. As such, there will be no initial NWC required. The first change in NWC is expected to occur in year 1 according to the sales of the year. ST is currently in the tax bracket of 35 percent and it requires a 20 percent returns on all of its projects. The firm also requires a payback of 3 years for all projects.

CASH FLOW ESTIMATION: Complete the following table below. Year 1 Year 3 Year 4 Year 5 $ D ) Year 2 $ $ 0 $ ta Sales VC Fixed costs Dep EBT Taxes (35%) $ $ $ AAAAA At tA AA AAAAL NI $ $ $ 7 $ + Dep OCF $ $ $ NWC Beg -End NWC CF $ AA $D $ $ tata $ NCF CASH FLOW ESTIMATION: Complete the following table below. Year 1 Year 3 Year 4 Year 5 $ D ) Year 2 $ $ 0 $ ta Sales VC Fixed costs Dep EBT Taxes (35%) $ $ $ AAAAA At tA AA AAAAL NI $ $ $ 7 $ + Dep OCF $ $ $ NWC Beg -End NWC CF $ AA $D $ $ tata $ NCF