You have recently been hired at Caterpillar as an accountant. Your company is about to issue a new bond for $10,000,000 to fund a plant expansion, and Chris Keen, your supervisor, is wondering if your company should consider using the fair value option for accounting for the bond. Chris recently attended a continuing education program where the fair value option for financial instruments was discussed. Chris has asked you to investigate. The bond term is 10 years. The stated rate is 8%. Interest is paid annually on 12/31. Projected issuance date: 1/1/2024. Market rate on the date of issuance: 10%. Projected market rates for the next 10 years at the end of the year: 2024 10.00% 2025 9.50% 2026 9.00% 2027 8.75% 2028 8.50% 2029 8.25% 2030 8.25% 2031 8.00% 2032 7.00% 2033 6.00%

This bond is a discount. I know how to make the table and need help calculating the starting Carrying value (PV) and how to end with 10,000,000 as my final Face Value at the end of the 10 years. How to I use this discount amortization bond to end with 10,000,000 as my ending face value?