Calculating EMI of a loan
Not what you're looking for?
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 ...
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.