PENGURUSAN WANG

1
ikan ruang sebelah kanan di bawa Summary Pinjaman Kereta Anda; Harga Kereta Idaman RM 70000 Bayaran Muka RM 7000 Pinjaman/Loan RM 63000 Jumlah Interest RM 19845 Interest / year % 3.50% Jumlah Perlu Bayar RM 82845 Jumlah tahun pinjaman Tahun 9 Bayaran Bulanan RM 767.08 Duration Acc Balance Duration Acc Balance Duration Acc Balance Year 1 1st month 767.08 767.08 82077.92 Year 4 1st month 767.08 28382.08 54462.92 Year 7 1st month 767.08 55997.08 26847.92 2nd month 767.08 1534.17 81310.83 2nd month 767.08 29149.17 53695.83 2nd month 767.08 56764.17 26080.83 3rd month 767.08 2301.25 80543.75 3rd month 767.08 29916.25 52928.75 3rd month 767.08 57531.25 25313.75 4th month 767.08 3068.33 79776.67 4th month 767.08 30683.33 52161.67 4th month 767.08 58298.33 24546.67 5th month 767.08 3835.42 79009.58 5th month 767.08 31450.42 51394.58 5th month 767.08 59065.42 23779.58 6th month 767.08 4602.50 78242.50 6th month 767.08 32217.50 50627.50 6th month 767.08 59832.50 23012.50 7th month 767.08 5369.58 77475.42 7th month 767.08 32984.58 49860.42 7th month 767.08 60599.58 22245.42 8th month 767.08 6136.67 76708.33 8th month 767.08 33751.67 49093.33 8th month 767.08 61366.67 21478.33 9th month 767.08 6903.75 75941.25 9th month 767.08 34518.75 48326.25 9th month 767.08 62133.75 20711.25 10th month 767.08 7670.83 75174.17 10th month 767.08 35285.83 47559.17 10th month 767.08 62900.83 19944.17 11th month 767.08 8437.92 74407.08 11th month 767.08 36052.92 46792.08 11th month 767.08 63667.92 19177.08 12th month 767.08 9205.00 73640.00 12th month 767.08 36820.00 46025.00 12th month 767.08 64435.00 18410.00 Duration Acc Balance Duration Acc Balance Duration Acc Balance Year 2 1st month 767.08 9972.08 72872.92 Year 5 1st month 767.08 37587.08 45257.92 Year 8 1st month 767.08 65202.08 17642.92 2nd month 767.08 10739.17 72105.83 2nd month 767.08 38354.17 44490.83 2nd month 767.08 65969.17 16875.83 3rd month 767.08 11506.25 71338.75 3rd month 767.08 39121.25 43723.75 3rd month 767.08 66736.25 16108.75 4th month 767.08 12273.33 70571.67 4th month 767.08 39888.33 42956.67 4th month 767.08 67503.33 15341.67 5th month 767.08 13040.42 69804.58 5th month 767.08 40655.42 42189.58 5th month 767.08 68270.42 14574.58 6th month 767.08 13807.50 69037.50 6th month 767.08 41422.50 41422.50 6th month 767.08 69037.50 13807.50 7th month 767.08 14574.58 68270.42 7th month 767.08 42189.58 40655.42 7th month 767.08 69804.58 13040.42 8th month 767.08 15341.67 67503.33 8th month 767.08 42956.67 39888.33 8th month 767.08 70571.67 12273.33 9th month 767.08 16108.75 66736.25 9th month 767.08 43723.75 39121.25 9th month 767.08 71338.75 11506.25 10th month 767.08 16875.83 65969.17 10th month 767.08 44490.83 38354.17 10th month 767.08 72105.83 10739.17 11th month 767.08 17642.92 65202.08 11th month 767.08 45257.92 37587.08 11th month 767.08 72872.92 9972.08 12th month 767.08 18410.00 64435.00 12th month 767.08 46025.00 36820.00 12th month 767.08 73640.00 9205.00 Duration Acc Balance Duration Acc Balance Duration Acc Balance Year 3 1st month 767.08 19177.08 63667.92 Year 6 1st month 767.08 46792.08 36052.92 Year 9 1st month 767.08 74407.08 8437.92 2nd month 767.08 19944.17 62900.83 2nd month 767.08 47559.17 35285.83 2nd month 767.08 75174.17 7670.83 3rd month 767.08 20711.25 62133.75 3rd month 767.08 48326.25 34518.75 3rd month 767.08 75941.25 6903.75 4th month 767.08 21478.33 61366.67 4th month 767.08 49093.33 33751.67 4th month 767.08 76708.33 6136.67 5th month 767.08 22245.42 60599.58 5th month 767.08 49860.42 32984.58 5th month 767.08 77475.42 5369.58 6th month 767.08 23012.50 59832.50 6th month 767.08 50627.50 32217.50 6th month 767.08 78242.50 4602.50 7th month 767.08 23779.58 59065.42 7th month 767.08 51394.58 31450.42 7th month 767.08 79009.58 3835.42 8th month 767.08 24546.67 58298.33 8th month 767.08 52161.67 30683.33 8th month 767.08 79776.67 3068.33 9th month 767.08 25313.75 57531.25 9th month 767.08 52928.75 29916.25 9th month 767.08 80543.75 2301.25 10th month 767.08 26080.83 56764.17 10th month 767.08 53695.83 29149.17 10th month 767.08 81310.83 1534.17 11th month 767.08 26847.92 55997.08 11th month 767.08 54462.92 28382.08 11th month 767.08 82077.92 767.08 12th month 767.08 27615.00 55230.00 12th month 767.08 55230.00 27615.00 12th month 767.08 82845.00 0.00 Anda hanya perlu isikan angka yang berwarna kuning sahaja (harga kereta, pinjaman, interest dan tahun) dan jumlah yang lain akan di Monthly pay Monthly pay Monthly pay Monthly pay Monthly pay Monthly pay Monthly pay Monthly pay Monthly pay

description

CARA PENGURUSAN WANG

Transcript of PENGURUSAN WANG

Page 1: PENGURUSAN WANG

Isikan ruang sebelah kanan di bawah; Summary Pinjaman Kereta Anda;

Harga Kereta Idaman RM 70000 Bayaran Muka RM 7000Pinjaman/Loan RM 63000 Jumlah Interest RM 19845Interest / year % 3.50% Jumlah Perlu Bayar RM 82845Jumlah tahun pinjaman Tahun 9 Bayaran Bulanan RM 767.08

Duration Acc Balance Duration Acc Balance Duration Acc Balance

Yea

r 1

1st month 767.08 767.08 82077.92

Yea

r 4

1st month 767.08 28382.08 54462.92

Yea

r 7

1st month 767.08 55997.08 26847.922nd month 767.08 1534.17 81310.83 2nd month 767.08 29149.17 53695.83 2nd month 767.08 56764.17 26080.833rd month 767.08 2301.25 80543.75 3rd month 767.08 29916.25 52928.75 3rd month 767.08 57531.25 25313.754th month 767.08 3068.33 79776.67 4th month 767.08 30683.33 52161.67 4th month 767.08 58298.33 24546.675th month 767.08 3835.42 79009.58 5th month 767.08 31450.42 51394.58 5th month 767.08 59065.42 23779.586th month 767.08 4602.50 78242.50 6th month 767.08 32217.50 50627.50 6th month 767.08 59832.50 23012.507th month 767.08 5369.58 77475.42 7th month 767.08 32984.58 49860.42 7th month 767.08 60599.58 22245.428th month 767.08 6136.67 76708.33 8th month 767.08 33751.67 49093.33 8th month 767.08 61366.67 21478.339th month 767.08 6903.75 75941.25 9th month 767.08 34518.75 48326.25 9th month 767.08 62133.75 20711.2510th month 767.08 7670.83 75174.17 10th month 767.08 35285.83 47559.17 10th month 767.08 62900.83 19944.1711th month 767.08 8437.92 74407.08 11th month 767.08 36052.92 46792.08 11th month 767.08 63667.92 19177.0812th month 767.08 9205.00 73640.00 12th month 767.08 36820.00 46025.00 12th month 767.08 64435.00 18410.00

