Find Jobs
Hire Freelancers

Mortgage Rate Forecast

$10-30 USD

In Progress
Posted almost 6 years ago

$10-30 USD

Paid on delivery
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: [login to view URL] 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€?
Project ID: 16770069

About the project

5 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $23 USD for this job
User Avatar
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.
$15 USD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
I'm an excellent researcher and article writer an d proficient with projects, i'm ready when you are ready. thank you
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I want to this job.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
Tamarac, Spain
4.8
1
Payment method verified
Member since Apr 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.