Finance Question

Job ID: 31382114

Budget: $10 – $30 AUD

A Financial Management Homework Question that I'm having difficulty completing.

Deposit $52,000

Go to finder.com.au and choose a home loan:
https://www.finder.com.au/ubank-uhomeloan-fixed-rate-home-loan#c4e04c76-e99e-419d-81eb-2c056ee680e4



Now that you have your deposit and your loan you are ready to buy a house based on the deposit you have and the loan you chose, go to realestate.com.au and choose a house that you can afford:
https://www.realestate.com.au/property-house-wa-jurien+bay-137052298



Assume you make payments monthly. For every month for the first two years calculate how much principal and interest you pay per payment and as such how much principal is left over after each payment is made. Make sure you take into account any fees.

This should be done on excel where possible.
Related categories: Excel Finance Mathematics