farmerjohn1324
New member
- Joined
- Mar 23, 2015
- Messages
- 16
[(aw)(h)]+[[a(1-w)+c]*(g)] = x
?
?
Last edited:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Can anyone solve for "a"?
- Thread starter farmerjohn1324
- Start date
D
Deleted member 4993
Guest
[(aw)(h)]+[[a(1-w)+c]*(g)] = x
?
Yes we can .... but what did you try?
What are your thoughts?
Please share your work with us ...even if you know it is wrong
If you are stuck at the beginning tell us and we'll start with the definitions.
You need to read the rules of this forum. Please read the post titled "Read before Posting" at the following URL:
http://www.freemathhelp.com/forum/th...Before-Posting
farmerjohn1324
New member
- Joined
- Mar 23, 2015
- Messages
- 16
stuck
I got stuck trying to factor the "a" out of the right side where it is next to the (1-w)
I am no longer in school. I am quite out of practice with this. I haven't done problems like this in years.
I can think of no way to isolate the "a" on this. I know about factoring, but I don't know how I would do that in this case.
=(F7*0.2)*((((G$4/12)*(1+(G$4/12))^G$3))/(((1+(G$4/12))^G$3)-1))
=((F8*0.8)+10000)*((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))
But, it was simplified from something that looked like that... so I have done quite a bit of work on it. It's for an MS Excel spreadsheet. These formulas represent "h" and "g" in the formula I put in. I don't think getting into every detail is entirely necessary. I've simplified everything to that equation I put up top.... and I don't know how to solve for "a."
Yes we can .... but what did you try?
What are your thoughts?
Please share your work with us ...even if you know it is wrong
If you are stuck at the beginning tell us and we'll start with the definitions.
You need to read the rules of this forum. Please read the post titled "Read before Posting" at the following URL:
http://www.freemathhelp.com/forum/th...Before-Posting
I got stuck trying to factor the "a" out of the right side where it is next to the (1-w)
I am no longer in school. I am quite out of practice with this. I haven't done problems like this in years.
I can think of no way to isolate the "a" on this. I know about factoring, but I don't know how I would do that in this case.
=(F7*0.2)*((((G$4/12)*(1+(G$4/12))^G$3))/(((1+(G$4/12))^G$3)-1))
=((F8*0.8)+10000)*((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))
But, it was simplified from something that looked like that... so I have done quite a bit of work on it. It's for an MS Excel spreadsheet. These formulas represent "h" and "g" in the formula I put in. I don't think getting into every detail is entirely necessary. I've simplified everything to that equation I put up top.... and I don't know how to solve for "a."
Last edited:
farmerjohn1324
New member
- Joined
- Mar 23, 2015
- Messages
- 16
rates...
Don't worry about getting back to me on the other post. This was a different way of asking the same question.
=((F6*0.8)+10000)*((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))
... this is my formula for using the 4.5% rate over 240 months to figure out the loan.
Maybe it is because 20% of the loan (the down payment) is financed by a 10.75% personal loan over 84 months? Could that account for the difference that you are seeing?
F6 = the loan amount (0.8 because 20% is financed by a down payment).
H4 = .045 (4.5%)
H3 = 240 (months)
awh + ag(1-w) + gc = x
a[wh + g(1-w)] = x - gc
a = (x - gc) / [wh + g(1-w)]
NOTE:
I'll get back to you on your other post a bit later.
In the meantime, CHECK what you have on the
com. loan portion: I can see that the rate (4.5%)
is either wrong, OR there is something else
affecting the payment calculation, maybe "tax"
added on or the likes...anyway, the resulting
payments shown in your attachment are higher
than called for at 4.5%: they're actually the
result of a 4.98% rate.
Don't worry about getting back to me on the other post. This was a different way of asking the same question.
=((F6*0.8)+10000)*((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))
... this is my formula for using the 4.5% rate over 240 months to figure out the loan.
Maybe it is because 20% of the loan (the down payment) is financed by a 10.75% personal loan over 84 months? Could that account for the difference that you are seeing?
F6 = the loan amount (0.8 because 20% is financed by a down payment).
H4 = .045 (4.5%)
H3 = 240 (months)
farmerjohn1324
New member
- Joined
- Mar 23, 2015
- Messages
- 16
formula....
Absolutely perfect. Thank you.
This is the resulting formula is the spreadsheet...
=(I21-((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))*(I4))/((I3)*((((G$4/12)*(1+(G$4/12))^G$3))/(((1+(G$4/12))^G$3)-1))+((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))*(1-(I3)))
... you can see how this stuff gets complicated?
Did the fact that 20% of the loan was at 10.75% over 84 months account for the difference in percentage?
awh + ag(1-w) + gc = x
a[wh + g(1-w)] = x - gc
a = (x - gc) / [wh + g(1-w)]
NOTE:
I'll get back to you on your other post a bit later.
In the meantime, CHECK what you have on the
com. loan portion: I can see that the rate (4.5%)
is either wrong, OR there is something else
affecting the payment calculation, maybe "tax"
added on or the likes...anyway, the resulting
payments shown in your attachment are higher
than called for at 4.5%: they're actually the
result of a 4.98% rate.
Absolutely perfect. Thank you.
This is the resulting formula is the spreadsheet...
=(I21-((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))*(I4))/((I3)*((((G$4/12)*(1+(G$4/12))^G$3))/(((1+(G$4/12))^G$3)-1))+((((H$4/12)*(1+(H$4/12))^(H$3)))/(((1+(H$4/12))^(H$3))-1))*(1-(I3)))
... you can see how this stuff gets complicated?
Did the fact that 20% of the loan was at 10.75% over 84 months account for the difference in percentage?
Last edited: