Purchase Solution

Calculating EMI of a loan

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

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 provided by:
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution


Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.