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.
- Final Assignment: Migrating FashionOnline’s Infrastructure to AWS: A Strategy for Enhanced Availability and Data Protection
- HRM331: Talent Management – Strategic Shift from the War for Talent to the Wealth of Talent
- Marginalised Populations – The Structural and Cultural Exclusion of People Experiencing Homelessness in Singapore
- CVEN3501 Assignment 2: Groundwater Modelling of Drawdown from a Pumping Bore
- CSCI312 Assignment 2: Conceptual Modelling and Implementation of a Data Warehouse and Hive Queries
- CH2123 Assignment: Fugacity, VLE Modeling & Applications of Henry’s Law
- BAFI1045 Assignment -Constructing and Evaluating Passive and Active Portfolios Based on the Straits Times Index (STI)
- FIN2210E/FIN2212E Group Assignment: Financial Risk Management Analysis of Bursa Malaysia Companies
- FLM101 Assignment: A Film Analysis: Stylistic Techniques and Their Thematic Importance
- HRM Assignment Answer: Talent Transformation in the Age of AI: Turning Challenges into Opportunities via Ecosystem Innovation
UP TO 15 % DISCOUNT