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.
1) Calculate the interest rate earned in an investment that requires $759 to buy and pays back $1,000 in 3 years from now. The investment compounds quarterly.
2) Calculate how many years will it take for an investment to grow from $100,000 to $500,000 with a 20% APR that compounds monthly.
3) Calculate the future value of a 10% APR earning account in which you make $100 deposits every month for 3 years and you make your first deposit today.
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 |