Columbus, Ohio advertised for bids for the purchase of $4.5 million principal amount of Waste Water Revenue Bonds. Bonds will be delivered on June 1, 2022, and the interest will be paid on June 1st of the following years. The bonds mature as follows:

The City received three competing bids offers for the Waste Water Revenue Bonds. The three offers are as follows:

From Rogue Securities: -The City receives $4.2 million dollars -The Interest Rates for the serial bonds with maturities: 2027 through 2030, 3.33 percent 2031 through 2037, 4.00 percent

From Johnson-Miller: -The City Receives $4.5 million dollars -The Interest Rates for the serial bonds with maturities: 2027 through 2029, 2.75 percent 2030 through 2034, 3.28 percent 2035 through 2037, 4.50 percent

From Shostak Corp: -The City receives $4.55 million dollars -The Interest rates for the serial bonds with maturities: 2027 to 2033, 3.45 percent 2034 to 2037, 4.25 percent

For each bid, compute the net interest cost (NIC) and the true interest cost (TIC). Which bid is more advantageous for the city?

Please show excel calculations, explanations, and interpretation.

Maturity Amount Date ($) 6/1/2027 150,000 6/1/2028 200,000 6/1/2029 200,000 6/1/2030 250,000 6/1/2031 300,000 6/1/2032 300,000 6/1/2033 350,000 6/1/2034 450,000 6/1/2035 500,000 6/1/2036 800,000 6/1/2037 | 1,000,000 Maturity Amount Date ($) 6/1/2027 150,000 6/1/2028 200,000 6/1/2029 200,000 6/1/2030 250,000 6/1/2031 300,000 6/1/2032 300,000 6/1/2033 350,000 6/1/2034 450,000 6/1/2035 500,000 6/1/2036 800,000 6/1/2037 | 1,000,000