Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Template Below To Answer Question Below. Please Included All Formula You Entered Into Template in Excel. $600,000 30-year fully-amortizing CAM loan with monthly payments.
Use Template Below To Answer Question Below. Please Included All Formula You Entered Into Template in Excel. $600,000 30-year fully-amortizing CAM loan with monthly payments. The contract interest rate on the loan is 3.25% and there are no points associated with the loan. Assuming 1 point in origination fees and a 2% prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? Template Used In Excel B D E F H J K 1 2 3 EIR 4 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points 5 6 Cash flows Month Beg balance Payment Interest 7 8 Principal End balance 9 10 2 3 4 5 11 12 13 6 14 7 15 8 16 17 18 19 12 20 Dora = 998 13 21 14 15 22 23 16 24 17 25 18 26 19 27 20 28 21
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started