EXCEL FORM!

Option: renting the apartment with a perpetual contract, meaning forever. The family was very happy living in that area, and they had the chance to live there forever at an offered price of 1,450 EUR the first month, and the rent price will be growing by a 0.15% monthly. This option would prevent the Marco family from applying for a loan, which represented a heavy burden off the family budget Option : consisted in acquiring the property with a mortgage scheme for 30 years. The total price of the apartment is 850.000. The family can pay an initial down payment of 250,000 EUR and the rest (600,000 EUR) to be paid in constant monthly payments with an annual interest rate of 2.75% compounded monthly Mrs. Marco establishes the maximum amount they can pay monthly as 2.250 In case of taking option I, what is the amount of the monthly payment the Marco family should pay in 30 years (in month 360)? (only the amount to be paid that month, show the calculations) In case of taking option I, how much money will have the Marco family paid in total after 30 years? If the Marco family decides to leave Barcelona in 10 years, to attend a better offer elsewhere, what is the present value of the rental contract offered by the owner as option I? (consider 2.75% compounded monthly as the interest/discount rate) If Mrs. Marco decides to buy the apartment, and accepts Option II, what will be the amount of each monthly payment to be done during the next 30 Years