2 provided below: Bridgeport Manufacturing Inc. intends to finance the acquisition of new manufacturing equipment that costs $169,000 by Issuing a 5- year, 3.50% note payable. The note would be issued on January 1, 2021. Bridgeport's year end is December and the note would require annual payments on December 31. The finance company has given Bridgeport the choice of making blended payments of $37.430, or making fixed payments of $33,800 plus interest 10 11. Using the above WileyPlus question please enter the appropriate information from the question into the appropriate boxes below 13 14 Data from the WileyPlus Algimant Ouestion 15 10 osteal the instalnem notupwable January 2011 vinopal amount borrowed 100,000.00 At Home in the part below MUST ofenced to your data to the feel Termine the on Interstate 11 We had two updates to the stem thawk on Wednesday - this was with who error message in the Adaptive Assigments and Blended Parments 5 37430 00 24 would recommend their clear their cache, but through 'm very sorry for any inconvenience this may h 25 2 Faed Payments 5 33 800.00 22 First payment date December 31, 2023 be cool and read your question 29 Part A Assume that the company has chosen to make Wended payment to pay the instalment note payable, the loan). Answer the questions below accordingly 30 30 . Using the cel formula calculate the ended unnual principal repayment amount for the instalment note (1 mark) 1537410 Does this aree with the amount in the 31 2 Prepare an instalment payment schedule for the note (4 marks Reduction of Payment Date Gah Payment Interest Expense Principal Principal Balance 5169.000.00 December 11, 2021 537 430.005 5913.00 $11,5155 1745 37 December 21 2022 512430.00 $32.6115 104867 December 11, 2023 33740.005 3,670 $13,700 71107 39 December 11, 2024 537430.00 2,420 514 36,166 December 31, 2015 517430.005 1.264 536164 2 42 It the 3117250 $18.152 $168.999 3 Prepare Journal entries to record 1) the instalment note payable on the date of 2 marks), and 2) the entry for the first instalment payment (3 mars Date Account Name Debat Credit lan 1.2001 Equipment 5 169,000.00 Notes Payable $ 169,000.00 Dec 31, 2001 5 Interest Expen Notes Payable Cash 5,915.00 31.315 $37 430.00 4 Prepare the company's partial balance sheet (lability section ONLY) at December 31, 2021.4 marks) Name Balance Sheet December 31, 2021 Long term Lite Notes Payable (160,000-17.40 3 111.570.00 NOW Prepare the company's partial balance sheet liability section or Name Balance Sheet Date Current liabilities Interest Payable 15.01510/12) 5 Long term tibi Notes Payable Part B Assume now that the company has chosen to make fixed principal payments plus interest to repay the Instalment note payable fle, the loan). Answer the question below according 1 Prepare an instalment payment schedule for the note using the fixed principal repayment provided in the question above. (3 marks) Reduction of Payment Data Cash Payment Interest Expense Principal Principal Balance $ 169,000.00 Dec 31, 2021 23 800 Dec 31, 2022 All items in this schedule MUST be cell referenced to your data above Dec 31, 2023 Use Excel formula for amounts including dates Dec 31, 2014 Dec 31, 2025 Total the columns $0.00 $0.00 $0.00 2 Prepare journal entries to record 1) the instalment note payable on the date of issue (1 mark), and the entry for the first instalment payment (1 mark) Date Account Name Debit Credit