4. Return to Excel and create a timeline with the cash flows and discount rates you will need to value the new bond issue.

a. To create the required spot rates for Ford's issue, add the appropriate spread to the Treasury yield of the same maturity.

b. The yield curve and spread rates you have found do not cover every year that you will need for the new bonds. Specifically, you do not have yields or spreads for four-, six-, eight-, and nine-year maturities. Fill these in by linearly interpolating the given yields and spreads. For example, the four-year spot rate and spread will be the average of the three- and five-year rates. The six-year rate and spread will be the average of the five- and seven-year rates. For years eight and nine you will have to spread the difference between years seven and ten across the two years.

c. To compute the spot rates for Ford's current debt rating, add the yield spread to the Treasury rate for each maturity. However, note that the spread is in basis points, which are 1/100th of a percentage point.

d. Compute the cash flows that would be paid to bondholders each year and add them to the timeline.