just write the forumla /

Option #	Copany Name	Number of Compunding Periods per year	Annual Interest Rate	Loan Duration in years	Payment per period (PMT)	Present Value (PV)	Future Value (FV)	Total Yearly Outlay
1	TNC Executives Inc.	4		2	$ 8,500.00	$ 65,000.00
2	Hicks & Bradshaw	12	6.50%	1.5		55000.00
3	AdWest Inc.	2	6.25%		9200.00	44000.00
4	Johnson, Bellview & Associate	12	5.00%	3	1500.00

3. Include the title TZEdge Advertising Options on your worksheet, mer centered over the data 4. Using the information provided for the options, enter the appropriate d data and calculations for each (across the row) so that all information is listed. For all o assume that the payment period duration will be used as the compoundin and that payments are made at the end of each period Option 1-TNC Executives Inc. has proposed a campaign costing $65,000 agency willLaccept full payment over the next two years i ments of S8,500 For this option, you need to calculate the anpual interes 1S n equal quarterly insta e Option Hicks & Bradshaw has designed a campaign for $55,000 and in cated that it will charge a 6.5% annat rapa of interest on this amount, wit monthly payments paid out over the next I8 calculate periodic payments. Option 3-AdWest Inc. has proposed an ad campaign-costing $44,000. Thi agency is willing to accept sen paid off. AdWest Inc. will charge a 625% 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 h excellent campaign that will cost $1,500 a month for the next three 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 months, For this option, you need to nual paym ents of $9,200 until the campaign is as shown the marketing group an . In an adjacent column, calculate the total yearly payments required for each option Format your worksheet so that it is easy to read. Be certain that dollars and percent at columns display consistent numbers of decimal places (line up decimal points). Wrap text, as necessary, to format the column headings within reasonable column widths. Highlight cells with the data outputs In a row below your data, select an option to recommend if you were trying to mini mize the yearly outlay for this campaign. Label and highlight your recommendation in pink Save and close the Advertising.xlsx workbook