You are asked to answer all the questions in the proposed case. This task assesses the following learning outcomes:
• Assess the present value of future cash flows and the future value of regular savings, annually and periodically.
• Understand the Perpetuity and annuity valuation and their factors – annual and periodical – and with various starting dates with and without
growth.
• Demonstrate an ability to apply the technical skills in a practical context.
Submission file format: Word document with all the answers, clearly identifying all steps, results, and including comments besides each answer. Task (100 points)
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€.
1) In case of taking option A, what is the amount of the monthly payment the Marconi family should pay in 40 years? (only the amount to be paid that month) Show the calculations and explain why.
2) In case of taking option A, how much money will have the Marconi family paid in total after 40 years?
3) If the Marconi family decides to leave Barcelona in 10 years, back to Italy, what is the present value of the rental contract offered by the owner as option A?
4) If Mrs. Marconi decides to buy the apartment, and accepts Option B, what will be the amount of each monthly payment to be done during the next 40 years?
5) Mrs. Marconi believes that, if she takes option B and acquires the ownership of the flat, she might be interested in selling the apartment in 40 years’ time, that is to say, when she has already paid it all.
If she wants to recover absolutely all the money invested (initial payments plus all monthly payments done), what will be the price she will ask for that apartment at that moment?
6) Mrs. Marconi is very happy for knowing how to calculate future values and present values, because this helps her in taking this type of decisions. Having said that, she wonders what the future value of the flat will be in 40 years, if the interest rate for this type of operations is an annual 1.5% (comp. monthly). Can you help her? Explain your answer and show your calculations.
7) The family is still thinking that the monthly payments they’ll have to afford during the next forty years are too much, and they believe they could convince the seller of making payments only once a year, at the end of each year. The interest rate would still be the same 2.4%. How much money will they save with this action?
a) What is the amount of the yearly payment to be done?
b) What is the total amount they’ll have paid in total after 40 years?
c) How much has the family saved (if any) by paying it yearly instead of monthly?
8) In case that the Marconi family pays the pending amount in yearly payments, the owner can only grant them a 2.4% during the first 10 years. There is the possibility that, after the first 10 years the interest rate increases to a 3.0% for the remaining 30 years.
How much should the Marconi family pay per year from year 11 onwards if this occurs?
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Ace Writing Center has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
Essays
At Ace Writing Center, Nowadays, students normally have extremely busy schedules. You will note that some of them have to take on some evening or weekend jobs in order to get some income that can help them to sustain in college or in the university. This can deny them a chance to write all the essays given. Others usually get bombarded with a lot of work by their lecturers. This can still delay such students from working on all their essays. However, some of them usually try to work on all these essays but end up delivering their work late. This can prevent them from graduating since most lecturers are strict on deadlines. If you want to write a business essay, the wise way is to hire an outstanding essay writing service like us, so that you can get the best results. If you are keen, you will note that many companies usually overcharge their customers. Some of them are there only to make money. And in reality, they really don’t care to build a long term commitment with students. You should not choose such companies. You should take your time and choose a reliable company to work with. Ace Writing Center is the ultimate solution for you. We have been offering our writing service for more than 7 years. This is a clear indication that you will get quality essay writing service. We have a wide range of writers who can work on any business essay that you might have. We believe in doing extensive research so that we can provide quality work to all our clients. .
Admissions
Admission and Business Papers
Have you ever had to write an admission essay for college? The majority of students face the same issues when applying to a university or college and many in such situations decide they need professional help to cope with this matter. They get in a situation when the deadline keeps coming closer but lack motivation to start because they are just not sure if their writing skills are strong enough. We have a solution for you! Ace Writing Center is the best admission essay writing service with a large professional team and years of experience in providing high-quality papers to students of all levels and faculties. The mission of our team is to help students make their dreams of entering a good college come true and that’s what we offer!.
Editing
Editing and Proofreading
Sometimes all the words for your paper just flow out of your mind and into your fingers. You type quickly at your keyboard and there they are, your beautiful words right there on the screen. But you have no idea how to polish it up. You may be wishing there was a paper writing service that offered this type of writing service. Look no more! Here at Ace Writing Center, we offer you an editing and proofreading option that you can't find anywhere else..
Coursework
College Essay Writing
In case you are familiar Ace Writing Center, you know the way to distinguish a better company from a cheap one exactly. First of all, poor service website does not have a sufficient support. We think support team is an essential part of success; it has to answer all clients’ questions and be a connecting link between clients and their writers. On our web-service you will get answers about anything you need and your writer will receive all your instructions, assignments and requirements exactly and swiftly. A writing service that we run has got a flexible pricing system that will save you from senseless wastes and many bonus systems that let you sparing money for something important for you.