Can anyone please make a loan mortgage table for maximum 10 years @ 9.75% interest p.a. calculated monthly
Actually there are a lot of templates for this. But I need the following features
1. there should be provision for extra loan repayment by the borrower in any month possible
I have a sheet called "2017 OTP Comparison" which houses tax data.
There are the following columns
A. Tax Type - Tax Return, Provision, or RTP designation
B. Adjustment - Several different kinds
C. Total - The numeric total for each adjustment
D. Entity - Several different kinds
I have costs in ageing bucket and a provision in 1 column. I wish to deduct provision from cost ageing based on LIFO method and arrive at a net aged cost.
There are few checks to be applied:-
1. Total provision to be deducted can not exceed total aged cost.
2. Provision has to be...