Write an excel spreadsheet to amortize a general ARM. Make sure that your program can handle – assignmentcollections.com

Business Finance Assignment Collections – assignmentcollections.com

Different interest rate caps (periodic, lifetime and initial rate increase. This also means your program will be able to handle fixed rate mortgages) [1/4/2];

Payment caps (with neg am cap; assume once this is hit, the loan becomes amortizing according to 5 below) [10%, 120%];

Different reset periods. While the index should be recomputed monthly, the reset should be specified in years (see also 6 below) [1];

Different mortgage terms (up to 360 months) [180];

Different amortization terms [360];

Differing hybrid types (1/1, 3/1, 5/1, etc.), along with the rate for the fixed interest rate periods [3/1, 3.5%];

Differing initial index rate [Use index path in attached].

The inputs above (along with the margin [2.5%] and loan amount [100k]) must be taken from a separate input sheet. That is, if I change any of the terms above in one input cell on the input tab, the amortization schedule (CF sheet) should correctly re-compute without having to alter anything in the CF amortization sheet.

(For this part of the project) use the sample index path as given in the accompanying file “InterestRatePath2Use.xlsx.”

– assignmentcollections.com

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational
/by