Đang Thực Hiện

Loan repayment Spreadsheet

Loan Servicing Spreadsheet

I want an excel spread sheet that can do the following:

The loan balance is $12,500.

Payments are to be made 2 times per year in equal installments.

The note shall be paid in 8 equal semi-annual installments.

No interest should be charged on the amount of the loan as long as repayments are made on the dates when they are due.

If a payment is missed, interest will be charged at the rate of 6% per annum on the amount of any payment not made when due- to be

calculated from the date of its due date- simple interest.

The spreadsheet should be able to show the beginning balance, amount paid towards principle, amount paid towards interest, ending balance,

number of remaining payments to be made with the amount per payment, and a column for payment date.

Again, if there is no payment- $0-interest is to be charged going forward. As long as there is a payment every time it is due, no interest should be charged. The spreadsheet should be adaptable to varying scenarios.

The actual amount of payment made can vary from $0- full which will be the input with the other categories to automatically calculate.

If you have any questions, please email me so that the spreadsheet is correct.

Kỹ năng: Xử lí dữ liệu, Excel, Tài chính

Xem thêm: loan repayment spreadsheet, excel spreadsheet loan repayment, loan repayment spreadsheet excel, repayment spreadsheet, excel sheet loan servicing, excel loan repayment spreadsheet, spreadsheet loan repayment, loan servicing excel, repayment loan balance sheet, spread repayments loan, excel spread loan repayment, excel spreadsheet simple interest, want spreadsheet loan repayment, want excel spread sheet, loan me, adaptable, loan repayment spread sheet, spreadsheet loan repayment interest, spreadsheet input, spreadsheet 2, repayment, loan, loan servicing, email spreadsheet, annual rate excel

Về Bên Thuê:
( 0 nhận xét ) Stroudsburg, United States

Mã Dự Án: #1713273

Đã trao cho:

muzaffarbalooch

Dear, I am professional Accountant and member of Institute of Chartered Accountant of Pakistan. I have 10 year experience of banking industry. I will give you the spreadsheet it will help you like a program. I wi Thêm

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0