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)