Question: table [ [ Project Option # 4 : Manufacture Liquid Caffi,,,,,,,, ] , [ Expansion Project Title, table [ [ Project Description and

\table[[Project Option #4: Manufacture Liquid Caffi,,,,,,,,],[Expansion Project Title,\table[[Project Description and],[Details]],\table[[Project Cost],[(Initial]],\table[[First Year Cash],[Flow]],\table[[Annual Growth],[Rate (5 years)]],\table[[Expenses as a],[percentage of]],Payback Period,NPV,IRR],[Development of Straight Caffine,\table[[This project is another],[brain child of the research],[and development team.],[It extracts the caffine that],[is naturally found in],[coffee and concentrates it],[into a liquid, squirtable],[additive that can be used],[in any drink. R&D has],[been using variations of],[this liquid caffine to],[increase department],[productivity. Since it],[already exists,],[investment would be],[minimal.]],$6,500,000,$2,500,000,4%,32%,,,],[Calculation of Minimum Payback Period:,,,Years,,,,,],[,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[NPV of Projected Cash Flows,,,,,,,,],[,,,,,,,,],[,Year 0 Cash Flow,Year 1 Cash Flow,Year 2 Cash Flow,Year 3 Cash Flow,\table[[Year 4 Cash],[Flow]],\table[[Year 5 Cash],[Flow]],,],[Projected Revenues at annual growth rate,,,,,,,,],[Projected Expenses at 32% of Revenue,,,,,,,,],[Annual Cash Flows,,,,,,,,],[Discount rate for each year (6%),,,,,,,,],[Present value of cash flows,,,,,,,,],[,,,,,,,,],[NPV of Projected Cash Flows,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[Internal Rate of Return (IRR):,,,,,,,,]]
 \table[[Project Option #4: Manufacture Liquid Caffi,,,,,,,,],[Expansion Project Title,\table[[Project Description and],[Details]],\table[[Project Cost],[(Initial]],\table[[First

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!