Assignment # 1 MTH302 (Spring 2011) New and final April 06

[sana.pari]

oh ho ab ms excel per kia karna hai...???????

[crpshoaib]

Hi,

Just to know how it works on Excel. I don't have much command on Excel, so u got me.

Thanks,

Muhammad

[sana.pari]

oright. what do u do???????????? that u don't have time.

[crpshoaib]

Doing government job, working as Assistant Director Urban Planning in Multan Development Authority and enrolled in MBA at VU. N u?

[sana.pari]

is it Mba. Ex?

[crpshoaib]

Nopes simple MBA, joined in Spring 2010 but didn't continue. Now I got readmission, but will finish in 2 years, inshaAllah.

[sana.pari]

ic u r lucky person..

[crpshoaib]

Thank you.

[sana.pari]

you are welcome. So u r off tomorrow....

[crpshoaib]

Interest rate/annum i =7%
Interest rate/month i =7/12% = 0.005833

Amount C =Rs. 8450
Number of years N =17
Number of periods n =17*12 = 204
Present Value (loan) PV =?

Using Formula mentioned in the book for Ordinary Annuity


Putting Values PV=8450(1-(1+0.005833)^-204)/0.005833
PV =8450(1-(1.005833)^-204)/0.005833
PV =8450(1-0.3053)/0.005833
PV =8450(0.6947/0.005833)
PV =8450*119.098
PV =Rs. 1006380