Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loan amortization loan in months | Excel Worksheet Functions | |||
Loan Estimator | Excel Worksheet Functions | |||
loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
Loan amortization | Excel Worksheet Functions | |||
How do you set up a loan using the loan calculator w/odd payments. | Excel Discussion (Misc queries) |