Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how to make this model, please also attach the formula of excel, thank you! Mortgage Pool CFs (w/ service fee) 1000 mortgages begin{tabular}{l|l} $250,000 &

image text in transcribedimage text in transcribedhow to make this model, please also attach the formula of excel, thank you!

Mortgage Pool CFs (w/ service fee) 1000 mortgages \begin{tabular}{l|l} $250,000 & =PMT(.08/12,360,250000,0,0) \\ 30 -year, fixed & =$1,834.41 \end{tabular} 8% interest 0.5% service fee WAC=7.5% - WAM=30 years - 7.5% is "passed through" to investors

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Werte Controlling Zur Ber Cksichtigung Von Wertvorstellungen In Unternehmensentscheidungen

Authors: Bernhard Hirsch

2002nd Edition

3824476568, 978-3824476565

More Books

Students also viewed these Accounting questions

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago