You are working in XYZ Bank. Part of your job is to promote a personal loan scheme introduced by the bank and to advice potential customers about the scheme. By using Excel, construct a loan schedule. Specify the interest rate i. Hint: You may refer to the table provided as guidance. S TAHUN & JUMLAH PEMBIAYAAN "Kami Memberikan Khidmat Kaunseling & Panduan Kepada Anda Tentang Pengurusan Kewangan Bijak dari Segi Bajet, Pengurusan Wang & Penggunaan Kredit 2 3 6 7 8 9 10 10,000 205 176 156 141 129 120 458 318 247 919 636 495 410 20,000 353 313 283 2:59 240 30,000 1378 954 742 615 530 470 424 3:49 361 40,000 1838 1272 990 820 707 626 566 519 481 50,000 2297 1591 1237 1025 884 783 707 649 601 60,000 2756 1909 1485 1231 1061 940 849 778 722 3216 2227 1732 1436 1238 1097 991 908 842 3675 2545 1980 1641 1415 1253 1132 1038 963 1083 70,000 80,000 90,000 4135 2863 2227 1846 1592 1410 1274 1168 100,000 4584 3181 2475 2051 1769 1567 1415 1298 1203 110,000 5054 3500 2723 22:56 1945 1723 1557 1427 1324 120,000 5613 3818 2970 2461 2122 1880 1444 1658 1557 2037 1840 1687 1565 130,000 5873 4136 3218 2667 6432 4454 3465 2872 1982 1817 1685 2476 2194 2653 6892 4772 3713 3077 2350 2123 1947 1805 2265 2076 19:26 140,000 150,000 160,000 7351 5091 3960 3282 170,000 7811 5409 4208 3487 3007 180,000 8270 5727 190,000 8730 6045 4703 3898 3361 200,000 9189 6363 4950 4103 3538 28:30 2507 2664 2820 2548 2336 2166 2406 2206 2046 4455 3692 3184 2287 2689 2466 2831 2596 2407 2299 2977 3134 You are working in XYZ Bank. Part of your job is to promote a personal loan scheme introduced by the bank and to advice potential customers about the scheme. By using Excel, construct a loan schedule. Specify the interest rate i. Hint: You may refer to the table provided as guidance. S TAHUN & JUMLAH PEMBIAYAAN "Kami Memberikan Khidmat Kaunseling & Panduan Kepada Anda Tentang Pengurusan Kewangan Bijak dari Segi Bajet, Pengurusan Wang & Penggunaan Kredit 2 3 6 7 8 9 10 10,000 205 176 156 141 129 120 458 318 247 919 636 495 410 20,000 353 313 283 2:59 240 30,000 1378 954 742 615 530 470 424 3:49 361 40,000 1838 1272 990 820 707 626 566 519 481 50,000 2297 1591 1237 1025 884 783 707 649 601 60,000 2756 1909 1485 1231 1061 940 849 778 722 3216 2227 1732 1436 1238 1097 991 908 842 3675 2545 1980 1641 1415 1253 1132 1038 963 1083 70,000 80,000 90,000 4135 2863 2227 1846 1592 1410 1274 1168 100,000 4584 3181 2475 2051 1769 1567 1415 1298 1203 110,000 5054 3500 2723 22:56 1945 1723 1557 1427 1324 120,000 5613 3818 2970 2461 2122 1880 1444 1658 1557 2037 1840 1687 1565 130,000 5873 4136 3218 2667 6432 4454 3465 2872 1982 1817 1685 2476 2194 2653 6892 4772 3713 3077 2350 2123 1947 1805 2265 2076 19:26 140,000 150,000 160,000 7351 5091 3960 3282 170,000 7811 5409 4208 3487 3007 180,000 8270 5727 190,000 8730 6045 4703 3898 3361 200,000 9189 6363 4950 4103 3538 28:30 2507 2664 2820 2548 2336 2166 2406 2206 2046 4455 3692 3184 2287 2689 2466 2831 2596 2407 2299 2977 3134