After reviewing the entire case, cast yourself in the role of Richard McManus.Make a financing recommendation to Sharon Light in a memo. Be sure to discuss the financial implications of each alternative on the income statements and balance sheets for 2017 and 2018 in the memo. Can someone show me how this is done

Case 3-1 Bond Amortization Schedules (Lightpoint, Inc.)

In order to make a reasonable financing recommendation, how do we do an 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

El '3 Home insen Draw Page Layout Formulas Data BUADeseMoLllgmhouse,spreadsheet , Compallblllty Mode , Excel Rewew View Help '2 Tell me what you want to do Lam b, Autumn 1i Partial Amortization Table for Conventional 4% Par Value Term Bonds 1 1 1; Cash Int. Exp Amortized Unamort. P.V of 13 Date Paid-4% 4% Discount Discount Bonds 14 1/1/2017 $ - $ 200,000,000 15 12/31/2017 $ 8,000,000 $ 8,000,000 $ - - 200,000,000 16 12/31/2018 17 12/31/2019 18 12/31/2020 19' 12/31/2021 20 12/31/2022 21 12/31/2023 22 12/31/2024 23 12/31/2025 24 12/31/2026 25 2E 27: Partial Amortization Table for 0% Zero-Percent Term Bonds effective! 28 297 X \" .55389 = 200,000,000 307 $200,000,000 / .55389 = $358,170,000 31 $358,170,000 - $200,000,000 = $158,170,000 ieldin 6% interest 32 32: Cash int. Exp Amortized Unamort. P.V of 34 Date Paid-0% 6% Discount Discount Bonds 735 1/1/2017 $ 158,170,000 $ 200,000,000 367 12/31/2017 $ - $ 12,000,000 $ 12,000,000 146,170,000 212,000,000 37 12/31/2018 38 12/31/2019 39 (1231/2020 40 12/31/2021 41 12/31/2022 42 12I31/2023 43 12/31/2024 44 12/31/2025 45 12/31/2026 4e, 47 Case 3-1 SheetZ l Sheet3 l (-9 Select destination and press ENTER or choose Paste 0 Type here to search