4. 10.26 The strategic plan of a solar energy company that manufactures high-efficiency solar cells includes an expansion of its physical plant in 4 years. As the engineer in charge of facilities, you estimate that the expenditure required now is $8,000,000, but in 4 years the cost will be higher by an amount equal to the annual inflation rate. If the company sets aside $7,000,000 now and it earns at 7% per year, you want to inform the finance committee of the maximum inflation rate allowed to ensure that exactly the right amount of money is available for the expansion. What is that inflation rate? Solve by

(a) factors, and

(b) a spreadsheet with GOAL SEEK.