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
The listing and selling brokers agree to split a 7% commission fifty-fifty on a $96,900 lot sale. The listing broker is on a 30%
Sergio039 [100]

Answer:

1,187.03

Explanation:

he listing and selling broker each get 50% of the 7 5 commission.

The commission equal  7/100 x $96,900

Each broker gets   =3,391.5

The selling broker (broker working with the buyer) get 35 % of  3,391.5

=35/100 x 3,391.5

=1,187.025

=1,187.03

5 0
3 years ago
The market value of​ Fords' equity, preferred​ stock, and debt are $ 7 ​billion, $ 2 ​billion, and $ 13 ​billion, respectively.
steposvetlana [31]

Answer:

WACC is 9%

Explanation:

WACC is the average cost of capital of the firm based on the weightage of the debt and weightage of the equity multiplied to their respective costs.

According to WACC formula

WACC = ( Cost of equity x Weightage of equity ) + ( Cost of debt ( 1- t) x Weightage of debt ) + ( Cost of Preferred equity x Weightage of Preferred equity )

As per given data

Market Values

Equity = $7 ​billion,

Preferred​ stock = $2 ​billion

Debt = $13 ​billion

Cost

Equity

Capital asset pricing model measure the expected return on an asset or investment. it is considered as the cost of common stock.

Formula for CAPM

Cost of Equity = Risk free rate + beta ( market return - risk free rate )

Cost of Equity = Rf + β ( Mrp )

Cost of Equity = 3% + 1.6 ( 8% ) = 15.8%

Preferred​ stock = $2 / $26 = 0.077 = 7.7%

Debt = 8%

Placing values in the formula

WACC = ( 15.8% x $7 billion / $22 billion ) + ( 8% ( 1- 0.3) x $13 billion / $22 billion ) + ( 7.7% x $2 billion / $22 billion )

WACC = 5.03% + 3.31% + 0.7% = 9.04%

7 0
3 years ago
Price elasticity of demand is defined as: a. the slope of the demand curve. b. the slope of the demand curve divided by the pric
Mandarinka [93]

Answer: Option D

Explanation: In simple words, price elasticity refers to the degree of change in demand of a commodity with respect to change in its price. It generally shows the fact that when the price of a commodity rises the demand for ti decreases due to various phenomenon coming into force such as income effect etc.

The price elasticity is calculated by dividing the change in quantity demanded with the change in price.

4 0
3 years ago
) when originally issued, an investment in bonds of Flushing Dough, Inc., promised to provide an annual coupon of 7.50%. The bon
galina1969 [7]

Answer:

The likely yield to maturity on the bonds is 10.23%.

Explanation:

The likely yield to maturity on the bonds can be calculated using the following RATE function in Excel:

YTM = RATE(nper,pmt,-pv,fv) .............(1)

Where;

YTM = likely yield to maturity on the bonds = ?

nper = number of periods = number of years until maturity = 4

pmt = annual coupon payment = annual coupon rate * Face value = 7.50% * $1,000 = $75 = 75

pv = present value = market price = $735 = 735

fv = face value or par value of the bond = 1000

Substituting the values into equation (1), we have:

YTM = RATE(40,75,-735,1000) ............ (2)

Inputting =RATE(40,75,-735,1000) into a cell in an excel (Note: as done in the attached excel file), the YTM is obtained as 10.23%.

Therefore, the likely yield to maturity on the bonds is 10.23%.

Download xlsx
8 0
3 years ago
Juanita is having her yard landscaped. She obtained an estimate from two landscaping companies. Company A gave an estimate of $2
mafiozo [28]

Answer:

8 hours is required for both companies to cost the same

Explanation:

given data

company A materials and equipment = $220

company A labor = $45 per hour

company B materials and equipment = $300

company B labor = $35 per hour

to find out

how many hours of labor required

solution

total cost of company A =  220 + 45 h

total cost of company B =  300 + 35 h

so we can say

total cost of company A = total cost of company B

220 + 45 h  = 300 + 35 h

h = 8

so 8 hours is required for both companies to cost the same

5 0
3 years ago
Other questions:
  • When Coca Cola introduced Coke Zero,this was an example of a _____ strategy.
    13·1 answer
  • An esop: allows an owner to transfer all or part of his company to the employees as gradually or as quickly as he chooses. works
    6·1 answer
  • What is it called when you take part of someone's paycheck for yourself? (aka stealing their money)
    9·1 answer
  • Awnser.......<br>please<br>please<br>please
    7·1 answer
  • As a Customer Relations Specialist, Kendra must deny a customer's request for a cash refund. In her message to the customer, Ken
    10·1 answer
  • Olivia’s employer deducts an amount from her paycheck for the Medicare program. What type of withholding is being deducted from
    15·2 answers
  • The cost of creating an email campaign for a product or a service is typically more expensive and takes longer to conduct than a
    8·1 answer
  • On January​ 1, 2018, Tyson Manufacturing Corporation purchased a machine for​ $40,000,000. Tyson's management expects to use the
    7·1 answer
  • Earnings of workers are typically decreased by
    12·1 answer
  • Due to My Amazing grades from Brainly my token of honor im doing another brainliest giveaway the last ones GOT DELETED by a girl
    7·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!