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:-
- A2329C Dosage Form Design AY2024 Term 4 – Graded Assignment (Individual Report), Singapore
- ANL312 Text Mining and Applied Project Formulation, End-of-Course Assessment, SUSS, Singapore
- CMM315 Peacebuilding and Security, End-of-Course Assessment, SUSS, Singapore
- HFS351 ECA (End-of-Course Assessment) SUSS : July Semester 2024 – Safety Management and Audit
- HFSY217 ECA (End-of-Course Assessment) SUSS : July Semester 2024 – Emergency Preparedness and Response Planning, Singapore
- NSG3EPN Assignment Two instructions rubric – Contemporary nursing practice :Engagement in Professional Nursing, LTU Singapore
- 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
UP TO 15 % DISCOUNT