1) The optical products division of Panasonic is planning a $3.5 million building expansion for manufacturing its powerful Lumix DMC digital zoom camera. If the company uses an interest rate of 16% per year, compounded quarterly for all new investments, what is the uniform amount per quarter the company must make in order to recover its investment in 6 years?
The uniform amount per quarter that the company must make in order to recover its investment in 6 years is $
2) Environmental recovery company RexChem Partners plans to finance a site reclamation project that will require a 4-year cleanup period. If the company borrows $4.1 million now, how much will the company have to get at the end of each year in order to earn 15% per year, compounded quarterly on its investment? Calculate the answer using both formula and spreadsheet function?
In order to earn 15% per year compounded quarterly on its investment at the end of each year, the company will have to get $