In an Excel spreadsheet answer the scenarios below. To submit this homework you

Question

In an Excel spreadsheet answer the scenarios below. To submit this homework you must send the Excel sheet through e-mail as an attachment. The formulas and/or functions used must be in the excel sheet for me to review. Excel sheets with numbers only as answers will not be considered as submitted.

*Please show work

4) Calculate the present value of an investment discounted at 8% and pays you $100 every 6 months for 5 years and you receive the first payment today. 5) Build an amortization table for a 12 month $2,500 loan. The loan has an 8% APR. Compounding and payments are monthly. The table should have the following headings:

| Month | Beginning Balance | Payment Interest | Portion of Payment | Principal Portion of Payment | End Balance |

The answer is $843.53(Given by professor)

Explanation / Answer

N = 10

FV = 0

rate = 8%/2

PMT = 100

use PV function in Excel with type as 1

present value of the payments = 843.53

2.

Year Beg Balance Total Pmt Interest Principal Paid End Balance 1 2,500 217.47 16.67 200.80 2,299 2 2,299 217.47 15.33 202.14 2,097 3 2,097 217.47 13.98 203.49 1,894 4 1,894 217.47 12.62 204.85 1,689 5 1,689 217.47 11.26 206.21 1,483 6 1,483 217.47 9.88 207.59 1,275 7 1,275 217.47 8.50 208.97 1,066 8 1,066 217.47 7.11 210.36 856 9 856 217.47 5.70 211.77 644 10 644 217.47 4.29 213.18 431 11 431 217.47 2.87 214.60 216 12 216 217.47 1.44 216.03 0

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.