Embed
Email

Spreadsheet

Document Sample
Spreadsheet
Shared by: HC111207052352
Categories
Tags
Stats
views:
7
posted:
12/6/2011
language:
pages:
3
Manchester Unity Credit Union Limited

Loan Repayment Terms

(weekly) 1.00

monthly interest rate on reducing balance, % 23.00%



Monthly Payments Loan Amount, £ APR = 12.7 %

You can change yellow cells 10 25 50 100 200 500 1000 2000 4000 6000 7500

3 3.40 8.50 17.00 34.00 68.00 170.01 340.02 680.04 1360.09 2040.13 2550.17

6 1.73 4.31 8.63 17.25 34.51 86.27 172.55 345.10 690.19 1035.29 1294.11

9 1.17 2.92 5.84 11.67 23.35 58.37 116.74 233.48 466.96 700.44 875.55

months

No. of



12 0.89 2.22 4.44 8.88 17.77 44.42 88.85 177.70 355.40 533.09 666.37

15 0.72 1.80 3.61 7.21 14.42 36.06 72.12 144.25 288.50 432.74 540.93

18 0.61 1.52 3.05 6.10 12.20 30.49 60.98 121.96 243.93 365.89 457.37

24 0.47 1.18 2.35 4.71 9.41 23.54 47.07 94.15 188.29 282.44 353.05

30 0.39 0.97 1.94 3.87 7.75 19.37 38.75 77.50 154.99 232.49 290.61

36 0.33 0.83 1.66 3.32 6.64 16.61 33.21 66.43 132.86 199.29 249.11

48 0.26 0.66 1.32 2.63 5.27 13.17 26.33 52.67 105.34 158.00 197.50

Weekly Payments Loan Amount, £ APR = 12.7 %

You can change yellow cells 10 25 50 100 200 500 1000 2000 4000 6000 7500

12 0.85 2.11 4.23 8.46 16.92 42.29 84.58 169.17 338.34 507.51 634.38

16 0.64 1.59 3.19 6.37 12.75 31.86 63.73 127.46 254.92 382.37 477.97

26 0.40 0.99 1.98 3.97 7.93 19.83 39.67 79.33 158.67 238.00 297.50

40 0.26 0.65 1.31 2.62 5.24 13.10 26.20 52.39 104.78 157.18 196.47

weeks

No. of









50 0.21 0.53 1.06 2.12 4.24 10.60 21.19 42.39 84.78 127.17 158.96

52 0.20 0.51 1.02 2.04 4.09 10.21 20.43 40.85 81.70 122.55 153.19

70 0.15 0.39 0.77 1.55 3.10 7.74 15.48 30.97 61.93 92.90 116.12

80 0.14 0.34 0.68 1.37 2.74 6.85 13.70 27.40 54.80 82.20 102.75

100 0.11 0.28 0.56 1.12 2.24 5.60 11.21 22.41 44.82 67.23 84.04

150 0.08 0.20 0.39 0.79 1.58 3.95 7.89 15.78 31.56 47.34 59.18

200 0.06 0.16 0.31 0.62 1.25 3.12 6.24 12.49 24.97 37.46 46.83

Notes…

1 These figures are true (to nearest p) only if all repayments are made on time.

2 Members add a small amount to each repayment, to add to their savings, minimum £5.00 pm

3 Loans include insurance (subject to conditions) at no direct cost to members.

4 There is no penalty for paying back loans faster or sooner than promised. It's encouraged!

5 For other amounts and these periods, add the repayments: eg £550 over 15 months,

repayment due is £36.06 + £3.61, total £39.67. Or use this spreadsheet!

6 For other amounts and/or other periods, ask the Administrator. Or use this spreadsheet!

7 All loans are offered in accordance with the laws and policies for the time being in force.

Briefly, member's 1st. loan max 5x savings, thereafter 10x savings, 'top-ups' available when

df8c6e6b-5b6e-4c57-a054-3be3473369aa.xls

loan > 50%cleared, maximum loan considered = £7,500, maximum normal term = 4 years.

Manchester Unity Credit Union Limited

Loan Repayment Terms

monthly interest rate on reducing balance, % 1.00

(weekly) 23.00%



M onthly Payments Loan Amount, £ APR = 12.7 %

You can change yellow cells 10 25 50 100 200 500 1000 2000 4000 6000 7500

3 3.40 8.50 17.00 34.00 68.00 170.01 340.02 680.04 1360.09 2040.13 2550.17

6 1.73 4.31 8.63 17.25 34.51 86.27 172.55 345.10 690.19 1035.29 1294.11

9 1.17 2.92 5.84 11.67 23.35 58.37 116.74 233.48 466.96 700.44 875.55

months

No. of









