Question

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.


$1.99
Sales0
Views119
Comments0
  • CreatedSeptember 22, 2015
  • Files Included
Post your question
5000