Tools Data Window Help AutoSave OFF D C ... ne Finance Advanced Excel Test - DMe sales finance Review View Tell me Insert Draw Page Layout Formulas Data Calibri ID 10 > ' ' General Conditional Il lil 191 BIU HIU III ilil !!! Format as . $ % ) de 28 Call Styles fx D Instructions: "Database" tab contains all the raw data required for the analysis. Create a high level "summary" tab to summarize the total business by quarter and year. Create a chart to show the trend of units, bookings, and price. Calculate the Yoy (year over year) and QoQ (quarter over quarter) growth for units and bookings Create a detailed level summary tab to summarize the business by qur and year which will help answer below questions and provide your analysis/observations Which state has been performing well? Which animal is better cator dog? Would you recommend trained or untrained cat/dog Whats the average price of cat and dog, whose price is better? Calculate the forecast for FY21 and provide your assumptions (Metrics - Units/bookings/price/revenue/ARR/Attrition/cost and Margin) Calculate the following metrics Metrics Asumptions Contract duration period - 12 months ARA Business started in Q1 2015 and customers are renewing the contract on a yearly basis Attrition For Q115 attrition rate refer the "Rate assumption" Tab. The attrition rate is increasing by 0.1% every Qtr exce Revenue Tools Data Window Help AutoSave OFF D C ... ne Finance Advanced Excel Test - DMe sales finance Review View Tell me Insert Draw Page Layout Formulas Data Calibri ID 10 > ' ' General Conditional Il lil 191 BIU HIU III ilil !!! Format as . $ % ) de 28 Call Styles fx D Instructions: "Database" tab contains all the raw data required for the analysis. Create a high level "summary" tab to summarize the total business by quarter and year. Create a chart to show the trend of units, bookings, and price. Calculate the Yoy (year over year) and QoQ (quarter over quarter) growth for units and bookings Create a detailed level summary tab to summarize the business by qur and year which will help answer below questions and provide your analysis/observations Which state has been performing well? Which animal is better cator dog? Would you recommend trained or untrained cat/dog Whats the average price of cat and dog, whose price is better? Calculate the forecast for FY21 and provide your assumptions (Metrics - Units/bookings/price/revenue/ARR/Attrition/cost and Margin) Calculate the following metrics Metrics Asumptions Contract duration period - 12 months ARA Business started in Q1 2015 and customers are renewing the contract on a yearly basis Attrition For Q115 attrition rate refer the "Rate assumption" Tab. The attrition rate is increasing by 0.1% every Qtr exce Revenue