Mortgage Rate Forecast

I need to take historical data of rental prices and forecast which city/district would be best to rent.

I need to also answer the following questions using the excel files provided and this website: [url removed, login to view]

What would be the rental yearly margin, calculated as: ( yearly revenue - yearly costs )/ purchase price? Assuming costs are 2000€ per year

Calculate the price for a 50 square meter property, and consider the following loan

Capital: 50% of the purchase price excluding taxes

Duration: 10 years (start date 1/1/2018 end date 31/12/2018)

There’re two types of mortgages available:

Fixed interest rate of 3%

Variable interest rate of EURIBOR+1,25

Calculate the loan monthly payment by December 2028 for the fixed interest rate.

Using a 10 year forecast of EURIBOR, calculate the loan monthly payment by December 2028

Which type of interest is more efficient for this scenario?

Which duration makes one mortgage more appealing than the other?

How much capital is it necessary to repay in a one-off payment by 2021, so the monthly payments for both loans to be the same?

- Create a new scenario changing the variables:

- Fixed interest rate of 2%

- Variable interest rate of EURIBOR+0,99

- Duration: 20 years

- What would be the interest rate that makes the loan monthly payments equals to 500€?

Beceriler: Muhasebe, Veri Girişi, Veri İşleme, Excel, Finans

İşveren Hakkında:
( 0 değerlendirme ) Spain

Proje NO: #16770069

Seçilen:

ValueResearcher

i live here in Madrid so i actually know about the zones you want. i can actually project the variable interest rate because this would be a big factor. Actually i made a projection for a hotel in Madrid not to lon Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 45%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 7 freelancer ortalamada \$44 teklif veriyor

sunprah2018

I am an MBA, and ex-investment banker. I assure all my clients a high quality work in a stipulated time period. My skill set includes the following: 1. Business Analysis 2. Financial Modelling 3. PowerPoint Presen Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.9
anieliashvili

Hello, I am Ani. I am an advanced excel user with some background in finance and accounting. I feel I am the right candidate for the job. Looking forward to be awarded.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.9
johnderekwork

I'm an excellent researcher and article writer an d proficient with projects, i'm ready when you are ready. thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Vrunda217

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
mmrh

I want to this job.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0