Hello i am having a lot of trouble trying to make an amortization table for this case 3 problem to get the PV of the bond. i know the formula to get the PV however i am having trouble with both tables. also may you help wit the recommendation section as well. the question is on the bottom of the first page and the whole second page most of the upload is history. i have also uploaded a template provided by my professor.

Thank you

Case 3-1 Study Hints (Lightpoint, Inc.) In order to make a reasonable financing recommendation, you must first complete amortization schedules for each of the two case scenarios presented. Using the bond amortization information presented in the text (and the partial amortization tables presented below), you should be able to construct the necessary tables. Note that the two scenarios given in the case are not exactly the same as those outlined in the chapter so you will need to use some analytical skills to work through the options presented. After you've created your tables, outline the impact of each option on the financial statements (balance sheets, income statements, and statements of cash flows) for two years (2017 and 2018). This analysis will become the basis of your support for the option selected. Note that there is no one correct recommendation. Just be sure to support your choice with reasonable financial analysis. Partial Amortization Table for Conventional 4% Par Value Term Bonds Cash Paid-4% Date 1/1/2017 12/31/2017 1/1/2018 12/31/2018 1/1/2019 12/31/2019 1/1/2020 12/31/2020 1/1/2021 12/31/2021 1/1/2022 12/31/2022 1/1/2023 12/31/2023 1/1/2024 12/31/2024 1/1/2025 12/31/2025 1/1/2026 12/31/2026 1/1/2027 12/31/2027 Int. Exp 4% Amortized Discount Unamort. Discount $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 88,000,000 $ $ P.V of Bonds - - $ 200,000,000 200,000,000 7,396,449.70 Partial Amortization Table for 0% Zero-Percent Term Bonds (effectively yielding 6% interest) Date 1/1/2017 12/31/2017 $ Cash Paid-0% Int. Exp 6% Amortized Discount Unamort. Discount $ - $ 12,000,000 $ 12,000,000 158,170,000 $ 146,170,000 P.V of Bonds 200,000,000 212,000,000 1/1/2018 12/31/2018 1/1/2019 12/31/2019 1/1/2020 12/31/2020 1/1/2021 12/31/2021 1/1/2022 12/31/2022 1/1/2023 12/31/2023 1/1/2024 12/31/2024 1/1/2025 12/31/2025 1/1/2026 12/31/2026 1/1/2027 12/31/2027 1/1/2028 12/31/2028 1/1/2029 12/31/2029 of the two case bles presented exactly the sented. me statements, or the option inancial Payment 8000 pv $ $ 1,622,180.00 1,472,018.00 63.4920634921