Question

In: Accounting

A company’s average monthly loan balance for the past year is $18,350,000. The interest rates on...

A company’s average monthly loan balance for the past year is $18,350,000. The interest rates on the loan fluctuated between 6.5% and 7.5% during the year.

The income statement shows interest expense of $1,150,000 for the year.

Answer these four following questions:

1. Show how you would calculate an interest expense Expectation for the interest expense account and show your expected interest expense amount.

2. Compare your expectation of interest expense with the income statement amount and show the difference.

3. If you have determined the tolerable difference is 10% of the company’s recorded amount compare the tolerable dollar amount of difference using this % with your calculated difference above and show the amount your calculated difference is either above or below the 10%tolerable amount.

4.Should you accept the income statement interest expense account as fairly stated or not and why.

Solutions

Expert Solution

1. To calculate an interest expense expectation we will calculate the average interest rate by adding the 2 interest rates and dividing it by 2.

expected interest rate = (6.5% + 7.5%)/2 = 7%

interest expense expectation will be 7% of 18,350,000 = $ 1,284,500

2. The actual interest expense is less than the expected interest rate. The difference in the expectation and actual interest expense =

  • $1,284,500 - $1,150,000 = $134,500

3. The 10% tolerable dollar amount of difference = 10% of 1,284,500 = $ 128,450

Difference in actual calculated difference and tolarable difference = $134,500 - $128,450 = $6,050

So the actual interest expense is $ 6,050 bove the tolerable amount.

4. No, The interest wxpense should not be accepted because it is going above the tolerable amount of difference.


Related Solutions

A $40,000 mortgage loan charges interest at 6.6% compounded monthly for a four-year term. Monthly payments...
A $40,000 mortgage loan charges interest at 6.6% compounded monthly for a four-year term. Monthly payments were calculated for a 15-year amortization and then rounded up to the next higher $10. a) What will be the principal balance at the end of the first term? b) What will the monthly payments be on renewal for a three-year term if it is calculated for an interest rate of 7.2% compounded monthly and an 11-year amortization period, but again rounded to the...
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest...
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded montly? A. $452.91 B. $492.75 C. $377.42 D. $500.00 true or false: 27.)When doing a comparison of ratios for your company, the comparison probably should be with the industry average. 28.)When taking out a loan you would rather get an interest rate of 7% compounded monthly, instead of one compounded daily. 29.)Which of the following financial ratios are market-based ratios?...
Compute the monthly payment for a $133,440 home loan. The stated interest of the loan is...
Compute the monthly payment for a $133,440 home loan. The stated interest of the loan is 5% with monthly payments. The loan amortization is over 25 years.
A student graduates with a total loan balance of​ $30,000 in a single loan with monthly...
A student graduates with a total loan balance of​ $30,000 in a single loan with monthly payments for a term of 10 years at ​7% APR interest rate. What is the monthly payment for this​ loan? What will the unpaid balance be after 5​ years?
With a 12-year loan of 13% annual interest rate compoundedmonthly, how much is the monthly...
With a 12-year loan of 13% annual interest rate compounded monthly, how much is the monthly loan payment of $841,590
For a 30-year loan with a face value of $150,000, 5 percent annual interest, and monthly...
For a 30-year loan with a face value of $150,000, 5 percent annual interest, and monthly payments, find the monthly payment and remaining mortgage balance at the end of years 5, 20, and 30
Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000 at...
Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000 at an APR of 6.8%.
a. Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000...
a. Prepare the amortization schedule for a thirty-year variable interest loan with monthly payments of $250,000 at an APR of 6.8%. specifies monthly compounding. b.What is the interest payment and principal amounts in the 110th payment? c. Use the annuity formula to find how much principal you still owe to the bank for the 110th payment. Check that this value is the same you have in your amortization schedule. d. How much in total interest will you pay? e. Suppose...
You took a loan to buy a new car. The monthly interest rate on the loan...
You took a loan to buy a new car. The monthly interest rate on the loan is 1.5% and you have to pay $240 every month for 60 months 1)What is the Present value of the Cash flows if its an ordinary annuity? 2)What is the future value of cash flows if its an ordinary annuity? 3)What is the present value of the cash flows if its an annuity due? 4)What is the future value of cash flows if its...
You have taken a 5-year bullet loan carrying a floating interest rate. Market interest rates are...
You have taken a 5-year bullet loan carrying a floating interest rate. Market interest rates are likely to rise in future.Which product is best suited for you? Select one: a. Interest rate Collar b. None of these c. Interest rate Cap d. Interest rate Floor
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT