Comparison between loan repayemnts

Encerrado Postado há 10 meses Pago na entrega
Encerrado

i have $95,000 owing on a loan at 6.78% pa variable interest, but with $70,000 available cash back (due to payments in advance). This loan is for 25 years, expiring October 2044. I also have $781,000 owning on a different loan at 6.12% pa variable interest, a 30 year loan expiring September 2052. Both have interest accruing monthly, and monthly payments (although the smaller loan I have not paid back in some time due to payments in advance).

I believe I can save some interest by cashing out payments in advance on the smaller loan, and using this to pay down the larger. However the higher interest rate is obviously the catch. I want a comparison showing how much cash available I should use to pay down the larger loan - ideally a side-by-side table, perhaps in $5k increments, showing this in terms of overall interest expense saved. Assume otherwise standard/base repayments for the duration of the loans.

Note I'd expect a .5% increase in interest across both loans in the near future, however I'm not sure that's materially worth factoring into the calculations?

I'd like an Excel (or Google) spreadsheet returned with workings/formulas so I can understand the workings.

Contabilidade Excel Finanças Análise de Negócios Processamento de dados

ID do Projeto: #36795323

Sobre o projeto

21 propostas Projeto remoto Ativo em há 9 meses

21 freelancers estão ofertando em média $14/hora nesse trabalho

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Mais

$15 AUD / hora
(552 Comentários)
8.4
arslanu2

Hi! We are a professional accounting firm having Nine years-long exposure in the accounting field. Our team also includes professionals with high-end qualifications like Chartered Accountancy. We handle clients for al Mais

$15 AUD / hora
(29 Comentários)
5.7
dheerajjshetty19

Hello DanBScott, I have read your project description and I am confident that I can help you with your loan repayment comparison. With over 7 years of experience in accounting and finance, I have helped numerous clien Mais

$11 AUD / hora
(70 Comentários)
6.0
Amrsamra

i can do it with excel formula and calculations msg me plz

$12 AUD / hora
(82 Comentários)
5.5
RonDalgleish

I am an Australian investment banker based in HK for several decades. I have raised nearly US$500 millions over the course of my very international career from start ups (low 100'sK) to much larger sums for substantial Mais

$15 AUD / hora
(3 Comentários)
4.6
IMBASANTAKUMAR

I understand you are looking for a comparison between the loan repayments, and how much cash available should be used to pay down the larger loan - ideally a side-by-side table showing this in terms of overall interest Mais

$8 AUD / hora
(27 Comentários)
3.5
YashJainCA

My name is Yash and I am a chartered accountant dedicated to helping small businesses reach their highest potential by providing virtual accounting and financial advisory services. I specialize in helping startups navi Mais

$12 AUD / hora
(3 Comentários)
2.7
johnmichael2033

Hello, my name is John and I am a certified ethical hacker, with over 15 years of experience in IT security and penetration testing. I am confident that I can provide the necessary expertise to conduct the analysis you Mais

$12 AUD / hora
(0 Comentários)
0.0
CAAmit09

Hello, I am a chartered Accountant having 16 years of experiance in banking and IT industry. I would be able to provide you and insight into your question. Looking forward to listen back from you. Thanks CA Amit M Mais

$12 AUD / hora
(0 Comentários)
0.0
mfak016

I can complete this project with complete accuracy in the give time period. I had a command over this project and can easily done the entire task efficiently. I can complete this project with complete accuracy in the g Mais

$12 AUD / hora
(0 Comentários)
0.0
khushal0000

Hello. My name is khushal mohurle and I am from india. I have been working as a Data Entry and Data Extracting Expert for more than 1 years now. In my previous working years, I have finished many successful projects wi Mais

$12 AUD / hora
(0 Comentários)
0.0
ny78805

DATA ENTRY IN FRESHER(MS WORD , GOOGLE SHEET & MS EXCLE) IN FLIPKART 1 YEAR EXPIRIENCE

$40 AUD / hora
(0 Comentários)
0.0
shuhanliu5268

Hi, I am Shuhan, a CPA, CPA(WA) and CIA. I worked in Big 4 and have experience in providing all kinds of financial services (audit, NTR, tax filing and tax planing, CRA correspondence) to individuals and companies. I a Mais

$15 AUD / hora
(0 Comentários)
0.0
AmitUppal

I understand that you have two loans, let's say A & B which are the only fixed element in your calculation and the rest all are variables: Interest rate (this is fixed till there's a change in lending rates) Monthly i Mais

$15 AUD / hora
(1 Comentário)
0.0
Izzasinatrya

i have 4 years experience as auditor in financial services industry. you can save your time for explaining finance term especially in financing industry. i believe my background is suited for your project. Dont hestita Mais

$12 AUD / hora
(0 Comentários)
0.0