Use the amortization schedule below to calculate the Lender's IRR. Assume the loan balloons in Year 10.
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the amortization schedule below to calculate the Lender's IRR. Assume the loan balloons in Year 10.
Loan Principal $1,200,000
Amortization Term 25
Loan Term 10
Interest Rate 10.00%
Lender Fee 4.00%
Lender IRR ???
amortization schedule
Begin PMT Interest Principal End Lender CF's
Please show all math and formulas in excel
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: