FIN
posted by HELP .
After 12 months of making extra payments, what will be the loan balance? After 12 months of making the regular
payment and investing the $50, what will be the loan balance?
Under the regular payment and investing option, excluding the tax due on the interest earned, what is the investment balance after 12 months? Compare the scenarios of investment versus prepayment by examining the 60th payment, which occurs at the end of the fifth year. What is the difference between the (a) interest portion of that payment, (b) tax deduction for interest, and (c) principal balance? Finally, how much is in the investment account? (a) How long does it take to repay the entire loan under the prepayment option? (b) What is the total interest paid over the life of the loan? Compare the total interest paid under each scenario? How much less in interest do you pay under the prepayment option?
Loan Balance: $135000
Current Payment: $990.62
Additional Payment: $50.00
Loan Interest Rate: 8.0%
Loan Interest Deductibility: YES
Investment Rate Return: 6.00%*
Tax Bracket: 30.00%
Investment Type: AfterTax

FIN 
economyst
An EXCEL spreadsheet is very helpful for these types of problems. Just set it up. eg., the balance formula (no extra payments) is: B1 = (B0P)*(1+.08/12)
Respond to this Question
Similar Questions

math
fixed installment loan of $13,500 with 60 months to pay back, monthly payments of $280.24. instead of making 36th payment, pays remaining balance on loan. how much interest saved? 
math
A farmer buys a new tractor for $38,000. He makes a down payment of $10,000 and finances the balance at 8.5% APR over 48 months. Before making the 12th payment, the farmer decides to pay the remaining balance on the loan. How much … 
Math questions
1. Shawn Fitzgerald finds a suitable property and agrees upon a selling price of $137,900. The mortgage company requires a 20% down payment and Shawn chooses to finance the property for 30 years at 8%. What is the total amount of interest … 
math
1. Shawn Fitzgerald finds a suitable property and agrees upon a selling price of $137,900. The mortgage company requires a 20% down payment and Shawn chooses to finance the property for 30 years at 8%. What is the total amount of interest … 
Math Question
Tom Newman took out a simple interest loan of $1,500.00 at 10 percent interest for 12 months. after 4 payments the balance is 1,100. he pays off the loan when the next payment is due what is the interest? 
math
Tim Newman took out a simple interest loan of $1500 at a 10 percent interest for 12 months. After 4 payments, the balance is $1100. He pays off the loan when the next payment is due. What is the interest? 
MathPlease help!!
Tim Newman took out a simple interest loan of $1500 at a 10 percent interest for 12 months. After 4 payments, the balance is $1100. He pays off the loan when the next payment is due. What is the interest? 
Finance
Could someone tell me how to calculate this in excel? 
business finance
Stacy took out a loan for $15,000. Her note was for 300 days at 5% ordinary interest. On day 100 she made a partial payment of $5,000. On day 200 she made a second payment of $5,000. On day 250 she made yet a third payment of $2,500. … 
Math (Problem Solving)
Sasha took in a car loan with a maturity of 5 years in which the first payment was on December 2016. Right after paying the first month on December 15, she made an advance payment for two (2) months and he intends to pay extra month …