Consider the Everglade cash flow problem analyzed in Sec. 28.3. The spreadsheet model is available on this website.
(a) Generate a parameter analysis report to consider five possible long-term loan amounts between $0 million and $20 million and forecast Everglade’s mean ending balance. Which long-term loan amount maximizes Everglade’s mean ending balance?
(b) Generate a trend chart for the five long-term loan amounts considered in part a.
(c) Use ASPE’s Solver to search for the long-term loan amount that maximizes Evergreen’s mean ending balance.