Given detailed answers to each question in the doc below

Business Finance Professor Saeid Hoseinzade Homework #2 1. Complete the following table. Number of Payments or Years Annual Interest Rate Future Value Annuity Present Value 10 6% 0 $250.00 ? 20 12% ? $1,000 0 25 4% 0 ? $500,000 30 2% $1,000,000 ? 0 2. You just started working and you planned to save $5,000 every year in your retirement account. How much money will you have in your retirement account once you retire in 40 years? Your retirement account pays 4% interest rate per year. 3. You just retired with $1,000,000 savings. You'd like to receive your savings as an annuity for 20 years. If the interest rate on your account is 5%, how much do you receive every year? 4. You have received a $10,000 loan from your bank for 10 years. If the bank charges you 5% interest, how much do you need pay back to the bank at the end of each year: a. If the loan is a discount loan. b. If the loan is an interest-only loan. c. If the loan is an amortized loan. 5. For the previous question, calculate the total amount of money that you have to pay pack to the bank in each loan payment structure. Page 1 of 3 6. The Canadian Government has once again decided to issue a consol (a bond with a neverending interest payment and no maturity date). The bond will pay $40 in interest each year (at the end of the year) but never return the principal. The current discount rate for Canadian government bonds is 7.5%. What should this bond sell for in the market? 7. You want to purchase a condo in downtown Boston for $1,200,000. You can finance 80% of its cost by receiving a 20-year mortgage. Considering your income and your credit score, your bank offered 4.5% interest on your mortgage. For simplicity assume that you make yearly payments to your mortgage. Build an amortization schedule for this loan in Excel and answer the following questions. a. How much in total do you have to pay back to the bank? b. How much do you owe to the bank at the end of year 10? c. At the end of year 10, you decide to refinance your home with a new 15-year 3.5% mortgage. How much is your new yearly payment? d. Consider the initial mortgage (not the case where you refinanced). Starting from year 11, you decide to increase your yearly payments by 10% hoping that it helps you pay off your mortgage sooner. In this case, how long does it take for you to pay off your mortgage? 8. Complete the following table. Period APR Semi-Annual 8% Quarterly 9% Monthly 7.5% Daily 4.25% Compounding Per Year Periodic Rate Effective Annual Rate 9. You need $10'000 for 2 years and you go to your bank asking for a loan. The loan officer gives you the following options: a) 12% APR, yearly compounding b) 11.5% APR, semi-annually compounding c) 11% APR, monthly compounding Which one would you choose and why? Page 2 of 3 10. Which statement is true and which one is false. Explain in 2 lines max. a. Interest rate on a 20-year mortgage is higher than the interest rate on a 30-year mortgage. b. Interest rate on credit card debt is higher than the interest rate on a mortgage. c. Interest rate on a AAA corporate bond is lower than interest rate on a BB corporate bond with the same maturity. d. Interest rate on a AAA corporate bond with 1 year until maturity is necessarily higher than interest rate on a 10-year treasury bond. Page 3 of 3