Please answer the following 10 questions using Excel:

1. Your mom is expected to get $160,000 in 15 years when she retires from her job. She, however, wanted to open a shop now to generate a second income when she becomes jobless. In order to finance her project now, how much maximum she could borrow from a bank in exchange of her retirement benefit if the interest rate is 9%?

2. You got delighted to have a news that you will get $60,000 in your bank account soon because your grandmother deposited some money as a gift on your first birthday. As you are busy with your studies, you are thinking of transferring the money to an investment account that will pay 9.5% per annum. How much will you have your in account if you transfer your money in that invest account and withdraw it after 8 years?

3. What is the present value of the cash flow of $3,000 at the end of 3rd year, $5,000 at the end of 6th year and $10,000 at end of ten year if the interest rate is 5%?

4. You are expected a cash flow of $2,500 at the end of 3rd year, $4,000 at the end of 6th year and $10,000 at end of ten year. If the interest rate is 8.5%, what is the future value of the cashflows at the end of year 20?

5. Recognizing that you are a new millionaire, someone proposed you to donate a fund so that poor children might have a warm meal every day at school for ever. An estimate shows that they need $25,000 per year for that lunch at school. How much must you donate if the fund can earn 9% per year?

6. You are interested to buy a new car that costs $70,000. What would be the monthly payment if you like to repay the loan in 15 years and the interest rate is 7.5%?

7. A housing agent is insisting you to buy a house by taking a mortgage at the rate of 8% per year. The agent informed you that you have to pay $3,000 per month to have the mortgage for 27 years. What was the price of the house (or present value of the mortgage)?

8. How much should you be willing to pay for a bond with a face value $1,000 that pays 5.5% coupon and matures in 10 years if your expected rate of return is 7%?

9. FastTrack bikes is thinking of developing a new composite road bike. Development will take six years and the cost is $197,300 per year. Once in production, the bike is expected to make $286,185 per year for 15 years. The cash inflows begins at the end of year 7. Assuming the cost of capital is 7%, calculate the NPV of this investment opportunity.

10. OpenSeas, Inc., is evaluating the purchase of a new cruise ship. The ship will cost $497 million, and will operate for 23 years. OpenSeas expects annual cash flows from operating the ship to be $71.1 million and its cost of capital is 12%. What is the NPV of this project?