Duration Acc Balance Duration Acc Balance Duration Acc Balance

Yea

r 2

1st month 767.08 9972.08 72872.92

Yea

r 5

1st month 767.08 37587.08 45257.92

Yea

r 8

1st month 767.08 65202.08 17642.922nd month 767.08 10739.17 72105.83 2nd month 767.08 38354.17 44490.83 2nd month 767.08 65969.17 16875.833rd month 767.08 11506.25 71338.75 3rd month 767.08 39121.25 43723.75 3rd month 767.08 66736.25 16108.754th month 767.08 12273.33 70571.67 4th month 767.08 39888.33 42956.67 4th month 767.08 67503.33 15341.675th month 767.08 13040.42 69804.58 5th month 767.08 40655.42 42189.58 5th month 767.08 68270.42 14574.586th month 767.08 13807.50 69037.50 6th month 767.08 41422.50 41422.50 6th month 767.08 69037.50 13807.507th month 767.08 14574.58 68270.42 7th month 767.08 42189.58 40655.42 7th month 767.08 69804.58 13040.428th month 767.08 15341.67 67503.33 8th month 767.08 42956.67 39888.33 8th month 767.08 70571.67 12273.339th month 767.08 16108.75 66736.25 9th month 767.08 43723.75 39121.25 9th month 767.08 71338.75 11506.2510th month 767.08 16875.83 65969.17 10th month 767.08 44490.83 38354.17 10th month 767.08 72105.83 10739.1711th month 767.08 17642.92 65202.08 11th month 767.08 45257.92 37587.08 11th month 767.08 72872.92 9972.0812th month 767.08 18410.00 64435.00 12th month 767.08 46025.00 36820.00 12th month 767.08 73640.00 9205.00

Duration Acc Balance Duration Acc Balance Duration Acc Balance

Yea

r 3

1st month 767.08 19177.08 63667.92

Yea

r 6

1st month 767.08 46792.08 36052.92

Yea

r 9

1st month 767.08 74407.08 8437.922nd month 767.08 19944.17 62900.83 2nd month 767.08 47559.17 35285.83 2nd month 767.08 75174.17 7670.833rd month 767.08 20711.25 62133.75 3rd month 767.08 48326.25 34518.75 3rd month 767.08 75941.25 6903.754th month 767.08 21478.33 61366.67 4th month 767.08 49093.33 33751.67 4th month 767.08 76708.33 6136.675th month 767.08 22245.42 60599.58 5th month 767.08 49860.42 32984.58 5th month 767.08 77475.42 5369.586th month 767.08 23012.50 59832.50 6th month 767.08 50627.50 32217.50 6th month 767.08 78242.50 4602.507th month 767.08 23779.58 59065.42 7th month 767.08 51394.58 31450.42 7th month 767.08 79009.58 3835.428th month 767.08 24546.67 58298.33 8th month 767.08 52161.67 30683.33 8th month 767.08 79776.67 3068.339th month 767.08 25313.75 57531.25 9th month 767.08 52928.75 29916.25 9th month 767.08 80543.75 2301.2510th month 767.08 26080.83 56764.17 10th month 767.08 53695.83 29149.17 10th month 767.08 81310.83 1534.1711th month 767.08 26847.92 55997.08 11th month 767.08 54462.92 28382.08 11th month 767.08 82077.92 767.0812th month 767.08 27615.00 55230.00 12th month 767.08 55230.00 27615.00 12th month 767.08 82845.00 0.00

Anda hanya perlu isikan angka yang berwarna kuning sahaja (harga kereta, pinjaman, interest dan tahun) dan jumlah yang lain akan dikira secara automatik.

Monthly pay

Monthly pay

Monthly pay

Monthly pay

Monthly pay

Monthly pay

Monthly pay

Monthly pay

Monthly pay