Homework: Business Financial & Customer KPI Analysis
For your first homework, you will be completing a Financial and Customer KPI Analysis for CrushIt, a digital startup business using the provided template. If you'd like to use the data associated with your own business or one you're interested in instead, you may but please communicate with your professor before doing so. Otherwise, you will use the numbers supplied on the data information sheet that goes along with the homework.
Using the data from the Homework data sheet, fill in the numbers in the yellow highlighted boxes. The KPIs will be automatically calculated. Please do not overwrite the formulas in the light orange cells. You will be determining:
o Net Profit o Gross Profit Margin o DE/Ratio o Working Capital Ratio o P/E Ratio o NPS o Customer Retention Rate AND o Customer Turnover Rate
The KPI formulas are also listed for your reference. After you have completed all of the KPI calculations within the template, you will type your takeaways related to the computed KPIs from the both the Financial and Customer aspects of the business below the template.
Note: Choose three of the five financial KPIs for your takeaways and provide your rationale for choosing them.
Include a business summary of what you found. Example: What do these KPI figures say about the business in terms of its strengths, weaknesses and areas of growth/opportunity? How does the company compare to the industry and/or prior year's performance? What is most important for your audience to know & why?
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.