Answered step by step
Verified Expert Solution
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:
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 buyersStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started