Purchase Solution

Accounting: Monthly Interest Rates

Not what you're looking for?

Ask Custom Question

Love Canal General Hospital wants to purchase a new blood analyzing device today. Its local bank is willing to lend it the money to buy the analyzer at a 3 percent monthly rate. The loan payments will start at the end of the month and will be $1,600 per month for the next eighteen months. What is the purchases price of the device?

Dr. Thomas plans to retire today and would like an income of $ 400,000 per year for the next fifteen years with the income payments starting one year from today. He will be able to earn interest of 8 percent per year compounded annually from his investment account. What must he deposit today in his investment account to achieve this income of $ 400,000 per year?

Carondelet Hospital is evaluating a lease arrangement for its ambulance fleet. The total value of the lease is $420,000. The hospital will be making equal monthly payments starting today.

Questions:
a. What is the monthly interest rate if the lease payments are $24,000 per month for twenty-four months?
b. What is the monthly interest rate if the lease payments are $24,000 per month for thirty-six months?
c. What is the monthly interest rate if the lease payments are $30,000 per month for for thirty-six months?

Purchase this Solution

Solution Summary

This solution illustrates how to use Excel functions to find the purchase price of an asset based on its monthly payments, the annual amount a person will have if they draw down a deposit over several years, and the interest rate implicit in a lease.

Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Operations Management

This quiz tests a student's knowledge about Operations Management

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)