Question: Exhibit 1 4 A B&K Distributors - ROI Model Summary Page ( US$ in thousands ) table [ [ , Year 0 , Year

Exhibit 14A
B&K Distributors-ROI ModelSummary Page (US$ in thousands)
\table[[,Year 0,Year 1,Year 2,Year 3,Year 4,Year 5],[Revenue],[Upside,,4,643,5,619,6,487,7,293,7,886],[Baseline,,3,608,3,828,4,061,4,308,4,569],[Incremental,,1,035,1,791,2,426,2,986,3,316],[Net income],[Upside,,583,734,878,1,003,1,121],[Baseline,,436,463,491,521,552],[Incremental,,147,272,387,,569],[Incremental investment program (after tax)],[Upfront costs,(387),,,,,,],[Ongoing costs,,(283),(291),(300),(309),(319)],[Total,(387),(283),(291),,(300),(309),(319)],[Total (after tax),(240),(175),(181),(186),(192),(197)],[,,,,,,],[Total incremental cash flow,(240),(28),91,201,291,,371],[,\bar ((268)),\bar ((177)),\bar (24),\bar (314),6886],[Five-year IRR],[,,,,,,],[Net present value],[Discount rate,12%,,,,,],[Tax rate,38%,,,,,],[Support cost inflation rate,3%,,,,,],[,,,,,,],[Three-year IRR,3.3%,,,,,],[Total incremental cash flow,(240),(28),91,201,291,371],[Cumulative cash flows,,(268),(177),24,314,686],[Payback,,,,,,]]Read the B&K Distributors: Calculating ROI for a WebBased Customer Portal and complete your case analysis.
Please ensure that you answer the following questions:
1) What is the ROI for the proposed web portal project?
2) If you were B&Ks CEO would you move forward with this project?
Please answer the above questions in a word document. Please elaborate as much as you can.
This particular case study may be less than 3 pages.
Also, please complete Exhibit 14A (summary ROI) with the appropriate numbers in the excel file provided. I am most interested in: five year IRR, NPV, and payback.
Submission Requirements: Please submit the completed Excel sheet attached with the requested cells filled in along with the case study write up.
Be prepared to discuss the following: 1) summarize the key Business Analytics issues in the case; 2) make recommendations on how the issues should be handled; & 3) provide a justification for the recommendations.
All case assignments are due by Sundays, midnight, in word format in Moodle. For more information regarding how the cases will be grades, please refer to the case analysis grading rubric on Moodle.
 Exhibit 14A B&K Distributors-ROI ModelSummary Page (US$ in thousands) \table[[,Year 0,Year

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!