Show the calculated commission amounts

Assignment Help Financial Accounting
Reference no: EM132958980

Question - Anne Wilson, the Sales Manager, has asked you to write the following procedures and email it to her in the following business day for review.

a) A procedure how to use Excel Number Format option to show the calculated commission amounts in cells H5 to H14 to two decimal places; and

b) A procedure how to use Excel online help about formatting a cell with dollar amount to two decimal places.

Reference no: EM132958980

Questions Cloud

Record journal entries for inception of lease : Record journal entries for: inception of lease, cost of goods sold, first payment of lease, and interest income. The equipment's regular selling price $164,000.
Determine what estimated cost of common equity using capm : The market risk premium is 7.5%, and the return on an average stock in the market last year was 15%. What is the estimated cost of common equity using the CAPM?
What entry to record the cost of inventory will include a : XYZ also paid $100 for freight-in and $50 for insurance during transportation. The entry to record the cost of inventory will include a
Prepare the amortization table for winthrop inc : Calculate the present value of the lease payments. At the end of the lease the leased asset will revert to the lessor. Winthrop's fiscal year end is December 31
Show the calculated commission amounts : A procedure how to use Excel Number Format option to show the calculated commission amounts in cells H5 to H14 to two decimal places
What is wacc for shi import-export : Shi Import-Export's balance sheet shows $300 million, If Shi target capital structure of 30% debt, 5% preferred stock, and 65% common stock, what is its WACC?
Interest based approach to collective bargaining : 1) Discuss how management and workers can benefit from engaging in collective agreement-making.
Find the effective interest rate : Then amount of $5,000 is deposited and the total remains invested for an additional 4 years. Find the effective interest rate
What area of hrm could help address issue : We are worried about a major health pandemic (e.g. Coronavirus, SARS, Ebola, H1N1) (Risk management and policies for pandemics)

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate Christine net pay

Christine works for Marian Transport in Québec and is paid $962.35 weekly. Calculate Christine net pay

  Compute what is avery wacc

Find What is Avery's WACC? Avery Corporation's target capital structure is 35% debt, 10% preferred, The firm will not be issuing any new common stock.

  What is mcfarland net pay

Kenneth McFarland's weekly gross earnings for the week ending March 9 were $1,950, and her federal income tax, what is McFarland's net pay?

  What were three possible alternative courses of action

In the case, Accounting for a Loss Contingency, what were three possible alternative courses of action and What is the reason that accounting choices might have

  Explain each adjustment made in the reconciliation schedule

Prepare a reconciliation schedule to convert 2017 income and December 31, 2017 stockholders' equity from IFRS basis to U.S. GAAP. Ignore income taxes.

  What will be the carrying value of the bond on june

If the bond was issued on January 1, 2020, what will be the carrying value of the bond On June 30, 2021. Did the bond issue at a premium

  What is the beginning inventory

The following relate to the income statement of Growth Company for the year ended 2010.  - What is the beginning inventory?

  What is the journal entry to record change in revaluation

After recording the depreciation as of Jul. 1, 2026, what is the journal entry to record the change in revaluation using the proportionate method?

  Post the transactions to the ledger accounts

Analyze the transactions in tabular format. And prove the equality of the basic accounting equation. Post the transactions to the ledger accounts

  How do solve the amount of money justin had to deposit

How do Solve the amount of money Justin had to deposit in an investment fund growing at an interest rate of 2.50% compounded annually

  On 1st january rare bird ltd purchased 12 percent bonds

on 1st january rare bird ltd. purchased 12 percent bonds dated 1st january with a face amount of 20 million. the bonds

  What approximate level should a new order be placed

When the inventory falls to what approximate level should a new order be placed, using reorder point? When reached, drives a new order to be placed to ensure

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