Math of Finance Monthly Payments
Not what you're looking for?
You find a small business loan in the amount of 50,000 is the amount you need to purchase the restaurant location. After researching banks to find the best interest rate, you find that the best interest rate of 9% intersest that compounds monthly for seven years.
1. What is the monthly payment for this loan? Show the formula used and the values used for each variable to calculate the monthly payment.
2. What is the unpaid balance of the loan at the end of the 1st year? Show the formula that was used and the values used for each variable to calculate the unpaid balance at the end of the first year.
3. What is the unpaid balance at the end of the 6th year? Show the formula that was used for each variable to calculate the unpaid balance at the end of the 6th year.
Purchase this Solution
Solution Summary
The math of monthly payments are examined. The unpaid balance at the end of the year is determined.
Solution Preview
This is a typical loan payment problem that can be solved with Microsoft Excel. The figures below were calculated using the attached Microsoft Excel spreadsheet. The spreadsheet was created to allow for any numbers to be entered.
1. What is the monthly payment for this loan? Show the formula used and the values used for each variable to calculate the monthly payment.
The monthly payment for the loan will be $804.45 over the course of 7 years (84 months). The Excel formula to ...
Purchase this Solution
Free BrainMass Quizzes
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce