I have been solving these all day, but this one has me stumped.

Log is natural (base e) log.

Nov 2, 2002, 5:18 AM

User (378 posts)

Nov 2, 2002, 5:18 AM

Post #4 of 10

Views: 8291

Had a look at it. It looks like it's simple algebra. I'll try to get you the answer tommorow. Can't remember how to get rid of the log base e (ln) off the top of my head My bloody maths lecturer would kill me if he found out I couldn't do that question.

Cheers,

Michael Bray

Cheers,

Michael Bray

Nov 3, 2002, 7:39 AM

Enthusiast (619 posts)

Nov 3, 2002, 7:39 AM

Post #6 of 10

Views: 8240

I don’t think it can be resolved.

The problem here is not being able to use inverse functions with so many variables.

D11 are both in base and exponent.

~ ERASER

Free JavaScripts @ Insight Eye

The problem here is not being able to use inverse functions with so many variables.

D11 are both in base and exponent.

~ ERASER

Free JavaScripts @ Insight Eye

Nov 3, 2002, 2:27 PM

User (378 posts)

Nov 3, 2002, 2:27 PM

Post #8 of 10

Views: 8227

I think that what is going to happen in the solution is that the "-D11" is going to go over onto the left hand side. You'll bring the "D10" across to the right. After doing this, you'll go through some algebra on the right hand side which will enable you to cancel out the Logs on the right which have the "D11"s in them.

Good luck doing it though, it's a bitch of a question :) If you post it on the maths forum at vbforums.com you'll get the answer for sure.

Cheers,

Michael Bray

Good luck doing it though, it's a bitch of a question :) If you post it on the maths forum at vbforums.com you'll get the answer for sure.

Cheers,

Michael Bray

Nov 4, 2002, 9:26 AM

Veteran / Moderator (18436 posts)

Nov 4, 2002, 9:26 AM

Post #9 of 10

Views: 8190

why are you trying to solve this question?

Andy (mod)

andy@ultranerds.co.uk

Want to give me something back for my help? Please see my Amazon Wish List

**GLinks ULTRA Package** | **GLinks ULTRA Package PRO**

**Links SQL Plugins** | **Website Design and SEO** | **UltraNerds** | **ULTRAGLobals Plugin** | **Pre-Made Template Sets** | **FREE GLinks Plugins!**

Andy (mod)

andy@ultranerds.co.uk

Want to give me something back for my help? Please see my Amazon Wish List

Nov 4, 2002, 9:31 AM

Veteran (2577 posts)

Nov 4, 2002, 9:31 AM

Post #10 of 10

Views: 8149

Hi Michael, thanks for the tips!

Andy: For my never ending thirst of knowledge :)

Actually, this is part of it:

Given:

// E9 Principal Amount (in Dollars)

// D11 Payments per Year (12=Monthly, 26=Bi-Weekly, 52=Weekly)

// D12 Published Interest Rate (i.e. 9% = 0.09)

// D13 Times per Year Interest Calculated (12=Normal/US Mortage 2=CDN Mortgage)

Find:

// D10 Amortization Period (in Years i.e. 6 months = 0.5)

I have looked around everywhere and there are many formulas to solve for Payments (D10) and even some which will solve for the Period of the loan (D10). The problem is, they do not take D13 into account (Times per year interest is compounded).

http://www.iuni.com/...tware/web/index.html

Links Plugins

Andy: For my never ending thirst of knowledge :)

Actually, this is part of it:

Given:

// E9 Principal Amount (in Dollars)

// D11 Payments per Year (12=Monthly, 26=Bi-Weekly, 52=Weekly)

// D12 Published Interest Rate (i.e. 9% = 0.09)

// D13 Times per Year Interest Calculated (12=Normal/US Mortage 2=CDN Mortgage)

Find:

// D10 Amortization Period (in Years i.e. 6 months = 0.5)

I have looked around everywhere and there are many formulas to solve for Payments (D10) and even some which will solve for the Period of the loan (D10). The problem is, they do not take D13 into account (Times per year interest is compounded).

http://www.iuni.com/...tware/web/index.html

Links Plugins