Ask Experts Questions for FREE Help!
 

Free Answers in 3 Easy Steps

Register Now
3 Steps
 


Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  Answer this Question    Ask about Finance & Accounting    Ask about another Subject  
 

elhing
Apr 4, 2009, 11:32 PM
I am practising for my midsem exam tomorrow and having problems with one question which says to find out the years of the loan taken out.

Loan - 100,000
Interest Rate - 12% compounded quarterly
Quarterly repayments are - $5904.74

i have tried doing the problem but I am confused as to which formula to use..

PLEASE HELP...

ROLCAM
Apr 5, 2009, 04:23 AM
The answer is 6 years.

Loan - 100,000
Interest Rate - 12% compounded quarterly
Quarterly repayments are - $5904.74

1 100,000.00 103,000.00 5,904.74 97,095.26
2 97,095.26 100,008.12 5,904.74 94,103.38
3 94,103.38 96,926.48 5,904.74 91,021.74
4 91,021.74 93,752.39 5,904.74 87,847.65
5 87,847.65 90,483.08 5,904.74 84,578.34
6 84,578.34 87,115.69 5,904.74 81,210.95
7 81,210.95 83,647.28 5,904.74 77,742.54
8 77,742.54 80,074.82 5,904.74 74,170.08
9 74,170.08 76,395.18 5,904.74 70,490.44
10 70,490.44 72,605.15 5,904.74 66,700.41
11 66,700.41 68,701.42 5,904.74 62,796.68
12 62,796.68 64,680.58 5,904.74 58,775.84
13 58,775.84 60,539.12 5,904.74 54,634.38
14 54,634.38 56,273.41 5,904.74 50,368.67
15 50,368.67 51,879.73 5,904.74 45,974.99
16 45,974.99 47,354.24 5,904.74 41,449.50
17 41,449.50 42,692.99 5,904.74 36,788.25
18 36,788.25 37,891.89 5,904.74 31,987.15
19 31,987.15 32,946.77 5,904.74 27,042.03
20 27,042.03 27,853.29 5,904.74 21,948.55
21 21,948.55 22,607.00 5,904.74 16,702.26
22 16,702.26 17,203.33 5,904.74 11,298.59
23 11,298.59 11,637.55 5,904.74 5,732.81
24 5,732.81 5,904.79 5,904.74 0.05