Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
An insurance company is negotiating contract terms on a $100m commercial mortgage loan with a potential borrower. The loan in question is a monthly payment, 20-year amortization, fixed rate balloon with a seven-year term (i.e., maturity), and annual interest rate of 5.85% and 1.5 points of disbursementdiscount. Calculate the yield to the lender assuming the loan is held to the end of the term (assume a loan amount of $100, ignore the millions). (You should use Excel by creating a spreadsheet that takes the mortgage contract terms (amount, rate, etc.) as inputs and then use financialfunctions [=PMT( ), =FV( ), etc.] to calculate PMT and OLB. I your Excel you will show the mortgage cash flows from month 0 to month 84 in a single column,and use the =IRR( ) function to solve for the yield to the lender.)
Consider the situation in the previous question. Now suppose that the borrower wants to modify the loan cash flows as follows: payments are interest-only for the first two years in the life of the loan, and then amortized payments start in the first month of the third year, with a 20-year amortization period[hence, payments in years 3 to 7 are the same as those you calculated in the original loan in part (a)]. The lender agrees but only if the borrower promisesto make a lump sum payment, in addition to the OLB at the end of year 7, such that the lender´s yield (IRR) is 6.5%. Determine the size of the lump sumpayment. (Modify the Excel spreadsheet you created before and add another column to make the required changes to the PMTs and OLB(84),and then determine the additional lump sum required to make the IRR equal 6.5%.)
A) $0B) $1004C) $3120D) $6700
If ai = 0, bi = 1.2, ci = -0.4, and di = 1.3, what is the stock's predicted return? Do not round intermediate calculations.
A trader opens a new position by writing two put option contracts. Each contract is on 100 shares of Exxon Mobil common stock. The option premium is $6.06, the
What is the present value of cash outflows for each of these alternatives, using the after-tax cost of debt as the discount rate
Why does the market value of the claim on the assets of a company equal the market value of the assets
Discount Interest Loans. This question illustrates what is known as discount interest. Imagine you are discussing a loan with a somewhat unscrupulous lender.
Explain using examples what are the usefulness of disclosure notes to the users of the financial statements.
What are the advantages of the possible upgrading of RBC's operations in Thailand to a branch status? What are Thailand's most important exports?
You have been requested by the secretary of agriculture of a Central American country to determine whether cattle produced in that country could be hedged.
Start by establishing a timeline placing the major events of the case in chronological order.
If we did not touch the money that is currently in the bank, how much more money will the company need to earn at the end of the 4th year to pay for the second
The contract states the work is expected to start within five business days. What steps should you take as the project manager to resolve this?
dozier corporation is a fast-growing supplier of office products. analysts project the following free cash flows fcfs
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd