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. 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 ProfitStep 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
