How much interest is paid on the loan in first month payment

Assignment Help Financial Management

Reference no: EM13971889

A company takes out a loan for $150,000 at a nominal interest rate of 8% compounded monthly. The company agrees to pay back the loan in equal monthly payments for 15 years.

a) What is the monthly payment for this loan?

b) How much interest is paid on the loan in the first month payment?

c) Using Excel or other spreadsheet, complete an amortization table for this loan.

Reference no: EM13971889

Questions Cloud

What will be the future worth of the money in your account : Assume that you open a savings account that accrues 3% nominal annual interest that is compounded monthly. Initially, your account has no funds in it. Starting next month, you add $50 / month for 6 months. At the end of 1 year, what will be the prese..

Return on your investments in retirement : You want to know in which scenario you need to save the LEAST amount of money monthly. First plan is to have $1,250,000 in 25 years when you retire and your investments will earn 9%. The second option is to receive a monthly payment of $6,000 in reti..

Savings account : John Vincent invested 10,000 in a savings account. The account pays 4.5% annual interest. john will have how much in the account at the end of 10 years? Round to the nearest dollar

What will be the present worth of the money in your account : Assume that you open a savings account that accrues 3% nominal annual interest that is compounded monthly. Initially, your account has no funds in it. Starting next month, you add $50 / month for 6 months. Then, you increase your monthly deposit by $..

How much interest is paid on the loan in first month payment : A company takes out a loan for $150,000 at a nominal interest rate of 8% compounded monthly. The company agrees to pay back the loan in equal monthly payments for 15 years. What is the monthly payment for this loan? How much interest is paid on the l..

What price would you expect to pay for a stock : What price would you expect to pay for a stock with a 13% required rate of return, 4% constant rate of dividend growth, and an annual dividend of $2.50 that was paid today?

Take care of the maintenance of the equipment : A contractor estimates that maintenance on a new piece of equipment will be $275 for the first month and it will increase by 0.5% each month afterwards. However, the contractor is offered a service contract that would maintain the equipment for a tot..

What is an estimate of the price of the stock : ABC Co. presently does not pay a dividend, but is expected to pay a dividend in year 3 of $.75 and the dividend then will increase at a constant rate of 5% annually. The rate of return is 10%. What is an estimate of the price of the stock today?

What would be the expected price of a stock : What would be the expected price of a stock when dividends are expected to grow at a 25% rate for each of the next three years, then grow at a constant rate of 5%, if the stock's required rate of return is 13% and next year's dividend will be $4.00?

User Account

All Pages