I need solution by financial calculator not by excel.
Thank you
[15] A homeowner purchases a property for $500,000. He finances the purchase with an 80% LT. 30-year fully amortizing GPM carrying a 10% interest rate. An 8% rate of graduation will be applied to monthly payments beginning year 2 and the beginning of year 3, only (payments in years 3 and 4 and on are the same). The homeowner will sell the property after 5 years and does not curtail the loan. Upfront fees amount to 3% of the loan amount, and a soft prepayment penalty of 3% applies. 1. [61 What is the first year's payment? B. A. 12] What is the OLB at the end of year 5? (4] What is the effective cost of the loan? C. D. 13] All else equal, would you expect the note rate for an equivalent fully amortizing, constant payment mortgage to be or to 10%? Explain your answer. 2. [15 points] In what follows, assume fully amortizing, level payment mortgages, and that only scheduled payments are made (both in past and future). Ignore the effect of taxes and the value of the option to refi again, later. A borrower has had a 30 year, 8%, $500,000 mortgage for 5 years. Closing fees on this mortgage were 3% of the loan amount, and the prepayment penalty is 4% of OLB. The borrower is considering a refi into a 15-year mortgage at 7%. She will finance the payoff and all fees, and take out no additional cash. The closing fees on the new mortgage are 3% of the loan amount. The borrower will sell the house and pay off any remaining mortgage 20 years from now. What is the NPV of refinancing, and should the borrower refi? 3. [15 pts] Consider a semiannual 30-year risk-free, option-free bullet bond with a yield of 6% and coupon of 5%. a. [10 pts] Compute its modified duration and convexity. Hint: use the numerical approximation for a derivative. b. [5 pts) Suppose yield decline by 1%. Find the %error in the %-change of the value of the bond when (1) using duration only, and (i) using duration and convexity