MONTH March April May June July Aug Sept Oct ADVERTISINGS 900 2700 3150 1300 3400 1500 2300 2250 SALES S 56000 89200 98500 54000 97000 56000 93000 79000 Please give a short explanation as to how and why you came up with your advertising spending for the above 4 months Example: You want to buy a $18,500 car. The company is offering a 3% interest rate for 4 years. What will your monthly payments be? I will do this one for you and show you how I want you to describe your formula/inputs in excel if that is how you choose to go about solving problems 2 through 5 - which I strongly recommend. If you choose to perform the calculations by hand show the formula used with values. Excel: Formula used: PMT Rate input:.03/12 NPer input: 4*12 Px input: 18500 Answer: $409.49 per month MONTH March April May June July Aug Sept Oct ADVERTISINGS 900 2700 3150 1300 3400 1500 2300 2250 SALES S 56000 89200 98500 54000 97000 56000 93000 79000 Please give a short explanation as to how and why you came up with your advertising spending for the above 4 months Example: You want to buy a $18,500 car. The company is offering a 3% interest rate for 4 years. What will your monthly payments be? I will do this one for you and show you how I want you to describe your formula/inputs in excel if that is how you choose to go about solving problems 2 through 5 - which I strongly recommend. If you choose to perform the calculations by hand show the formula used with values. Excel: Formula used: PMT Rate input:.03/12 NPer input: 4*12 Px input: 18500 Answer: $409.49 per month