BREAKING: Target Test Prep releases Brand New 2026 On Demand GMAT prep course

Redeem
TTP OnDemand GMAT Video Course
Featured Course

Target Test Prep GMAT OnDemand

Scott Woodbury-Stewart’s private virtual classroom — 400 hours of master-class video lessons for the GMAT Focus Edition.

  • 715+ score guarantee — highest in the industry (99th percentile)
  • 52 chapters · 1,500+ lessons · 4,000+ practice questions
  • 400 hours of video · 1,500+ instructor-led HD smartboard lessons
  • 300,000+ students accepted to Harvard, Stanford, Wharton, Booth & Sloan & more
  • 24/7 live support + weekly Zoom office hours with GMAT instructors
  • TTP AI Assist — 24/7 AI-powered virtual tutor for instant help
  • 1,200+ flashcards + AI-powered study assistant & daily calendar
  • OnDemand, LiveTeach & GMAT Bootcamp formats available
  • Also: GRE, SAT Math & Executive Assessment courses
  • MBA Admissions Consulting now available
  • 🏆 2025 EdTech Breakthrough Award: Test Prep Solution Provider of the Year
  • 200,000+ students served
  • 5-day free trial — $0 to start, no auto-billing, cancel anytime
★★★★★ 5.0 (559 reviews)
130-pt guarantee
$0 to start then $127/mo
Start Free 5-Day Trial Read 559 Reviews →

IRR calculation help

Expert replies
Post new topic Post Reply
Previous Topic Next Topic
Newbie | Next Rank: 10 Posts
Posts: 2
Joined: Tue Nov 22, 2011 3:52 am
by musicfreak007 » Tue Nov 22, 2011 4:16 am
Guys I am trying to get my basics right in maths. please find a simple question below:

X lends Y a sum of INR 100000 at an interest rate of 16.25% (reducing) for a period of 3 years which he expects to be paid back in 36 equal installment. At the same time X takes a deposit of INR 12500 from Y at an interest rate of 8%(reducing) for which Y expects to be paid back in 36 equal installment. The processing fee charged by X is INR 750 (being taken upfront). How much annual IRR is the X making from the whole transaction?

Kindly help me solving this on excel as well.

Many thanks
A
Top
Join the discussion
Log in to postLogin with Googleuse password
QUOTE IN REPLY
Source: — Problem Solving |
Master | Next Rank: 500 Posts
Posts: 385
Joined: Fri Sep 23, 2011 9:02 pmFollowed by: 6 members
Thanked: 62 times

by user123321 » Tue Nov 22, 2011 6:56 am
musicfreak007 wrote:Guys I am trying to get my basics right in maths. please find a simple question below:

X lends Y a sum of INR 100000 at an interest rate of 16.25% (reducing) for a period of 3 years which he expects to be paid back in 36 equal installment. At the same time X takes a deposit of INR 12500 from Y at an interest rate of 8%(reducing) for which Y expects to be paid back in 36 equal installment. The processing fee charged by X is INR 750 (being taken upfront). How much annual IRR is the X making from the whole transaction?

Kindly help me solving this on excel as well.

Many thanks
A
is it 44,666 INR ??
please provide the choices.

user123321
Just started my preparation :D
Want to do it right the first time.
Top
Join the discussion
Log in to postLogin with Googleuse password
QUOTE IN REPLY
Junior | Next Rank: 30 Posts
Posts: 20
Joined: Sun Apr 17, 2011 7:16 amFollowed by: 1 member

by chaitanyabhansali » Tue Nov 22, 2011 9:25 am
45ooo?
Answer please..!
Top
Join the discussion
Log in to postLogin with Googleuse password
QUOTE IN REPLY
Newbie | Next Rank: 10 Posts
Posts: 2
Joined: Tue Nov 22, 2011 3:52 am

by musicfreak007 » Tue Nov 22, 2011 11:37 pm
Can you help me with the calculations you did to arrive to this answer. Sorry I dont have any answer. Would much appreciate if the mentors/ experts out here can throw some light.
Thanks
Top
Join the discussion
Log in to postLogin with Googleuse password
QUOTE IN REPLY
Post new topic Post Reply
• Page 1 of 1