Question

Using financial function to answer the following problems

1. 1) Calculate the present value of an annuity that pays $2,000 each two months for 4 years. The interest is 10% per year and each payment is made at the start of the period.

2. 2) Calculate the interest rate required to save $20,000, over 2 years, with a starting value of $1000, and monthly savings of $800. The payments are to be made at the start of each month.

3. 3) Calculate the number of months required to pay off in full, a loan of $50,000 at a rate of $1,000 per month. Interest is charged at a rate of 4% per year, and the payment to the loan is to be

   made at the end of each month.

4. 4) Calculate the monthly payments required to increase an investment from $2000 to $5,000 over

   a period of 2 years. Interest is paid at a rate of 3.5% per year and the payment into the

   investment is to be made at the beginning of each quarter.

5. 5) A loan of $50,000 which is to be paid off in full after 5 years. Interest is charged at a rate of 5% per year and the monthly payment to the loan is to be made at the end of each month.
   - What is the monthly payment.
   - What is the amount paid in the sixth month only from the loan.

   - What is the interest paid in the sixth month only from the loan. 2

-What is the amount paid during the first six months from the loan. -What is the interest paid during the first six months from the loan.

6) We bought a machine factory at a cost of NIS 20,000 at the end of the second quarter of 2019 and the life span of 6 years and have a scrap value at the end of life NIS 3,500. Calculate the depreciation of this machine within one year after purchase.

7) A machine price of NIS 500,000 and its value in the last useful life (12 years) is estimated at 150,000 NIS. This machine was purchased in the fifth month of 2018. Calculate the depreciation of this machine at the end of its first year (ie the end of 2018 year).

8) The price of a machine is $14000 and the default life is 7 years and the scrap value( salvage) is $2300. Calculate the depreciation of this machine after three years by using sum of years digits depreciation.

I need the answer in excel file :)

Answer 1