Fill in the appropriate data inputs and calculations

Assignment Help Management Theories

Reference no: EM133359666

Complete the following:

1. Create the following column headings on your downloaded file Advertising that is blank:

2. Include the title Advertising Options on your worksheet, merged and centered over the data.

3. Fill in the appropriate data inputs and calculations for each option (across the row) so that all information is listed. For all options, assume payments are made at the end of each period.

• Option 1-AD Executives Inc. has proposed a campaign costing $45,000. This agency will accept full payment over the next two years in equal monthly installments of $2,100. For this option, you need to calculate the annual interest rate.

• Option 2-Bradshaw & Hicks has designed a campaign for $45,000 and indicated that it will charge a 6.25% annual interest rate compounded quarterly on this amount, with fixed quarterly payments paid out over the next 18 months. For this option, you need to calculate periodic payments.

• Option 3-AdWest Inc. has proposed the most modestly priced campaign, costing $30,000. This agency is willing to accept monthly payments of $1,400 until the campaign is completely paid off. AdWest Inc. will charge a 6.5% annual interest rate compounded monthly. For this option, you need to calculate the duration in years that will be required to pay off this debt.

• Option 4-Johnson, Bellview & Associates has shown the Marketing team an excellent campaign that will cost $1,500 a month for the next two years. This agency's payment terms are based on an annual interest rate of 5% compounded monthly. For this option, you need to calculate the initial value of this advertising campaign.

Reference no: EM133359666

Questions Cloud

Whom does transformational leadership matter more : Whom does transformational leadership matter more? An examination of neurotic and introverted followers and their organizational citizenship behavior

Analyze quality of the coach-athlete relationship of curry : Analyze the quality of the coach-athlete relationship of curry and Kerr. please detail to write the maintenance of their relationship quality.

What were some of the benefits that social tools : What were some of the benefits that social tools can provide for business. 3- what made Cemex a good candidate for a company- wide social net work?

What element of verbal communication : What element of verbal communication, whether it's a specific concept or theory, do you find most interesting and why?So? What element or theory dealing with

Fill in the appropriate data inputs and calculations : Fill in the appropriate data inputs and calculations for each option (across the row) so that all information is listed. For all options, assume payments

Would you like me to bring my notes to the office : Would you like me to bring my notes to the office tomorrow and let you look through them?" How do you respond

What do you think that male sexuality is stereotyped : Do you think that male sexuality is stereotyped according to artificial norms in popular culture? Provide examples of some of those stereotypical male norms

Does money motivate : Does money motivate? If you think money motivates, find an academic research article that supports your assumption.

Provide feedback for the post : business ethics go a long way in terms of the company's reputation and maintaining customers' and stakeholders trust - provide feedback for the post

User Account

All Pages