Spreadsheet Assignment #1 - Finance 367

Spreadsheet Assignment #1 - Finance 367 - DustinJohnston...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Dustin Johnston FIN 367 Spreadsheet Assignment 1 1)  a.  N = 10 I = 6.00% PV = ($5,500.00) PMT = 0 FV= $9,849.66  b. N = 40 I = 1.50% PV = ($5,500.00) PMT = 0 FV= $9,977.10  2) a. N = 5 I = 7.00% PV = $41,001.97  PMT = ($10,000.00) FV= $0.00  b. N = 5 I = 7.00% PV = $43,872.11  PMT = ($10,000.00) FV= $0.00  3) a. N = 11 I = 5% PV = ($400.00) PMT = 0 FV= $684.00  b. N = 4 I = 8% PV = ($183.00) PMT = 0 FV= $249.00  c. N = 7 I = 0% PV = ($300.00) PMT = 0 FV= $300.00 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Loan Amortization Schedule Enter values Loan summary Loan amount  $250,000.00  Scheduled payment  $4,694.94  Annual interest rate 4.80 %  Scheduled number of payments 60  Loan period in years Actual number of payments 60  Number of payments per year 12  Total early payments  $-    Start date of loan 1/1/2009 Total interest  $31,696.13  Optional extra payments Lender name: Payment Date Beginning Balance Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest 1 2/1/2009  $250,000.00   $4,694.94   $-     $4,694.94   $3,694.94   $1,000.00   $246,305.06   $1,000.00  2 3/1/2009  $246,305.06   $4,694.94   $-     $4,694.94   $3,709.72   $985.22   $242,595.35   $1,985.22  3 4/1/2009  $242,595.35   $4,694.94   $-     $4,694.94   $3,724.55   $970.38   $238,870.80   $2,955.60  4 5/1/2009  $238,870.80   $4,694.94   $-     $4,694.94   $3,739.45   $955.48   $235,131.34   $3,911.08  5 6/1/2009  $235,131.34   $4,694.94   $-     $4,694.94   $3,754.41   $940.53   $231,376.93   $4,851.61  6 7/1/2009  $231,376.93   $4,694.94   $-     $4,694.94   $3,769.43   $925.51   $227,607.50   $5,777.12  7 8/1/2009  $227,607.50   $4,694.94   $-     $4,694.94   $3,784.51   $910.43   $223,823.00   $6,687.55  8 9/1/2009  $223,823.00   $4,694.94   $-     $4,694.94   $3,799.64   $895.29   $220,023.36   $7,582.84  9 10/1/2009  $220,023.36   $4,694.94   $-     $4,694.94   $3,814.84   $880.09   $216,208.51   $8,462.93  10 11/1/2009  $216,208.51   $4,694.94   $-     $4,694.94   $3,830.10   $864.83   $212,378.41   $9,327.77  11 12/1/2009  $212,378.41   $4,694.94   $-     $4,694.94   $3,845.42   $849.51   $208,532.99   $10,177.28  12 1/1/2010  $208,532.99   $4,694.94   $-     $4,694.94   $3,860.80   $834.13   $204,672.19   $11,011.41  13 2/1/2010  $204,672.19   $4,694.94   $-     $4,694.94   $3,876.25   $818.69   $200,795.94   $11,830.10  14 3/1/2010  $200,795.94   $4,694.94   $-     $4,694.94   $3,891.75   $803.18   $196,904.19   $12,633.29  15 4/1/2010  $196,904.19   $4,694.94   $-     $4,694.94   $3,907.32   $787.62   $192,996.87   $13,420.90  16 5/1/2010  $192,996.87   $4,694.94   $-     $4,694.94   $3,922.95   $771.99   $189,073.92   $14,192.89 
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

Spreadsheet Assignment #1 - Finance 367 - DustinJohnston...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online