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

  Describe what marcus lemonis did

Describe what episodes you watched and what the problems were that caused the business to be failing.

  What is annual rate of interest with continuous compounding

Find the present value for a payment of $10; 000 to be received in 3,5 years, if the annual interest rate is 4% that: (i) compounded monthly; (ii) compounded continuously. What is the annual rate of interest with continuous compounding is equal to 10..

  A brief email on vacation policy changes to be distributed

You will need to listen to a voice mail from your supervisor with instructions on how to create the email to announce the new vacation policy.

  What is the project net present value

What is the project’s net present value? What is the project’s internal rate of return to the nearest whole percent?

  What is the equipments after-tax salvage value

Kennedy Air Services is now in the final year of a project. The equipment originally cost $24 million, of which 90% has been depreciated. Kennedy can sell the used equipment today for $6 million, and its tax rate is 30%. What is the equipment's after..

  Issue floating rate bond denominated in foreign currency

What factors should be considered by a U.S. firm that plans to issue a floating rate bond denominated in a foreign currency? Is the risk of issuing a floating rate bond higher or lower than the risk of issuing a fixed rate Eurobond? Explain.

  Disadvantages of payback period decision rule

Which of the following are disadvantages of the payback period decision rule?

  Confidence interval for next quarter fund flows

What is the width of the 95% confidence interval for next quarter's fund flows?

  What is the conversion ratio-what is the conversion value

Market rates are 10% annually. (I) What is the conversion ratio? (II) What is the conversion value?

  Hedging anticipated loan with an interest rate call option

Determine the effective annual rate on the loan with and without the call option for each of the following outcomes:

  Find the firm cash flow from assets

find the firm's 2013 cash flow from assets (CFFA).

  The current price of the bond is

Johnson construction inc. has issued 20 years $1000 face value, 8% annual coupon bonds with a yield to maturity of 10%. the current price of the bond is?

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