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 year 2 year 3 year 4 year 5 total CAGR maximum average median minimum
%--- Revenue
less:expenses
net income
%----- expenses%revenue