Yields the total cost of purchasing any number of ads

Assignment Help Financial Management

Reference no: EM131991175

You are thinking of advertising Microsoft products on a sports telecast. As you buy more ads, the price of each ad decreases as shown in the following table.

Number of ads / Price per ad

1– 5 $ 12,000

6– 10 $ 11,000

11– 20 $ 10,000

21 and higher $ 9,000

For example, if you buy 8 ads, you pay $ 11,000 per ad, but if you buy 14 ads, you pay $ 10,000 per ad. Write a formula that yields the total cost of purchasing any number of ads.

PLEASE SHOW WORK USING EXCEL.

Reference no: EM131991175

Questions Cloud

How to find the amount received by the seller of the stock : How to find the amount received by the seller of the stock (at the day's closing price). Be sure to duduct sale expenses.

What is the firm after tax cost to issue these bonds : The company can issue $1,000 bonds at 10%, although the current market is paying 11%. What is the firm’s AFTER TAX cost to issue these bonds?

Determine the present value of carolyn lifetime earnings : Determine the present value of Carolyn’s lifetime earnings if she does not return to school.

Detail the concept of financial management : Discuss and analyse in detail the concept of financial management. Explain how the existence of the financial market help in raising funding.

Yields the total cost of purchasing any number of ads : you pay $ 11,000 per ad, but if you buy 14 ads, you pay $ 10,000 per ad. Write a formula that yields the total cost of purchasing any number of ads.

How much interest is due to the provincial bank : The Provincial Bank lent $20 000 to the owner of the Purple Pelican on April 1, 2012, How much interest is due to the Provincial Bank on December 31?

Discuss the form and extent of remuneration disclosure : Discuss the form and extent of remuneration disclosure that applies to financial advisers.

What is the value of the project on the basis of flexibility : What is the value of the project on the basis of flexibility and what is the risk adjusted discount rate?

What is new effective interest rate being charged borrower : What is the new effective interest rate being charged the borrower (without prepayment)?

User Account

All Pages