Explore BrainMass
Share

# Calculating EMI of a loan

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

A.) On January 1, 2007, Sammy Sosa offers to buy Mark Grace's used snowmobile for \$8,000, payable in 5 equal installments, which are to include 8.25% interest on the unpaid balance and a portion of the principal. If the first payment is to be made on January 1, 2007, how much will each payment be?

B.) Repeat the requirements in A, assuming Sosa makes the first payment on December 31, 2007.

#### Solution Preview

Please refer attached file for better understanding of Excel functions.

Solution:
Loan amount=Present Value of all future payments=8000
Rate of interest=8.25%
Number of ...

#### Solution Summary

Solution describes the steps for calculating equal periodic installment of a loan amount if payments are made in the beginning of period and if payments are made at the end of period. Calculation are made by using financial functions of MS Excel.

\$2.19