Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide step by step with finding IRR with a BA II calculator. No excel. Answers are circled. Thank you Calculations examples 1. Polaris is
Please provide step by step with finding IRR with a BA II calculator. No excel. Answers are circled. Thank you
Calculations examples 1. Polaris is taking out a $5,000,000 two-year loan at a variable rate of LIBOR plus 100%. The LIBOR rate will be reset each year at an agreed upon date. The current LIBOR rate is 4.00% per year. The loan has an upfront fee of 2.00% Loan Interest Rates Year 0 Year1 LIBOR (Heating Year 2 400 4.00 4.00 Spread (Fixed) 1.00 LOOR 100 Total Interest Payable 5.00 5.00 SOP Interest Cash Rows on Loan LIHOR (Floating) ($200,000) 65200,000) Spread (Fixed) ($50,000) ($50,000) Total Interest ($250,000 ($250,000 Lean Proceeds (Repayment) $4.900.000 (55,000,000 Total Loan Cash Flows $4.900.000 ($250,000) (55,250,000) a) Refer to table above. What is the all-in-cost (ie, the internal rate of return) of the Polaris loan including the LIBOR rate, fixed spread and upfront feel? 4.00% 5.00% 5.53% 6.09% b) Refer to the table above. If the LIBOR rate falls from 4.00% to 3.00% in year 2, what will be the all-in- cost (ie the internal rate of return) for Polaris for the entire loan? 4.00% 4.50% 5.25% 5.60% 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