1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Luba_88 [7]
2 years ago
14

Ohlson Co. is preparing an Excel spreadsheet for its 20-year, 4.5%, $500,000 bonds payable. The bonds were issued on January 1 t

o yield 5% annually. Interest is paid semi-annually. A portion of the spreadsheet appears as follows: A B C D E 1 Stated rate: 0.045 2 Effective rate: 0.05 3 Face amount: 500,000 4 Term to maturity in years: 20 5 6 Period Cash Payment Interest Expense Change in Discount Outstanding Balance 7 0 8 1 9 2 What formula should Ohlson use in cell C8 to calculate interest expense for the first interest payment? Multiple Choice =E7*B3/2 =E7*B3 =B8 – D8 =E7*C2/2

Business
1 answer:
uranmaximum [27]2 years ago
6 0

Answer:

=E7*C2/2

Explanation:

The interest expense will be the carrying value of the bond times the effective interest rate.

On cell C8 we have the interest expense

On E7 we have the carrying value which is the outstanding balance.

Then, on C2 we got the effective rate

As this is an annual formula, we must divide by two to convert to semiannual rate.

A file is attached for how the excel sheet looks like

You might be interested in
In human resource management, _____ usually refers to teaching operational or technical employees how to do the job for which th
Gre4nikov [31]

In HRM, training typically relates to imparting knowledge on operational or technical staff members regarding how to carry out their assigned duties. Most businesses offer managers and staff consistent opportunities for training and development.

The group of organizational operations known as human resource management (HRM) are focused on luring, fostering, and retaining a productive staff.

Short-term training is frequently required to solve a specific technical deficiency because it is created for certain occupations and abilities. On the other hand, development is focused on the individual and how they might acquire the abilities they need to advance in their work.

To learn more on human resource management

brainly.com/question/27956348

#SPJ4

4 0
2 years ago
What changes has affirmative action brought
WARRIOR [948]
Affirmative Action is a policy which function by favouring the cause of disadvantaged set of people who are suffering or had suffered from discrimination within a community. The group was established in the 1960s. The major goals of this group is to: close the gaps of employment inequalities and pay, increase access to education, promote diversity and address past injustices. Affirmative Action had produced both positive and negative outcomes. Positive outcomes include: closing the gaps in employment eligibility and payment, increasing number of people having access to education and promotion of diversity. Negative outcomes include: driving away of skilled labour which resulted in poor economic growth and mismatching of skills.
3 0
3 years ago
Jason Graham's startup, which is in the electronics industry, was launched on January 1, 2009. However, prior to its formal laun
Bas_tet [7]

Answer:

C) sweat equity

Explanation:

The definitions ok sweat equity are:

1. Increase in the value of a business (beyond the money invested) created by the unpaid mental and / or physical work of the founder / owner.

2. Increase in the value of a property (beyond its purchase price) created by the hard work of the owner / occupant in improving its comforts and / or appearance.

3. An additional percentage of a company's common stock (common stock) allocated to senior executives (beyond their current stock) as additional motivation to continue working hard for the success of the company.

8 0
3 years ago
Read 2 more answers
Two decades ago when the United states entered info the North American Free Trade Agreement with Canada and Mexico, there was si
stepan [7]

Answer: It was believed by some politicians and unions that NAFTA poses more harm to the United States economy unlike TTIP.

Explanation:

The North American Free Trade Agreement (NAFTA) is an agreement entered into by Canada, United States, and Mexico that ensures free trade among the countries as it was created to remove tariff barriers to different sectors of the economy and ensure free trade.

The Transatlantic Trade and Investment Partnership (TTIP) is a trade agreement which is proposed between the United States and the European Union with the aim of promoting economic growth and trading activities.

Some politicians and trade unions were in disagreement with NAFTA because it led to job losses especially in the manufacturing firms in the U.S. Companies also threatened to relocate to Mexico in order to keep their workers from joining trade unions and this suppressed wages as workers could not negotiate for better wages.

NAFTA allowed trucks from Mexico to enter the United States. These Mexican also entered the United States illegally by crossing the border. These were some of the reasons some people were not in agreement with NAFTA.

5 0
3 years ago
Sid files a suit against tina. before going to trial, the parties, with their attorneys, meet to try to resolve their dispute. a
Maurinko [17]
A third party help them to reach an agreement and this is meditation. Meditation is a practice where individuals train or operates their mind or induces a mode of consciousness. When the person meditate, this person wants more time to think and to make her mind calmer and be more focused.
8 0
3 years ago
Other questions:
  • Key practices in the partnering approach to managing contracted relationships include
    15·1 answer
  • Pak Co.'s professional fees expense account had a balance of $82,000 at December 31, Year 1, before considering year-end adjustm
    14·1 answer
  • The length of a senator's term, how old they have to be, and number of terms they can serve.
    14·1 answer
  • Duverger’s Law states that a) proportional representation systems result in two-party systems. b) one-party systems are the resu
    8·1 answer
  • Megan, a human resource manager, recently approved the hiring of five summer interns. She will use ________ to decide which depa
    14·1 answer
  • Pick a side and argue for or against raising the minimum wage. Use your knowledge of price floors and find an article to back up
    10·1 answer
  • Prepare the journal entries to record these transactions on Wildhorse Co.’s books using a periodic inventory system. (If no entr
    5·1 answer
  • When you are making a list of careers that interest you, you should always:
    13·2 answers
  • A flower shop makes a large sale for $1,000 on November 30. The customer is sent a statement on December 5 and a check is receiv
    9·1 answer
  • Khalil Hamid Ali borrowed $12,000 and paid $1,890 in exact interest when the loan came due 11 to 2 years later. What rate of int
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!