Calculate the rate of interest for weeks two

Assignment Help Financial Accounting
Reference no: EM132468484

The Bensington Glass Company entered into a loan agreement with the? firm's bank to finance the? firm's working capital. The loan called for a floating rate that was 26 basis points ?(0.26%) over an index based on LIBOR. In? addition, the loan adjusted weekly based on the closing value of the index for the previous week and had a maximum annual rate of 2.25% and a minimum of 1.78%.

Question 1: Calculate the rate of interest for weeks 2 through 10? I need to know how to calculate in excel.

Date       LIBOR

Week 1   1.93%

Week 2   1.68%

Week 3  1.52%

Week 4  1.29%

Week 5  1.59%

Week 6  1.66%

Week 7   1.67%

Week 8  1.92%

Week 9   1.88%

Reference no: EM132468484

Questions Cloud

Create a working thesis statement : Create a working thesis statement and basic research plan that considers context, audience, purpose, and presents potential sources
What is the current ratio after the declaration : The board of directors declares a cash dividend of $189,000. What is the current ratio after the declaration but before payment
What are the tax consequences for robin transaction : Robin also had a net long-term capital loss in 2017 of $2,000, which it could not use, and ordinary income of $13,000. What are the tax consequences in 2018
Prepare a maximum informal memo : Prepare a maximum informal memo and explain to Ms. Skaros why her production cost report showed only 2,000 equivalent units in ending inventory.
Calculate the rate of interest for weeks two : Calculate the rate of interest for weeks 2 through 10? I need to know how to calculate in excel. The Bensington Glass Company entered into a loan
Differences between hearing and listening : Explain the listening types (informational, critical, and empathic) and stages of listening. Discuss the key differences between hearing and listening
What is hobart corporations sca : What is Hobart corporations SCA and its branding equity?
Prepare the perpetual inventory schedule : Prepare the perpetual inventory schedule for the above transactions using FIFO. (Round answers to 0 decimal places, e.g. 1,250.)
Various principles of business-to-business marketing : Identify/locate a news item (online, in print, on the TV news, etc.) that can be tied back to various principles of business-to-business marketing.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Question in verifying investing cycle balances a cpa

question in verifying investing cycle balances a cpa identify that the subsequent misstatements may occur or exist1. a

  What is the equivalent annual cost

What is the Equivalent Annual Cost for each project? Should Solar or Recycle be selected?

  Make or buy production decision makingassume that a

make or buy production decision making.assume that a division of bose makes an electronic component for its speakers.

  How many days does ken company have

how many days does Ken Company have from the date of purchase before the payment is considered to be late? Days

  Pension obligation is considered a long-term liability

Prepare a revised balance sheet given the available information. Assume that the accumulated depreciation balance for the buildings is $163,760 and for the equipment, $108,760. The allowance for doubtful accounts has a balance of $20,760. The pension..

  Develop journal entries for all of accounting transactions

Develop journal entries for all of the accounting transactions in January for Fishy Farm - create an income statement for the month of January for Fishy Farm and reconstruct the balance sheet for Fishy Farm as of January 31, 20x1.

  About the limitations of financial condition analysis

Which of the following statements about the limitations of financial condition analysis is(are) most correct? Comparison with industry averages is difficult if the organization operates in several different lines of business. Seasonal factors can dis..

  Transactions on accounts of equation by recording increases

Mr. State started the C State Co., a new business that began operations on Dec. 1. The company completed the following transactions during its first month of operations. Use the following accounts and show the effect of the transactions on the accoun..

  Consumer receives loan from financial institution

When a consumer receives a loan from a financial institution, the consumer will be charged an origination fee. After reading and learning many aspects about the banking industry, do you believe origination fees and other fees are necessary to charge?..

  Reconciliation of master budget operating income flexible

reconciliation of master budget operating income flexible budget operating income and actual operating income.downes

  Dependent on her parents tax return

In 2016, Sheryl is claimed as a dependent on her parents' tax return. Her parents' ordinary income marginal tax rate is 35 percent. Sheryl did not provide more than half her own support. What is Sheryl's tax liability for the year in each of the foll..

  Contrast the internal service funds and enterprise funds

State and local governments use proprietary funds to account for particular government operated activities. Discuss answers to the following questions and justify your response: Compare and contrast the Internal Service Funds and Enterprise Funds

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd