Create Spreadsheet on excel Content Video games direct is modeling out the next 5 years...

60.1K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students