LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How much to borrow for a 401(k) loan

Hi,

I'm finding this challenge, well, challenging...I want to borrow funds from
my 401(k), and the basic parameters a

1) interest rate is 7%

2) loan period is 5 years

3) payments are monthly

I have the option to pay it off early, and I plan on doing so in 3 years.
The catch is that I want to borrow an amount that covers all of my payments
during the 3 years, so that I have no out-of-pocket payments during that
time.

For example, I need $10,000 to do some house remodelling. So, I actually
need to borrow something like $13,000...$10,000 for the house, and $3,000 to
cover three years' worth of payments on a 5-year $13,000 loan.

Any ideas on a formula for this (so that I can play around with the loan
amount)?

Thanks!

Dan
Colorado


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
loan amortization loan in months weisse Excel Worksheet Functions 5 November 7th 07 12:43 AM
Loan Estimator AL Excel Worksheet Functions 0 September 18th 07 10:12 PM
loan amortization template with loan start date AND first payment Lisa W Excel Discussion (Misc queries) 0 January 30th 06 10:27 PM
Loan amortization Michelle - ecowtent Excel Worksheet Functions 1 April 8th 05 06:15 PM
How do you set up a loan using the loan calculator w/odd payments. rad Excel Discussion (Misc queries) 0 February 3rd 05 06:05 PM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"