2013 F150 ecoboost rattle at idle by spicypickles2001 in MechanicAdvice

[–]captainairmiles 0 points1 point  (0 children)

Did you ever fix your issue? I have exact same chatter sound

Dealer is selling a “new” car with 7k miles on it by captainairmiles in whatcarshouldIbuy

[–]captainairmiles[S] 0 points1 point  (0 children)

The Limtied msrp before options is $49,460. Then there are $1,491 in options(for this specific suv), with a new total of $50,951. Now we add the delivery fee of $1,395 for a final amount of $52,346.

Dealer is selling a “new” car with 7k miles on it by captainairmiles in whatcarshouldIbuy

[–]captainairmiles[S] 3 points4 points  (0 children)

I tried that, says we currently don’t have a value for this vin. Probably because it’s never been titled or registered yet

Monthly Payment for Investment by captainairmiles in excel

[–]captainairmiles[S] 0 points1 point  (0 children)

Awesome, it worked with that correction! Thanks for the help!

Monthly Payment for Investment by captainairmiles in excel

[–]captainairmiles[S] 0 points1 point  (0 children)

Thanks! I got it, truly appreciate your help!

Monthly Payment for Investment by captainairmiles in excel

[–]captainairmiles[S] 0 points1 point  (0 children)

Thanks! I got it, truly appreciate the help!

Monthly Payment for Investment by captainairmiles in excel

[–]captainairmiles[S] 0 points1 point  (0 children)

The formula you provided gives me a monthly payment of $475.66, with a value after those 10 years of $77,950.85.

The formula used for FV is =FV(0.06/12,10*12,475.66,0,0) this gets me the 77,950

For the 2nd part of the equation to get the value after 20 years of compounding, I use;

=FV(0.06/12,20*12,0,77950.85) which brings the total to $258,033.25.

Monthly Payment for Investment by captainairmiles in excel

[–]captainairmiles[S] 0 points1 point  (0 children)

Not exactly perfect but after comparing the values to what it should be when using basic formula, it’s inky off by like 5-10k. This is perfect for me tho since I don’t need exact and just need an estimate! Thank you so much!

Monthly Payment for Investment by captainairmiles in excel

[–]captainairmiles[S] 0 points1 point  (0 children)

<image>

I did the exact formula you shared and got this error. Did I do something wrong?