1. In paragraph 1:
To calculate the monthly payments on the mortgage, we need to use the loan amount, interest rate, and loan term. In this case, the loan amount is $100,000, the interest rate is 7.5% (or 0.075 as a decimal), and the loan term is 30 years.
Using the formula for the monthly payment on a fixed-rate mortgage:
PMT = P * r * (1 + r)^n / ((1 + r)^n - 1)
where PMT is the monthly payment, P is the loan amount, r is the monthly interest rate, and n is the total number of payments, we can calculate the monthly payment:
PMT = 100,000 * 0.075/12 * (1 + 0.075/12)^(30*12) / ((1 + 0.075/12)^(30*12) - 1)
The monthly payment on the mortgage equals $699.21 (rounded to the nearest cent).
Next, to calculate the monthly Internal Rate of Return (IRR), we can use the PMT function in Excel or similar software. IRR calculates the discount rate at which the net present value (NPV) of cash flows is zero.
Using the PMT function, we enter the following parameters:
Rate: 7.5%/12 (monthly interest rate)
Nper: 30*12 (total number of payments)
Pmt: -$699.21 (negative because it represents outgoing cash flow)
The result is an IRR of 0.59324 (rounded to five decimal places). Note that the IRR is expressed as a decimal.
To confirm that the APR in the paragraph is equal to the monthly IRR multiplied by 12, we calculate:
APR = 0.59324 * 12 = 7.11888 (approximately)
Lastly, to compute the Effective Annual Interest Rate (EAIR), we can use the following formula:
EAIR = (1 + IRR)^(12/n) - 1
Here, n is the total number of payments per year. In this case, there are 12 payments per year.
EAIR = (1 + 0.59324)^(12/1) - 1 = 0.80685 (approximately)
2. In paragraph 2:
To compute the monthly IRR, APR, and EAIR for both loans, we would need the relevant loan parameters such as interest rates, fees, and loan terms. The paragraph does not provide specific values for these parameters. Therefore, we cannot calculate the requested values without additional information.
Please note that the paragraph mentions that the numbers on the webpage are slightly off, so caution should be exercised when using them.
Regarding which loan is preferable, it would typically depend on individual preferences and financial goals. Different loans offer varying trade-offs between upfront costs and long-term savings. The choice between loans would require a thorough evaluation of factors such as the borrower's financial situation, future plans, and priorities.
3. The statement claiming that loan 2 is preferable because the total payments over 60 months are lower is not correct as mentioned in the paragraph. The calculation comparing the total payments of both loans over 60 months shows that loan 1 actually costs $1,333 less than loan 2. Therefore, loan 1 would be more cost-effective in this scenario.
4. To calculate how much you would need to borrow with loan 1 in order to receive a net amount of $100,000, you can use the formula for present value (PV):
PV = FV / (1 + r)^n
Here, PV is the present value (loan amount), FV is the future value (net amount), r is the interest rate per period (monthly rate), and n is the number of periods (loan term in months).
We rearrange the formula to solve for PV:
PV = FV / (1 + r)^n
Plugging in the provided values:
FV = $100,000
r = 0.075/12 (monthly interest rate)
n = 30*12 (total number of payments)
PV = 100,000 / (1 + 0.075/12)^(30*12)
The calculated present value (loan amount) is approximately $93,184.67.
By comparing the loan amounts required to achieve a net amount of $100,000, we can see that loan 1 is more favorable as it requires a lower initial loan amount.