Question: Exhibit 1 4 A B&K Distributors - ROI Model Summary Page ( US$ in thousands ) table [ [ , Year 0 , Year
Exhibit A
B&K DistributorsROI ModelSummary Page US$ in thousands
tableYear Year Year Year Year Year RevenueUpsideBaselineIncrementalNet incomeUpsideBaselineIncrementalIncremental investment program after taxUpfront costs,Ongoing costs,,TotalTotal after taxTotal incremental cash flow,bar bar bar bar Fiveyear IRRNet present valueDiscount rate,Tax rate,Support cost inflation rate,Threeyear IRR,Total incremental cash flow,Cumulative cash flows,,PaybackRead the B&K Distributors: Calculating ROI for a WebBased Customer Portal and complete your case analysis.
Please ensure that you answer the following questions:
What is the ROI for the proposed web portal project?
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 pages.
Also, please complete Exhibit A 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: summarize the key Business Analytics issues in the case; make recommendations on how the issues should be handled; & 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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
