Use the following information on the selected company (NOVARTIS):
- Revenues =start with the most current year you can fine and increase by 8% each year
- Expenses = start with the same year for revuenue and increase by 10% each year
- Tax rate = 25%
- Discount rate = 10%
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®.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
- Calculate the 5-year projected income.
- Calculate a 5-year projected cash flow.
- Calculate net present value (NPV).
- Calculate the internal rate of return (IRR).