Question 2

How much should you deposit today in a savings account that earns 8.5% per year so that: 16 years from today, you will have 4,282.43 in your account?

Report the answer with 2 numbers after decimal place

Question 3

Today you deposit $1000 in a saving account carrying an annual interest rate of 6.75%, what will be the balance of your account 20 year from today?

Report the answer with 2 numbers after decimal place

Question 4

If you deposit $600 at the end of each year for the next 35 years in a saving account that earn an annual interest rate of 9%, what will be the balance in your account at the end of the 35-year period?

Report the answer with 2 numbers after decimal place

Question 6

John borrows $30,000 to buy a new car from a local bank with 0.65% interest rate per month. He agrees to pay off the loan in 36 equal end-of-month payments. The first payment will be made at the end of this month.

a.What should be the monthly payment?

Report the answer with 2 numbers after decimal place

b.make an amortization table showing his payment, interest payment, principal payment and loan balance over time. What is the Total Interest payment of the loan over the 36 months?

Report the answer with 2 numbers after decimal place

c.What must be the interest rate so that the total interest he pays to the bank over the life of the loan is 5562.74?

Report the answer in percentage term with 2 numbers after decimal place such as 12.43%.

Question 7

At the beginning of the year, you bought a regular bond with following information:

Face value: 10,000

Coupon rate: 6.25%

Coupon payment is made at the end of each year

Interest rate (or require rate of return): 5%

Maturity: 35 years

a.What should be the fair value/price of the bond?

Report the answer with 2 numbers after decimal place

b.If the market price for this bond is 8,990 and you decided to pay that price to own the bond and hold it till maturity, what is the rate of return you should receive?

Report the answer in percentage term with 2 numbers after decimal place such as 12.43%.

Question 8

Assuming a project having the following cash flows:

Year 0 1 2 3 4 5 6

cash flow -6000 500 -500 5000 1000 1000 1000

a.What is the NPV of this project if the discount rate is 5%?

Report the answer with 2 numbers after decimal place

b.What is the IRR of this project?

Report the answer in percentage term with 2 numbers after decimal place such as 12.43%.

c.What discount rate will make NPV of this project equals to -494.258

Report the answer in percentage term with 2 numbers after decimal place such as 12.43%.

Question 9. Using "Inventory data" sheet.

Find the total value of all cells that is greater than 300?

Question 10. Using "Inventory data" sheet.

How many days (rows) that meet all conditions below?

Division 1 inventory greater than 100 AND division 2 inventory greater than 400 AND division 3 inventory Less than 700