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
Dear Ms. Gonzalez: Although I am disappointed to hear that you have selected another candidate for the marketing position, I app
adoni [48]

Answer:

It emphasize on applicant's continued interest because when you create a follow up letter after rejection, candidate should be confident and persistent . He should show confidence in meeting the job requirements.

Explanation:

5 0
3 years ago
According to the Fisher Effect, the expected rate of inflation does not influence the:________.
Alekssandra [29.7K]

Answer:

ex ante real interest rate.

Explanation:

According to Fisher effect the expected inflation rate will affect indices like nominal interest rate, current prices of goods, and the demand for money.

However it does not affect the ex ante real interest rate.

The Fisher effect shows how real interest rate is related to nominal interest rate.

Real interest rate = Nominal interest rate - Expected inflation rate

Ex ante real interest rate is the anticipated real interest rate in the future.

This is not considered in the Fisher effect

6 0
2 years ago
Yi Min started an engineering firm called Min Engineering. He began operations and completed seven transactions in May, which in
otez555 [7]

Answer:

                                  Trial Balance

Items                                     Group             Debit ($)    Credit ($)

Cash                                      Asset               37641

Office Supplies                     Asset               890

Prepaid Insurance                Asset               4600  

Office Equipment                 Asset               12900

Accounts Payable                Liability                                12900

Capital                                   Equity                                  18000

Withdrawals                          Equity              3329  

Engineering Fees earned    Revenue                              36000

Rent Expense                        Expense         <u>7540</u>           <u>            </u>

Total                                                               <u>$66900</u>      <u>$66900</u>

6 0
3 years ago
The delivery of computing as a service is knonw as?​
ZanzabumX [31]

Answer:

Infrastructure as a service

Explanation:

5 0
3 years ago
The following is the stockholders' equity section of Harbor Co.'s balance sheet on December 31: Common stock $10 par, 100,000 sh
Murljashka [212]

Answer:

The book value of shares is $10

Explanation:

The balance of shareholders equity is $2,200,000.This comprises of retained earnings of $800,000 and Issued Share Capital of $1,400,000(for 140,000 units of shares)

To ascertain the unit of shares,see below:

45000units= $450,000

15000units reacquired at $150,000

Which also means that $1,100,000 is for 110,000units of shares.

In each of these cases highlighted above share price is $10

for instance:$450,000/45000shares=$10

$150,000/15000=$10 e.t.c

8 0
3 years ago
Other questions:
  • A $10,000 8 percent coupon bond that sells for $10,000 has a yield to maturity of
    15·1 answer
  • Which of the following was proposed by Alexander Hamilton in 1792 and is by far the oldest economic argument for government inte
    8·2 answers
  • 3. Suppose that all households hold all their wealth in assets that automatically rise in value when the aggregate price level r
    15·1 answer
  • If Bojana Tax Services' office supplies account balance on March 1 was $1,400, the company purchased $675 of supplies during the
    8·1 answer
  • What is 9 and 5/6 minus 3 and 3/6​
    11·2 answers
  • a company has established 5 pounds of material j at $2 per pound as the standard for the material in its product z. the company
    8·1 answer
  • ILL GIVE BRAINLIEST!! HELP ASAP!!
    12·1 answer
  • I need help asap ! thank you :)
    9·1 answer
  • Outsourcing some production is a means of supporting a constraint. Group of answer choices TRUE FALSE
    14·1 answer
  • On January 1, Year 1, Raven Limo Service, Inc. paid $64,000 cash to purchase a limousine. The limo was expected to have a six ye
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!