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 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!