Question
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.
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. 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 suitable cleaned up.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started