Using excel to explain amortization table
29
Years | Beginning Balance=30000 | PMT =PMT(6%,3,-30000) | Interest part of PMT | Principal part of PMT= PMT-Interest | Ending Balance |
1.00 | 30000.00 | 11223.29 | 1800.00 | 9423.29 | 20576.71 |
2.00 | 20576.71 | 11223.29 | 1234.60 | 9988.69 | 10588.01 |
3.00 | 10588.01 | 11223.29 | 635.28 | 10588.01 | 0.00 |
30.PV =1000
Rate =10%
Number of Years =500/365
FV =PV*e^(rt)=1000*e^(10%*500/365) =1146.81
29. Your firm just acquired a bank loan in the amount of $20.000 at 6% APR....
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
Total Loan amount: The total mortgage loan amount is the amount you borrow after paying your down payment. Here, we assumed that you would pay 20% of the home value (property value) as a down payment. 2. Months: The mortgage payment period is set to 30 years. In terms of months, this is equivalent to 30 years multiplied by 12 months. We put our primary basis of payments in terms of months, which is why we need to convert everything...
I need help on question 2.
MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
5. Find the two roots of each of the following functions (that is find the two X values that make Y = 0). This skill may be useful in assignment 11. EXAMPLE: Y = 3X2 -11X +6 is the product of (3X -2)(X -3). If you let Y = 3X-2 then X = 2/3 will make Y = 0. If you let Y = X-3 then X = 3 will make Y = 0. Thus both X = 2/3 and X = 3 are roots. Show the algebra...