# (SOLVED) A loan should be fully repaid in 60 monthly instalments of $5 million.

**Discipline:** Finance

**Type of Paper:** Question-Answer

**Academic Level:** Undergrad. (yrs 1-2)

**Paper Format:** APA

**Pages:**1

**Words:**67

Question

**Question :**

**1.
A loan should be fully repaid in 60 monthly installments of $5 million.
If the loan is $250 million, what will be the total interest payment for
the first year?**

**2.
A loan should be fully repaid in 60 monthly installments of $5 million.
If the loan is $250 million, what is the effective interest rate (j12)
of the loan? **

**3.
A loan should be fully repaid in 60 monthly instalments of $5 million.
If the loan is $250 million, what will be the principal repayment during
the first year?**

**Please provide and explain how to calculate and get the answer exactly like this, using excel!**

**1)**

**The first step is to find the interest rate of the loan using the RATE function in excel.**

**Interest rate per month = 0.62 % **