University | Singapore University of Social Science (SUSS) |
Subject | FIN205 Data Technologies for Financial Modelling |
FIN205 Data Technologies for Financial Modelling Assignment, SUSS, Singapore: After some years of working, your fiancé/fiancée and you are getting married
Question 1
After some years of working, your fiancé/fiancée and you are getting married. You intend to buy an apartment by setting aside 30% of your combined gross income for monthly mortgage payments. Currently, your monthly combined income is $10,000.
You saw an apartment selling at $500,000 and are prepared to pay $80,000 with your existing savings as downpayment and borrow the remaining amount. For the mortgage loan, the bank charges a fixed rate APR of 5% for a 20-year loan. You are expected to pay monthly instalments for the mortgage loan.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
(a) What is the monthly instalment for the mortgage loan?
(b) Using an amortization schedule, demonstrate the interest and principal payments in the first 12 months. Calculate the total interest paid for the entire loan period (20 years)?
(c) Plot a chart to show the trends of monthly instalment payments, interest payments and principal payments over time. Account for the differences in these trends.
(d) Discuss two (2) factors you would consider for your accommodation before buying this apartment.
After settling the mortgage, you are contemplating to buy a new car. However, you are only willing to spend $2,000 per month for the car loan. The bank’s APR is 8% for a 10-year car loan.
(e) What is the most expensive car you can buy (ignore COE)?
Your financial advisor friend approaches and advises you to invest in asset X with its expected nominal annual returns in the table below. Inflation rate is expected to be 3% per year for the next 5 years.
(f) Compute the average real annual returns for Assets X.
Buy Custom Answer of This Assessment & Raise Your Grades
Master FIN205 Data Technologies for Financial Modelling with our specialized online assignment help in Singapore service. We offer the Best Online Exam Help in Singapore tailored to students' needs. Trust our experts to provide comprehensive support, ensuring success in your academic endeavors. Singapore students can confidently pay for our assistance, guaranteeing excellence in their assignments and exams. Trust us to guide you towards academic success.
Tags:-
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT