COST BENEFIT ANALYSIS

I buy widgets from a wholesaler at $3.50 each and sell them from my store in a strip mall for $10.00. It costs $1.50 to ship them to m store, sol clear $5.00 per Widget: Demand for my Widgets is 50,000 units, so my Gross Profits are $250,000/ year. According to a trade organization, Price Elasticity models show if I could sell them for $8.00,1 could sell 100,000 units. I'd only make $3.00 per unit, but my gross profit would increase to $300,000. However, the increase in market share would eventually translate to more sales when customers return to buy new Widgets to replace their worn out Widgets. The risk of this model being wrong is very low since stores in other states have experienced similar volume increases. With a sizeable investment, could practically eliminate the shipping costs, and I know I could make them cheaper if I had the equipment: Would have to buy $50,000 in raw materials. Land about a mile away is available for $150,000 and it would cost $350,000 for the equipment and a building. My shipping costs would drop to only 15 cents per Widget, and my cost per unit would only be $1.00 I'mnot good a financial stuff, so a $550,000 up front cost doesn't seem worth it to me, so lve asked you for your opinion. The Bulding and Equipment depreciate over 5 years with a salvage value of $250,000. The land would appreciate in value to 275,000 . My tax rate is 25% and I can get a loan at 3.8% and my Money Market Savings Account earns 1.29% For the terminal cash flow. assume I will have and can sell my raw materials for the same $50,000. This is not an annual expense since the cost of this materialis in the cost of Goods Sold (Cost per Widget). What do you think? Should I do it? 7 Current New 8 Demand for Widgets 9 Selling Price 10 11 Cost per Widget 12 Shipping Cost per Widget 13 Per Widget GP 14 Gross Profit 15 Investment in raw materials 16 Investment in Land 17 Salvage value of land 18 Actual Sale of Land 19 Plant and Equipment 20 Salvage value of Plant \& Equipment 21 Actual Sale of Plant \& Equipment 22 Depreciable P\&E 23 Life of Project 24 Tax Rate WACC 27 Investment/Savings Rate 28 What's my initial outlay? 29 Annual Change in Ater-tax Cash Flow 30 Terminal Cash Flow Discounted Payback Payback Penod Profitability Index NPV IRR MIRR \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} (5 points) (5 points ) (5 points ) (5 points ) (2.5 points) (2.5 poirts ) \begin{tabular}{|l|} \hline 0 \\ \hline 0 \\ \hline 0 \\ \hline 0 \\ \hline 0 \\ \hline 0 \\ \hline \end{tabular} (5 point