Question: I need help with putting the answers into excel. Need formulas Annual revenue growth rates are between 20 percent and 60 percent. Annual expense growth

I need help with putting the answers into excel. I need help with putting the answers into excel. Need formulas

Annual revenue growth rates are between 20 percent and 60 percent.

Annual expense growth rates are between 10 and 30 percent

Future revenue/expense=current revenue/expense x(1+Growth rate)^number of years

in the worst case scenario, annual revenue growth rate of 20% and annual expense growth rate of 10% will be used

Worst Case Revenue Expenses Revenue Growth Expense Growth $ $ Expected Case Revenue Expenses Revenue Growth Expense Growth 100,000,000 150,000,000 0.2 0.1 $ 100,000,000 $ 150,000,000 Best Case Revenue Expenses Revenue Growth Expense Growth $ 100,000,000 $ 150,000,000 0.6 0.3 0.4 0.2 Years Expected Revenue Expected Expenses Total Profit Years Expected Revenue Expected Expenses Total Profit Years Expected Revenue Expected Expenses Total Profit

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 General Management Questions!