finance problem
you have to solve the 7 questions in excel and there is also another file attached for hints to its answers
2 years ago 20
financae2.docx
finance2hints.xlsx
financae2.docx
HW Problems - Chapter 4
image1.png
image2.png
image3.png
image4.png
image5.png
image6.png
finance2hints.xlsx
Sheet1
| Hints to Chapter 4 Problems (Similar Problems) | ||||||
| 4-5 | FV | Nper | Rate | PV | ||
| 1000 | 10 | 5% | annual | $613.91 | ||
| 1000 | 10 | 10% | annual | $385.54 | ||
| 4-7 | FV | Nper | Rate | # of compounding | PV | |
| 3000 | 5 | 8% | 1 | $2,041.75 | ||
| 3000 | 5 | 8% | 4 | $2,018.91 | ||
| 3000 | 5 | 8% | 12 | $2,013.63 | ||
| 4-9 | PMT | Rate | Nper | end/begin | FV | |
| 425 | 6% | 8 | end | $4,206.42 | ||
| 425 | 6% | 8 | begin | $4,458.81 | ||
| 4-14 | PMT | Rate | Nper (yrs) | end/begin | PV | |
| 300 | 6.0% | 15 | monthly | end | $35,551.05 | |
| 300 | 6.0% | 15 | monthly | begin | $35,728.81 | |
| 4-18 | PV | FV | Nper | RATE | ||
| 1000 | 4000 | 10 | annual | 14.9% | ||
| 4-19 | PV | Rate | PMT | Nper (months) | ||
| 20000 | 4.0% | 500 | monthly | 43.0 | ||
| 4-25 | PV | Rate | Nper (yrs) | PMT | ||
| 30000 | 2.5% | 5 | monthly | $532.42 | monthly pmt | |
| PMT | Rate | Nper | PV | |||
| $532.42 | 2.5% | 36 | monthly | $18,447.52 | loan balance |
Sheet2
Sheet3
financae2.docx
HW Problems - Chapter 4
image1.png
image2.png
image3.png
image4.png
image5.png
image6.png
finance2hints.xlsx
Sheet1
| Hints to Chapter 4 Problems (Similar Problems) | ||||||
| 4-5 | FV | Nper | Rate | PV | ||
| 1000 | 10 | 5% | annual | $613.91 | ||
| 1000 | 10 | 10% | annual | $385.54 | ||
| 4-7 | FV | Nper | Rate | # of compounding | PV | |
| 3000 | 5 | 8% | 1 | $2,041.75 | ||
| 3000 | 5 | 8% | 4 | $2,018.91 | ||
| 3000 | 5 | 8% | 12 | $2,013.63 | ||
| 4-9 | PMT | Rate | Nper | end/begin | FV | |
| 425 | 6% | 8 | end | $4,206.42 | ||
| 425 | 6% | 8 | begin | $4,458.81 | ||
| 4-14 | PMT | Rate | Nper (yrs) | end/begin | PV | |
| 300 | 6.0% | 15 | monthly | end | $35,551.05 | |
| 300 | 6.0% | 15 | monthly | begin | $35,728.81 | |
| 4-18 | PV | FV | Nper | RATE | ||
| 1000 | 4000 | 10 | annual | 14.9% | ||
| 4-19 | PV | Rate | PMT | Nper (months) | ||
| 20000 | 4.0% | 500 | monthly | 43.0 | ||
| 4-25 | PV | Rate | Nper (yrs) | PMT | ||
| 30000 | 2.5% | 5 | monthly | $532.42 | monthly pmt | |
| PMT | Rate | Nper | PV | |||
| $532.42 | 2.5% | 36 | monthly | $18,447.52 | loan balance |