FRL 3832 Business Finance Excel Question
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
HW 1
FRL 3832
Total: 50 points. Show all work for full credit (annotate relevant formulae in excel, substantial penalties otherwise). Make sure your presentation is clear and staple in the order of the questions. Excel table rules apply (show no more than 1 page of repeated rows, 5-point penalty otherwise).
1. [15 pts] The average life τ of a bond is defined as
where PCFt is the principal cash flow at time t, and T is the maturity of the bond.
a. [1 pt.] What is the average life of a zero-coupon bond? Show work
b. [1 pt.] What is the average life of an interest only bond? Show work
c. [2 pts] Consider a fully amortizing level-payment fixed-rate mortgage that does not default, nor is it ever curtailed or prepaid. Show that
where c is the mortgage contract rate.
d. [11 pts] Compute the realized average life of a 30 yr., 5/1 ARM with initial rate of 4%, and a margin of 2%. The underlying index is (date in yrs., index in %): (0,2), (1,3), (2,3), (3,2.5), (4,3), (5,5), (6,5), and (7-30,6). The loan is never prepaid, nor curtailed, nor defaults. There are no rate or payment caps. Annotate any excel and show all work.
2. [6 pts] A borrower is faced with choosing between two fully amortizing level-payment loans. Loan A is available for $75,000 at 10% MEY for 30 years, with 6 points included in the closing costs. Loan B would be made for the same amount, but at 11% MEY for 30 years, with 2 points included in the closing costs. Neither loan defaults/is curtailed.
a. [4] If the loan is to be repaid after 15 years, which is the better choice?
b. [2] If the loan is repaid after 5 years, which is the better choice?
Hint: Use the effective cost of borrowing to make the decision. Show work.
3. [14 pts]
A. [2] Describe the model of firm equity as a call option on assets of the firm. What does it mean for this option to be “out-the-money?”
B. [3] Why were many thrifts insolvent by the early 1980’s?
C. [4] Using the equity model in A, and the concept of forbearance, describe and explain the behavior of thrifts, both insolvent and solvent, in the early 1980’s.
D. [2] How does securitization help mitigate the problem described in B?
E. [3] Describe how securitization eventually played a role in the creation of the “RE bubble” of the early- to mid-2000’s.
4. [15 pts] You have had a 30yr FA FRM at 8% for 7 years. The original principal was 1,200,000. You are considering a cash-out refi into a 15-year mortgage at 6.5%. The old mortgage has a prepay penalty of 3% if payoff occurs before year 8. The new mortgage has variable fees of 3%, and fixed fees of $10,000, and a 2% prepay penalty. The additional cash is for a $100,000 car which you must have and can be borrowed elsewhere at 8% over 10 years, with upfront fees of $500.
Assume that all fees will be financed, and that under either scenario you will be moving 12 years from now. Ignore taxes, the option to wait to refinance, and assume no loan is prepaid, curtailed, nor ever defaults.
What is the NPV of refinancing? Show all work.
Essay writing help – FRL 3832 Business Finance Excel Question Online Essay Writing Agency – EssayGuru Pro.
DO MY HOMEWORK NOW!Write my Essay. Premium essay writing services is the ideal place for homework help or essay writing service. if you are looking for affordable, high quality & non-plagiarized papers, click on the button below to place your order. Provide us with the instructions and one of our writers will deliver a unique, no plagiarism, and professional paper.
Get help with your toughest assignments and get them solved by a Reliable Custom Papers Writing Company. Save time, money and get quality papers. Buying an excellent plagiarism-free paper is a piece of cake!
All our papers are written from scratch. We can cover any assignment/essay in your field of study.
