BroadStreet Bank has just been given a $10,000,000, 5 year CD deposit by the local municipality. The bank has agreed to pay 8%, compounded annually on this deposit. The bank wishes to choose one debt investment to cover this deposit, so that they have earnings from this investment to just cover the interest and CD principal when it comes due in 5 years. They are looking at the following 3 possibilities for investment BondMaturityCouponYTM Duration 0.00% 8.00%5.00 7.90% 8.00%5.00 17.15% 8.00%5.00 б 7 Show that each of three investment will cover the future payout required by the CD, even if market rates increase or drop by 2 % by the end of 5 years 123

Toyota S murang auto finance company is prepared to offer you a loan of $38,000 to buy a new Toyota Corolla. The repayments are at the end of every year for a period of 7 years. If the interest rate on the loan is 12%, perform loan amortization calculation that will allow you to determine the amount of the loan outstanding after making the second installment. PV of ordinary annuity-= C/r  x [1-1(1+r)n]

2. Using tab 2 in the template, create the amortization spreadsheet and answer the following questions for a $700,000 10-year adjustable-rate mortgage (ARM) loan that is fully-amortizing and has monthly payments. A teaser rate of 4.4% applies to the mortgage payments and amortization during the first 2 years of the loan. After the second , the annual interest rate on the loan is equal to the going rate on an index + a margin of 2.7%, subject to an annual interest rate cap of 2.5% and a lifetime interest rate cap of 5.8% over the initial teaser rate. Expectations for the beginning-of-year values for the appropriate index are as follows: year, Year Index 3451 3.1% 4.7% 6.5% 6 2.5% 7 2.9% 8 5.1% 9 6.6% 10 6.0% a) Based on these expectations and conditions, what would be the actual (contract) interest rates applied to the mortgage payment during years 1 through 10? b) What would be the APR on this loan, if held until maturity – assuming up-front points of 2.0%? c) What is the outstanding…

(Loan Amortization Problem) Your company is planning to borrow $2,500,000.  This will be a six-year, 2 percent per year, annual payment, fully amortized term loan.  The first payment will be made one year from today.  What fraction of the total annual payment made at the end of year three will represent repayment of principal?  [Hint: you need only complete the first three rows of the amortization schedule to answer this question.] Step By Step please, as if writing down the solution on a sheet of paper.