D2L Amortization & Sin| X Setup Instructions & X D2L News - W2023 BUS X Contemporary Busi X Contemporary Busi X i How To Calculate In X + X A ilearn.canadorecollege.ca/d21/le/content/385246/viewContent/2285080/View W . Question 4 10 pts 9 1 0 Details A $23, 130 loan is to be settled by making payments of $6,796 at the end of every six months. The interest is 6.14% compounded quarterly. a) Find the number of payments in the term. N = b) Fill in the missing values of the amortization schedule below. Enter all your answers as a positive value. Round all the monetary values to two decimal places. Payment Payment Amount($) Interest Portion ($) Principal Portion ($) Loan Balance ($) Number PMT INT PRN BAL O 3 4 Add Work Submit Question 5 0 C Q Search L X 13:21 ENG 20/4/2023D21 Amortization & Sin| X Contemporary Busi X i How To Calculate In X + X Setup Instructions a X D2L News - W2023 BUS X Contemporary Busi X - COC:/Users/lenovo/Downloads/Setup%20Instructions%20and%20Examples%20of%20Amortization%20Schedules%20and... @ W E Setup Instructions and Examples of Amortization Schedules an... 2 / 4 121% + B C D E F G H Loan Amortization Template 1- 2 2 j Enter your nominal interest rate here Amortization Schedule Outstanding Principal C/Y Enter the number of compoundings per Payment Number Amount Paid Interest Paid Principal Repaid Balance 4 year here =B13 5 P/Y Enter number of payments per year here C EE6-F6 =H5-G6 6 Enter the term (in years) here 1 =ROUND($B$12,2) ROUND(H5*$B$10, 2) 2 =ROUND($B$12,2) =ROUND(H6*$B$10, 2) =E7-F7 =H6-G7 7 =E8-F8 8 i =ROUND($B$12,2) =ROUND(H7*$B$10, 2) =H7-G8 =B3/B4 A w 9 C =B4/B5 =ROUND($B$12,2) =ROUND(H8*$B$10, 2) =E9-F9 =H8-G9 10 p =(1+B8)^B9-1 5 =ROUND($B$12,2) =ROUND(H9*$B$10, 2) =E10-F10 =H9-G10 =ROUND(H10*$B$10, 2) =H10-G11 n =85*B6 6 =ROUND($B$12,2) =E11-F11 11 =H11-G12 12 PMT =-PMT(B10, B11,B13) 7 =ROUND($B$12,2) =ROUND(H11*$B$10, 2) =E12-F12 Enter PV of loan here 8 =ROUND(H12*$B$10, 2) =E13-F13 =H12-G13 13 PV =ROUND($B$12,2) 9 =ROUND($B$12,2) ROUND(H13*$B$10, 2) =E14-F14 =H13-G14 14 15 10 =ROUND($B$12,2) =ROUND(H14*$B$10, 2) =E15-F15 =H14-G15 16 11 =ROUND($B$12,2) ROUND(H15*$B$10, 2) =E16-F16 =H15-G16 12 = H16+F17 =ROUND(H16*$B$10, 2) =H16 =H16-G17 17 TOTAL =SUM($E$5:E17) -SUM($F$5:F17) =SUM($G$5:G17) Don't forget the negative sign in front of PMT here The final two rows will have to be manually adjusted like so (note that they do not fit the NOTE 13:21 5 0 C Q Search L ENG 20/4/2023+ D2L Amortization & Sin| X Setup Instructions & X Contemporary Busi X | How To Calculate In X X D2L News - W2023 BUS X Contemporary Busi X - COC:/Users/lenovo/Downloads/Setup%20Instructions%20and%20Examples%20of%20Amortization%20Schedules%20and... @ W E Setup Instructions and Examples of Amortization Schedules an... 4 121% + C D E F G H A Sinking Fund Template W N - j Enter your nominal interest rate here Sinking Fund Schedule Payment Interval Balance at End of C/Y Enter the number of compoundings per Payment Number Periodic Payment Increase in Fund Interest Payment Interval year here P/Y Enter number of payments per year here 0 0 t Enter the term (in years) here =ROUND($B$12,2) =ROUND(H5*$B$10,2) =E6+F6 =H5+G6 2 =ROUND($B$12,2) =ROUND(H6*$B$10,2) =E7+F7 =H6+G7 -B3/B4 3 =ROUND($B$12,2) =ROUND(H7*$B$10,2) =E8+F8 =H7+G8 CO i 9 C -B4/B5 4 =ROUND($B$12,2) =ROUND(H8*$B$10,2) =E9+F9 =H8+G9 10 P =(1+B8)^B9-1 15 =ROUND($B$12,2) =ROUND(H9*$B$10,2) =E10+F10 =H9+G10 =H10+G11 11 n =B5*B6 =ROUND($B$12,2) =ROUND(H10*$B$10,2) =E11+F11 PMT =-PMT(B10,B11,0,B13) Co O =ROUND($B$12,2) =ROUND(H11*$B$10,2) =E12+F12 =H11+G12 FV Enter FV of loan here =B13-F13-H12 =ROUND(H12*$B$10,2) =E13+F13 =H12+G13 AWN TOTAL =SUM($E$5:E13) =SUM($F$5:F13) =SUM($G$5:G13) 15 Don't forget the negative sign in front of PMT here The final two rows will have to be manually adjusted like so (note that they do not fit the same format as all the other rows). 13:22 5 . C Q Search L ENG 20/4/2023D2L Amortization & Sin| X Setup Instructions & X D2L News - W2023 BUS X Contemporary Busi X Contemporary Busi X How To Calculate In X + V X A ilearn.canadorecollege.ca/d21/le/content/385246/viewContent/2285080/View W Amortization & Sinking Fund Assignment Progress saved Add Work VO . : 80 points possible 6/8 answered Question 7 10 pts 9 1 0 Details You have taken a loan of $90,000.00 for 35 years at 3.9% compounded quarterly. Payments are also quarterly. Fill in the table below: (Round all answers to 2 decimal places. ) Payment number |Payment amount Principal Amount Interest Balance 0) $90,000.00 1) S S S 2) 3) S S Add Work Submit Question 5 0 C Q Search L X 13:22 ENG 20/4/2023