Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am so confused. Could someone please help me, I am terrible at excel. :( 1. Create a worksheet with the following column headings: Advertising

I am so confused. Could someone please help me, I am terrible at excel. :( image text in transcribed
1. Create a worksheet with the following column headings: Advertising Options Number of Compounding AnualLoar Total Periods per Interest Duration Payment Present Future Yearly Option# Company Name Year Rate in Years per Period Value Value Payments 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 that the payment period duration will be used as the compounding period and that 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 rate of interest 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. 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%. For this option, you need to calculate the initial value of this advertising campaign. 4. In an adjacent column, calculate the total yearly payments required for each option. 5. Format your worksheet so that it is easy to read. Be certain that dollars and percentages are included where appropriate and that columns display consistent numbers of decimal places. Wrap text, as necessary, to format the column headings within reasonable column widths. Highlight cells with the data outputs. 6. In a row below your data, select an option to recommend if you were trying to minimize the yearly outlay for this campaign. Highlight your recommendation in pink

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions