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:-
- HFS201 GBA (Group-based Assignment) SUSS: July 2024 – Workplace Evaluation and Design
- Business Accounting & Finance – (VM) – A3 Assignment, UOM, Singapore
- HRM3010S: Managing People At Work, Assignment, UCD, Singapore
- HFS351: Safety Management and Audit, End-of-Course Assessment, SUSS, Singapore
- HFSY217: Emergency Preparedness and Response Planning, TMA (Tutor-Marked Assignment), SUSS
- CMM315: TMA (Tutor-Marked Assignment) – Peacebuilding and Security, SUSS, Singapore
- Harley Davidson utilized different entry mode strategies in pursuit of internationalization: Sustainable, Assignment, UoN, Singapore
- Nursing Patients With Chronic Illness, Assignment 3, LTU, Singapore: Jason Bundhoo is a 42-year-old car driver from Triolet
- DSM: R for Data Science, Coursework 2, UOL, Singapore: In this coursework assignment you should return to this dataset and perform an appropriate investigation into building a statistical model
- DSM120: Financial Data Modelling, Coursework 1, UOL, Singapore
UP TO 15 % DISCOUNT