I can't figure out how to create a "what-if" summary by using 2 cells for each scenario. For example, there is a $1,000 loan with payments of $50,$100,$150 and a $2000 loan with payments of $100,$150,$250, the interest rate is 10%.How can I use the scenario manager to create a summary showing different payback lengths and total amount paid?
No comments:
Post a Comment