Nova Corporation Case

In this assignment I was asked to carry out a financial analysis of a proposal for the NOVA Corporation and to include analysis concerning the possible impact of a price change for their product in question. I was asked to consider several sales growth scenarios and expected to obtain the NPV of the project for over a five-year period. The model also needed to allow for measuring NPV as change in sales volume, price and labor cost occurred.
I first needed to acquire additional information to complete a spreadsheet that would compute the cash flows for the analysis. I learned cash flow in any year depends on sales volume and profit margin per unit in that year. I learned that sales volume is a function of price. Also profit margin per unit is calculated by the difference between price per unit and costs per unit.
After filling in the table data for years 2008-2012

But in this assignment I had a few things that I have never been subjected to or had to do before. That is what is great about taking these classes and having the ability to broaden your knowledge and know how.
A wide variety of data sources can be used to import data into Excel. In this assignment we imported data from a text file into a worksheet. The use of the Import wizard helps to examine the files you are importing and ensures that you can import it in the way you need to. I have imported data into Excel and have also imported/exported data to Access from Excel. This portion of the assignment was not difficult to me.
Pivot tables are a powerful feature in Excel. It allows you to sort large amounts of data easily and allows for certain distinction in what is pulled and sorted. I currently use pivot tables daily with my job and have used them in my past work experiences. They ability to sort data is vital; it allows you so many different options for how you can display important information in your