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]
3 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]3 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 America, being "normal" is
Stella [2.4K]
Being selfish I guess
7 0
3 years ago
Real Estate tax, a tax based on the value of the land and the buildings owned by its taxpayers, is a good example of _____. A. I
sesenic [268]
C is the answer property tax
4 0
3 years ago
When the production process is complete in process costing, the completed goods and the accumulated costs are transferred across
alukav5142 [94]

Answer:

A debit to the Finished Goods Inventory account and a credit to the Work in Process account for the final department in the series of process

Explanation:

In the case when the process related to the production is finished so the completed goods and accumulated profits could be transferred

So, the following should be the journal entry

Finished goods inventory XXXXX

          To Work in Process Inventory - Final dept XXXXX

(Being the production process is completed recorded)

Here the finished goods is debited as it increased the assets and credited the work in process as it decreased the assets

3 0
3 years ago
According to the video, what are the goals of window displays? check all that apply.
Harlamova29_29 [7]

Answer:

a and c

Explanation:

8 0
2 years ago
Read 2 more answers
Which best describes how an investor makes money from an equity investment?
Alexxx [7]
By selling the asset for a profit
5 0
3 years ago
Read 2 more answers
Other questions:
  • In which document can the project manager (pm) find guidance for implementing earned value management (evm) contract management
    7·1 answer
  • What is interest earned on bonds called?
    9·1 answer
  • For national security reasons a government decides that all of its base metal industry should not be located in the same geograp
    15·1 answer
  • Transactions for the Swifty Company, which provides welding services, for the month of June are presented below. June 1Swifty in
    9·1 answer
  • For each of the items indicate whether its amount affects the bank or book side of a bank reconciliation and is an addition or a
    11·1 answer
  • A product enters the maturity phase of the life cycle, during which sales are strong but growth is slowing. What product managem
    8·1 answer
  • Ordinary simple interest brings increased revenue to the lender. The general practice
    10·1 answer
  • Maria is going to a hiking trip this weekend. She has been busy shopping for the trip. Which of these items that she bought are
    11·1 answer
  • On January 1, 2021, Badger Inc. adopted the dollar-value LIFO method. The inventory cost on this date was $101,600. The ending i
    11·1 answer
  • What are some products and services that may be purchased by calling the eight companies customer service number
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!