Question: Create Spreadsheet on excel Content Video games direct is modeling out the next 5 years of revenues, expenses and profits based on the following assumptions:
Create Spreadsheet on excel Content Video games direct is modeling out the next 5 years of revenues, expenses and profits based on the following assumptions: Revenue = $100,000 in year 1 and expected to grow 10%/year through year 5 Expenses = $50,000 in year 1 and expected to leverage 120 bps (i.e. 1.2%)/year through year 5 Use the following format:
Driver year1 year2 year3 year4 year5 total CAGR maximum average median minimum
%--- Revenue
less:expenses
net income
%----- expenses%revenue
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
