Based on your answer to question 1, what should the annual investment be if the companys goal were to reach $500,000 at the end of the 5 years? HINT: Use Goal Seek in Excel (Review Appendix A if needed).

a. Are net sales growth rates truly expected to be the same every year?

b. Is it reasonable to expect a flat portfolio growth rate increase each year? We know that financial markets vary widely over time, so you are now thinking that a flat growth rate is not reasonable.