Calculation for Finance and Loans

Click For Summary
SUMMARY

The discussion focuses on calculating the comparison rate for an offset loan with a principal amount of $735,000 and an offset amount of $100,000. The original term length is 300 months, while the offset term length is 254 months. The original repayments are $4,228.50, with adjusted repayments for the comparison rate calculated at $4,224.57. The total cost of the loan is confirmed as $1,073,040.97, which includes interest and account fees, and the comparison rates calculated are 3.82% per annum and 5.46% per annum based on different present value assumptions.

PREREQUISITES
  • Understanding of offset loans and their mechanics
  • Familiarity with financial calculators and Time Value of Money (TVM) concepts
  • Knowledge of calculating comparison rates and total loan costs
  • Basic financial mathematics, including interest calculations
NEXT STEPS
  • Research how to accurately calculate comparison rates for different loan types
  • Learn about the implications of offset accounts on loan interest calculations
  • Explore the functionality of financial calculators for TVM calculations
  • Investigate the impact of varying present values on loan comparison rates
USEFUL FOR

Finance students, loan officers, mortgage brokers, and anyone involved in calculating loan costs and comparison rates for offset loans.

Shakattack12
Messages
24
Reaction score
2

Homework Statement


We are asked to calculate the comparison rate of an offset loan.
Loan amount = $735000
Offset amount = $100000
Original term length = 300 months
Offset term length = 254 months
Original repayments = $4228.50
Adjusted Repayments (for comparison rate) = $4224.57
Total amount = $1 073 040.97 - please help with this too

I want to double check that I got the total amount correct (see below for calculations)

Homework Equations


We have been asked to compute the comparison rate like this:
1. total cost of loan/number of repayments
2. Use adjusted repayments to solve for new interest rate (using calculator)

The Attempt at a Solution


So I have computed all the above information correctly. however, I am unsure of which value to call the present value of the loan in the TVM solver.
Using PV = 735000, comparison rate = 3.82%pa
Using PV = 635000, comparison rate = 5.46%pa
Which version do I use?

Edit
For total cost:
C = Interest + account fees
= 1 069 825.97 + 3215
= 1 073 040.97
*Do I need to add back the offset amount or not?*
 
Last edited:
Physics news on Phys.org
I know that an offset loan allows a person to link a savings account to the loan, then the interest is calculated on the difference between the loan principal balance and the amount of the savings account. I am not sure what happens when the loan balance becomes less than the amount in the savings account, though.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
Replies
1
Views
1K
Replies
14
Views
7K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 20 ·
Replies
20
Views
3K
Replies
4
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
16
Views
6K
  • · Replies 1 ·
Replies
1
Views
2K