anyone know how to do finance excel aboutamortize a hybrid ARM, business and finance homework help

SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.


Order a Similar Paper Order a Different Paper

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].

Writerbay.net

Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net