Returns correct loan amortization schedule

Assignment Help Financial Management

Reference no: EM131949787

Today, John borrowed $40,000 from the bank. His initial plan is to pay his entire principal and interest amount in 48 months. He plans to pay some extra payment for the first year to pay off the debt earlier. As an excel programming trainer, please do the following requirements:

a. If He plans to make extra payment of $600 every month. Write a flexible program that returns the correct loan amortization schedule (including month, interest, payment, repayment of principal and remaining balance) and the correct output section for any change in items in input section.

b. You need to roundup the actual loan period sine partial period does not make sense. You have to use the if statement and the program should be flexible with respect to all variables in the input section .

c. John needs to find out when it is the first time the remaining balance hit below $10,000, so he may exercise the option to prepay off the rest of the loan. You need to use the excel function such as Vlookup , Index, Match, or IF to solve this question. You are allowed to create additional column to assist your problem solvoing. But you can not manually find out the answer, you still need to make the solution flexible.

d. In a separate excel tab, solve for the following question: If the extra payment $600 starts from month 1 till the end of month 12, please redo the question, find out the actual loan payment, and the first time your balance hit below $10,000.

Reference no: EM131949787

Questions Cloud

Revisit some of the major incidents of ethical misbehavior : Use the Scandalous 2000’s discussion thread to revisit some of the major incidents of ethical misbehavior that impacted the financial market sector.

What is the net present value for the project : Bring It On Home, Inc. is considering a new 4-year expansion project that requires an initial fixed asset investment of $3.53 million.

Addition to standard business and financial risk : However, there are challenges that businesses face when exposed to foreign exchange risk in addition to standard business and financial risk.

What should the bond sell for : Your broker offers to sell for $1150 a AAA rated bond with a coupon rate of 6% and a maturity of 8 years. Given that the interest rate on comparable debt is 4%.

Returns correct loan amortization schedule : Write a flexible program that returns the correct loan amortization schedule and the correct output section for any change in items in input section.

What is the value of the fund today : Your brother, who is 6 years old, just received a trust fund that will be worth $21,000 when he is 21 years old. If the fund earns 0.11 interest compounded

Compute the three equal payments : Compute the three equal payments.

What annual rate of return is earned : What annual rate of return is earned on a $1,000 investment when it grows to $3,400 in seven years?

Calculate the initial exchange of payments : Calculate the initial exchange of payments that takes place at the beginning of the swap. Calculate the semiannual payments.

User Account

All Pages