Compute and analyze the financial data using a Microsoft® Excel® spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so others can see how you arrived at your calculations and analysis. Items should be submitted in Microsoft® Excel®; indicate your recommendation in the
Calculate a 5-year projected cash flow.
Revenues = increasing by 8% each year
Expenses = increasing by 10% each year
Tax rate = 25%
Discount rate = 10%