12 0.89 2.22 4.44 8.88 17.77 44.42 88.85 177.70 355.40 533.09 666.37

15 0.72 1.80 3.61 7.21 14.42 36.06 72.12 144.25 288.50 432.74 540.93

18 0.61 1.52 3.05 6.10 12.20 30.49 60.98 121.96 243.93 365.89 457.37

24 0.47 1.18 2.35 4.71 9.41 23.54 47.07 94.15 188.29 282.44 353.05

30 0.39 0.97 1.94 3.87 7.75 19.37 38.75 77.50 154.99 232.49 290.61

36 0.33 0.83 1.66 3.32 6.64 16.61 33.21 66.43 132.86 199.29 249.11

48 0.26 0.66 1.32 2.63 5.27 13.17 26.33 52.67 105.34 158.00 197.50



Weekly Payments Loan Amount, £ APR = 12.7 %

You can change yellow cells 10 25 50 100 200 500 1000 2000 4000 6000 7500

12 0.85 2.11 4.23 8.46 16.92 42.29 84.58 169.17 338.34 507.51 634.38

16 0.64 1.59 3.19 6.37 12.75 31.86 63.73 127.46 254.92 382.37 477.97

26 0.40 0.99 1.98 3.97 7.93 19.83 39.67 79.33 158.67 238.00 297.50

40 0.26 0.65 1.31 2.62 5.24 13.10 26.20 52.39 104.78 157.18 196.47

weeks

No. of









50 0.21 0.53 1.06 2.12 4.24 10.60 21.19 42.39 84.78 127.17 158.96

52 0.20 0.51 1.02 2.04 4.09 10.21 20.43 40.85 81.70 122.55 153.19

70 0.15 0.39 0.77 1.55 3.10 7.74 15.48 30.97 61.93 92.90 116.12

80 0.14 0.34 0.68 1.37 2.74 6.85 13.70 27.40 54.80 82.20 102.75

100 0.11 0.28 0.56 1.12 2.24 5.60 11.21 22.41 44.82 67.23 84.04

150 0.08 0.20 0.39 0.79 1.58 3.95 7.89 15.78 31.56 47.34 59.18

200 0.06 0.16 0.31 0.62 1.25 3.12 6.24 12.49 24.97 37.46 46.83



Notes…

1 These figures are true (to nearest p) only if all repayments are made on time.

2 Members add a small amount to each repayment, to add to their savings, minimum £5.00

3 Loans include insurance (subject to conditions) at no direct cost to members.

4 There is no penalty for paying back loans faster or sooner than promised. It's encourage

5 For other amounts and these periods, add the repayments: eg £550 over 15 months,

repayment due is £36.06 + £3.61, total £39.67. Or use this spreadsheet!

6 For other amounts and/or other periods, ask the Administrator. Or use this spreadshee

7 All loans are offered in accordance with the laws and policies for the time being in force

Briefly, member's 1st. loan max 5x savings, thereafter 10x savings, 'top-ups' available wh

loan > 50%cleared, maximum loan considered = £7,500, maximum normal term = 4 yea

mited

ment Terms

balance, % 1.00

(weekly) 23.00%

APR = 12.7 %

00 6000 7500

0.09 2040.13 2550.17

19 1035.29 1294.11

96 700.44 875.55

40 533.09 666.37

50 432.74 540.93

93 365.89 457.37

29 282.44 353.05

99 232.49 290.61

86 199.29 249.11

34 158.00 197.50

APR = 12.7 %

00 6000 7500

34 507.51 634.38

92 382.37 477.97

67 238.00 297.50

78 157.18 196.47

78 127.17 158.96

70 122.55 153.19

93 92.90 116.12

80 82.20 102.75

82 67.23 84.04

56 47.34 59.18

97 37.46 46.83





are made on time.

o their savings, minimum £5.00 pm

st to members.

r than promised. It's encouraged!

eg £550 over 15 months,

s spreadsheet!

ator. Or use this spreadsheet!

cies for the time being in force.

savings, 'top-ups' available when

maximum normal term = 4 years.


Related docs
Other docs by HC111207052352
AOASM 24th Annual Clinical Conference
Views: 0  |  Downloads: 0
Psychology 101A, Spring 2006
Views: 3  |  Downloads: 0
auditory processing
Views: 1  |  Downloads: 0
Practitioner Self Referral Act
Views: 0  |  Downloads: 0
Cabinet Minutes
Views: 0  |  Downloads: 0
SELBY DISTRICT COUNCIL
Views: 15  |  Downloads: 0
SML Personal Finance Application family
Views: 0  |  Downloads: 0
Dressage Results 6th December 2009
Views: 0  |  Downloads: 0
Dr. William Robertson
Views: 1  |  Downloads: 0
Edward Town Middle School
Views: 1  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!