I was having trouble calculating this problem as this is my third attempt at solving this on my own. I'm hoping to ask if someone can walk me through this when providing the answer in excel. Thanks in advance!

You work for Apple. After toiling away on $9.3 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the wink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along (or until users are unable to interact with actual human beings). Revenues are projected to be $456.7 million per year along with expenses of $358.5 million. You will need to spend $55.2 million immediately on additional equipment that will be depreciated using the 5 -year MACRS schedule. Additionally, you will use some fully depreciated existing equipment that has a market value of $10.8 million. As the iGlasses are an outcome of the R\&D center, Apple plans to charge $4.7 million of the annual costs of the center to the iGlasses product for four years. Finally, Apple's working capital levels will increase from their current level of $120.4 million to $139.7 million immediately. They will remain at the elevated level until year 4 , when they will return to $120.4 million. Apple's discount rate for this project is 14.4% and its tax rate is 21%. Calculate the free cash flows and determine the NPV of this project. (Note: Assume that the opportunity cost must be after-tax and the equipment is put into use in year 1.) You work for Apple. After toiling away on $9.3 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the wink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along (or until users are unable to interact with actual human beings). Revenues are projected to be $456.7 million per year along with expenses of $358.5 million. You will need to spend $55.2 million immediately on additional equipment that will be depreciated using the 5 -year MACRS schedule. Additionally, you will use some fully depreciated existing equipment that has a market value of $10.8 million. As the iGlasses are an outcome of the R\&D center, Apple plans to charge $4.7 million of the annual costs of the center to the iGlasses product for four years. Finally, Apple's working capital levels will increase from their current level of $120.4 million to $139.7 million immediately. They will remain at the elevated level until year 4 , when they will return to $120.4 million. Apple's discount rate for this project is 14.4% and its tax rate is 21%. Calculate the free cash flows and determine the NPV of this project. (Note: Assume that the opportunity cost must be after-tax and the equipment is put into use in year 1.)