Question

In: Statistics and Probability

How to create the graph? Make a graph of the average life vs the contract rate...

How to create the graph? Make a graph of the average life vs the contract rate c, where 0 ? c ? 100% and T=30y. In you submission, show the amortization table for c=5% (and make sure it fits on one page and is annotated)

Solutions

Expert Solution

IN T=30Y , T AND Y ARE UNDEFINED.

1. Steps of making graphs

  1. Open Microsoft Excel. Its app icon resembles a green box with a white "X" on it.
  2. Click Blank workbook. ...
  3. Consider the type of graph you want to make. ...
  4. Add your graph's headers. ...
  5. Add your graph's labels. ...
  6. Enter your graph's data. ...
  7. Select your data. ...
  8. Click the Insert tab.

The average life is the length of time the principal of a debt issue is expected to be outstanding. The average life is an average period before a debt is repaid through amortization or sinking fundpayments.

In an amortization schedule, the percentage of each payment that goes toward interest diminishes a bit with each payment and the percentage that goes toward principal increases.

LETS TAKE AN EXAMPLE OF AMORTIZATION TABLE:-

Month Month 1 Month 2 Month 3
Total Payment $1,266.71 $1,266.71 $1,266.71
Principal $329.21 $330.45 $331.69
Interest $937.50 $936.27 $935.03
Total Interest $937.50 $1,873.77 $2,808.79
Loan Balance $249,670.79 $249,340.34 $249,008.65

Related Solutions

For python: How do I make an y vs x graph where x is from 1...
For python: How do I make an y vs x graph where x is from 1 to 20 and y is x times 7
Long vs. short hedge, how to conduct them? Which contract to use? How many contract should...
Long vs. short hedge, how to conduct them? Which contract to use? How many contract should be used? How to calculate net price received/paid by hedging? Payoff compared to not hedging?
How do I make the series graph
How do I make the series graph
How much money on average will an insurance company make off of a 1-year life insurance...
How much money on average will an insurance company make off of a 1-year life insurance policy worth $50,000, if they charge $800.00 for the policy, and you have a 0.9999 probability of surviving the year?           When I tried solving this, I ended up with $750.72 but the answer key says $795
How to create and provide one original GDP graph?
How to create and provide one original GDP graph?
Order Integrated Rate Law Graph Slope 0 [A] = −kt + [A]0 [A] vs. t -k...
Order Integrated Rate Law Graph Slope 0 [A] = −kt + [A]0 [A] vs. t -k 1 ln[A] = −kt + ln[A]0 ln[A] vs. t -k 2 1/[A] = kt + 1/[A]0 1/[A] vs. t k Part A The reactant concentration in a zero-order reaction was 5.00×10−2M after 115 s and 3.00×10−2M after 325 s. What is the rate constant for this reaction?     K0th = 9.52x10-5 M/s Part B What was the initial reactant concentration for the reaction described in...
compare and contrast slope and average rate of change identify the characteristics of the graph of...
compare and contrast slope and average rate of change identify the characteristics of the graph of a quadratic equation give a real life application of a quadratic function
Create a graph using GeoGebra of x 3 − 3x 2 + 2x. Make sure the...
Create a graph using GeoGebra of x 3 − 3x 2 + 2x. Make sure the graph contains the zeros, maxima, and minima with labels for each. Having a really hard time graphing on this application, an explanation of how to do so would be extremely helpful.
How can I create a graph of these differential equations in Mathcad?
How can I create a graph of these differential equations in Mathcad?
why is the graph of the force vs position not uniform
why is the graph of the force vs position not uniform
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT