QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 356 Weeks Ago, 4 Days Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 27 May 2017 My Price 15.00

anyone know how to do finance excel

Question description

 

 

Write an excel spreadsheet to amortize a hybrid ARM. Use the (monthly) index rate supplied in the accompanying spreadsheet. Assume all rates are quoted as MEYs. Make sure that your program can handle (send me the file with inputs set as marked in […], but note that I will want to be able to change them):

1.  A periodic interest rate cap (only; do not bother with lifetime or initial rate caps, not bother with payment caps). Also, for simplicity, ignore the fact that caps usually come with “floors.” [1%];

2.  Different rate reset periods [1yr intervals];

3.  Different initial fixed rate period length [3yrs], along with the rate for this period [3.5%];

4.  Different mortgage terms (up to 30 yrs) [15yrs];

5.  Different amortization terms [30yrs];

6.  The margin [2.5%]; and the

7.  Loan amount [$100k].


 

 

Answers

QuickHelper
(10)
Status NEW Posted 27 May 2017 07:05 PM My Price 15.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)