Module 2A Assignment By the due date, submit the answers to the following in an Excel spreadsheet one tab per question. Submit only ONE file. Total 20 points. Counts as participation assignment. Be sure to allow for inputs to be entered in distinct, labeled cells, and that each calculated cell has a formula (not just a number). This is the equivalent of must show all work. Submissions that do not do this, even with correct numbers, will be penalized at least 50%.

1. [10pts] Find a set of no more than 10 (can be less than 10) cash flows with exactly 2 positive internal rates of return. Show the cash flows, the IRRs, and graph the NPV profile.

2. [10pts] Consider a 15-year monthly annuity-style loan for $300,000. The fixed interest rate is 8.125% MEY. Amortize the loan and graph (1) payment, interest paid and principal paid v time, and separately (2) the loan balance over time. Make sure the graphs are at the top of a separate tab and suitably cleaned up.