Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The loan amount is $761399, fill in the blanks with Excel, and give the steps to calculate with Excel: Assumptions: 1. You have a full

The loan amount is $761399, fill in the blanks with Excel, and give the steps to calculate with Excel:

image text in transcribed Assumptions: 1. You have a full time job and are going to buy your first home (owner occupier). 2. You are eligible to apply for a mortgage. You have already saved 20% for the deposit and all other related costs associated with buying the house and applying for the mortgage (e.g. stamp duty, conveyancing \& legal Pg. 1/6 fees, pest & building inspections, mortgage registration fee, and loan application fee). i.e. the amount borrowed excludes the 20% deposit and all the associated costs. 3. You make fortnightly repayments on the amount borrowed (the principal), plus you pay interest on that amount (you cannot have interest-only mortgage). You will pay off the mortgage over 25 years. 4. After 5 years, the interest rate will increase by 2.25% and will remain unchanged for the next five years (i.e. Year 6 - 10). It will then increase by a further 1.75% in Year 11 and will remain unchanged for the following five years (i.e. Year 11-15). A further increase of 1% in the subsequent year. It will remain unchanged for the rest of the loan term (i.e. Year 16 onwards). 5. You will get a big promotion in 17 years. Therefore you plan to repay extra per fortnight from Year 18 onwards. Use the last digit of your student number as the extra hundred(s) of dollars repayment. (If your student number end with zero (0), use $100 as the extra payment). E.g. Student no. 5151515 - the extra payment per fortnight will be $500 6. Please ignore any government subsidies for first home buyers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Making Of Finance

Authors: Isabelle Chambost, Marc Lenglet, Yamina Tadjeddine

1st Edition

1138498572, 978-1138498570

More Books

Students also viewed these Finance questions