Reference no: EM131128812
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. 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
b) If there is no extra payment, how much more interest payments John would save if the original loan term is 24 month instead of 48 month.
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 Use functions such as Vlookup , 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) 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.
|
What is the resonant frequency of the circuit
: What would be the resonant frequency if the inductor resistance were reduced to 40 Ω?
|
|
Company uses five types of rocks to fill four orders
: A rock company uses five types of rocks to fill four orders. The phosphate content, availability of each type of rock, and the production cost per pound for each rock are listed below, as well as the size of each order and the minimum and maximum ..
|
|
Calculate the keq
: Calculate the Keq for this reaction at 25°C. - Does this reaction move forward (from left to right) or backward under standard state conditions? Explain your answer in one sentence.
|
|
What is the importance of a cash flow budget or report
: BSBFIM501 - Manage budgets and financial plans - Accounting QUESTIONS. What is responsibility accounting and what is its importance to an organisation? Discuss in 100 to 120 words? What are cost centres? Discuss in 100 to 120 words. Give examples of..
|
|
Pay his entire principal and interest amount
: 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, plea..
|
|
What is the correlation
: Create and paste in a scatterplot that compares Final Exam Score and Project Score. What is the correlation (r-value)? How would you describe the correlation
|
|
Values and interpretations of slack and surplus variables
: Nooner Appliance Producers (NAP), a small appliance manufacturing company that specializes in clocks, must decide what types and quantities of output to manufacture for each week's sale. What are the values and interpretations of all slack and surplu..
|
|
What are two types of post retirement benefits
: What are two types of post-retirement benefits?
|
|
Which is not primary characteristics ofcommunication
: According to Bevan and Sole, which of the following is not one of the five primary characteristics ofcommunication?
|