Calculate the discount amount for this order

Assignment Help Financial Management
Reference no: EM132319207

Question

In cell F27, use an IF function to calculate the discount amount for this order based on the customer's status (which is found in F16).

If the customer's status is Preferred, the discount amount will be the Order Subtotal ( 116.91 ) times the discount percentage 10% otherwise the discount amount will be 0 (zero).

Hint: You will need to use a formula for the Value if True argument.

Reference no: EM132319207

Questions Cloud

Professional development during the professional exposure : What types of work environments attracts you the most - Are there specific networking challenges that you are more interested in for the future? Explain
How to present a bank reconciliation for the company : How to present a bank reconciliation for the company as of 11/30/17 and to record any necessary journal entries for the West company?
What is the labor efficiency quantity variance : What is the labor efficiency quantity variance? A negative number indicates an favorable variance and a positive number indicates an unfavorable variance.
Perform an analysis of HVCs investment problem : Managerial Report - Perform an analysis of HVC's investment problem and prepare a report that presents your findings and recommendations
Calculate the discount amount for this order : In cell F27, use an IF function to calculate the discount amount for this order based on the customer's status (which is found in F16).
Determine the number of units of kites that ocean city : Use this information to determine the number of units of kites that Ocean City Kite Company must sell in FY 2019 to meet this goal?
Job along with experience and education : Should personality also be considered when hiring for a job along with experience and education? Why or why not? Please explain with detail and examples.
Prepare the journal entries to record the lease by hand : Deal Leasing leased equipment to Hand Company on January 1, 2018. The lease payments were calculated to provide the lessor a 8% return.
Describe the diversification of disney : Describe the diversification of Disney. How does Disney go above and beyond to connect with it's customers?

Reviews

Write a Review

Financial Management Questions & Answers

  Present value of the right to receive four equal payments

What is the present value of the right to receive four equal payments (annuity due) of $1,000 per period, discounted at a rate of 10 percent per period? Which of the following statements about stock trading is correct?

  Calculate the total funds received by howett pockett

Calculate the gross proceeds per share. Calculate the total funds received by Howett Pockett from the sale of the 11.9 million shares of stock.

  What is maximum gain and loss in this covered call position

An investor buys 200 shares of stock selling at $50. The stock now sells for $70 and the investor writes a 70 call for $3.50. What is the maximum gain and loss in this covered call position?

  National bank maintains an average clearing balance

The Hollingsworth National Bank maintains an average clearing balance of $7,000,000 with the Federal Reserve. The Federal Funds rate is currently 5.25 percent. What is the credit the bank will earn over the maintenance period that can be used to offs..

  What is the floatation percentage

Investment bankers advised the firm that a new preferred if issued will require a yield (cost to the firm) of 6%. What is the floatation percentage?

  Issues create image problems for the corporation

what risks does the corporation take on, by having franchises, as could a bad location, that has issues create image problems for the corporation?

  Ideas and principles established by the well-known theorist

The ideas and principles established by the well-known theorist F.W. Taylor have implications for both operations and management even today. Describe briefly FIVE of these ideas and principles.

  What is its free cash flow

This year, FCF Inc. has earnings before interest and taxes of $9,330,000, If its tax rate is 35%, what is its free cash flow?

  What is the marginal value of road repair

What is the marginal value of road repair for each type of individual? What is the marginal cost to each type of individual?

  Pays the invoice

Maplewood Supply received a $5,390 invoice dated 4/15/10. The $5,390 included $390 freight. Terms were 3/10, 2/30, n/60. a. If Maplewood pays the invoice on April 27, what will it pay? If Maplewood pays the invoice on May 21, what will it pay?

  Wacc and percentage of debt financing

Hook Industries' capital structure consists solely of debt and common equity. It can issue debt at rd = 12%, and its common stock currently pays a $3.50 dividend per share (D0 = $3.50). The stock's price is currently $22.50, its dividend is expected ..

  Percentage change in price of bonds

Both Bond Bill and Bond Ted have 12.2 percent coupons, make semiannual payments, and are priced at par value. Bond Bill has 4 years to maturity, whereas Bond Ted has 21 years to maturity. Requirement 1: If interest rates suddenly rise by 2 percent, w..

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