Construct a spreadsheet that computes the effective annual rates on the commercial paper offerings. Inputs to the

Question:

Construct a spreadsheet that computes the effective annual rates on the commercial paper offerings. Inputs to the spreadsheet should include the dollar amount of paper to be issued, the number of days the paper is outstanding, the stated annual rate, and fees. All paper is sold on a discount basis. Use it to find the effective annual rates in problem 8.