In: Finance
I ONLY NEED QUESTION 6,7,8
The Marconi family—comprising Mrs. Marconi, aged 40, Mr. Marconi, aged 38, and their three young children— relocated to Barcelona in January 2020 when Mrs. Marconi received a job offer from a leading investment banking giant. They rented a three- bedroom condominium in Barcelona for 2.000€ per month, which included parking and condominium fees.
While renting made life easy, the Marconi family began weighing the pros and cons of purchasing a flat, in the same building, that became available in June 2020. In the past three years, the real estate market had softened somewhat, and the cost of the flats were stable. The idea of home ownership as a form of pension investment appealed to the couple. The monthly rents could be used for mortgage payments instead.
While searching for the right property they found a nice apartment with 200 square meters, very close to Diagonal-Numancia, one of the best locations of the city.
The apartment was owned and had been promoted by a state-owned construction company and was offering two alternatives:
Option A: renting the apartment with a perpetual contract, meaning for ever. The Marconi family thought that could be a good solution for them.
The family was very happy living in that area, and they had the chance to live there forever at an offered price of 1.600€ the first month, and the rent price will be growing by a 0.1% monthly.
At the same time, they were not forced to ask for a loan, which represented a heavy burden off the Marconi’s.
Option B: consisted in acquiring the property with a mortgage scheme for 40 years. The total price of the apartment is 800.000€. The family can pay an initial down payment of 200.000€ and the rest (600k€) to be paid in constant monthly payments with an annual interest rate of a 2.4% compounded monthly.
Mrs. Marconi establishes the maximum amount they can pay monthly as 2.000€.
b) What is the total amount they’ll have paid in total after 40 years? (10 points)
c) How much has the family saved (if any) by paying it yearly
instead of monthly? (10 points)
Question 6.
The price of the Apartment is: 800,000€. Let Present Value (PV)of the Apartment be 800,000€.
No of years (N)= 40.
The rate (r) = 1,5%
The compounding Frequency (m) is: 12( Since we have to calculate the future value considering the 1.5% p.a compounded monthly)
The formula for calculating Future Value is:
FV=PV(1+(r/m))^m*n
Therefore the answer for question 6 is FV= 800,000(1+(0.015/12))^12*40= 1457148.962€.
Question 7 part a:The amount that the family has to pay off during the 40 years is:the amount of the house after the down payment because 600,000€ is the amount that they had taken to pay off during those years as 200,000€ of lump sum has been initially paid by them as down payment.
Considering that they will be taking one payment at the end of each year at 2.5% p.a.
FV= | 0 |
PV= | 6,00,000 |
N= | 40 |
R= | 2.40% |
PMT(Annual payment)= | ₹ -23,500.96 |
Using =pmt formula in excel =pmt(rate,nper,pv,fv,type) take type as 0.
queation 7 part b
after 40 years, they will have paid 23500.96*40= 940038.40
question 7 part c
FV= | 0 | |
PV= | 6,00,000 | |
N= | 480 | |
R= | 0.002 | (2.4/12)% |
PMT(Annual payment)= | ₹ -1,945.72 | |
The monthly payment considering will be 1945.72 and annual will be 1945.72*12=23348.64
The family would not have saved by paying on a yearly basis instead of paying monthly
By paying yearly , they will lose 23500.96-23348.64=152.32.
Question 8
will get the answer shortly