Cathy Paul Necides Final Exam - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cut == D Wrap Text 12 Calibn -11 BIU-- Fg Copy Format Painter EV Comma 2 Conditional Format as Good Formatting Table Paste -A ====Merge & Center - % Number Clipboard 5 Font G A1 I X fx Problem 1 B Alignment D A E G 1 Problem 1 2 3 Marigold borrows A from a bank at a nominal rate of B percent compounded monthly, to be repaid in 1 year. In the first six (6) payments she also wants to make additional equal contributions to the prinicipal, in the amount of C. 4 5 6 Assumption Table 7 Loan Amount (A) $ 5,789 8 Nominal Interest rate (B) 7.00% 9 Term of Loan (annual) Additional Principal 10 Contribution Amount (C) 58.00 11 12 13 Interest Years 0.005833333 12 14 15 16 17 18 19 Payment Monthly: $500.90 5 marks 20 21 Complete the Amortization table below, making the necessary adjustments to accommodate prepayments in the schedule: 22 Beginning of period Loan 23 Number of periods Balance Principal 24 1 Payment 5,789 5,196.33 $500.90 25 $500.90 26 4,607.11 $500,90 27 4,021.33 $500.90 28 3,438.97 $500.90 $500.90 29 2,860.01 5.504.45 A Instructions Problem 1 Problem 2 Problem 5 Problem 6 READY H Type here to search 1 year 2 3 4 5 6 Problem 3 Problem 4 # M General $-% Interest Problem 7 MEM 33.77 30.31 26.87 23.46 20.06 16.68 Problem 8 W3 + Normal Neutral ( Styles $534.67 $531.22 $527.78 $524.36 $520.96 $517.59 CREAS X H Pre-Payment AutoSum Clear K Bad Calculation T I End of Period Loan Balance 58.00 58.00 5,196.33 4,607.11 58.00 4,021.33 58.00 3,438.97 2.860.01 58.00 58.00 2,284,42 4.350.40 M- 29C Mostly sunny 4 Insert Delete Format J ? - x A Microsoft account. AT H Sort & Find & Filter Select M Editing L + 5:15 pm 01/05/2022 NA + 90% 5 Cathy Paul Necides Final Exam - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cut == D Wrap Text 12 Calibn -11 BIU-- Fg Copy Format Painter EV Comma 2 Conditional Format as Good Formatting Table Paste -A ====Merge & Center - % Number Clipboard 5 Font G A1 I X fx Problem 1 B Alignment D A E G 1 Problem 1 2 3 Marigold borrows A from a bank at a nominal rate of B percent compounded monthly, to be repaid in 1 year. In the first six (6) payments she also wants to make additional equal contributions to the prinicipal, in the amount of C. 4 5 6 Assumption Table 7 Loan Amount (A) $ 5,789 8 Nominal Interest rate (B) 7.00% 9 Term of Loan (annual) Additional Principal 10 Contribution Amount (C) 58.00 11 12 13 Interest Years 0.005833333 12 14 15 16 17 18 19 Payment Monthly: $500.90 5 marks 20 21 Complete the Amortization table below, making the necessary adjustments to accommodate prepayments in the schedule: 22 Beginning of period Loan 23 Number of periods Balance Principal 24 1 Payment 5,789 5,196.33 $500.90 25 $500.90 26 4,607.11 $500,90 27 4,021.33 $500.90 28 3,438.97 $500.90 $500.90 29 2,860.01 5.504.45 A Instructions Problem 1 Problem 2 Problem 5 Problem 6 READY H Type here to search 1 year 2 3 4 5 6 Problem 3 Problem 4 # M General $-% Interest Problem 7 MEM 33.77 30.31 26.87 23.46 20.06 16.68 Problem 8 W3 + Normal Neutral ( Styles $534.67 $531.22 $527.78 $524.36 $520.96 $517.59 CREAS X H Pre-Payment AutoSum Clear K Bad Calculation T I End of Period Loan Balance 58.00 58.00 5,196.33 4,607.11 58.00 4,021.33 58.00 3,438.97 2.860.01 58.00 58.00 2,284,42 4.350.40 M- 29C Mostly sunny 4 Insert Delete Format J ? - x A Microsoft account. AT H Sort & Find & Filter Select M Editing L + 5:15 pm 01/05/2022 NA + 90% 5